diff options
| author | Adam Soltys <[email protected]> | 2022-09-02 11:02:06 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2022-09-02 11:02:06 -0700 |
| commit | 7a8d64833de8873afb92982b3f5bfff59b30c542 (patch) | |
| tree | bc92e20c7d5127d3b6b17f7b8d3190e08579f49e /db/migrations | |
| parent | b06e117af96a38b163384f6a343f1de7c8996724 (diff) | |
| download | coinos-server-7a8d64833de8873afb92982b3f5bfff59b30c542.tar.gz coinos-server-7a8d64833de8873afb92982b3f5bfff59b30c542.zip | |
es6 migration
Diffstat (limited to 'db/migrations')
9 files changed, 29 insertions, 29 deletions
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'); |
