3.json (7605B)
1 { 2 "formatVersion": 1, 3 "database": { 4 "version": 3, 5 "identityHash": "f5749abb17fccdddf795c446e17b96b6", 6 "entities": [ 7 { 8 "tableName": "content_recommendations", 9 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`corpusItemId` TEXT NOT NULL, `scheduledCorpusItemId` TEXT NOT NULL, `url` TEXT NOT NULL, `title` TEXT NOT NULL, `excerpt` TEXT NOT NULL, `topic` TEXT, `publisher` TEXT NOT NULL, `isTimeSensitive` INTEGER NOT NULL, `imageUrl` TEXT NOT NULL, `tileId` INTEGER NOT NULL, `receivedRank` INTEGER NOT NULL, `recommendedAt` INTEGER NOT NULL, `impressions` INTEGER NOT NULL, PRIMARY KEY(`corpusItemId`))", 10 "fields": [ 11 { 12 "fieldPath": "corpusItemId", 13 "columnName": "corpusItemId", 14 "affinity": "TEXT", 15 "notNull": true 16 }, 17 { 18 "fieldPath": "scheduledCorpusItemId", 19 "columnName": "scheduledCorpusItemId", 20 "affinity": "TEXT", 21 "notNull": true 22 }, 23 { 24 "fieldPath": "url", 25 "columnName": "url", 26 "affinity": "TEXT", 27 "notNull": true 28 }, 29 { 30 "fieldPath": "title", 31 "columnName": "title", 32 "affinity": "TEXT", 33 "notNull": true 34 }, 35 { 36 "fieldPath": "excerpt", 37 "columnName": "excerpt", 38 "affinity": "TEXT", 39 "notNull": true 40 }, 41 { 42 "fieldPath": "topic", 43 "columnName": "topic", 44 "affinity": "TEXT", 45 "notNull": false 46 }, 47 { 48 "fieldPath": "publisher", 49 "columnName": "publisher", 50 "affinity": "TEXT", 51 "notNull": true 52 }, 53 { 54 "fieldPath": "isTimeSensitive", 55 "columnName": "isTimeSensitive", 56 "affinity": "INTEGER", 57 "notNull": true 58 }, 59 { 60 "fieldPath": "imageUrl", 61 "columnName": "imageUrl", 62 "affinity": "TEXT", 63 "notNull": true 64 }, 65 { 66 "fieldPath": "tileId", 67 "columnName": "tileId", 68 "affinity": "INTEGER", 69 "notNull": true 70 }, 71 { 72 "fieldPath": "receivedRank", 73 "columnName": "receivedRank", 74 "affinity": "INTEGER", 75 "notNull": true 76 }, 77 { 78 "fieldPath": "recommendedAt", 79 "columnName": "recommendedAt", 80 "affinity": "INTEGER", 81 "notNull": true 82 }, 83 { 84 "fieldPath": "impressions", 85 "columnName": "impressions", 86 "affinity": "INTEGER", 87 "notNull": true 88 } 89 ], 90 "primaryKey": { 91 "autoGenerate": false, 92 "columnNames": [ 93 "corpusItemId" 94 ] 95 }, 96 "indices": [], 97 "foreignKeys": [] 98 }, 99 { 100 "tableName": "sponsored_content", 101 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`url` TEXT NOT NULL, `title` TEXT NOT NULL, `clickUrl` TEXT NOT NULL, `impressionUrl` TEXT NOT NULL, `imageUrl` TEXT NOT NULL, `domain` TEXT NOT NULL, `excerpt` TEXT NOT NULL, `sponsor` TEXT NOT NULL, `blockKey` TEXT NOT NULL, `flightCapCount` INTEGER NOT NULL, `flightCapPeriod` INTEGER NOT NULL, `priority` INTEGER NOT NULL, PRIMARY KEY(`url`))", 102 "fields": [ 103 { 104 "fieldPath": "url", 105 "columnName": "url", 106 "affinity": "TEXT", 107 "notNull": true 108 }, 109 { 110 "fieldPath": "title", 111 "columnName": "title", 112 "affinity": "TEXT", 113 "notNull": true 114 }, 115 { 116 "fieldPath": "clickUrl", 117 "columnName": "clickUrl", 118 "affinity": "TEXT", 119 "notNull": true 120 }, 121 { 122 "fieldPath": "impressionUrl", 123 "columnName": "impressionUrl", 124 "affinity": "TEXT", 125 "notNull": true 126 }, 127 { 128 "fieldPath": "imageUrl", 129 "columnName": "imageUrl", 130 "affinity": "TEXT", 131 "notNull": true 132 }, 133 { 134 "fieldPath": "domain", 135 "columnName": "domain", 136 "affinity": "TEXT", 137 "notNull": true 138 }, 139 { 140 "fieldPath": "excerpt", 141 "columnName": "excerpt", 142 "affinity": "TEXT", 143 "notNull": true 144 }, 145 { 146 "fieldPath": "sponsor", 147 "columnName": "sponsor", 148 "affinity": "TEXT", 149 "notNull": true 150 }, 151 { 152 "fieldPath": "blockKey", 153 "columnName": "blockKey", 154 "affinity": "TEXT", 155 "notNull": true 156 }, 157 { 158 "fieldPath": "flightCapCount", 159 "columnName": "flightCapCount", 160 "affinity": "INTEGER", 161 "notNull": true 162 }, 163 { 164 "fieldPath": "flightCapPeriod", 165 "columnName": "flightCapPeriod", 166 "affinity": "INTEGER", 167 "notNull": true 168 }, 169 { 170 "fieldPath": "priority", 171 "columnName": "priority", 172 "affinity": "INTEGER", 173 "notNull": true 174 } 175 ], 176 "primaryKey": { 177 "autoGenerate": false, 178 "columnNames": [ 179 "url" 180 ] 181 }, 182 "indices": [], 183 "foreignKeys": [] 184 }, 185 { 186 "tableName": "sponsored_content_impressions", 187 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`url` TEXT NOT NULL, `impressionId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `impressionDateInSeconds` INTEGER NOT NULL, FOREIGN KEY(`url`) REFERENCES `sponsored_content`(`url`) ON UPDATE NO ACTION ON DELETE CASCADE )", 188 "fields": [ 189 { 190 "fieldPath": "url", 191 "columnName": "url", 192 "affinity": "TEXT", 193 "notNull": true 194 }, 195 { 196 "fieldPath": "impressionId", 197 "columnName": "impressionId", 198 "affinity": "INTEGER", 199 "notNull": true 200 }, 201 { 202 "fieldPath": "impressionDateInSeconds", 203 "columnName": "impressionDateInSeconds", 204 "affinity": "INTEGER", 205 "notNull": true 206 } 207 ], 208 "primaryKey": { 209 "autoGenerate": true, 210 "columnNames": [ 211 "impressionId" 212 ] 213 }, 214 "indices": [ 215 { 216 "name": "index_sponsored_content_impressions_url", 217 "unique": false, 218 "columnNames": [ 219 "url" 220 ], 221 "orders": [], 222 "createSql": "CREATE INDEX IF NOT EXISTS `index_sponsored_content_impressions_url` ON `${TABLE_NAME}` (`url`)" 223 } 224 ], 225 "foreignKeys": [ 226 { 227 "table": "sponsored_content", 228 "onDelete": "CASCADE", 229 "onUpdate": "NO ACTION", 230 "columns": [ 231 "url" 232 ], 233 "referencedColumns": [ 234 "url" 235 ] 236 } 237 ] 238 } 239 ], 240 "views": [], 241 "setupQueries": [ 242 "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)", 243 "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, 'f5749abb17fccdddf795c446e17b96b6')" 244 ] 245 } 246 }