initialize migrations dir

1 files changed, 17 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..5322cf6d
--- /dev/null
+++ b/db/migrations/20210612192804_init_waiting_list.js.js
@@ -0,0 +1,17 @@
+
+exports.up = function(knex) {
+    return knex.schema.createTable('waiting_list', function(t) {
+        t.increments('id').unsigned().primary();
+
+        t.string('email').nullable();
+        t.string('sms').nullable();
+        t.enum('status', ['pending', 'contacted', 'registered', 'cancelled')).notNull().defaultTo('pending');
+        t.int('user_id').notNull();
+	t.foreign('user_id').references('users.user_id');
+
+	t.timestamps();  
+};
+
+exports.down = function(knex) {
+    return knex.schema.dropTable('waiting_list');
+};