From 93521f9f18d598cf104d5b3a6949bcd94ce5e1dd Mon Sep 17 00:00:00 2001 From: Stefan Niedermann Date: Sun, 11 Apr 2021 18:44:24 +0200 Subject: #831 Use IF EXISTS before dropping indices --- .../persistence/migration/Migration_20_21.java | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) (limited to 'app/src/main/java/it/niedermann/owncloud/notes/persistence/migration') 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) { -- cgit v1.2.3