initialize migrations dir

1 files changed, 19 insertions, 0 deletions

diff --git a/db/migrations/20210612181508_init_referrals.js b/db/migrations/20210612181508_init_referrals.js
new file mode 100644
index 00000000..260a2c8f
--- /dev/null
+++ b/db/migrations/20210612181508_init_referrals.js
@@ -0,0 +1,19 @@
+
+exports.up = function(knex) {
+    return knex.schema.createTable('referrals', function(t) {
+        t.increments('id').unsigned().primary();
+
+        t.string('token').notNull();
+        t.string('expiry').nullable();
+        t.enum('status', ['pending', 'active', 'expired', 'cancelled')).notNull().defaultTo('pending');
+        t.int('sponsor_id').notNull();
+	t.foreign('sponsor_id').references('users.user_id')
+        t.int('user_id').nullable();
+	t.foreign('user_id').references('users.user_id')
+
+        t.timestamps();
+};
+
+exports.down = function(knex) {
+  return knex.schema.dropTable('referrals');
+};