aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrations/user_adjustments.js
diff options
context:
space:
mode:
authorAdam Soltys <[email protected]>2021-06-29 10:28:58 -0700
committerAdam Soltys <[email protected]>2021-07-07 12:42:19 -0700
commit0fb703b85d99c888d1df971e7c3562f7918e0ff8 (patch)
tree2f167df25b172c3b7166952444e39e7f582e93c4 /db/migrations/user_adjustments.js
parent9bf4080d67d6342624c8f1fb543acab00191f730 (diff)
downloadcoinos-server-0fb703b85d99c888d1df971e7c3562f7918e0ff8.tar.gz
coinos-server-0fb703b85d99c888d1df971e7c3562f7918e0ff8.zip
add webhooks to invoices
Diffstat (limited to 'db/migrations/user_adjustments.js')
-rw-r--r--db/migrations/user_adjustments.js53
1 files changed, 0 insertions, 53 deletions
diff --git a/db/migrations/user_adjustments.js b/db/migrations/user_adjustments.js
deleted file mode 100644
index b4273848..00000000
--- a/db/migrations/user_adjustments.js
+++ /dev/null
@@ -1,53 +0,0 @@
-
-exports.up = function(knex) {
- return Promise.all([
-
- // move security fields to separate t (potentially different access permissions)
-
- knex.schema.createTable('user_security', function (t) {
- t.increments('id').unsigned().primary();
- t.int('user_id').notNull();
- t.foreign('user_id').references('users.user_id');
-
- t.boolean('twofa').notNull().defaultTo(false);
- t.string('pin').notNull();
- t.string('otp_secret').nullable();
- t.string('seed').nullable();
- },
-
- knex.raw("INSERT INTO user_security (user_id, twofa, pin, otp_secret, seed) SELECT users.id, twofa, pin, otpsecret, seed FROM users"),
-
- // move user-customizeable fields to separate t (potentially different access permissions)
-
- knex.schema.createTable('user_preferences', function (t) {
- t.increments('id').unsigned().primary();
- t.int('user_id').notNull();
- t.foreign('user_id').references('users.user_id');
-
- t.enum('default_unit', ['SAT', 'BTC', 'CAD']).notNull().defaultTo('SAT');
- t.enum('default_currency', ['CAD', 'USD']).notNull().defaultTo('CAD');
- t.enum('default_fiat', ['CAD', 'USD']).notNull().defaultTo('CAD');
- t.set('show_currencies', ['CAD', 'USD']).notNull().defaultTo('CAD');
- }
-
- knex.raw("INSERT INTO user_preferences (user_id, default_unit, default_currency, default_fiat, show_currencies) SELECT users.id, unit, currency, fiat, currencies FROM users"),
-
- // remove deprecated fields
-
- knex.schema.table('users', function (t) {
- t.string('uuid');
- t.enum('access', ['Anonymous', 'Member', 'Admin']).defaultTo('Anonymous');
-
- t.dropColumn('account_id');
- t.dropColumn('unit');
- t.dropColumn('fiat');
- t.dropColumn('currency');
- t.dropColumn('currencies');
- },
- ])
-
-};
-
-exports.down = function(knex) {
-
-};