app/schemas/com.futsch1.medtimer.database.MedicineRoomDatabase/9.json
{
"formatVersion": 1,
"database": {
"version": 9,
"identityHash": "529390d3ca0bf1c196236b6cc96dd4f3",
"entities": [
{
"tableName": "Medicine",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`medicineName` TEXT, `medicineId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `color` INTEGER NOT NULL DEFAULT 0xFFFF0000, `useColor` INTEGER NOT NULL DEFAULT false, `notificationImportance` INTEGER NOT NULL DEFAULT 3)",
"fields": [
{
"fieldPath": "name",
"columnName": "medicineName",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "medicineId",
"columnName": "medicineId",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "color",
"columnName": "color",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "0xFFFF0000"
},
{
"fieldPath": "useColor",
"columnName": "useColor",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "false"
},
{
"fieldPath": "notificationImportance",
"columnName": "notificationImportance",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "3"
}
],
"primaryKey": {
"autoGenerate": true,
"columnNames": [
"medicineId"
]
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "Reminder",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`medicineRelId` INTEGER NOT NULL, `reminderId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `timeInMinutes` INTEGER NOT NULL, `createdTimestamp` INTEGER NOT NULL DEFAULT 0, `consecutiveDays` INTEGER NOT NULL DEFAULT 1, `pauseDays` INTEGER NOT NULL DEFAULT 0, `instructions` TEXT DEFAULT '', `cycleStartDay` INTEGER NOT NULL DEFAULT 19823, `amount` TEXT, `days` TEXT DEFAULT '[true, true, true, true, true, true, true]', `active` INTEGER NOT NULL DEFAULT true, `periodStart` INTEGER NOT NULL DEFAULT 0, `periodEnd` INTEGER NOT NULL DEFAULT 0)",
"fields": [
{
"fieldPath": "medicineRelId",
"columnName": "medicineRelId",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "reminderId",
"columnName": "reminderId",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "timeInMinutes",
"columnName": "timeInMinutes",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "createdTimestamp",
"columnName": "createdTimestamp",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "0"
},
{
"fieldPath": "consecutiveDays",
"columnName": "consecutiveDays",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "1"
},
{
"fieldPath": "pauseDays",
"columnName": "pauseDays",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "0"
},
{
"fieldPath": "instructions",
"columnName": "instructions",
"affinity": "TEXT",
"notNull": false,
"defaultValue": "''"
},
{
"fieldPath": "cycleStartDay",
"columnName": "cycleStartDay",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "19823"
},
{
"fieldPath": "amount",
"columnName": "amount",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "days",
"columnName": "days",
"affinity": "TEXT",
"notNull": false,
"defaultValue": "'[true, true, true, true, true, true, true]'"
},
{
"fieldPath": "active",
"columnName": "active",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "true"
},
{
"fieldPath": "periodStart",
"columnName": "periodStart",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "0"
},
{
"fieldPath": "periodEnd",
"columnName": "periodEnd",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "0"
}
],
"primaryKey": {
"autoGenerate": true,
"columnNames": [
"reminderId"
]
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "ReminderEvent",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`reminderEventId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `medicineName` TEXT, `amount` TEXT, `color` INTEGER NOT NULL DEFAULT 0, `useColor` INTEGER NOT NULL DEFAULT false, `status` TEXT, `remindedTimestamp` INTEGER NOT NULL, `processedTimestamp` INTEGER NOT NULL, `reminderId` INTEGER NOT NULL, `notificationId` INTEGER NOT NULL DEFAULT 0)",
"fields": [
{
"fieldPath": "reminderEventId",
"columnName": "reminderEventId",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "medicineName",
"columnName": "medicineName",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "amount",
"columnName": "amount",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "color",
"columnName": "color",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "0"
},
{
"fieldPath": "useColor",
"columnName": "useColor",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "false"
},
{
"fieldPath": "status",
"columnName": "status",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "remindedTimestamp",
"columnName": "remindedTimestamp",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "processedTimestamp",
"columnName": "processedTimestamp",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "reminderId",
"columnName": "reminderId",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "notificationId",
"columnName": "notificationId",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "0"
}
],
"primaryKey": {
"autoGenerate": true,
"columnNames": [
"reminderEventId"
]
},
"indices": [],
"foreignKeys": []
}
],
"views": [],
"setupQueries": [
"CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
"INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, '529390d3ca0bf1c196236b6cc96dd4f3')"
]
}
}