8586878889909192
" PRIMARY KEY (g, s, p, o)", ") ENGINE="+engineType.getEngineName() )) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException formatting table '"+TableDescTriples.name()+"'",ex) ; } }
111112113114115116117118
" PRIMARY KEY Hash (hash)", ") ENGINE="+engineType.getEngineName()+" DEFAULT CHARSET=utf8;" )) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException formatting table '"+TableDescNodes.name()+"'",ex) ; } }
129130131132133134135136
" PRIMARY KEY (prefix)", ") ENGINE="+engineType.getEngineName()+" DEFAULT CHARSET=utf8" )) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException resetting table '"+TablePrefixes.name()+"'",ex) ; } }
140141142143144145146
{ try { // MySQL note: DELETE FROM is transactional, TRUNCATE is not connection().exec("TRUNCATE "+tableName) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException : Can't truncate table: "+tableName, ex) ; } }
49505152535455
" o INT NOT NULL,", " PRIMARY KEY (s, p, o)", ")" )) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException formatting table '"+TableDescTriples.name()+"'",ex) ; } }
149150151152153154155
protected void dropTable(String tableName) { try { connection().exec("DROP TABLE IF EXISTS "+tableName) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException : Can't drop table: "+tableName, ex) ; } }
67686970717273
" o INT NOT NULL,", " PRIMARY KEY (g, s, p, o)", ")" )) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException formatting table '"+TableDescTriples.name()+"'",ex) ; } }
8889909192939495
")" )) ; connection().exec("CREATE UNIQUE INDEX Hash ON " + TableDescNodes.name() + " (hash)"); } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException formatting table '"+TableDescNodes.name()+"'",ex) ; } }
5051525354555657
" PRIMARY KEY (s, p, o)", ")" )) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException formatting table '"+TableDescTriples.name()+"'",ex) ; } }
7071727374757677
" PRIMARY KEY (g, s, p, o)", ")" )) ; } catch (SQLException ex) { throw new SDBExceptionSQL("SQLException formatting table '"+TableDescTriples.name()+"'",ex) ; } }