exports.up = function(knex) {
  return knex.schema.createTable('withdrawals', function(t) {
    t.increments('id').unsigned().primary();

    t.int('debit_id').notNull();
    t.foreign('debit_id').references('debits.id');

    t.int('bank_account_id').notNull();
    t.foreign('bank_account_id').references('bank_accounts.id');

    t.double('withdrawal_fee').notNull().defaultTo(0)

    t.text('notes');

    t.timestamps();
  })
}

exports.down = function(knex) {
  return knex.schema.dropTable('withdrawals');
};

// Changes:
//
// bank info -> bank_account records

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

// const attributes = {
//   id: {
//     type: DataTypes.INTEGER(11),
//     allowNull: false,
//     defaultValue: null,
//     primaryKey: true,
//     autoIncrement: true,
//     comment: null,
//     field: "id"
//   },
//   amount: {
//     type: DataTypes.DOUBLE,
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "amount"
//   },
//   user_id: {
//     type: DataTypes.INTEGER(11),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "user_id"
//   },
//   createdAt: {
//     type: DataTypes.DATE,
//     allowNull: false,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "createdAt"
//   },
//   updatedAt: {
//     type: DataTypes.DATE,
//     allowNull: false,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "updatedAt"
//   },
//   transit: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "transit"
//   },
//   institution: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "institution"
//   },
//   account: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "account"
//   },
//   email: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "email"
//   },
//   notes: {
//     type: DataTypes.TEXT,
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "notes"
//   },
// };

// const options = {
//   tableName: "withdrawals",
//   comment: "",
//   indexes: []
// };

// db["Withdrawal"] = db.define("withdrawals_model", attributes, options);
tion value='svelte-5'>svelte-5</option>
<option value='swapee'>swapee</option>
<option value='test'>test</option>
<option value='tickets'>tickets</option>
<option value='video'>video</option>
<option value='welcome-page'>welcome-page</option>
<option value='well'>well</option>
</select> <input type='submit' value='switch'/></form></td></tr>
<tr><td class='sub'>coinos ui — legacy coinos.io web app (SvelteKit)</td><td class='sub right'>coinos</td></tr></table>
<table class='tabs'><tr><td>
<a href='/coinos-ui.git/about/'>about</a><a href='/coinos-ui.git/'>summary</a><a href='/coinos-ui.git/refs/?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>refs</a><a href='/coinos-ui.git/log/src/components/Image.svelte'>log</a><a class='active' href='/coinos-ui.git/tree/src/components/Image.svelte?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>tree</a><a href='/coinos-ui.git/commit/src/components/Image.svelte?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>commit</a><a href='/coinos-ui.git/diff/src/components/Image.svelte?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>diff</a><a href='/coinos-ui.git/stats/src/components/Image.svelte'>stats</a></td><td class='form'><form class='right' method='get' action='/coinos-ui.git/log/src/components/Image.svelte'>
<input type='hidden' name='id' value='cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'/><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-ui.git/tree/?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>root</a>/<a href='/coinos-ui.git/tree/src?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>src</a>/<a href='/coinos-ui.git/tree/src/components?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>components</a>/<a href='/coinos-ui.git/tree/src/components/Image.svelte?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>Image.svelte</a></div><div class='content'>blob: b7db2b929d9cd8d1b7bb22a5e22e4893d72a17cf (<a href='/coinos-ui.git/plain/src/components/Image.svelte?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>plain</a>) (<a href='/coinos-ui.git/blame/src/components/Image.svelte?id=cbdd2672ab52a9a7bcb2a2696d5519815b9cd0fb'>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>
</pre></td>
<td class='lines'><pre><code>