aboutsummaryrefslogtreecommitdiffstats
path: root/db/normalized/referrals.js
diff options
context:
space:
mode:
Diffstat (limited to 'db/normalized/referrals.js')
-rw-r--r--db/normalized/referrals.js20
1 files changed, 0 insertions, 20 deletions
diff --git a/db/normalized/referrals.js b/db/normalized/referrals.js
deleted file mode 100644
index 7380f2cf..00000000
--- a/db/normalized/referrals.js
+++ /dev/null
@@ -1,20 +0,0 @@
-export const up = function(knex) {
- return knex.schema.createTable('referrals', function(t) {
- t.increments('id').unsigned().primary();
- t.int('user_id').nullable();
- t.foreign('user_id').references('users.id');
-
- t.int('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();
- })
-};
-
-export const down = function(knex) {
- return knex.schema.dropTable('referrals');
-};