aboutsummaryrefslogtreecommitdiffstats
path: root/db/normalized/user_preferences.js
diff options
context:
space:
mode:
Diffstat (limited to 'db/normalized/user_preferences.js')
-rw-r--r--db/normalized/user_preferences.js20
1 files changed, 0 insertions, 20 deletions
diff --git a/db/normalized/user_preferences.js b/db/normalized/user_preferences.js
deleted file mode 100644
index 6af69f3f..00000000
--- a/db/normalized/user_preferences.js
+++ /dev/null
@@ -1,20 +0,0 @@
-export const up = function(knex) {
- return knex.schema.createTable('user_preferences', function(t) {
- t.increments('id').unsigned().primary();
- t.int('user_id').notNull();
- t.foreign('user_id').references('users.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');
- t.longtext(`subscriptions`).collate('utf8mb4').nullable(); // CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL")
- t.timestamps();
-
- // knex.raw("ALTER TABLE users MODIFY `subscriptions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL")
- })
-};
-
-export const down = function(knex) {
- return knex.schema.dropTable('user_preferences');
-};