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

   1 {
   2   "formatVersion": 1,
   3   "database": {
   4     "version": 57,
   5     "identityHash": "5a5aa2f77594578d228d211d5e4406a6",
   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}` (`level` INTEGER NOT NULL, `profile` TEXT 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, PRIMARY KEY(`profile`, `name`))",
 278         "fields": [
 279           {
 280             "fieldPath": "level",
 281             "columnName": "level",
 282             "affinity": "INTEGER",
 283             "notNull": true
 284           },
 285           {
 286             "fieldPath": "profile",
 287             "columnName": "profile",
 288             "affinity": "TEXT",
 289             "notNull": true
 290           },
 291           {
 292             "fieldPath": "name",
 293             "columnName": "name",
 294             "affinity": "TEXT",
 295             "notNull": true
 296           },
 297           {
 298             "fieldPath": "nameUpper",
 299             "columnName": "name_upper",
 300             "affinity": "TEXT",
 301             "notNull": true
 302           },
 303           {
 304             "fieldPath": "parentName",
 305             "columnName": "parent_name",
 306             "affinity": "TEXT",
 307             "notNull": false
 308           },
 309           {
 310             "fieldPath": "expanded",
 311             "columnName": "expanded",
 312             "affinity": "INTEGER",
 313             "notNull": true,
 314             "defaultValue": "1"
 315           },
 316           {
 317             "fieldPath": "amountsExpanded",
 318             "columnName": "amounts_expanded",
 319             "affinity": "INTEGER",
 320             "notNull": true,
 321             "defaultValue": "0"
 322           },
 323           {
 324             "fieldPath": "generation",
 325             "columnName": "generation",
 326             "affinity": "INTEGER",
 327             "notNull": true,
 328             "defaultValue": "0"
 329           }
 330         ],
 331         "primaryKey": {
 332           "columnNames": [
 333             "profile",
 334             "name"
 335           ],
 336           "autoGenerate": false
 337         },
 338         "indices": [],
 339         "foreignKeys": []
 340       }
 341     ],
 342     "views": [],
 343     "setupQueries": [
 344       "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
 345       "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, '5a5aa2f77594578d228d211d5e4406a6')"
 346     ]
 347   }
 348 }