How to use

createTable

method

in

org.tmatesoft.sqljet.core.table.SqlJetDb

  @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, "