コード例 #1
0
  @Override
  public void onCreate(SQLiteDatabase db) {
    super.onCreate(db);

    db.execSQL(
        "CREATE TABLE "
            + TABLE_PUBKEYS
            + " (_id INTEGER PRIMARY KEY, "
            + FIELD_PUBKEY_NICKNAME
            + " TEXT, "
            + FIELD_PUBKEY_TYPE
            + " TEXT, "
            + FIELD_PUBKEY_PRIVATE
            + " BLOB, "
            + FIELD_PUBKEY_PUBLIC
            + " BLOB, "
            + FIELD_PUBKEY_ENCRYPTED
            + " INTEGER, "
            + FIELD_PUBKEY_STARTUP
            + " INTEGER, "
            + FIELD_PUBKEY_CONFIRMUSE
            + " INTEGER DEFAULT 0, "
            + FIELD_PUBKEY_LIFETIME
            + " INTEGER DEFAULT 0)");
  }