]> git.ktnx.net Git - mobile-ledger.git/blob - app/schemas/net.ktnx.mobileledger.db.DB/46.json
no need for gravity, only one edge is constrained anyway
[mobile-ledger.git] / app / schemas / net.ktnx.mobileledger.db.DB / 46.json
1 {
2   "formatVersion": 1,
3   "database": {
4     "version": 46,
5     "identityHash": "52e5cab6607fcee6f0cd8d39ba38415a",
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         "foreignKeys": []
104       },
105       {
106         "tableName": "pattern_accounts",
107         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `pattern_id` INTEGER, `acc` TEXT, `position` INTEGER, `acc_match_group` INTEGER, `currency` INTEGER, `currency_match_group` INTEGER, `amount` REAL, `amount_match_group` INTEGER, `comment` TEXT, `comment_match_group` INTEGER)",
108         "fields": [
109           {
110             "fieldPath": "id",
111             "columnName": "id",
112             "affinity": "INTEGER",
113             "notNull": false
114           },
115           {
116             "fieldPath": "patternId",
117             "columnName": "pattern_id",
118             "affinity": "INTEGER",
119             "notNull": false
120           },
121           {
122             "fieldPath": "accountName",
123             "columnName": "acc",
124             "affinity": "TEXT",
125             "notNull": false
126           },
127           {
128             "fieldPath": "position",
129             "columnName": "position",
130             "affinity": "INTEGER",
131             "notNull": false
132           },
133           {
134             "fieldPath": "accountNameMatchGroup",
135             "columnName": "acc_match_group",
136             "affinity": "INTEGER",
137             "notNull": false
138           },
139           {
140             "fieldPath": "currency",
141             "columnName": "currency",
142             "affinity": "INTEGER",
143             "notNull": false
144           },
145           {
146             "fieldPath": "currencyMatchGroup",
147             "columnName": "currency_match_group",
148             "affinity": "INTEGER",
149             "notNull": false
150           },
151           {
152             "fieldPath": "amount",
153             "columnName": "amount",
154             "affinity": "REAL",
155             "notNull": false
156           },
157           {
158             "fieldPath": "amountMatchGroup",
159             "columnName": "amount_match_group",
160             "affinity": "INTEGER",
161             "notNull": false
162           },
163           {
164             "fieldPath": "accountComment",
165             "columnName": "comment",
166             "affinity": "TEXT",
167             "notNull": false
168           },
169           {
170             "fieldPath": "accountCommentMatchGroup",
171             "columnName": "comment_match_group",
172             "affinity": "INTEGER",
173             "notNull": false
174           }
175         ],
176         "primaryKey": {
177           "columnNames": [
178             "id"
179           ],
180           "autoGenerate": true
181         },
182         "indices": [],
183         "foreignKeys": []
184       }
185     ],
186     "views": [],
187     "setupQueries": [
188       "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
189       "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, '52e5cab6607fcee6f0cd8d39ba38415a')"
190     ]
191   }
192 }