From 8a4dfd6fd0d27090f4368ee916b4b97445bf979c Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Sat, 14 Aug 2021 13:51:03 -0700 Subject: fix db conflicts --- db/migrations/20210814193811_fix_db_conflicts.js | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 db/migrations/20210814193811_fix_db_conflicts.js (limited to 'db/migrations/20210814193811_fix_db_conflicts.js') diff --git a/db/migrations/20210814193811_fix_db_conflicts.js b/db/migrations/20210814193811_fix_db_conflicts.js new file mode 100644 index 00000000..37ff2bbc --- /dev/null +++ b/db/migrations/20210814193811_fix_db_conflicts.js @@ -0,0 +1,16 @@ + +exports.up = function(knex) { + return Promise.all([ + knex.raw("UPDATE waiting_list set created_at = '2021-01-01', updated_at='2021-01-01' WHERE updated_at IS NULL OR created_at IS NULL"), + knex.raw("ALTER TABLE waiting_list MODIFY created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP"), + knex.raw("ALTER TABLE waiting_list MODIFY updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP"), + + knex.raw("UPDATE referrals set created_at = '2021-01-01', updated_at='2021-01-01' WHERE updated_at IS NULL OR created_at IS NULL"), + knex.raw("ALTER TABLE referrals MODIFY created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP"), + knex.raw("ALTER TABLE referrals MODIFY updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP") + ]) +}; + +exports.down = function(knex) { + +}; -- cgit v1.2.3