]> git.ktnx.net Git - mobile-ledger.git/blob - app/schemas/net.ktnx.mobileledger.db.DB/60.json
bump version of two test libraries
[mobile-ledger.git] / app / schemas / net.ktnx.mobileledger.db.DB / 60.json
1 {
2   "formatVersion": 1,
3   "database": {
4     "version": 60,
5     "identityHash": "b52e9a5f88719ae4a44e047ce81b34ee",
6     "entities": [
7       {
8         "tableName": "templates",
9         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `name` TEXT 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, `is_fallback` INTEGER NOT NULL)",
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": "regularExpression",
25             "columnName": "regular_expression",
26             "affinity": "TEXT",
27             "notNull": true
28           },
29           {
30             "fieldPath": "testText",
31             "columnName": "test_text",
32             "affinity": "TEXT",
33             "notNull": false
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             "fieldPath": "isFallback",
97             "columnName": "is_fallback",
98             "affinity": "INTEGER",
99             "notNull": true
100           }
101         ],
102         "primaryKey": {
103           "columnNames": [
104             "id"
105           ],
106           "autoGenerate": true
107         },
108         "indices": [],
109         "foreignKeys": []
110       },
111       {
112         "tableName": "template_accounts",
113         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `template_id` INTEGER 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, `negate_amount` INTEGER, FOREIGN KEY(`template_id`) REFERENCES `templates`(`id`) ON UPDATE RESTRICT ON DELETE CASCADE , FOREIGN KEY(`currency`) REFERENCES `currencies`(`id`) ON UPDATE RESTRICT ON DELETE RESTRICT )",
114         "fields": [
115           {
116             "fieldPath": "id",
117             "columnName": "id",
118             "affinity": "INTEGER",
119             "notNull": true
120           },
121           {
122             "fieldPath": "templateId",
123             "columnName": "template_id",
124             "affinity": "INTEGER",
125             "notNull": true
126           },
127           {
128             "fieldPath": "accountName",
129             "columnName": "acc",
130             "affinity": "TEXT",
131             "notNull": false
132           },
133           {
134             "fieldPath": "position",
135             "columnName": "position",
136             "affinity": "INTEGER",
137             "notNull": true
138           },
139           {
140             "fieldPath": "accountNameMatchGroup",
141             "columnName": "acc_match_group",
142             "affinity": "INTEGER",
143             "notNull": false
144           },
145           {
146             "fieldPath": "currency",
147             "columnName": "currency",
148             "affinity": "INTEGER",
149             "notNull": false
150           },
151           {
152             "fieldPath": "currencyMatchGroup",
153             "columnName": "currency_match_group",
154             "affinity": "INTEGER",
155             "notNull": false
156           },
157           {
158             "fieldPath": "amount",
159             "columnName": "amount",
160             "affinity": "REAL",
161             "notNull": false
162           },
163           {
164             "fieldPath": "amountMatchGroup",
165             "columnName": "amount_match_group",
166             "affinity": "INTEGER",
167             "notNull": false
168           },
169           {
170             "fieldPath": "accountComment",
171             "columnName": "comment",
172             "affinity": "TEXT",
173             "notNull": false
174           },
175           {
176             "fieldPath": "accountCommentMatchGroup",
177             "columnName": "comment_match_group",
178             "affinity": "INTEGER",
179             "notNull": false
180           },
181           {
182             "fieldPath": "negateAmount",
183             "columnName": "negate_amount",
184             "affinity": "INTEGER",
185             "notNull": false
186           }
187         ],
188         "primaryKey": {
189           "columnNames": [
190             "id"
191           ],
192           "autoGenerate": true
193         },
194         "indices": [
195           {
196             "name": "fk_template_accounts_template",
197             "unique": false,
198             "columnNames": [
199               "template_id"
200             ],
201             "createSql": "CREATE INDEX IF NOT EXISTS `fk_template_accounts_template` ON `${TABLE_NAME}` (`template_id`)"
202           },
203           {
204             "name": "fk_template_accounts_currency",
205             "unique": false,
206             "columnNames": [
207               "currency"
208             ],
209             "createSql": "CREATE INDEX IF NOT EXISTS `fk_template_accounts_currency` ON `${TABLE_NAME}` (`currency`)"
210           }
211         ],
212         "foreignKeys": [
213           {
214             "table": "templates",
215             "onDelete": "CASCADE",
216             "onUpdate": "RESTRICT",
217             "columns": [
218               "template_id"
219             ],
220             "referencedColumns": [
221               "id"
222             ]
223           },
224           {
225             "table": "currencies",
226             "onDelete": "RESTRICT",
227             "onUpdate": "RESTRICT",
228             "columns": [
229               "currency"
230             ],
231             "referencedColumns": [
232               "id"
233             ]
234           }
235         ]
236       },
237       {
238         "tableName": "currencies",
239         "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)",
240         "fields": [
241           {
242             "fieldPath": "id",
243             "columnName": "id",
244             "affinity": "INTEGER",
245             "notNull": true
246           },
247           {
248             "fieldPath": "name",
249             "columnName": "name",
250             "affinity": "TEXT",
251             "notNull": true
252           },
253           {
254             "fieldPath": "position",
255             "columnName": "position",
256             "affinity": "TEXT",
257             "notNull": true
258           },
259           {
260             "fieldPath": "hasGap",
261             "columnName": "has_gap",
262             "affinity": "INTEGER",
263             "notNull": true
264           }
265         ],
266         "primaryKey": {
267           "columnNames": [
268             "id"
269           ],
270           "autoGenerate": true
271         },
272         "indices": [],
273         "foreignKeys": []
274       },
275       {
276         "tableName": "accounts",
277         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `profile_id` INTEGER NOT NULL, `level` INTEGER NOT NULL, `name` TEXT NOT NULL, `name_upper` TEXT NOT NULL, `parent_name` TEXT, `expanded` INTEGER NOT NULL DEFAULT 1, `amounts_expanded` INTEGER NOT NULL DEFAULT 0, `generation` INTEGER NOT NULL DEFAULT 0, FOREIGN KEY(`profile_id`) REFERENCES `profiles`(`id`) ON UPDATE RESTRICT ON DELETE CASCADE )",
278         "fields": [
279           {
280             "fieldPath": "id",
281             "columnName": "id",
282             "affinity": "INTEGER",
283             "notNull": true
284           },
285           {
286             "fieldPath": "profileId",
287             "columnName": "profile_id",
288             "affinity": "INTEGER",
289             "notNull": true
290           },
291           {
292             "fieldPath": "level",
293             "columnName": "level",
294             "affinity": "INTEGER",
295             "notNull": true
296           },
297           {
298             "fieldPath": "name",
299             "columnName": "name",
300             "affinity": "TEXT",
301             "notNull": true
302           },
303           {
304             "fieldPath": "nameUpper",
305             "columnName": "name_upper",
306             "affinity": "TEXT",
307             "notNull": true
308           },
309           {
310             "fieldPath": "parentName",
311             "columnName": "parent_name",
312             "affinity": "TEXT",
313             "notNull": false
314           },
315           {
316             "fieldPath": "expanded",
317             "columnName": "expanded",
318             "affinity": "INTEGER",
319             "notNull": true,
320             "defaultValue": "1"
321           },
322           {
323             "fieldPath": "amountsExpanded",
324             "columnName": "amounts_expanded",
325             "affinity": "INTEGER",
326             "notNull": true,
327             "defaultValue": "0"
328           },
329           {
330             "fieldPath": "generation",
331             "columnName": "generation",
332             "affinity": "INTEGER",
333             "notNull": true,
334             "defaultValue": "0"
335           }
336         ],
337         "primaryKey": {
338           "columnNames": [
339             "id"
340           ],
341           "autoGenerate": true
342         },
343         "indices": [
344           {
345             "name": "un_account_name",
346             "unique": true,
347             "columnNames": [
348               "profile_id",
349               "name"
350             ],
351             "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `un_account_name` ON `${TABLE_NAME}` (`profile_id`, `name`)"
352           },
353           {
354             "name": "fk_account_profile",
355             "unique": false,
356             "columnNames": [
357               "profile_id"
358             ],
359             "createSql": "CREATE INDEX IF NOT EXISTS `fk_account_profile` ON `${TABLE_NAME}` (`profile_id`)"
360           }
361         ],
362         "foreignKeys": [
363           {
364             "table": "profiles",
365             "onDelete": "CASCADE",
366             "onUpdate": "RESTRICT",
367             "columns": [
368               "profile_id"
369             ],
370             "referencedColumns": [
371               "id"
372             ]
373           }
374         ]
375       },
376       {
377         "tableName": "profiles",
378         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `name` TEXT NOT NULL, `deprecated_uuid` TEXT, `url` TEXT NOT NULL, `use_authentication` INTEGER NOT NULL, `auth_user` TEXT, `auth_password` TEXT, `order_no` INTEGER NOT NULL, `permit_posting` INTEGER NOT NULL, `theme` INTEGER NOT NULL DEFAULT -1, `preferred_accounts_filter` TEXT, `future_dates` INTEGER NOT NULL, `api_version` INTEGER NOT NULL, `show_commodity_by_default` INTEGER NOT NULL, `default_commodity` TEXT, `show_comments_by_default` INTEGER NOT NULL DEFAULT 1, `detected_version_pre_1_19` INTEGER NOT NULL, `detected_version_major` INTEGER NOT NULL, `detected_version_minor` INTEGER NOT NULL)",
379         "fields": [
380           {
381             "fieldPath": "id",
382             "columnName": "id",
383             "affinity": "INTEGER",
384             "notNull": true
385           },
386           {
387             "fieldPath": "name",
388             "columnName": "name",
389             "affinity": "TEXT",
390             "notNull": true
391           },
392           {
393             "fieldPath": "deprecatedUUID",
394             "columnName": "deprecated_uuid",
395             "affinity": "TEXT",
396             "notNull": false
397           },
398           {
399             "fieldPath": "url",
400             "columnName": "url",
401             "affinity": "TEXT",
402             "notNull": true
403           },
404           {
405             "fieldPath": "useAuthentication",
406             "columnName": "use_authentication",
407             "affinity": "INTEGER",
408             "notNull": true
409           },
410           {
411             "fieldPath": "authUser",
412             "columnName": "auth_user",
413             "affinity": "TEXT",
414             "notNull": false
415           },
416           {
417             "fieldPath": "authPassword",
418             "columnName": "auth_password",
419             "affinity": "TEXT",
420             "notNull": false
421           },
422           {
423             "fieldPath": "orderNo",
424             "columnName": "order_no",
425             "affinity": "INTEGER",
426             "notNull": true
427           },
428           {
429             "fieldPath": "permitPosting",
430             "columnName": "permit_posting",
431             "affinity": "INTEGER",
432             "notNull": true
433           },
434           {
435             "fieldPath": "theme",
436             "columnName": "theme",
437             "affinity": "INTEGER",
438             "notNull": true,
439             "defaultValue": "-1"
440           },
441           {
442             "fieldPath": "preferredAccountsFilter",
443             "columnName": "preferred_accounts_filter",
444             "affinity": "TEXT",
445             "notNull": false
446           },
447           {
448             "fieldPath": "futureDates",
449             "columnName": "future_dates",
450             "affinity": "INTEGER",
451             "notNull": true
452           },
453           {
454             "fieldPath": "apiVersion",
455             "columnName": "api_version",
456             "affinity": "INTEGER",
457             "notNull": true
458           },
459           {
460             "fieldPath": "showCommodityByDefault",
461             "columnName": "show_commodity_by_default",
462             "affinity": "INTEGER",
463             "notNull": true
464           },
465           {
466             "fieldPath": "defaultCommodity",
467             "columnName": "default_commodity",
468             "affinity": "TEXT",
469             "notNull": false
470           },
471           {
472             "fieldPath": "showCommentsByDefault",
473             "columnName": "show_comments_by_default",
474             "affinity": "INTEGER",
475             "notNull": true,
476             "defaultValue": "1"
477           },
478           {
479             "fieldPath": "detectedVersionPre_1_19",
480             "columnName": "detected_version_pre_1_19",
481             "affinity": "INTEGER",
482             "notNull": true
483           },
484           {
485             "fieldPath": "detectedVersionMajor",
486             "columnName": "detected_version_major",
487             "affinity": "INTEGER",
488             "notNull": true
489           },
490           {
491             "fieldPath": "detectedVersionMinor",
492             "columnName": "detected_version_minor",
493             "affinity": "INTEGER",
494             "notNull": true
495           }
496         ],
497         "primaryKey": {
498           "columnNames": [
499             "id"
500           ],
501           "autoGenerate": true
502         },
503         "indices": [],
504         "foreignKeys": []
505       },
506       {
507         "tableName": "options",
508         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`profile_id` INTEGER NOT NULL, `name` TEXT NOT NULL, `value` TEXT, PRIMARY KEY(`profile_id`, `name`))",
509         "fields": [
510           {
511             "fieldPath": "profileId",
512             "columnName": "profile_id",
513             "affinity": "INTEGER",
514             "notNull": true
515           },
516           {
517             "fieldPath": "name",
518             "columnName": "name",
519             "affinity": "TEXT",
520             "notNull": true
521           },
522           {
523             "fieldPath": "value",
524             "columnName": "value",
525             "affinity": "TEXT",
526             "notNull": false
527           }
528         ],
529         "primaryKey": {
530           "columnNames": [
531             "profile_id",
532             "name"
533           ],
534           "autoGenerate": false
535         },
536         "indices": [],
537         "foreignKeys": []
538       },
539       {
540         "tableName": "account_values",
541         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `account_id` INTEGER NOT NULL, `currency` TEXT NOT NULL DEFAULT '', `value` REAL NOT NULL, `generation` INTEGER NOT NULL DEFAULT 0, FOREIGN KEY(`account_id`) REFERENCES `accounts`(`id`) ON UPDATE RESTRICT ON DELETE CASCADE )",
542         "fields": [
543           {
544             "fieldPath": "id",
545             "columnName": "id",
546             "affinity": "INTEGER",
547             "notNull": true
548           },
549           {
550             "fieldPath": "accountId",
551             "columnName": "account_id",
552             "affinity": "INTEGER",
553             "notNull": true
554           },
555           {
556             "fieldPath": "currency",
557             "columnName": "currency",
558             "affinity": "TEXT",
559             "notNull": true,
560             "defaultValue": "''"
561           },
562           {
563             "fieldPath": "value",
564             "columnName": "value",
565             "affinity": "REAL",
566             "notNull": true
567           },
568           {
569             "fieldPath": "generation",
570             "columnName": "generation",
571             "affinity": "INTEGER",
572             "notNull": true,
573             "defaultValue": "0"
574           }
575         ],
576         "primaryKey": {
577           "columnNames": [
578             "id"
579           ],
580           "autoGenerate": true
581         },
582         "indices": [
583           {
584             "name": "un_account_values",
585             "unique": true,
586             "columnNames": [
587               "account_id",
588               "currency"
589             ],
590             "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `un_account_values` ON `${TABLE_NAME}` (`account_id`, `currency`)"
591           },
592           {
593             "name": "fk_account_value_acc",
594             "unique": false,
595             "columnNames": [
596               "account_id"
597             ],
598             "createSql": "CREATE INDEX IF NOT EXISTS `fk_account_value_acc` ON `${TABLE_NAME}` (`account_id`)"
599           }
600         ],
601         "foreignKeys": [
602           {
603             "table": "accounts",
604             "onDelete": "CASCADE",
605             "onUpdate": "RESTRICT",
606             "columns": [
607               "account_id"
608             ],
609             "referencedColumns": [
610               "id"
611             ]
612           }
613         ]
614       },
615       {
616         "tableName": "transactions",
617         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `ledger_id` INTEGER NOT NULL, `profile_id` INTEGER NOT NULL, `data_hash` TEXT NOT NULL, `year` INTEGER NOT NULL, `month` INTEGER NOT NULL, `day` INTEGER NOT NULL, `description` TEXT NOT NULL COLLATE NOCASE, `comment` TEXT, `generation` INTEGER NOT NULL, FOREIGN KEY(`profile_id`) REFERENCES `profiles`(`id`) ON UPDATE RESTRICT ON DELETE CASCADE )",
618         "fields": [
619           {
620             "fieldPath": "id",
621             "columnName": "id",
622             "affinity": "INTEGER",
623             "notNull": true
624           },
625           {
626             "fieldPath": "ledgerId",
627             "columnName": "ledger_id",
628             "affinity": "INTEGER",
629             "notNull": true
630           },
631           {
632             "fieldPath": "profileId",
633             "columnName": "profile_id",
634             "affinity": "INTEGER",
635             "notNull": true
636           },
637           {
638             "fieldPath": "dataHash",
639             "columnName": "data_hash",
640             "affinity": "TEXT",
641             "notNull": true
642           },
643           {
644             "fieldPath": "year",
645             "columnName": "year",
646             "affinity": "INTEGER",
647             "notNull": true
648           },
649           {
650             "fieldPath": "month",
651             "columnName": "month",
652             "affinity": "INTEGER",
653             "notNull": true
654           },
655           {
656             "fieldPath": "day",
657             "columnName": "day",
658             "affinity": "INTEGER",
659             "notNull": true
660           },
661           {
662             "fieldPath": "description",
663             "columnName": "description",
664             "affinity": "TEXT",
665             "notNull": true
666           },
667           {
668             "fieldPath": "comment",
669             "columnName": "comment",
670             "affinity": "TEXT",
671             "notNull": false
672           },
673           {
674             "fieldPath": "generation",
675             "columnName": "generation",
676             "affinity": "INTEGER",
677             "notNull": true
678           }
679         ],
680         "primaryKey": {
681           "columnNames": [
682             "id"
683           ],
684           "autoGenerate": true
685         },
686         "indices": [
687           {
688             "name": "un_transactions_ledger_id",
689             "unique": true,
690             "columnNames": [
691               "profile_id",
692               "ledger_id"
693             ],
694             "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `un_transactions_ledger_id` ON `${TABLE_NAME}` (`profile_id`, `ledger_id`)"
695           },
696           {
697             "name": "idx_transaction_description",
698             "unique": false,
699             "columnNames": [
700               "description"
701             ],
702             "createSql": "CREATE INDEX IF NOT EXISTS `idx_transaction_description` ON `${TABLE_NAME}` (`description`)"
703           },
704           {
705             "name": "fk_transaction_profile",
706             "unique": false,
707             "columnNames": [
708               "profile_id"
709             ],
710             "createSql": "CREATE INDEX IF NOT EXISTS `fk_transaction_profile` ON `${TABLE_NAME}` (`profile_id`)"
711           }
712         ],
713         "foreignKeys": [
714           {
715             "table": "profiles",
716             "onDelete": "CASCADE",
717             "onUpdate": "RESTRICT",
718             "columns": [
719               "profile_id"
720             ],
721             "referencedColumns": [
722               "id"
723             ]
724           }
725         ]
726       },
727       {
728         "tableName": "transaction_accounts",
729         "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `transaction_id` INTEGER NOT NULL, `order_no` INTEGER NOT NULL, `account_name` TEXT NOT NULL, `currency` TEXT NOT NULL DEFAULT '', `amount` REAL NOT NULL, `comment` TEXT, `generation` INTEGER NOT NULL DEFAULT 0, FOREIGN KEY(`transaction_id`) REFERENCES `transactions`(`id`) ON UPDATE RESTRICT ON DELETE CASCADE )",
730         "fields": [
731           {
732             "fieldPath": "id",
733             "columnName": "id",
734             "affinity": "INTEGER",
735             "notNull": true
736           },
737           {
738             "fieldPath": "transactionId",
739             "columnName": "transaction_id",
740             "affinity": "INTEGER",
741             "notNull": true
742           },
743           {
744             "fieldPath": "orderNo",
745             "columnName": "order_no",
746             "affinity": "INTEGER",
747             "notNull": true
748           },
749           {
750             "fieldPath": "accountName",
751             "columnName": "account_name",
752             "affinity": "TEXT",
753             "notNull": true
754           },
755           {
756             "fieldPath": "currency",
757             "columnName": "currency",
758             "affinity": "TEXT",
759             "notNull": true,
760             "defaultValue": "''"
761           },
762           {
763             "fieldPath": "amount",
764             "columnName": "amount",
765             "affinity": "REAL",
766             "notNull": true
767           },
768           {
769             "fieldPath": "comment",
770             "columnName": "comment",
771             "affinity": "TEXT",
772             "notNull": false
773           },
774           {
775             "fieldPath": "generation",
776             "columnName": "generation",
777             "affinity": "INTEGER",
778             "notNull": true,
779             "defaultValue": "0"
780           }
781         ],
782         "primaryKey": {
783           "columnNames": [
784             "id"
785           ],
786           "autoGenerate": true
787         },
788         "indices": [
789           {
790             "name": "fk_trans_acc_trans",
791             "unique": false,
792             "columnNames": [
793               "transaction_id"
794             ],
795             "createSql": "CREATE INDEX IF NOT EXISTS `fk_trans_acc_trans` ON `${TABLE_NAME}` (`transaction_id`)"
796           },
797           {
798             "name": "un_transaction_accounts",
799             "unique": true,
800             "columnNames": [
801               "transaction_id",
802               "order_no"
803             ],
804             "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `un_transaction_accounts` ON `${TABLE_NAME}` (`transaction_id`, `order_no`)"
805           }
806         ],
807         "foreignKeys": [
808           {
809             "table": "transactions",
810             "onDelete": "CASCADE",
811             "onUpdate": "RESTRICT",
812             "columns": [
813               "transaction_id"
814             ],
815             "referencedColumns": [
816               "id"
817             ]
818           }
819         ]
820       }
821     ],
822     "views": [],
823     "setupQueries": [
824       "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
825       "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, 'b52e9a5f88719ae4a44e047ce81b34ee')"
826     ]
827   }
828 }