From dab8ce27232e48782562419849a227f6cf7edf74 Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Tue, 20 Jul 2021 14:03:51 -0700 Subject: remove virtual column from orders --- db/migrations/20210714123455_data_fixes_merge.js | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/db/migrations/20210714123455_data_fixes_merge.js b/db/migrations/20210714123455_data_fixes_merge.js index aed78258..3816920c 100644 --- a/db/migrations/20210714123455_data_fixes_merge.js +++ b/db/migrations/20210714123455_data_fixes_merge.js @@ -4,6 +4,11 @@ exports.up = function(knex) { knex.raw("update users set account_id = 10427 where id = 6262 and account_id = 10428"); knex.raw("delete from payments where account_id not in (select id from accounts)"), knex.raw("delete from orders where a1_id not in (select id from accounts) or a2_id not in (select id from accounts)"), + + knex.raw("alter table orders drop rate"); + knex.raw("alter table orders add rate double"); + knex.raw("update orders set rate = v1/v2"); + ]) } -- cgit v1.2.3