From fc19ca29073fc4fc193af583dde6a9e15fa776ba Mon Sep 17 00:00:00 2001
From: Ran Guin <rguin@iMac.local>
Date: Wed, 28 Jul 2021 16:25:07 -0700
Subject: tweak user_id reference

---
 .../20210612192804_init_waiting_list.js.js         | 27 +++++++++++++---------
 1 file changed, 16 insertions(+), 11 deletions(-)

(limited to 'db/migrations/20210612192804_init_waiting_list.js.js')

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) {
-- 
cgit v1.2.3