· 5 years ago · Oct 20, 2020, 03:14 PM
1[
2 {
3 "formatVersion": 1,
4 "database": {
5 "version": 1,
6 "identityHash": "5c2dbd9d3c1b887fa18efb783e48fcfa",
7 "entities": [
8 {
9 "tableName": "QuoteRow",
10 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`symbol` TEXT NOT NULL, `name` TEXT NOT NULL, `last_trade_price` REAL NOT NULL, `change_percent` REAL NOT NULL, `change` REAL NOT NULL, `exchange` TEXT NOT NULL, `currency` TEXT NOT NULL, `description` TEXT NOT NULL, PRIMARY KEY(`symbol`))",
11 "fields": [
12 {
13 "fieldPath": "symbol",
14 "columnName": "symbol",
15 "affinity": "TEXT",
16 "notNull": true
17 },
18 {
19 "fieldPath": "name",
20 "columnName": "name",
21 "affinity": "TEXT",
22 "notNull": true
23 },
24 {
25 "fieldPath": "lastTradePrice",
26 "columnName": "last_trade_price",
27 "affinity": "REAL",
28 "notNull": true
29 },
30 {
31 "fieldPath": "changeInPercent",
32 "columnName": "change_percent",
33 "affinity": "REAL",
34 "notNull": true
35 },
36 {
37 "fieldPath": "change",
38 "columnName": "change",
39 "affinity": "REAL",
40 "notNull": true
41 },
42 {
43 "fieldPath": "stockExchange",
44 "columnName": "exchange",
45 "affinity": "TEXT",
46 "notNull": true
47 },
48 {
49 "fieldPath": "currency",
50 "columnName": "currency",
51 "affinity": "TEXT",
52 "notNull": true
53 },
54 {
55 "fieldPath": "description",
56 "columnName": "description",
57 "affinity": "TEXT",
58 "notNull": true
59 }
60 ],
61 "primaryKey": {
62 "columnNames": [
63 "symbol"
64 ],
65 "autoGenerate": false
66 },
67 "indices": [],
68 "foreignKeys": []
69 },
70 {
71 "tableName": "HoldingRow",
72 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `quote_symbol` TEXT NOT NULL, `shares` REAL NOT NULL, `price` REAL NOT NULL)",
73 "fields": [
74 {
75 "fieldPath": "id",
76 "columnName": "id",
77 "affinity": "INTEGER",
78 "notNull": false
79 },
80 {
81 "fieldPath": "quoteSymbol",
82 "columnName": "quote_symbol",
83 "affinity": "TEXT",
84 "notNull": true
85 },
86 {
87 "fieldPath": "shares",
88 "columnName": "shares",
89 "affinity": "REAL",
90 "notNull": true
91 },
92 {
93 "fieldPath": "price",
94 "columnName": "price",
95 "affinity": "REAL",
96 "notNull": true
97 }
98 ],
99 "primaryKey": {
100 "columnNames": [
101 "id"
102 ],
103 "autoGenerate": true
104 },
105 "indices": [],
106 "foreignKeys": []
107 }
108 ],
109 "views": [],
110 "setupQueries": [
111 "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
112 "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, '5c2dbd9d3c1b887fa18efb783e48fcfa')"
113 ]
114 }
115 },
116 {
117 "formatVersion": 1,
118 "database": {
119 "version": 2,
120 "identityHash": "ab186383424cdc864d156bd76b58b280",
121 "entities": [
122 {
123 "tableName": "QuoteRow",
124 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`symbol` TEXT NOT NULL, `name` TEXT NOT NULL, `last_trade_price` REAL NOT NULL, `change_percent` REAL NOT NULL, `change` REAL NOT NULL, `exchange` TEXT NOT NULL, `currency` TEXT NOT NULL, `is_post_market` INTEGER NOT NULL, `annual_dividend_rate` REAL NOT NULL, `annual_dividend_yield` REAL NOT NULL, PRIMARY KEY(`symbol`))",
125 "fields": [
126 {
127 "fieldPath": "symbol",
128 "columnName": "symbol",
129 "affinity": "TEXT",
130 "notNull": true
131 },
132 {
133 "fieldPath": "name",
134 "columnName": "name",
135 "affinity": "TEXT",
136 "notNull": true
137 },
138 {
139 "fieldPath": "lastTradePrice",
140 "columnName": "last_trade_price",
141 "affinity": "REAL",
142 "notNull": true
143 },
144 {
145 "fieldPath": "changeInPercent",
146 "columnName": "change_percent",
147 "affinity": "REAL",
148 "notNull": true
149 },
150 {
151 "fieldPath": "change",
152 "columnName": "change",
153 "affinity": "REAL",
154 "notNull": true
155 },
156 {
157 "fieldPath": "stockExchange",
158 "columnName": "exchange",
159 "affinity": "TEXT",
160 "notNull": true
161 },
162 {
163 "fieldPath": "currency",
164 "columnName": "currency",
165 "affinity": "TEXT",
166 "notNull": true
167 },
168 {
169 "fieldPath": "isPostMarket",
170 "columnName": "is_post_market",
171 "affinity": "INTEGER",
172 "notNull": true
173 },
174 {
175 "fieldPath": "annualDividendRate",
176 "columnName": "annual_dividend_rate",
177 "affinity": "REAL",
178 "notNull": true
179 },
180 {
181 "fieldPath": "annualDividendYield",
182 "columnName": "annual_dividend_yield",
183 "affinity": "REAL",
184 "notNull": true
185 }
186 ],
187 "primaryKey": {
188 "columnNames": [
189 "symbol"
190 ],
191 "autoGenerate": false
192 },
193 "indices": [],
194 "foreignKeys": []
195 },
196 {
197 "tableName": "HoldingRow",
198 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `quote_symbol` TEXT NOT NULL, `shares` REAL NOT NULL, `price` REAL NOT NULL)",
199 "fields": [
200 {
201 "fieldPath": "id",
202 "columnName": "id",
203 "affinity": "INTEGER",
204 "notNull": false
205 },
206 {
207 "fieldPath": "quoteSymbol",
208 "columnName": "quote_symbol",
209 "affinity": "TEXT",
210 "notNull": true
211 },
212 {
213 "fieldPath": "shares",
214 "columnName": "shares",
215 "affinity": "REAL",
216 "notNull": true
217 },
218 {
219 "fieldPath": "price",
220 "columnName": "price",
221 "affinity": "REAL",
222 "notNull": true
223 }
224 ],
225 "primaryKey": {
226 "columnNames": [
227 "id"
228 ],
229 "autoGenerate": true
230 },
231 "indices": [],
232 "foreignKeys": []
233 },
234 {
235 "tableName": "PropertiesRow",
236 "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `properties_quote_symbol` TEXT NOT NULL, `notes` TEXT NOT NULL, `alert_above` REAL NOT NULL, `alert_below` REAL NOT NULL)",
237 "fields": [
238 {
239 "fieldPath": "id",
240 "columnName": "id",
241 "affinity": "INTEGER",
242 "notNull": false
243 },
244 {
245 "fieldPath": "quoteSymbol",
246 "columnName": "properties_quote_symbol",
247 "affinity": "TEXT",
248 "notNull": true
249 },
250 {
251 "fieldPath": "notes",
252 "columnName": "notes",
253 "affinity": "TEXT",
254 "notNull": true
255 },
256 {
257 "fieldPath": "alertAbove",
258 "columnName": "alert_above",
259 "affinity": "REAL",
260 "notNull": true
261 },
262 {
263 "fieldPath": "alertBelow",
264 "columnName": "alert_below",
265 "affinity": "REAL",
266 "notNull": true
267 }
268 ],
269 "primaryKey": {
270 "columnNames": [
271 "id"
272 ],
273 "autoGenerate": true
274 },
275 "indices": [],
276 "foreignKeys": []
277 }
278 ],
279 "views": [],
280 "setupQueries": [
281 "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
282 "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, 'ab186383424cdc864d156bd76b58b280')"
283 ]
284 }
285 }
286]