Lines Matching defs:db
43 static final String DATABASE_NAME = "cell_broadcasts.db";
62 public void onCreate(SQLiteDatabase db) {
63 db.execSQL("CREATE TABLE " + TABLE_NAME + " ("
85 createDeliveryTimeIndex(db);
88 private void createDeliveryTimeIndex(SQLiteDatabase db) {
89 db.execSQL("CREATE INDEX IF NOT EXISTS deliveryTimeIndex ON " + TABLE_NAME
115 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
120 log("Upgrading DB from version " + oldVersion + " to " + newVersion);
124 db.beginTransaction();
127 db.execSQL("DROP TABLE IF EXISTS " + TEMP_TABLE_NAME);
128 db.execSQL("ALTER TABLE " + TABLE_NAME + " RENAME TO " + TEMP_TABLE_NAME);
131 onCreate(db);
134 Cursor cursor = db.query(TEMP_TABLE_NAME, COLUMNS_V1, null, null, null, null,
138 upgradeMessageV1ToV2(db, cursor);
145 db.execSQL("DROP TABLE " + TEMP_TABLE_NAME);
146 db.setTransactionSuccessful();
148 db.endTransaction();
157 + " DB version " + oldVersion + " (customized by OEM?)");
161 createDeliveryTimeIndex(db);
169 private static void upgradeMessageV1ToV2(SQLiteDatabase db, Cursor cursor) {
324 db.insert(TABLE_NAME, null, cv);
