import { get, writable } from 'svelte/store'; import { browser } from '$app/environment'; // creates a Svelte store synced to sessionStorage with the given key and default value const persistSession = (key, defaultValue) => { let s = writable( browser && sessionStorage.getItem(key) && sessionStorage.getItem(key) !== 'undefined' ? JSON.parse(sessionStorage.getItem(key)) : defaultValue ); s.subscribe((v) => browser && sessionStorage.setItem(key, JSON.stringify(v))); return s; }; // creates a Svelte store synced to localStorage with the given key and default value const persistLocal = (key, defaultValue) => { let s = writable( browser && localStorage.getItem(key) && localStorage.getItem(key) !== 'undefined' ? JSON.parse(localStorage.getItem(key)) : defaultValue ); s.subscribe((v) => browser && localStorage.setItem(key, JSON.stringify(v))); return s; }; export const rate = writable(); export const redirect = writable(); export const rates = writable(); export const selectedRate = writable(); export const user = writable(); export const subject = writable(); export const invoiceAmount = writable(); export const invoiceAmountFiat = writable(); export const token = persistSession('token'); export const invoices = writable({}); export const newPayment = persistLocal('newPayment'); export const colorTheme = writable('from-primary to-gradient'); export const tempProfileFiles = writable(); export const avatarUpload = writable(); export const bannerUpload = writable(); g'>logging coinos server — legacy coinos.io backend (Lightning, on-chain, Liquid)coinos
aboutsummaryrefslogtreecommitdiffstats
path: root/db/normalized/withdrawals.js
blob: 9a45c51439296dcad581f2801259a7cc5879151a (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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128

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);
generated by cgit v1.2.3 (git 2.51.0) at 2026-11-06 19:12:32 +0000