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