- debug("db", "onUpgrade called");
- for (int i = oldVersion + 1; i <= newVersion; i++) applyRevision(db, i);
+ debug("db",
+ String.format(Locale.US, "needs upgrade from version %d to version %d", oldVersion,
+ newVersion));
+ for (int i = oldVersion + 1; i <= newVersion; i++)
+ applyRevision(db, i);
+ }
+ @Override
+ public void onOpen(SQLiteDatabase db) {
+ super.onOpen(db);
+ db.execSQL("pragma case_sensitive_like=ON;");
+ if (BuildConfig.DEBUG)
+ db.execSQL("PRAGMA foreign_keys=ON");