· 5 years ago · Apr 02, 2020, 01:00 PM
1{
2 "formatVersion": 1,
3 "database": {
4 "version": 4,
5 "identityHash": "36ce3937540013e94e9f2a51817eadb4",
6 "entities": [
7 {
8 "tableName": "Branding",
9 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` TEXT NOT NULL, `primaryColor` TEXT NOT NULL, `secondaryColor` TEXT NOT NULL, PRIMARY KEY(`id`))",
10 "fields": [
11 {
12 "fieldPath": "id",
13 "columnName": "id",
14 "affinity": "TEXT",
15 "notNull": true
16 },
17 {
18 "fieldPath": "primaryColor",
19 "columnName": "primaryColor",
20 "affinity": "TEXT",
21 "notNull": true
22 },
23 {
24 "fieldPath": "secondaryColor",
25 "columnName": "secondaryColor",
26 "affinity": "TEXT",
27 "notNull": true
28 }
29 ],
30 "primaryKey": {
31 "columnNames": [
32 "id"
33 ],
34 "autoGenerate": false
35 },
36 "indices": [],
37 "foreignKeys": []
38 },
39 {
40 "tableName": "Users",
41 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`externalId` TEXT NOT NULL, PRIMARY KEY(`externalId`))",
42 "fields": [
43 {
44 "fieldPath": "externalId",
45 "columnName": "externalId",
46 "affinity": "TEXT",
47 "notNull": true
48 }
49 ],
50 "primaryKey": {
51 "columnNames": [
52 "externalId"
53 ],
54 "autoGenerate": false
55 },
56 "indices": [],
57 "foreignKeys": []
58 },
59 {
60 "tableName": "Sessions",
61 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`accessToken` TEXT NOT NULL, `expiresIn` INTEGER NOT NULL, `receivedAt` INTEGER NOT NULL, `apiKey` TEXT NOT NULL, `environment` TEXT NOT NULL, PRIMARY KEY(`accessToken`))",
62 "fields": [
63 {
64 "fieldPath": "accessToken",
65 "columnName": "accessToken",
66 "affinity": "TEXT",
67 "notNull": true
68 },
69 {
70 "fieldPath": "expiresIn",
71 "columnName": "expiresIn",
72 "affinity": "INTEGER",
73 "notNull": true
74 },
75 {
76 "fieldPath": "receivedAt",
77 "columnName": "receivedAt",
78 "affinity": "INTEGER",
79 "notNull": true
80 },
81 {
82 "fieldPath": "apiKey",
83 "columnName": "apiKey",
84 "affinity": "TEXT",
85 "notNull": true
86 },
87 {
88 "fieldPath": "environment",
89 "columnName": "environment",
90 "affinity": "TEXT",
91 "notNull": true
92 }
93 ],
94 "primaryKey": {
95 "columnNames": [
96 "accessToken"
97 ],
98 "autoGenerate": false
99 },
100 "indices": [],
101 "foreignKeys": []
102 },
103 {
104 "tableName": "Channels",
105 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` TEXT NOT NULL, `title` TEXT NOT NULL, `profilePictureUrl` TEXT NOT NULL, `readStatus` TEXT NOT NULL, `pageCount` INTEGER NOT NULL, `initialPage` INTEGER NOT NULL, `sortOrder` INTEGER NOT NULL, `isDirty` INTEGER NOT NULL, PRIMARY KEY(`id`))",
106 "fields": [
107 {
108 "fieldPath": "id",
109 "columnName": "id",
110 "affinity": "TEXT",
111 "notNull": true
112 },
113 {
114 "fieldPath": "title",
115 "columnName": "title",
116 "affinity": "TEXT",
117 "notNull": true
118 },
119 {
120 "fieldPath": "profilePictureUrl",
121 "columnName": "profilePictureUrl",
122 "affinity": "TEXT",
123 "notNull": true
124 },
125 {
126 "fieldPath": "readStatus",
127 "columnName": "readStatus",
128 "affinity": "TEXT",
129 "notNull": true
130 },
131 {
132 "fieldPath": "pageCount",
133 "columnName": "pageCount",
134 "affinity": "INTEGER",
135 "notNull": true
136 },
137 {
138 "fieldPath": "initialPage",
139 "columnName": "initialPage",
140 "affinity": "INTEGER",
141 "notNull": true
142 },
143 {
144 "fieldPath": "sortOrder",
145 "columnName": "sortOrder",
146 "affinity": "INTEGER",
147 "notNull": true
148 },
149 {
150 "fieldPath": "isDirty",
151 "columnName": "isDirty",
152 "affinity": "INTEGER",
153 "notNull": true
154 }
155 ],
156 "primaryKey": {
157 "columnNames": [
158 "id"
159 ],
160 "autoGenerate": false
161 },
162 "indices": [],
163 "foreignKeys": []
164 },
165 {
166 "tableName": "Pages",
167 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` TEXT NOT NULL, `channelId` TEXT NOT NULL, `type` TEXT NOT NULL, `url` TEXT NOT NULL, `playCardUrl` TEXT NOT NULL, `swipeUpUrl` TEXT NOT NULL, `swipeUpText` TEXT NOT NULL, `showSwipeUpUi` INTEGER NOT NULL, `duration` INTEGER NOT NULL, `readStatus` TEXT NOT NULL, `skippable` INTEGER NOT NULL, `sortOrder` INTEGER NOT NULL, `isDirty` INTEGER NOT NULL, PRIMARY KEY(`id`), FOREIGN KEY(`channelId`) REFERENCES `Channels`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)",
168 "fields": [
169 {
170 "fieldPath": "id",
171 "columnName": "id",
172 "affinity": "TEXT",
173 "notNull": true
174 },
175 {
176 "fieldPath": "channelId",
177 "columnName": "channelId",
178 "affinity": "TEXT",
179 "notNull": true
180 },
181 {
182 "fieldPath": "type",
183 "columnName": "type",
184 "affinity": "TEXT",
185 "notNull": true
186 },
187 {
188 "fieldPath": "url",
189 "columnName": "url",
190 "affinity": "TEXT",
191 "notNull": true
192 },
193 {
194 "fieldPath": "playCardUrl",
195 "columnName": "playCardUrl",
196 "affinity": "TEXT",
197 "notNull": true
198 },
199 {
200 "fieldPath": "swipeUpUrl",
201 "columnName": "swipeUpUrl",
202 "affinity": "TEXT",
203 "notNull": true
204 },
205 {
206 "fieldPath": "swipeUpText",
207 "columnName": "swipeUpText",
208 "affinity": "TEXT",
209 "notNull": true
210 },
211 {
212 "fieldPath": "showSwipeUpUi",
213 "columnName": "showSwipeUpUi",
214 "affinity": "INTEGER",
215 "notNull": true
216 },
217 {
218 "fieldPath": "duration",
219 "columnName": "duration",
220 "affinity": "INTEGER",
221 "notNull": true
222 },
223 {
224 "fieldPath": "readStatus",
225 "columnName": "readStatus",
226 "affinity": "TEXT",
227 "notNull": true
228 },
229 {
230 "fieldPath": "skippable",
231 "columnName": "skippable",
232 "affinity": "INTEGER",
233 "notNull": true
234 },
235 {
236 "fieldPath": "sortOrder",
237 "columnName": "sortOrder",
238 "affinity": "INTEGER",
239 "notNull": true
240 },
241 {
242 "fieldPath": "isDirty",
243 "columnName": "isDirty",
244 "affinity": "INTEGER",
245 "notNull": true
246 }
247 ],
248 "primaryKey": {
249 "columnNames": [
250 "id"
251 ],
252 "autoGenerate": false
253 },
254 "indices": [
255 {
256 "name": "index_Pages_id",
257 "unique": false,
258 "columnNames": [
259 "id"
260 ],
261 "createSql": "CREATE INDEX `index_Pages_id` ON `${TABLE_NAME}` (`id`)"
262 },
263 {
264 "name": "index_Pages_channelId",
265 "unique": false,
266 "columnNames": [
267 "channelId"
268 ],
269 "createSql": "CREATE INDEX `index_Pages_channelId` ON `${TABLE_NAME}` (`channelId`)"
270 }
271 ],
272 "foreignKeys": [
273 {
274 "table": "Channels",
275 "onDelete": "CASCADE",
276 "onUpdate": "NO ACTION",
277 "columns": [
278 "channelId"
279 ],
280 "referencedColumns": [
281 "id"
282 ]
283 }
284 ]
285 },
286 {
287 "tableName": "Activities",
288 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `type` TEXT NOT NULL, `channelId` TEXT, `pageId` TEXT, `adId` TEXT)",
289 "fields": [
290 {
291 "fieldPath": "id",
292 "columnName": "id",
293 "affinity": "INTEGER",
294 "notNull": true
295 },
296 {
297 "fieldPath": "type",
298 "columnName": "type",
299 "affinity": "TEXT",
300 "notNull": true
301 },
302 {
303 "fieldPath": "channelId",
304 "columnName": "channelId",
305 "affinity": "TEXT",
306 "notNull": false
307 },
308 {
309 "fieldPath": "pageId",
310 "columnName": "pageId",
311 "affinity": "TEXT",
312 "notNull": false
313 },
314 {
315 "fieldPath": "adId",
316 "columnName": "adId",
317 "affinity": "TEXT",
318 "notNull": false
319 }
320 ],
321 "primaryKey": {
322 "columnNames": [
323 "id"
324 ],
325 "autoGenerate": true
326 },
327 "indices": [],
328 "foreignKeys": []
329 }
330 ],
331 "setupQueries": [
332 "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
333 "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, \"36ce3937540013e94e9f2a51817eadb4\")"
334 ]
335 }
336}