es6 migration

42 files changed, 115 insertions, 119 deletions

diff --git a/db/index.js b/db/index.js
index c4dab977..0592dc7c 100644
--- a/db/index.js
+++ b/db/index.js
@@ -1,8 +1,5 @@
-const Sequelize = require("sequelize");
-
-const dbOptions = require("./../config/knexfile.js")[
-  process.env.NODE_ENV || "development"
-];
+import Sequelize from 'sequelize';
+import dbOptions from './../config/knexfile.js';
 
 db = new Sequelize(
   dbOptions.connection.database,
@@ -23,15 +20,15 @@ db.authenticate().catch((err) => {
 
 knex = require("knex")(dbOptions);
 
-require("./models/accounts.js");
-require("./models/codes.js");
-require("./models/deposits.js");
-require("./models/invoices.js");
-require("./models/keys.js");
-require("./models/payments.js");
-require("./models/orders.js");
-require("./models/users.js");
-require("./models/withdrawals.js");
+import './models/accounts.js';
+import './models/codes.js';
+import './models/deposits.js';
+import './models/invoices.js';
+import './models/keys.js';
+import './models/payments.js';
+import './models/orders.js';
+import './models/users.js';
+import './models/withdrawals.js';
 
 // Require models in order (to enable FK relationship specs in models)
 
@@ -39,8 +36,9 @@ require("./models/withdrawals.js");
 // require("./normalized/user_keys.js");
 // require("./normalized/user_preferences.js");
 
-require("./models/referrals.js");
-require("./models/waiting_list.js");
+import './models/referrals.js';
+
+import './models/waiting_list.js';
 
 // require("./normalized/subscriptions.js");
 // require("./normalized/user_subscriptions.js");
diff --git a/db/migrations/20210612181508_init_referrals.js b/db/migrations/20210612181508_init_referrals.js
index ae07799d..63b20ce4 100644
--- a/db/migrations/20210612181508_init_referrals.js
+++ b/db/migrations/20210612181508_init_referrals.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return Promise.all([
     knex.schema.dropTableIfExists('referrals'),
 
@@ -19,6 +19,6 @@ exports.up = function(knex) {
   ])
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('referrals');
 };
diff --git a/db/migrations/20210612192804_init_waiting_list.js.js b/db/migrations/20210612192804_init_waiting_list.js.js
index 1e8d2be6..0cef7356 100644
--- a/db/migrations/20210612192804_init_waiting_list.js.js
+++ b/db/migrations/20210612192804_init_waiting_list.js.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
 
     return Promise.all([
       knex.schema.dropTableIfExists('waiting_list'),
@@ -17,8 +17,8 @@ exports.up = function(knex) {
         t.timestamps(true, true);
       })
     ])
-}
-  
-exports.down = function(knex) {
+};
+
+export const down = function(knex) {
     return knex.schema.dropTable('waiting_list');
-}
+};
diff --git a/db/migrations/20210612203333_schema_diff_merges.js b/db/migrations/20210612203333_schema_diff_merges.js
index a853f449..418105d2 100644
--- a/db/migrations/20210612203333_schema_diff_merges.js
+++ b/db/migrations/20210612203333_schema_diff_merges.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return Promise.all([
     knex.schema.dropTableIfExists('reset'),
     knex.schema.dropTableIfExists('naughty'),
@@ -21,9 +21,9 @@ exports.up = function(knex) {
     knex.raw("ALTER TABLE users MODIFY `subscriptions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL"),
 
   ])
-}
+};
 
