diff options
| author | Allan Wang <me@allanwang.ca> | 2019-03-07 14:59:40 -0500 |
|---|---|---|
| committer | Allan Wang <me@allanwang.ca> | 2019-03-07 14:59:40 -0500 |
| commit | 12f491737ec2e2d774a816e84170ff352d1b6cd6 (patch) | |
| tree | f61b20f5ba7630fecef50976733e26fbc4ef5a52 /app/src/schemas | |
| parent | f1878133d8af686ce8c27acffe28f26e9dda5165 (diff) | |
| download | frost-12f491737ec2e2d774a816e84170ff352d1b6cd6.tar.gz frost-12f491737ec2e2d774a816e84170ff352d1b6cd6.tar.bz2 frost-12f491737ec2e2d774a816e84170ff352d1b6cd6.zip | |
Add cache test
Diffstat (limited to 'app/src/schemas')
| -rw-r--r-- | app/src/schemas/com.pitchedapps.frost.db.FrostPrivateDatabase/1.json | 29 |
1 files changed, 24 insertions, 5 deletions
diff --git a/app/src/schemas/com.pitchedapps.frost.db.FrostPrivateDatabase/1.json b/app/src/schemas/com.pitchedapps.frost.db.FrostPrivateDatabase/1.json index 72b86db3..60d5cddd 100644 --- a/app/src/schemas/com.pitchedapps.frost.db.FrostPrivateDatabase/1.json +++ b/app/src/schemas/com.pitchedapps.frost.db.FrostPrivateDatabase/1.json @@ -2,7 +2,7 @@ "formatVersion": 1, "database": { "version": 1, - "identityHash": "099ffebd0f0fe80199c0f6413a549ebb", + "identityHash": "0a9d994786b7e07fea95c11d9210ce0e", "entities": [ { "tableName": "cookies", @@ -130,11 +130,17 @@ }, { "tableName": "frost_cache", - "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` TEXT NOT NULL, `lastUpdated` INTEGER NOT NULL, `contents` TEXT NOT NULL, PRIMARY KEY(`id`))", + "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `type` TEXT NOT NULL, `lastUpdated` INTEGER NOT NULL, `contents` TEXT NOT NULL, PRIMARY KEY(`id`, `type`), FOREIGN KEY(`id`) REFERENCES `cookies`(`cookie_id`) ON UPDATE NO ACTION ON DELETE CASCADE )", "fields": [ { "fieldPath": "id", "columnName": "id", + "affinity": "INTEGER", + "notNull": true + }, + { + "fieldPath": "type", + "columnName": "type", "affinity": "TEXT", "notNull": true }, @@ -153,18 +159,31 @@ ], "primaryKey": { "columnNames": [ - "id" + "id", + "type" ], "autoGenerate": false }, "indices": [], - "foreignKeys": [] + "foreignKeys": [ + { + "table": "cookies", + "onDelete": "CASCADE", + "onUpdate": "NO ACTION", + "columns": [ + "id" + ], + "referencedColumns": [ + "cookie_id" + ] + } + ] } ], "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, \"099ffebd0f0fe80199c0f6413a549ebb\")" + "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, \"0a9d994786b7e07fea95c11d9210ce0e\")" ] } }
\ No newline at end of file |