tweak user_id reference

1 files changed, 16 insertions, 11 deletions

diff --git a/db/migrations/20210612192804_init_waiting_list.js.js b/db/migrations/20210612192804_init_waiting_list.js.js
index 65d3eb42..67762ff1 100644
--- a/db/migrations/20210612192804_init_waiting_list.js.js
+++ b/db/migrations/20210612192804_init_waiting_list.js.js
@@ -1,17 +1,22 @@
 exports.up = function(knex) {
-    return knex.schema.createTable('waiting_list', function(t) {
-      t.increments('id').unsigned().primary();
+
+    return Promise.all([
+      knex.schema.dropTableIfExists('waiting_list'),
+
+      knex.schema.createTable('waiting_list', function(t) {
+        t.increments('id').unsigned().primary();
+    
+        t.string('email').notNull();
+        t.string('phone').notNull();
+        t.enu('status', ['pending', 'activated', 'expired', 'cancelled']).notNull();
   
-      t.string('email').notNull();
-      t.string('phone').notNull();
-      t.enu('status', ['pending', 'activated', 'expired', 'cancelled']).notNull();
- 
-      t.integer('user_id').nullable();
-      t.foreign('user_id').references('users.id');
-      t.text('notes').nullable();
+        t.integer('user_id').nullable();
+        t.foreign('user_id').references('users.id');
+        t.text('notes').nullable();
 
-      t.timestamps();
-    })
+        t.timestamps();
+      })
+    ])
 }
   
 exports.down = function(knex) {