aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrations
diff options
context:
space:
mode:
authorAdam Soltys <[email protected]>2022-09-02 11:02:06 -0700
committerAdam Soltys <[email protected]>2022-09-02 11:02:06 -0700
commit7a8d64833de8873afb92982b3f5bfff59b30c542 (patch)
treebc92e20c7d5127d3b6b17f7b8d3190e08579f49e /db/migrations
parentb06e117af96a38b163384f6a343f1de7c8996724 (diff)
downloadcoinos-server-7a8d64833de8873afb92982b3f5bfff59b30c542.tar.gz
coinos-server-7a8d64833de8873afb92982b3f5bfff59b30c542.zip
es6 migration
Diffstat (limited to 'db/migrations')
-rw-r--r--db/migrations/20210612181508_init_referrals.js4
-rw-r--r--db/migrations/20210612192804_init_waiting_list.js.js10
-rw-r--r--db/migrations/20210612203333_schema_diff_merges.js8
-rw-r--r--db/migrations/20210625232223_add_invoice_id_to_payments.js8
-rw-r--r--db/migrations/20210628221727_add_webhook_to_invoices.js4
-rw-r--r--db/migrations/20210713174217_add_admin_to_users.js4
-rw-r--r--db/migrations/20210714123455_data_fixes_merge.js8
-rw-r--r--db/migrations/20210714123456_add_fks_merge.js8
-rw-r--r--db/migrations/s2/user_adjustments.js4
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');