diff options
| author | desperateCoder <echotodevnull@gmail.com> | 2021-04-14 22:27:25 +0300 |
|---|---|---|
| committer | desperateCoder <echotodevnull@gmail.com> | 2021-04-14 22:27:25 +0300 |
| commit | 33707218b450dc5a6661d5d590d0aa952468afb7 (patch) | |
| tree | 4a754a303539020fb5baf49084e0901d1591e4f8 /app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters | |
| parent | fec2dacad067e4fac0e0f5ab5704e54cc740b1f2 (diff) | |
#935 just more fckup
Diffstat (limited to 'app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters')
| -rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/migration/Migration_30_31.java | 4 |
1 files changed, 2 insertions, 2 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 0e82147f8..0659b1229 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 @@ -27,10 +27,10 @@ public class Migration_30_31 extends Migration { 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 DEFAULT 2, FOREIGN KEY(`cardId`) REFERENCES `Card`(`localId`) ON UPDATE NO ACTION ON DELETE CASCADE , FOREIGN KEY(`accountId`) REFERENCES `Account`(`id`) ON DELETE CASCADE )"); + 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"); - database.execSQL("INSERT INTO `Activity_tmp` select * from `Activity`"); + database.execSQL("INSERT INTO `Activity_tmp` (`localId`, `accountId`, `id`, `status`, `lastModified`, `lastModifiedLocal`, `etag`, `cardId`, `subject`, `type`) select `localId`, `accountId`, `id`, `status`, `lastModified`, `lastModifiedLocal`, `etag`, `cardId`, `subject`, COALESCE(`type`, 2) from `Activity`"); database.execSQL("DROP TABLE `Activity`"); database.execSQL("ALTER TABLE `Activity_tmp` RENAME TO `Activity`"); database.execSQL("CREATE INDEX `activity_accID` ON `Activity` (`accountId`)"); |