· 7 years ago · Oct 03, 2018, 08:00 PM
1{
2 "formatVersion": 1,
3 "database": {
4 "version": 1,
5 "identityHash": "b4b5c4981b24b731a84a2c6cd13f8c1a",
6 "entities": [
7 {
8 "tableName": "table_config",
9 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`uid` INTEGER NOT NULL, `visited` INTEGER NOT NULL, `banned` TEXT, `vip` TEXT, `grand` TEXT, `elo` INTEGER NOT NULL, `coins` INTEGER NOT NULL, `medals` INTEGER NOT NULL, PRIMARY KEY(`uid`))",
10 "fields": [
11 {
12 "fieldPath": "uid",
13 "columnName": "uid",
14 "affinity": "INTEGER",
15 "notNull": true
16 },
17 {
18 "fieldPath": "visited",
19 "columnName": "visited",
20 "affinity": "INTEGER",
21 "notNull": true
22 },
23 {
24 "fieldPath": "banned",
25 "columnName": "banned",
26 "affinity": "TEXT",
27 "notNull": false
28 },
29 {
30 "fieldPath": "vip",
31 "columnName": "vip",
32 "affinity": "TEXT",
33 "notNull": false
34 },
35 {
36 "fieldPath": "grand",
37 "columnName": "grand",
38 "affinity": "TEXT",
39 "notNull": false
40 },
41 {
42 "fieldPath": "elo",
43 "columnName": "elo",
44 "affinity": "INTEGER",
45 "notNull": true
46 },
47 {
48 "fieldPath": "coins",
49 "columnName": "coins",
50 "affinity": "INTEGER",
51 "notNull": true
52 },
53 {
54 "fieldPath": "medals",
55 "columnName": "medals",
56 "affinity": "INTEGER",
57 "notNull": true
58 }
59 ],
60 "primaryKey": {
61 "columnNames": [
62 "uid"
63 ],
64 "autoGenerate": false
65 },
66 "indices": [],
67 "foreignKeys": []
68 },
69 {
70 "tableName": "table_games",
71 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`gid` INTEGER NOT NULL, `bid` INTEGER NOT NULL, `chat1` INTEGER NOT NULL, `created` INTEGER NOT NULL, `expire1` INTEGER NOT NULL, `expire2` INTEGER NOT NULL, `finished` INTEGER NOT NULL, `pilelen` INTEGER NOT NULL, `played1` INTEGER NOT NULL, `played2` INTEGER NOT NULL, `player1` INTEGER NOT NULL, `player2` INTEGER NOT NULL, `score` INTEGER NOT NULL, `score1` INTEGER NOT NULL, `score2` INTEGER NOT NULL, `given1` TEXT NOT NULL, `given2` TEXT, `hint1` TEXT, `photo1` TEXT, `photo2` TEXT, `reason` TEXT, `state1` TEXT, `hand1` TEXT NOT NULL, `pile` TEXT NOT NULL, `tiles` TEXT NOT NULL, `letters` TEXT NOT NULL, `values` TEXT NOT NULL, PRIMARY KEY(`gid`))",
72 "fields": [
73 {
74 "fieldPath": "gid",
75 "columnName": "gid",
76 "affinity": "INTEGER",
77 "notNull": true
78 },
79 {
80 "fieldPath": "bid",
81 "columnName": "bid",
82 "affinity": "INTEGER",
83 "notNull": true
84 },
85 {
86 "fieldPath": "chat1",
87 "columnName": "chat1",
88 "affinity": "INTEGER",
89 "notNull": true
90 },
91 {
92 "fieldPath": "created",
93 "columnName": "created",
94 "affinity": "INTEGER",
95 "notNull": true
96 },
97 {
98 "fieldPath": "expire1",
99 "columnName": "expire1",
100 "affinity": "INTEGER",
101 "notNull": true
102 },
103 {
104 "fieldPath": "expire2",
105 "columnName": "expire2",
106 "affinity": "INTEGER",
107 "notNull": true
108 },
109 {
110 "fieldPath": "finished",
111 "columnName": "finished",
112 "affinity": "INTEGER",
113 "notNull": true
114 },
115 {
116 "fieldPath": "pilelen",
117 "columnName": "pilelen",
118 "affinity": "INTEGER",
119 "notNull": true
120 },
121 {
122 "fieldPath": "played1",
123 "columnName": "played1",
124 "affinity": "INTEGER",
125 "notNull": true
126 },
127 {
128 "fieldPath": "played2",
129 "columnName": "played2",
130 "affinity": "INTEGER",
131 "notNull": true
132 },
133 {
134 "fieldPath": "player1",
135 "columnName": "player1",
136 "affinity": "INTEGER",
137 "notNull": true
138 },
139 {
140 "fieldPath": "player2",
141 "columnName": "player2",
142 "affinity": "INTEGER",
143 "notNull": true
144 },
145 {
146 "fieldPath": "score",
147 "columnName": "score",
148 "affinity": "INTEGER",
149 "notNull": true
150 },
151 {
152 "fieldPath": "score1",
153 "columnName": "score1",
154 "affinity": "INTEGER",
155 "notNull": true
156 },
157 {
158 "fieldPath": "score2",
159 "columnName": "score2",
160 "affinity": "INTEGER",
161 "notNull": true
162 },
163 {
164 "fieldPath": "given1",
165 "columnName": "given1",
166 "affinity": "TEXT",
167 "notNull": true
168 },
169 {
170 "fieldPath": "given2",
171 "columnName": "given2",
172 "affinity": "TEXT",
173 "notNull": false
174 },
175 {
176 "fieldPath": "hint1",
177 "columnName": "hint1",
178 "affinity": "TEXT",
179 "notNull": false
180 },
181 {
182 "fieldPath": "photo1",
183 "columnName": "photo1",
184 "affinity": "TEXT",
185 "notNull": false
186 },
187 {
188 "fieldPath": "photo2",
189 "columnName": "photo2",
190 "affinity": "TEXT",
191 "notNull": false
192 },
193 {
194 "fieldPath": "reason",
195 "columnName": "reason",
196 "affinity": "TEXT",
197 "notNull": false
198 },
199 {
200 "fieldPath": "state1",
201 "columnName": "state1",
202 "affinity": "TEXT",
203 "notNull": false
204 },
205 {
206 "fieldPath": "hand1",
207 "columnName": "hand1",
208 "affinity": "TEXT",
209 "notNull": true
210 },
211 {
212 "fieldPath": "pile",
213 "columnName": "pile",
214 "affinity": "TEXT",
215 "notNull": true
216 },
217 {
218 "fieldPath": "tiles",
219 "columnName": "tiles",
220 "affinity": "TEXT",
221 "notNull": true
222 },
223 {
224 "fieldPath": "letters",
225 "columnName": "letters",
226 "affinity": "TEXT",
227 "notNull": true
228 },
229 {
230 "fieldPath": "values",
231 "columnName": "values",
232 "affinity": "TEXT",
233 "notNull": true
234 }
235 ],
236 "primaryKey": {
237 "columnNames": [
238 "gid"
239 ],
240 "autoGenerate": false
241 },
242 "indices": [],
243 "foreignKeys": []
244 },
245 {
246 "tableName": "table_social",
247 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`social` INTEGER NOT NULL, `sid` TEXT NOT NULL, `auth` TEXT NOT NULL, `given` TEXT NOT NULL, `family` TEXT, `photo` TEXT, `lat` REAL, `lng` REAL, `stamp` INTEGER NOT NULL, PRIMARY KEY(`social`))",
248 "fields": [
249 {
250 "fieldPath": "social",
251 "columnName": "social",
252 "affinity": "INTEGER",
253 "notNull": true
254 },
255 {
256 "fieldPath": "sid",
257 "columnName": "sid",
258 "affinity": "TEXT",
259 "notNull": true
260 },
261 {
262 "fieldPath": "auth",
263 "columnName": "auth",
264 "affinity": "TEXT",
265 "notNull": true
266 },
267 {
268 "fieldPath": "given",
269 "columnName": "given",
270 "affinity": "TEXT",
271 "notNull": true
272 },
273 {
274 "fieldPath": "family",
275 "columnName": "family",
276 "affinity": "TEXT",
277 "notNull": false
278 },
279 {
280 "fieldPath": "photo",
281 "columnName": "photo",
282 "affinity": "TEXT",
283 "notNull": false
284 },
285 {
286 "fieldPath": "lat",
287 "columnName": "lat",
288 "affinity": "REAL",
289 "notNull": false
290 },
291 {
292 "fieldPath": "lng",
293 "columnName": "lng",
294 "affinity": "REAL",
295 "notNull": false
296 },
297 {
298 "fieldPath": "stamp",
299 "columnName": "stamp",
300 "affinity": "INTEGER",
301 "notNull": true
302 }
303 ],
304 "primaryKey": {
305 "columnNames": [
306 "social"
307 ],
308 "autoGenerate": false
309 },
310 "indices": [],
311 "foreignKeys": []
312 },
313 {
314 "tableName": "table_words",
315 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`word` TEXT NOT NULL, `expl` TEXT, PRIMARY KEY(`word`))",
316 "fields": [
317 {
318 "fieldPath": "word",
319 "columnName": "word",
320 "affinity": "TEXT",
321 "notNull": true
322 },
323 {
324 "fieldPath": "expl",
325 "columnName": "expl",
326 "affinity": "TEXT",
327 "notNull": false
328 }
329 ],
330 "primaryKey": {
331 "columnNames": [
332 "word"
333 ],
334 "autoGenerate": false
335 },
336 "indices": [],
337 "foreignKeys": []
338 }
339 ],
340 "setupQueries": [
341 "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
342 "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, \"b4b5c4981b24b731a84a2c6cd13f8c1a\")"
343 ]
344 }
345}