app/schemas/net.ktnx.mobileledger.db.DB/45.json

   1 {
   2   "formatVersion": 1,
   3   "database": {
   4     "version": 45,
   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 }