From f8b882c01915ca3799c09858ba29b644c8ce4d86 Mon Sep 17 00:00:00 2001
From: Ran Guin <rguin@iMac.local>
Date: Wed, 28 Jul 2021 14:22:10 -0700
Subject: add updated indexes

---
 db/migrations/20210714123456_add_fks_merge.js | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'db')

diff --git a/db/migrations/20210714123456_add_fks_merge.js b/db/migrations/20210714123456_add_fks_merge.js
index 5e7e6c8a..e714520b 100644
--- a/db/migrations/20210714123456_add_fks_merge.js
+++ b/db/migrations/20210714123456_add_fks_merge.js
@@ -6,6 +6,7 @@ exports.up = function(knex) {
     knex.schema.alterTable("invoices", function(t) {
       t.foreign('user_id').references('users.id')
       t.foreign('account_id').references('accounts.id')
+      t.index('updatedAt')
     }),
 
     // alter table payments add foreign key (user_id) references users (id);
@@ -13,6 +14,7 @@ exports.up = function(knex) {
     knex.schema.alterTable("payments", function(t) {
       t.foreign('user_id').references('users.id')
       t.foreign('account_id').references('accounts.id')
+      t.index('updatedAt')
     }),
 
     // alter table orders add foreign key (user_id) references users (id);
@@ -22,16 +24,19 @@ exports.up = function(knex) {
       t.foreign('user_id').references('users.id')
       t.foreign('a1_id').references('accounts.id')
       t.foreign('a2_id').references('accounts.id')
+      t.index('updatedAt')
     }),
 
     // alter table deposits add foreign key (user_id) references users (id)
     knex.schema.alterTable("deposits", function(t) {
       t.foreign('user_id').references('users.id')
+      t.index('updatedAt')
     }),
 
     // alter table withdrawals add foreign key (user_id) references users (id)
     knex.schema.alterTable("withdrawals", function(t) {
       t.foreign('user_id').references('users.id')
+      t.index('updatedAt')
     }),
   ])
 }
-- 
cgit v1.2.3