update migrations

1 files changed, 19 insertions, 0 deletions

diff --git a/db/migrations/20210612192804_init_waiting_list.js.js b/db/migrations/20210612192804_init_waiting_list.js.js
new file mode 100644
index 00000000..65d3eb42
--- /dev/null
+++ b/db/migrations/20210612192804_init_waiting_list.js.js
@@ -0,0 +1,19 @@
+exports.up = function(knex) {
+    return 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.integer('user_id').nullable();
+      t.foreign('user_id').references('users.id');
+      t.text('notes').nullable();
+
+      t.timestamps();
+    })
+}
+  
+exports.down = function(knex) {
+    return knex.schema.dropTable('waiting_list');
+}
\ No newline at end of file