blob: d6938dda6a6aeaf52a275d405dd4fb6efbfb6f57 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
package it.niedermann.nextcloud.deck.database.migration;
import androidx.annotation.NonNull;
import androidx.room.migration.Migration;
import androidx.sqlite.db.SupportSQLiteDatabase;
/**
* Adds support for marking a card as done: https://github.com/stefan-niedermann/nextcloud-deck/issues/1556
*/
public class Migration_32_33 extends Migration {
public Migration_32_33() {
super(32, 33);
}
@Override
public void migrate(@NonNull SupportSQLiteDatabase database) {
database.execSQL("ALTER TABLE `Card` add column done INTEGER");
// Reset ETags: Refetch all cards to support Done state which did not change ETags
database.execSQL("UPDATE `Account` SET `boardsEtag` = NULL");
database.execSQL("UPDATE `Board` SET `etag` = NULL");
database.execSQL("UPDATE `Stack` SET `etag` = NULL");
database.execSQL("UPDATE `Card` SET `etag` = NULL");
}
}
|