fix db conflicts

1 files changed, 16 insertions, 0 deletions

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) {
+  
+};