INSTANCE = Room.databaseBuilder(context, AppDatabase.class, DATABASE_NAME)
.addMigrations(MIGRATION_1_2, MIGRATION_2_3, MIGRATION_3_4)
.build();
static final Migration MIGRATION_1_2 = new Migration(1, 2) {
@Override
public void migrate(SupportSQLiteDatabase database) {
database.execSQL("ALTER TABLE sensor ADD COLUMN device_name TEXT NOT NULL DEFAULT ''");
database.execSQL("CREATE TABLE IF NOT EXISTS srs_radar_data ("
+ "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL"
+ ", built_in INTEGER NOT NULL DEFAULT 1"
+ ", sensor_status INTEGER NOT NULL"
+ ", activity_detect INTEGER NOT NULL DEFAULT 0"
+ ", data_id_count INTEGER NOT NULL DEFAULT 0"
+ ", data_id_1 INTEGER NOT NULL"
+ ", created_at_view TEXT"
+ ", created_at INTEGER NOT NULL"
+ ")");
}
};
https://www.notion.so/2020-07-27-85c5e2b993b3494a8b56a9a7a83557c9#cf0e0da7f71a40a7984f913e7531a326