1.json (3636B)
1 { 2 "formatVersion": 1, 3 "database": { 4 "version": 1, 5 "identityHash": "cf6d8bdd8e16b3f92043f9430524c80d", 6 "entities": [ 7 { 8 "tableName": "tab_collections", 9 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `title` TEXT NOT NULL, `updated_at` INTEGER NOT NULL, `created_at` INTEGER NOT NULL)", 10 "fields": [ 11 { 12 "fieldPath": "id", 13 "columnName": "id", 14 "affinity": "INTEGER", 15 "notNull": false 16 }, 17 { 18 "fieldPath": "title", 19 "columnName": "title", 20 "affinity": "TEXT", 21 "notNull": true 22 }, 23 { 24 "fieldPath": "updatedAt", 25 "columnName": "updated_at", 26 "affinity": "INTEGER", 27 "notNull": true 28 }, 29 { 30 "fieldPath": "createdAt", 31 "columnName": "created_at", 32 "affinity": "INTEGER", 33 "notNull": true 34 } 35 ], 36 "primaryKey": { 37 "columnNames": [ 38 "id" 39 ], 40 "autoGenerate": true 41 }, 42 "indices": [], 43 "foreignKeys": [] 44 }, 45 { 46 "tableName": "tabs", 47 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `title` TEXT NOT NULL, `url` TEXT NOT NULL, `stat_file` TEXT NOT NULL, `tab_collection_id` INTEGER NOT NULL, `created_at` INTEGER NOT NULL, FOREIGN KEY(`tab_collection_id`) REFERENCES `tab_collections`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE )", 48 "fields": [ 49 { 50 "fieldPath": "id", 51 "columnName": "id", 52 "affinity": "INTEGER", 53 "notNull": false 54 }, 55 { 56 "fieldPath": "title", 57 "columnName": "title", 58 "affinity": "TEXT", 59 "notNull": true 60 }, 61 { 62 "fieldPath": "url", 63 "columnName": "url", 64 "affinity": "TEXT", 65 "notNull": true 66 }, 67 { 68 "fieldPath": "stateFile", 69 "columnName": "stat_file", 70 "affinity": "TEXT", 71 "notNull": true 72 }, 73 { 74 "fieldPath": "tabCollectionId", 75 "columnName": "tab_collection_id", 76 "affinity": "INTEGER", 77 "notNull": true 78 }, 79 { 80 "fieldPath": "createdAt", 81 "columnName": "created_at", 82 "affinity": "INTEGER", 83 "notNull": true 84 } 85 ], 86 "primaryKey": { 87 "columnNames": [ 88 "id" 89 ], 90 "autoGenerate": true 91 }, 92 "indices": [ 93 { 94 "name": "index_tabs_tab_collection_id", 95 "unique": false, 96 "columnNames": [ 97 "tab_collection_id" 98 ], 99 "createSql": "CREATE INDEX `index_tabs_tab_collection_id` ON `${TABLE_NAME}` (`tab_collection_id`)" 100 } 101 ], 102 "foreignKeys": [ 103 { 104 "table": "tab_collections", 105 "onDelete": "CASCADE", 106 "onUpdate": "NO ACTION", 107 "columns": [ 108 "tab_collection_id" 109 ], 110 "referencedColumns": [ 111 "id" 112 ] 113 } 114 ] 115 } 116 ], 117 "setupQueries": [ 118 "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)", 119 "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, \"cf6d8bdd8e16b3f92043f9430524c80d\")" 120 ] 121 } 122 }