add two indices, corresponding to foreign keys to help Room

[mobile-ledger.git] / app / schemas / net.ktnx.mobileledger.db.DB / 51.json

diff --git a/app/schemas/net.ktnx.mobileledger.db.DB/51.json b/app/schemas/net.ktnx.mobileledger.db.DB/51.json
index e9fbfab7f6291d2962a778bb9e60db74e3885491..f755a4bd3e91240d7e4b4229b0bc1472c632efc3 100644 (file)
--- a/app/schemas/net.ktnx.mobileledger.db.DB/51.json
+++ b/app/schemas/net.ktnx.mobileledger.db.DB/51.json
@@ -2,7 +2,7 @@
   "formatVersion": 1,
   "database": {
     "version": 51,
-    "identityHash": "ed0a974c5dddf4db12e6ecd71552b550",
+    "identityHash": "d80c63258c511ee305dc5f0062a8af2a",
     "entities": [
       {
         "tableName": "patterns",
@@ -196,6 +196,22 @@
               "id"
             ],
             "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `un_pattern_accounts` ON `${TABLE_NAME}` (`id`)"
+          },
+          {
+            "name": "fk_pattern_accounts_pattern",
+            "unique": false,
+            "columnNames": [
+              "pattern_id"
+            ],
+            "createSql": "CREATE INDEX IF NOT EXISTS `fk_pattern_accounts_pattern` ON `${TABLE_NAME}` (`pattern_id`)"
+          },
+          {
+            "name": "fk_pattern_accounts_currency",
+            "unique": false,
+            "columnNames": [
+              "currency"
+            ],
+            "createSql": "CREATE INDEX IF NOT EXISTS `fk_pattern_accounts_currency` ON `${TABLE_NAME}` (`currency`)"
           }
         ],
         "foreignKeys": [
@@ -265,7 +281,7 @@
     "views": [],
     "setupQueries": [
       "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
-      "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, 'ed0a974c5dddf4db12e6ecd71552b550')"
+      "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, 'd80c63258c511ee305dc5f0062a8af2a')"
     ]
   }
 }
\ No newline at end of file