-exports.down = async function(knex) {
+export const down = async function(knex) {
   return Promise.all([
     knex.schema.table("orders", function(t) {
       t.integer("a1");
@@ -36,4 +36,4 @@ exports.down = async function(knex) {
       t.dropColumn("authyId");
     }),
   ])
-}
\ No newline at end of file
+};
\ No newline at end of file
diff --git a/db/migrations/20210625232223_add_invoice_id_to_payments.js b/db/migrations/20210625232223_add_invoice_id_to_payments.js
index d8f70a6f..adf99d24 100644
--- a/db/migrations/20210625232223_add_invoice_id_to_payments.js
+++ b/db/migrations/20210625232223_add_invoice_id_to_payments.js
@@ -1,13 +1,13 @@
-exports.up = async function (knex) {
+export const up = async function (knex) {
   return knex.schema.table("payments", function(table) {
     table.integer("invoice_id");
     table.foreign("invoice_id").references("invoices.id");
   })
-}
+};
 
-exports.down = async function (knex) {
+export const down = async function (knex) {
   return knex.schema.table("payments", function(table) {
     table.dropForeign("invoice_id");
     table.dropColumn("invoice_id");
   })
-}
+};
diff --git a/db/migrations/20210628221727_add_webhook_to_invoices.js b/db/migrations/20210628221727_add_webhook_to_invoices.js
index 073b8d01..434819e5 100644
--- a/db/migrations/20210628221727_add_webhook_to_invoices.js
+++ b/db/migrations/20210628221727_add_webhook_to_invoices.js
@@ -1,10 +1,10 @@
-exports.up = async function(knex) {
+export const up = async function(knex) {
   return knex.schema.table("invoices", function(table) {
     table.text("webhook");
   });
 };
 
-exports.down = async function(knex) {
+export const down = async function(knex) {
   return knex.schema.table("invoices", function(table) {
     table.dropColumn("webhook");
   });
diff --git a/db/migrations/20210713174217_add_admin_to_users.js b/db/migrations/20210713174217_add_admin_to_users.js
index 05b1bbc9..879c8cb7 100644
--- a/db/migrations/20210713174217_add_admin_to_users.js
+++ b/db/migrations/20210713174217_add_admin_to_users.js
@@ -1,4 +1,4 @@
-exports.up = async function(knex) {
+export const up = async function(knex) {
   return knex.schema.table("users", function(t) {
     t.boolean("admin");
     t.string('email');
@@ -7,7 +7,7 @@ exports.up = async function(knex) {
   });
 };
 
-exports.down = async function(knex) {
+export const down = async function(knex) {
   return knex.schema.table("users", function(t) {
     t.dropColumn("admin");
     t.dropColumn('email')
diff --git a/db/migrations/20210714123455_data_fixes_merge.js b/db/migrations/20210714123455_data_fixes_merge.js
index eb873554..dfe96509 100644
--- a/db/migrations/20210714123455_data_fixes_merge.js
+++ b/db/migrations/20210714123455_data_fixes_merge.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return Promise.all([
     knex.raw("delete from invoices where invoices.account_id not in (select id from accounts)"),
     knex.raw("delete from orders where orders.a1_id not in (select id from accounts) or orders.a2_id not in (select id from accounts)"),
@@ -13,10 +13,10 @@ exports.up = function(knex) {
     knex.raw('delete from accounts where user_id is null'),
     knex.raw('delete from users where length(username) > 32')
   ])
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return Promise.all([
 
   ])
-}
+};
diff --git a/db/migrations/20210714123456_add_fks_merge.js b/db/migrations/20210714123456_add_fks_merge.js
index e714520b..3d5f3e94 100644
--- a/db/migrations/20210714123456_add_fks_merge.js
+++ b/db/migrations/20210714123456_add_fks_merge.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return Promise.all([
 
     // alter table invoices add foreign key (user_id) references users (id);
@@ -39,7 +39,7 @@ exports.up = function(knex) {
       t.index('updatedAt')
     }),
   ])
-}
+};
 
-exports.down = function(knex) {
-}
+export const down = function(knex) {
+};
diff --git a/db/migrations/s2/user_adjustments.js b/db/migrations/s2/user_adjustments.js
index 010bbc76..cbe17977 100644
--- a/db/migrations/s2/user_adjustments.js
+++ b/db/migrations/s2/user_adjustments.js
@@ -1,5 +1,5 @@
 
-exports.up = function(knex) {
+export const up = function(knex) {
   return Promise.all([
 
     // move security fields to separate t (potentially different access permissions)
@@ -48,7 +48,7 @@ exports.up = function(knex) {
   
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return Promise.all([
     knex.schema.table('users', function (t) {
       t.dropColumn('uuid');
diff --git a/db/models/accounts.js b/db/models/accounts.js
index 14f5d044..3dd9ff71 100644
--- a/db/models/accounts.js
+++ b/db/models/accounts.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/codes.js b/db/models/codes.js
index 66a8f7e0..b00f5bfb 100644
--- a/db/models/codes.js
+++ b/db/models/codes.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   code: {
diff --git a/db/models/deposits.js b/db/models/deposits.js
index df870330..c52d37dd 100644
--- a/db/models/deposits.js
+++ b/db/models/deposits.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/invoices.js b/db/models/invoices.js
index d985ce82..54f3f8bd 100644
--- a/db/models/invoices.js
+++ b/db/models/invoices.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/keys.js b/db/models/keys.js
index 1a2a84ae..47ec7745 100644
--- a/db/models/keys.js
+++ b/db/models/keys.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/orders.js b/db/models/orders.js
index e9c701a3..864b6b44 100644
--- a/db/models/orders.js
+++ b/db/models/orders.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require("sequelize");
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/payments.js b/db/models/payments.js
index bbf7c436..fd6b3593 100644
--- a/db/models/payments.js
+++ b/db/models/payments.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/referrals.js b/db/models/referrals.js
index 39248540..79c73e38 100644
--- a/db/models/referrals.js
+++ b/db/models/referrals.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/users.js b/db/models/users.js
index d9180a7f..fa89f315 100644
--- a/db/models/users.js
+++ b/db/models/users.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/waiting_list.js b/db/models/waiting_list.js
index 9a876df6..742306c0 100644
--- a/db/models/waiting_list.js
+++ b/db/models/waiting_list.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/models/withdrawals.js b/db/models/withdrawals.js
index 7ece9b58..12f6ee6d 100644
--- a/db/models/withdrawals.js
+++ b/db/models/withdrawals.js
@@ -1,4 +1,4 @@
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/normalized/accounts.js b/db/normalized/accounts.js
index 6136d0a0..c6ab1100 100644
--- a/db/normalized/accounts.js
+++ b/db/normalized/accounts.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('accounts', function(t) {
     t.increments('id').unsigned().primary();
     t.int('user_id').notNull();
@@ -23,9 +23,9 @@ exports.up = function(knex) {
 
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('accounts');
 };
 
diff --git a/db/normalized/bank_accounts.js b/db/normalized/bank_accounts.js
index 3877ffd3..5d8ea0dc 100644
--- a/db/normalized/bank_accounts.js
+++ b/db/normalized/bank_accounts.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('bank_accounts', function(t) {
     t.increments('id').unsigned().primary();
     t.int('user_id').notNull();
@@ -13,9 +13,9 @@ exports.up = function(knex) {
     
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('user_security');
 };
 
diff --git a/db/normalized/credits.js b/db/normalized/credits.js
index 8b8dd5ea..92bf5359 100644
--- a/db/normalized/credits.js
+++ b/db/normalized/credits.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('credits', function(t) {
       t.increments('id').unsigned().primary();
 
@@ -16,7 +16,7 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
 return knex.schema.dropTable('credits');
 };
 
@@ -42,7 +42,7 @@ return knex.schema.dropTable('credits');
 // context for path, memo, rate, preimage, address, received, fee, tip, confirmed, redeemcode ?
 
 
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/normalized/debits.js b/db/normalized/debits.js
index 1b65adc6..256853c8 100644
--- a/db/normalized/debits.js
+++ b/db/normalized/debits.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('debits', function(t) {
       t.increments('id').unsigned().primary();
 
@@ -16,7 +16,7 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
 return knex.schema.dropTable('debits');
 };
 
@@ -42,7 +42,7 @@ return knex.schema.dropTable('debits');
 // context for path, memo, rate, preimage, address, received, fee, tip, confirmed, redeemcode ?
 
 
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/normalized/deposits.js b/db/normalized/deposits.js
index c14884ce..2a3c83fb 100644
--- a/db/normalized/deposits.js
+++ b/db/normalized/deposits.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('deposits', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -9,9 +9,9 @@ exports.up = function(knex) {
 
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('deposits');
 };
 
diff --git a/db/normalized/exchanges.js b/db/normalized/exchanges.js
index 3fd0a5ca..2f34a394 100644
--- a/db/normalized/exchanges.js
+++ b/db/normalized/exchanges.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('exchanges', function(t) {
       t.increments('id').unsigned().primary();
 
@@ -12,7 +12,7 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
 return knex.schema.dropTable('exchanges');
 };
 
@@ -38,7 +38,7 @@ return knex.schema.dropTable('exchanges');
 // context for path, memo, rate, preimage, address, received, fee, tip, confirmed, redeemcode ?
 
 
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/normalized/invoices.js b/db/normalized/invoices.js
index ec075db8..25f5b681 100644
--- a/db/normalized/invoices.js
+++ b/db/normalized/invoices.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('invoices', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -27,9 +27,9 @@ exports.up = function(knex) {
 
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('invoices');
 };
 
diff --git a/db/normalized/liquid_assets.js b/db/normalized/liquid_assets.js
index f16712d8..fab96dc5 100644
--- a/db/normalized/liquid_assets.js
+++ b/db/normalized/liquid_assets.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('liquid_assets', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -14,8 +14,8 @@ exports.up = function(knex) {
 
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('liquid_assets');
 };
\ No newline at end of file
diff --git a/db/normalized/ln_keys.js b/db/normalized/ln_keys.js
index 74f9ebad..7922e40e 100644
--- a/db/normalized/ln_keys.js
+++ b/db/normalized/ln_keys.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('ln_keys', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -9,8 +9,8 @@ exports.up = function(knex) {
     
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('ln_keys');
 };
\ No newline at end of file
diff --git a/db/normalized/lnurl_codes.js b/db/normalized/lnurl_codes.js
index 696b7d44..5ed81135 100644
--- a/db/normalized/lnurl_codes.js
+++ b/db/normalized/lnurl_codes.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('lnurl_codes', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -7,8 +7,8 @@ exports.up = function(knex) {
     
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('lnurl_codes');
 };
diff --git a/db/normalized/non_custodial_accounts.js b/db/normalized/non_custodial_accounts.js
index ad573bc2..5c56b966 100644
--- a/db/normalized/non_custodial_accounts.js
+++ b/db/normalized/non_custodial_accounts.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('non_custodial_accounts', function(t) {
     t.increments('id').unsigned().primary();
     t.int('account_id').notNull();
@@ -14,10 +14,9 @@ exports.up = function(knex) {
 
     t.timestamps();
   })
-}
-
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('non_custodial_accounts');
 };
 
diff --git a/db/normalized/orders.js b/db/normalized/orders.js
index 8d8418b6..06e83db1 100644
--- a/db/normalized/orders.js
+++ b/db/normalized/orders.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('orders', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -19,12 +19,11 @@ exports.up = function(knex) {
 
     t.timestamps();
   })
-}
- 
+};
 
 // Bid / Accepted ... separate into Bid (credit + debit),  Accepted (credit + debit)
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('orders');
 };
 
diff --git a/db/normalized/referrals.js b/db/normalized/referrals.js
index f09c98f4..7380f2cf 100644
--- a/db/normalized/referrals.js
+++ b/db/normalized/referrals.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('referrals', function(t) {
     t.increments('id').unsigned().primary();
     t.int('user_id').nullable();
@@ -15,6 +15,6 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('referrals');
 };
diff --git a/db/normalized/transactions.js b/db/normalized/transactions.js
index 7180b8d7..230faca4 100644
--- a/db/normalized/transactions.js
+++ b/db/normalized/transactions.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('transactions', function(t) {
       t.increments('id').unsigned().primary();
 
@@ -10,7 +10,7 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
 return knex.schema.dropTable('transactions');
 };
 
@@ -26,7 +26,7 @@ return knex.schema.dropTable('transactions');
 
 //
 // context for path, memo, rate, preimage, address, received, fee, tip, confirmed, redeemcode ?
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('transactions', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -36,6 +36,6 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
 return knex.schema.dropTable('transactions');
 };
\ No newline at end of file
diff --git a/db/normalized/transfers.js b/db/normalized/transfers.js
index cefc66f7..aa81472f 100644
--- a/db/normalized/transfers.js
+++ b/db/normalized/transfers.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('transfers', function(t) {
       t.increments('id').unsigned().primary();
 
@@ -23,7 +23,7 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
 return knex.schema.dropTable('transfers');
 };
 
@@ -49,7 +49,7 @@ return knex.schema.dropTable('transfers');
 // context for path, memo, rate, preimage, address, received, fee, tip, confirmed, redeemcode ?
 
 
-const { DataTypes } = require('sequelize');
+import { DataTypes } from 'sequelize';
 
 const attributes = {
   id: {
diff --git a/db/normalized/user_preferences.js b/db/normalized/user_preferences.js
index 36956dc0..6af69f3f 100644
--- a/db/normalized/user_preferences.js
+++ b/db/normalized/user_preferences.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('user_preferences', function(t) {
     t.increments('id').unsigned().primary();
     t.int('user_id').notNull();
@@ -13,8 +13,8 @@ exports.up = function(knex) {
     
     // knex.raw("ALTER TABLE users MODIFY `subscriptions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL")
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('user_preferences');
 };
diff --git a/db/normalized/user_security.js b/db/normalized/user_security.js
index 09afa7c6..919b2902 100644
--- a/db/normalized/user_security.js
+++ b/db/normalized/user_security.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('user_security', function(t) {
     t.increments('id').unsigned().primary();
     t.int('user_id').notNull();
@@ -17,6 +17,6 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('user_security');
 };
\ No newline at end of file
diff --git a/db/normalized/users.js b/db/normalized/users.js
index 2c2004c0..dd239f24 100644
--- a/db/normalized/users.js
+++ b/db/normalized/users.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('users', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -13,6 +13,6 @@ exports.up = function(knex) {
   })
 };
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('users');
 };
\ No newline at end of file
diff --git a/db/normalized/vouchers.js b/db/normalized/vouchers.js
index fa5e12a4..35d54de2 100644
--- a/db/normalized/vouchers.js
+++ b/db/normalized/vouchers.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('vouchers', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -11,8 +11,8 @@ exports.up = function(knex) {
   
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('vouchers');
 };
\ No newline at end of file
diff --git a/db/normalized/waiting_list.js b/db/normalized/waiting_list.js
index 42ec57a7..f6908868 100644
--- a/db/normalized/waiting_list.js
+++ b/db/normalized/waiting_list.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('waiting_list', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -8,9 +8,9 @@ exports.up = function(knex) {
   
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('waiting_list');
 };
 
diff --git a/db/normalized/withdrawals.js b/db/normalized/withdrawals.js
index 9a45c514..d404e6e3 100644
--- a/db/normalized/withdrawals.js
+++ b/db/normalized/withdrawals.js
@@ -1,4 +1,4 @@
-exports.up = function(knex) {
+export const up = function(knex) {
   return knex.schema.createTable('withdrawals', function(t) {
     t.increments('id').unsigned().primary();
 
@@ -14,9 +14,9 @@ exports.up = function(knex) {
 
     t.timestamps();
   })
-}
+};
 
-exports.down = function(knex) {
+export const down = function(knex) {
   return knex.schema.dropTable('withdrawals');
 };