diff options
author | desperateCoder <echotodevnull@gmail.com> | 2021-04-14 20:13:08 +0300 |
---|---|---|
committer | desperateCoder <echotodevnull@gmail.com> | 2021-04-14 20:13:24 +0300 |
commit | be5e0b2f4f04597753f8a0a04c2bbd358c19218b (patch) | |
tree | 45e658a4baf2e3744a05333b928650977e3aa842 | |
parent | 352580c69514a28cb86828ae06a1b33cf046b64c (diff) |
#935 wtf did i just witness?!1.17.5
-rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/migration/Migration_30_31.java | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/migration/Migration_30_31.java b/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/migration/Migration_30_31.java index 53d779362..24ae1b015 100644 --- a/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/migration/Migration_30_31.java +++ b/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/migration/Migration_30_31.java @@ -26,6 +26,7 @@ public class Migration_30_31 extends Migration { database.execSQL("CREATE INDEX `index_AccessControl_id` ON `AccessControl` (`id`)"); database.execSQL("CREATE INDEX `index_AccessControl_lastModifiedLocal` ON `AccessControl` (`lastModifiedLocal`)"); database.execSQL("CREATE UNIQUE INDEX `index_AccessControl_accountId_id` ON `AccessControl` (`accountId`, `id`)"); + database.execSQL("DROP TABLE IF EXISTS `Activity_tmp`"); database.execSQL("CREATE TABLE `Activity_tmp` (`localId` INTEGER PRIMARY KEY AUTOINCREMENT, `accountId` INTEGER NOT NULL, `id` INTEGER, `status` INTEGER NOT NULL, `lastModified` INTEGER, `lastModifiedLocal` INTEGER, `etag` TEXT, `cardId` INTEGER NOT NULL, `subject` TEXT, `type` INTEGER NOT NULL, FOREIGN KEY(`cardId`) REFERENCES `Card`(`localId`) ON UPDATE NO ACTION ON DELETE CASCADE , FOREIGN KEY(`accountId`) REFERENCES `Account`(`id`) ON DELETE CASCADE )"); database.execSQL("DELETE FROM `Activity` where accountId not in (select id from `Account`)"); database.execSQL("UPDATE `Activity` SET `type` = 2 WHERE `type` IS NULL"); |