diff options
| -rw-r--r-- | db/migrations/20210714123456_add_fks_merge.js | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrations/20210714123456_add_fks_merge.js b/db/migrations/20210714123456_add_fks_merge.js index a13ea5c9..ecdd08f3 100644 --- a/db/migrations/20210714123456_add_fks_merge.js +++ b/db/migrations/20210714123456_add_fks_merge.js @@ -1,26 +1,35 @@ exports.up = function(knex) { return Promise.all([ + // alter table invoices add foreign key (user_id) references users (id); + // alter table invoices add foreign key (account_id) references accounts (id); knex.schema.alterTable("invoices", function(t) { t.foreign('user_id').references('users.id') t.foreign('account_id').references('accounts.id') }), + // alter table payments add foreign key (user_id) references users (id); + // alter table payments add foreign key (account_id) references accounts (id); knex.schema.alterTable("payments", function(t) { t.foreign('user_id').references('users.id') t.foreign('account_id').references('accounts.id') }), + // alter table orders add foreign key (user_id) references users (id); + // alter table orders add foreign key (a1_id) references accounts (id); + // alter table orders add foreign key (a2_id) references accounts (id); knex.schema.alterTable("orders", function(t) { t.foreign('user_id').references('users.id') t.foreign('a1_id').references('accounts.id') t.foreign('a2_id').references('accounts.id') }), + // alter table deposits add foreign key (user_id) references users (id) knex.schema.alterTable("deposits", function(t) { t.foreign('user_id').references('users.id') }), + // alter table withdrawals add foreign key (user_id) references users (id) knex.schema.alterTable("withdrawals", function(t) { t.foreign('user_id').references('users.id') }), |