]> git.ktnx.net Git - mobile-ledger.git/blob - app/schemas/net.ktnx.mobileledger.db.DB/49.json
really prepare 0.20.4 (48) for release
[mobile-ledger.git] / app / schemas / net.ktnx.mobileledger.db.DB / 49.json
1 {
2   "formatVersion": 1,
3   "database": {
4     "version": 49,
5     "identityHash": "ac17a190c6cd158bcb3eae9471522c6a",
6     "entities": [
7       {
8         "tableName": "patterns",
9         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `name` TEXT NOT NULL, `position` INTEGER NOT NULL, `regular_expression` TEXT NOT NULL, `transaction_description` TEXT, `transaction_description_match_group` INTEGER, `transaction_comment` TEXT, `transaction_comment_match_group` INTEGER, `date_year` INTEGER, `date_year_match_group` INTEGER, `date_month` INTEGER, `date_month_match_group` INTEGER, `date_day` INTEGER, `date_day_match_group` INTEGER)",
10         "fields": [
11           {
12             "fieldPath": "id",
13             "columnName": "id",
14             "affinity": "INTEGER",
15             "notNull": true
16           },
17           {
18             "fieldPath": "name",
19             "columnName": "name",
20             "affinity": "TEXT",
21             "notNull": true
22           },
23           {
24             "fieldPath": "position",
25             "columnName": "position",
26             "affinity": "INTEGER",
27             "notNull": true
28           },
29           {
30             "fieldPath": "regularExpression",
31             "columnName": "regular_expression",
32             "affinity": "TEXT",
33             "notNull": true
34           },
35           {
36             "fieldPath": "transactionDescription",
37             "columnName": "transaction_description",
38             "affinity": "TEXT",
39             "notNull": false
40           },
41           {
42             "fieldPath": "transactionDescriptionMatchGroup",
43             "columnName": "transaction_description_match_group",
44             "affinity": "INTEGER",
45             "notNull": false
46           },
47           {
48             "fieldPath": "transactionComment",
49             "columnName": "transaction_comment",
50             "affinity": "TEXT",
51             "notNull": false
52           },
53           {
54             "fieldPath": "transactionCommentMatchGroup",
55             "columnName": "transaction_comment_match_group",
56             "affinity": "INTEGER",
57             "notNull": false
58           },
59           {
60             "fieldPath": "dateYear",
61             "columnName": "date_year",
62             "affinity": "INTEGER",
63             "notNull": false
64           },
65           {
66             "fieldPath": "dateYearMatchGroup",
67             "columnName": "date_year_match_group",
68             "affinity": "INTEGER",
69             "notNull": false
70           },
71           {
72             "fieldPath": "dateMonth",
73             "columnName": "date_month",
74             "affinity": "INTEGER",
75             "notNull": false
76           },
77           {
78             "fieldPath": "dateMonthMatchGroup",
79             "columnName": "date_month_match_group",
80             "affinity": "INTEGER",
81             "notNull": false
82           },
83           {
84             "fieldPath": "dateDay",
85             "columnName": "date_day",
86             "affinity": "INTEGER",
87             "notNull": false
88           },
89           {
90             "fieldPath": "dateDayMatchGroup",
91             "columnName": "date_day_match_group",
92             "affinity": "INTEGER",
93             "notNull": false
94           }
95         ],
96         "primaryKey": {
97           "columnNames": [
98             "id"
99           ],
100           "autoGenerate": true
101         },
102         "indices": [
103           {
104             "name": "un_patterns_id",
105             "unique": true,
106             "columnNames": [
107               "id"
108             ],
109             "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `un_patterns_id` ON `${TABLE_NAME}` (`id`)"
110           }
111         ],
112         "foreignKeys": []
113       },
114       {
115         "tableName": "pattern_accounts",
116         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pattern_id` INTEGER NOT NULL, `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `acc` TEXT, `position` INTEGER NOT NULL, `acc_match_group` INTEGER, `currency` INTEGER, `currency_match_group` INTEGER, `amount` REAL, `amount_match_group` INTEGER, `comment` TEXT, `comment_match_group` INTEGER, FOREIGN KEY(`pattern_id`) REFERENCES `patterns`(`id`) ON UPDATE NO ACTION ON DELETE NO ACTION , FOREIGN KEY(`currency`) REFERENCES `currencies`(`id`) ON UPDATE NO ACTION ON DELETE NO ACTION )",
117         "fields": [
118           {
119             "fieldPath": "patternId",
120             "columnName": "pattern_id",
121             "affinity": "INTEGER",
122             "notNull": true
123           },
124           {
125             "fieldPath": "id",
126             "columnName": "id",
127             "affinity": "INTEGER",
128             "notNull": true
129           },
130           {
131             "fieldPath": "accountName",
132             "columnName": "acc",
133             "affinity": "TEXT",
134             "notNull": false
135           },
136           {
137             "fieldPath": "position",
138             "columnName": "position",
139             "affinity": "INTEGER",
140             "notNull": true
141           },
142           {
143             "fieldPath": "accountNameMatchGroup",
144             "columnName": "acc_match_group",
145             "affinity": "INTEGER",
146             "notNull": false
147           },
148           {
149             "fieldPath": "currency",
150             "columnName": "currency",
151             "affinity": "INTEGER",
152             "notNull": false
153           },
154           {
155             "fieldPath": "currencyMatchGroup",
156             "columnName": "currency_match_group",
157             "affinity": "INTEGER",
158             "notNull": false
159           },
160           {
161             "fieldPath": "amount",
162             "columnName": "amount",
163             "affinity": "REAL",
164             "notNull": false
165           },
166           {
167             "fieldPath": "amountMatchGroup",
168             "columnName": "amount_match_group",
169             "affinity": "INTEGER",
170             "notNull": false
171           },
172           {
173             "fieldPath": "accountComment",
174             "columnName": "comment",
175             "affinity": "TEXT",
176             "notNull": false
177           },
178           {
179             "fieldPath": "accountCommentMatchGroup",
180             "columnName": "comment_match_group",
181             "affinity": "INTEGER",
182             "notNull": false
183           }
184         ],
185         "primaryKey": {
186           "columnNames": [
187             "id"
188           ],
189           "autoGenerate": true
190         },
191         "indices": [
192           {
193             "name": "un_pattern_accounts",
194             "unique": true,
195             "columnNames": [
196               "id"
197             ],
198             "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `un_pattern_accounts` ON `${TABLE_NAME}` (`id`)"
199           }
200         ],
201         "foreignKeys": [
202           {
203             "table": "patterns",
204             "onDelete": "NO ACTION",
205             "onUpdate": "NO ACTION",
206             "columns": [
207               "pattern_id"
208             ],
209             "referencedColumns": [
210               "id"
211             ]
212           },
213           {
214             "table": "currencies",
215             "onDelete": "NO ACTION",
216             "onUpdate": "NO ACTION",
217             "columns": [
218               "currency"
219             ],
220             "referencedColumns": [
221               "id"
222             ]
223           }
224         ]
225       },
226       {
227         "tableName": "currencies",
228         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `name` TEXT NOT NULL, `position` TEXT NOT NULL, `has_gap` INTEGER NOT NULL)",
229         "fields": [
230           {
231             "fieldPath": "id",
232             "columnName": "id",
233             "affinity": "INTEGER",
234             "notNull": true
235           },
236           {
237             "fieldPath": "name",
238             "columnName": "name",
239             "affinity": "TEXT",
240             "notNull": true
241           },
242           {
243             "fieldPath": "position",
244             "columnName": "position",
245             "affinity": "TEXT",
246             "notNull": true
247           },
248           {
249             "fieldPath": "hasGap",
250             "columnName": "has_gap",
251             "affinity": "INTEGER",
252             "notNull": true
253           }
254         ],
255         "primaryKey": {
256           "columnNames": [
257             "id"
258           ],
259           "autoGenerate": true
260         },
261         "indices": [],
262         "foreignKeys": []
263       }
264     ],
265     "views": [],
266     "setupQueries": [
267       "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
268       "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, 'ac17a190c6cd158bcb3eae9471522c6a')"
269     ]
270   }
271 }