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/20210612181508_init_referrals.js | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 db/migrations/20210612181508_init_referrals.js (limited to 'db/migrations/20210612181508_init_referrals.js') diff --git a/db/migrations/20210612181508_init_referrals.js b/db/migrations/20210612181508_init_referrals.js new file mode 100644 index 00000000..875d167f --- /dev/null +++ b/db/migrations/20210612181508_init_referrals.js @@ -0,0 +1,21 @@ +exports.up = function(knex) { + return knex.schema.createTable('referrals', function(t) { + t.increments('id').unsigned().primary(); + t.integer('user_id').nullable(); + t.foreign('user_id').references('users.id'); + + t.integer('sponsor_id').notNull(); + t.foreign('sponsor_id').references('users.id'); + + t.string('token').notNull(); + t.string('expiry').nullable(); + t.enum('status', ['available', 'used', 'expired', 'cancelled']).notNull().defaultTo('available'); + + t.timestamps(); + }) + }; + + exports.down = function(knex) { + return knex.schema.dropTable('referrals'); + }; + \ No newline at end of file -- cgit v1.2.3