diff options
| author | Stefan Niedermann <info@niedermann.it> | 2021-04-11 19:44:24 +0300 |
|---|---|---|
| committer | Stefan Niedermann <info@niedermann.it> | 2021-04-11 19:44:24 +0300 |
| commit | 93521f9f18d598cf104d5b3a6949bcd94ce5e1dd (patch) | |
| tree | 1d43bd03d61aad6a5e084cfc61dd6d80cfade1f2 | |
| parent | 1d2a18a1169684632f02864aa3cfc6889220a27b (diff) | |
#831 Use IF EXISTS before dropping indices
| -rw-r--r-- | app/src/main/java/it/niedermann/owncloud/notes/persistence/migration/Migration_20_21.java | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/app/src/main/java/it/niedermann/owncloud/notes/persistence/migration/Migration_20_21.java b/app/src/main/java/it/niedermann/owncloud/notes/persistence/migration/Migration_20_21.java index 21e1d363..994c20ec 100644 --- a/app/src/main/java/it/niedermann/owncloud/notes/persistence/migration/Migration_20_21.java +++ b/app/src/main/java/it/niedermann/owncloud/notes/persistence/migration/Migration_20_21.java @@ -40,17 +40,17 @@ public final class Migration_20_21 extends Migration { } private static void dropOldIndices(@NonNull SupportSQLiteDatabase db) { - db.execSQL("DROP INDEX ACCOUNTS_URL_idx"); - db.execSQL("DROP INDEX ACCOUNTS_USERNAME_idx"); - db.execSQL("DROP INDEX ACCOUNTS_ACCOUNT_NAME_idx"); - db.execSQL("DROP INDEX ACCOUNTS_ETAG_idx"); - db.execSQL("DROP INDEX ACCOUNTS_MODIFIED_idx"); - db.execSQL("DROP INDEX NOTES_REMOTEID_idx"); - db.execSQL("DROP INDEX NOTES_ACCOUNT_ID_idx"); - db.execSQL("DROP INDEX NOTES_STATUS_idx"); - db.execSQL("DROP INDEX NOTES_FAVORITE_idx"); - db.execSQL("DROP INDEX NOTES_CATEGORY_idx"); - db.execSQL("DROP INDEX NOTES_MODIFIED_idx"); + db.execSQL("DROP INDEX IF EXISTS ACCOUNTS_URL_idx"); + db.execSQL("DROP INDEX IF EXISTS ACCOUNTS_USERNAME_idx"); + db.execSQL("DROP INDEX IF EXISTS ACCOUNTS_ACCOUNT_NAME_idx"); + db.execSQL("DROP INDEX IF EXISTS ACCOUNTS_ETAG_idx"); + db.execSQL("DROP INDEX IF EXISTS ACCOUNTS_MODIFIED_idx"); + db.execSQL("DROP INDEX IF EXISTS NOTES_REMOTEID_idx"); + db.execSQL("DROP INDEX IF EXISTS NOTES_ACCOUNT_ID_idx"); + db.execSQL("DROP INDEX IF EXISTS NOTES_STATUS_idx"); + db.execSQL("DROP INDEX IF EXISTS NOTES_FAVORITE_idx"); + db.execSQL("DROP INDEX IF EXISTS NOTES_CATEGORY_idx"); + db.execSQL("DROP INDEX IF EXISTS NOTES_MODIFIED_idx"); } private static void createNewTables(@NonNull SupportSQLiteDatabase db) { |