aboutsummaryrefslogtreecommitdiffstats
path: root/db/models/codes.js
blob: 66a8f7e0b7dd1f7a6c62c8a907a82491019d3c1b (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
const { DataTypes } = require('sequelize');

const attributes = {
  code: {
    type: DataTypes.STRING(255),
    allowNull: false,
    defaultValue: null,
    primaryKey: true,
    autoIncrement: false,
    comment: null,
    field: "code"
  },
  text: {
    type: DataTypes.TEXT,
    allowNull: true,
    defaultValue: null,
    primaryKey: false,
    autoIncrement: false,
    comment: null,
    field: "text"
  },
};

const options = {
  tableName: "codes",
  comment: "",
  indexes: [],
  timestamps: false
};

db["Code"] = db.define("codes_model", attributes, options);
an>}, sponsor_id: { type: DataTypes.INTEGER(11), allowNull: true, defaultValue: null, primaryKey: false, autoIncrement: false, comment: null, field: "sponsor_id" }, token: { type: DataTypes.STRING(255), allowNull: true, defaultValue: null, primaryKey: false, autoIncrement: false, comment: null, field: "token" }, expiry: { type: DataTypes.DATE(), allowNull: true, defaultValue: null, primaryKey: false, autoIncrement: false, comment: null, field: "token" }, status: { type: DataTypes.ENUM, values: ['available', 'used', 'expired', 'cancelled'], allowNull: true, defaultValue: 'available', primaryKey: false, autoIncrement: false, comment: null, field: "token" } }; const options = { tableName: "referrals", comment: "", indexes: [] }; db["Referral"] = db.define("referrals_model", attributes, options); // exports.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(); // }) // }; // exports.down = function(knex) { // return knex.schema.dropTable('referrals'); // };