@Override public void execute(SqlJetDb database) throws SqlJetException { ISqlJetSchema schema = database.getSchema(); if (schema.getTable(INVOCATION_TABLE) == null) { database.createTable(CREATE_INVOCATION_SQL); } if (schema.getTable(INVOKER_TABLE) == null) { database.createTable(CREATE_INVOKER_SQL); database.createIndex(CREATE_INVOKER_INDEX); } } };
public Object run(SqlJetDb db) throws SqlJetException { db.createTable("create table revprop (revision integer UNIQUE not null, " + "properties BLOB not null);"); db.createIndex("create index i_revision on revprop (revision);"); db.getOptions().setUserVersion(1); return null; } });
private void createStructure(SqlJetDb db) throws SqlJetException { db.beginTransaction(SqlJetTransactionMode.WRITE); try { db.createTable("CREATE TABLE states (full_name TEXT NOT NULL PRIMARY KEY, version TEXT NULL)"); db.createIndex("CREATE INDEX full_name_index ON states(full_name)"); } finally { db.commit(); } }
@Override public void execute(SqlJetDb database) throws SqlJetException { ISqlJetSchema schema = database.getSchema(); if (schema.getTable(STATE_TABLE) == null) { database.createTable(CREATE_STATE_SQL); } else if (Boolean.getBoolean(StateManager.CLEAR_LOCAL_STATE)) { database.getTable(STATE_TABLE).clear(); } } };
handleSelect(); } else if ("create_table".equalsIgnoreCase(stmtName)) { db.createTable(sql); } else if ("drop_table".equalsIgnoreCase(stmtName)) { handleDropTable();
sDb.getDb().createTable("CREATE TABLE EXTERNALS ( " + " wc_id INTEGER NOT NULL REFERENCES WCROOT (id), " + " local_relpath TEXT NOT NULL, " +
db.createTable(stmt.getSql());
public void bumpTo(SVNWCDb db, SVNSqlJetDb sDb, File wcRootAbsPath) throws SVNException { try { sDb.getDb().createTable("CREATE TABLE NODES ( wc_id INTEGER NOT NULL REFERENCES WCROOT (id), local_relpath TEXT NOT NULL, op_depth INTEGER NOT NULL, " + " parent_relpath TEXT, repos_id INTEGER REFERENCES REPOSITORY (id), repos_path TEXT, revision INTEGER, presence TEXT NOT NULL, " + " moved_here INTEGER, moved_to TEXT, kind TEXT NOT NULL, properties BLOB, depth TEXT, checksum TEXT REFERENCES PRISTINE (checksum), symlink_target TEXT, "