4.json (6171B)
1 { 2 "formatVersion": 1, 3 "database": { 4 "version": 4, 5 "identityHash": "cc5b4d41781399f6ab7f123c10546acc", 6 "entities": [ 7 { 8 "tableName": "stories", 9 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`url` TEXT NOT NULL, `title` TEXT NOT NULL, `imageUrl` TEXT NOT NULL, `publisher` TEXT NOT NULL, `category` TEXT NOT NULL, `timeToRead` INTEGER NOT NULL, `timesShown` INTEGER NOT NULL, PRIMARY KEY(`url`))", 10 "fields": [ 11 { 12 "fieldPath": "url", 13 "columnName": "url", 14 "affinity": "TEXT", 15 "notNull": true 16 }, 17 { 18 "fieldPath": "title", 19 "columnName": "title", 20 "affinity": "TEXT", 21 "notNull": true 22 }, 23 { 24 "fieldPath": "imageUrl", 25 "columnName": "imageUrl", 26 "affinity": "TEXT", 27 "notNull": true 28 }, 29 { 30 "fieldPath": "publisher", 31 "columnName": "publisher", 32 "affinity": "TEXT", 33 "notNull": true 34 }, 35 { 36 "fieldPath": "category", 37 "columnName": "category", 38 "affinity": "TEXT", 39 "notNull": true 40 }, 41 { 42 "fieldPath": "timeToRead", 43 "columnName": "timeToRead", 44 "affinity": "INTEGER", 45 "notNull": true 46 }, 47 { 48 "fieldPath": "timesShown", 49 "columnName": "timesShown", 50 "affinity": "INTEGER", 51 "notNull": true 52 } 53 ], 54 "primaryKey": { 55 "columnNames": [ 56 "url" 57 ], 58 "autoGenerate": false 59 }, 60 "indices": [], 61 "foreignKeys": [] 62 }, 63 { 64 "tableName": "spocs", 65 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `url` TEXT NOT NULL, `title` TEXT NOT NULL, `imageUrl` TEXT NOT NULL, `sponsor` TEXT NOT NULL, `clickShim` TEXT NOT NULL, `impressionShim` TEXT NOT NULL, `priority` INTEGER NOT NULL, `lifetimeCapCount` INTEGER NOT NULL, `flightCapCount` INTEGER NOT NULL, `flightCapPeriod` INTEGER NOT NULL, PRIMARY KEY(`id`))", 66 "fields": [ 67 { 68 "fieldPath": "id", 69 "columnName": "id", 70 "affinity": "INTEGER", 71 "notNull": true 72 }, 73 { 74 "fieldPath": "url", 75 "columnName": "url", 76 "affinity": "TEXT", 77 "notNull": true 78 }, 79 { 80 "fieldPath": "title", 81 "columnName": "title", 82 "affinity": "TEXT", 83 "notNull": true 84 }, 85 { 86 "fieldPath": "imageUrl", 87 "columnName": "imageUrl", 88 "affinity": "TEXT", 89 "notNull": true 90 }, 91 { 92 "fieldPath": "sponsor", 93 "columnName": "sponsor", 94 "affinity": "TEXT", 95 "notNull": true 96 }, 97 { 98 "fieldPath": "clickShim", 99 "columnName": "clickShim", 100 "affinity": "TEXT", 101 "notNull": true 102 }, 103 { 104 "fieldPath": "impressionShim", 105 "columnName": "impressionShim", 106 "affinity": "TEXT", 107 "notNull": true 108 }, 109 { 110 "fieldPath": "priority", 111 "columnName": "priority", 112 "affinity": "INTEGER", 113 "notNull": true 114 }, 115 { 116 "fieldPath": "lifetimeCapCount", 117 "columnName": "lifetimeCapCount", 118 "affinity": "INTEGER", 119 "notNull": true 120 }, 121 { 122 "fieldPath": "flightCapCount", 123 "columnName": "flightCapCount", 124 "affinity": "INTEGER", 125 "notNull": true 126 }, 127 { 128 "fieldPath": "flightCapPeriod", 129 "columnName": "flightCapPeriod", 130 "affinity": "INTEGER", 131 "notNull": true 132 } 133 ], 134 "primaryKey": { 135 "columnNames": [ 136 "id" 137 ], 138 "autoGenerate": false 139 }, 140 "indices": [], 141 "foreignKeys": [] 142 }, 143 { 144 "tableName": "spocs_impressions", 145 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`spocId` INTEGER NOT NULL, `impressionId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `impressionDateInSeconds` INTEGER NOT NULL, FOREIGN KEY(`spocId`) REFERENCES `spocs`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE )", 146 "fields": [ 147 { 148 "fieldPath": "spocId", 149 "columnName": "spocId", 150 "affinity": "INTEGER", 151 "notNull": true 152 }, 153 { 154 "fieldPath": "impressionId", 155 "columnName": "impressionId", 156 "affinity": "INTEGER", 157 "notNull": true 158 }, 159 { 160 "fieldPath": "impressionDateInSeconds", 161 "columnName": "impressionDateInSeconds", 162 "affinity": "INTEGER", 163 "notNull": true 164 } 165 ], 166 "primaryKey": { 167 "columnNames": [ 168 "impressionId" 169 ], 170 "autoGenerate": true 171 }, 172 "indices": [ 173 { 174 "name": "index_spocs_impressions_spocId", 175 "unique": false, 176 "columnNames": [ 177 "spocId" 178 ], 179 "orders": [], 180 "createSql": "CREATE INDEX IF NOT EXISTS `index_spocs_impressions_spocId` ON `${TABLE_NAME}` (`spocId`)" 181 } 182 ], 183 "foreignKeys": [ 184 { 185 "table": "spocs", 186 "onDelete": "CASCADE", 187 "onUpdate": "NO ACTION", 188 "columns": [ 189 "spocId" 190 ], 191 "referencedColumns": [ 192 "id" 193 ] 194 } 195 ] 196 } 197 ], 198 "views": [], 199 "setupQueries": [ 200 "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)", 201 "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, 'cc5b4d41781399f6ab7f123c10546acc')" 202 ] 203 } 204 }