const { DataTypes } = require('sequelize');

const attributes = {
  id: {
    type: DataTypes.INTEGER(11),
    allowNull: false,
    defaultValue: null,
    primaryKey: true,
    autoIncrement: true,
    comment: null,
    field: "id"
  },
  user_id: {
    type: DataTypes.INTEGER(11),
    allowNull: true,
    defaultValue: null,
    primaryKey: false,
    autoIncrement: false,
    comment: null,
    field: "user_id"
  },
  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');
// };
are'>square</option>
<option value='stageUpdate'>stageUpdate</option>
<option value='stageUpdate2'>stageUpdate2</option>
<option value='staging'>staging</option>
<option value='taxi'>taxi</option>
<option value='tdex'>tdex</option>
<option value='test'>test</option>
<option value='tickets'>tickets</option>
<option value='v1.0.0'>v1.0.0</option>
<option value='vue'>vue</option>
<option value='withdraw'>withdraw</option>
</select> <input type='submit' value='switch'/></form></td></tr>
<tr><td class='sub'>coinos server — legacy coinos.io backend (Lightning, on-chain, Liquid)</td><td class='sub right'>coinos</td></tr></table>
<table class='tabs'><tr><td>
<a href='/coinos-server.git/about/'>about</a><a href='/coinos-server.git/'>summary</a><a href='/coinos-server.git/refs/?id=4d30edc5d3c1c6494514d5f55412d6046299ead2'>refs</a><a href='/coinos-server.git/log/README.md'>log</a><a class='active' href='/coinos-server.git/tree/README.md?id=4d30edc5d3c1c6494514d5f55412d6046299ead2'>tree</a><a href='/coinos-server.git/commit/README.md?id=4d30edc5d3c1c6494514d5f55412d6046299ead2'>commit</a><a href='/coinos-server.git/diff/README.md?id=4d30edc5d3c1c6494514d5f55412d6046299ead2'>diff</a><a href='/coinos-server.git/stats/README.md'>stats</a></td><td class='form'><form class='right' method='get' action='/coinos-server.git/log/README.md'>
<input type='hidden' name='id' value='4d30edc5d3c1c6494514d5f55412d6046299ead2'/><select name='qt'>
<option value='grep'>log msg</option>
<option value='author'>author</option>
<option value='committer'>committer</option>
<option value='range'>range</option>
</select>
<input class='txt' type='search' size='10' name='q' value=''/>
<input type='submit' value='search'/>
</form>
</td></tr></table>
<div class='path'>path: <a href='/coinos-server.git/tree/?id=4d30edc5d3c1c6494514d5f55412d6046299ead2'>root</a>/<a href='/coinos-server.git/tree/README.md?id=4d30edc5d3c1c6494514d5f55412d6046299ead2'>README.md</a></div><div class='content'>blob: 9215afae74e5b97bcf13b1399513bac207b4b55a (<a href='/coinos-server.git/plain/README.md?id=4d30edc5d3c1c6494514d5f55412d6046299ead2'>plain</a>) (<a href='/coinos-server.git/blame/README.md?id=4d30edc5d3c1c6494514d5f55412d6046299ead2'>blame</a>)
<table summary='blob content' class='blob'>
<tr><td class='linenumbers'><pre><a id='n1' href='#n1'>1</a>
<a id='n2' href='#n2'>2</a>
<a id='n3' href='#n3'>3</a>
<a id='n4' href='#n4'>4</a>
<a id='n5' href='#n5'>5</a>
<a id='n6' href='#n6'>6</a>
<a id='n7' href='#n7'>7</a>
<a id='n8' href='#n8'>8</a>
<a id='n9' href='#n9'>9</a>
<a id='n10' href='#n10'>10</a>
<a id='n11' href='#n11'>11</a>
<a id='n12' href='#n12'>12</a>
<a id='n13' href='#n13'>13</a>
<a id='n14' href='#n14'>14</a>
</pre></td>
<td class='lines'><pre><code>