From e238eab45f1f5b6f3dbf40ddff59b9db804ffb4f Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Mon, 19 Jul 2021 12:19:18 -0700 Subject: update migrations --- db/migrations/20210612192804_init_waiting_list.js.js | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 db/migrations/20210612192804_init_waiting_list.js.js (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 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 -- cgit v1.2.3