aboutsummaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorAdam Soltys <[email protected]>2020-03-11 15:10:40 -0700
committerAdam Soltys <[email protected]>2020-03-11 15:10:40 -0700
commitc0888fab024cc9f7c99812bfabf9d7774312dbf7 (patch)
treecad95683af97432f6092a2c2bae10fbb7a588db5 /migrations
parentbf2b51f0c2ae9b8f0f330dde6411e45fc0da8a25 (diff)
downloadcoinos-server-c0888fab024cc9f7c99812bfabf9d7774312dbf7.tar.gz
coinos-server-c0888fab024cc9f7c99812bfabf9d7774312dbf7.zip
refactor
Diffstat (limited to 'migrations')
-rw-r--r--migrations/20180128181238-create-user.js60
-rw-r--r--migrations/20180206033508-create-transaction.js39
-rw-r--r--migrations/20180214033702-addUserBalance.js11
-rw-r--r--migrations/20180215052148-addChannelPoint.js11
-rw-r--r--migrations/20180217065619-addChannelBalance.js11
-rw-r--r--migrations/20180221010609-createInvoices.js32
-rw-r--r--migrations/20180312160019-addInvoiceRateAndCurrency.js13
-rw-r--r--migrations/20180315232457-renameInvoices.js15
-rw-r--r--migrations/20180316032817-addPaymentsAmount.js11
-rw-r--r--migrations/20180322163730-addTipToPayments.js11
-rw-r--r--migrations/20181008052713-addUserChannels.js11
-rw-r--r--migrations/20181008053428-addUsersBalances.js11
-rw-r--r--migrations/20190113193839-create_orders.js25
13 files changed, 0 insertions, 261 deletions
diff --git a/migrations/20180128181238-create-user.js b/migrations/20180128181238-create-user.js
deleted file mode 100644
index 50424e18..00000000
--- a/migrations/20180128181238-create-user.js
+++ /dev/null
@@ -1,60 +0,0 @@
-'use strict';
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.createTable('users', {
- id: {
- allowNull: false,
- autoIncrement: true,
- primaryKey: true,
- type: Sequelize.INTEGER
- },
- username: {
- type: Sequelize.STRING
- },
- password: {
- type: Sequelize.STRING
- },
- email: {
- type: Sequelize.STRING
- },
- address: {
- type: Sequelize.STRING
- },
- unit: {
- type: Sequelize.STRING
- },
- symbol: {
- type: Sequelize.STRING
- },
- currency: {
- type: Sequelize.STRING
- },
- commission: {
- type: Sequelize.STRING
- },
- title: {
- type: Sequelize.STRING
- },
- pubkey: {
- type: Sequelize.STRING
- },
- privkey: {
- type: Sequelize.STRING
- },
- index: {
- type: Sequelize.INTEGER
- },
- createdAt: {
- allowNull: false,
- type: Sequelize.DATE
- },
- updatedAt: {
- allowNull: false,
- type: Sequelize.DATE
- }
- });
- },
- down: (queryInterface, Sequelize) => {
- return queryInterface.dropTable('users');
- }
-};
diff --git a/migrations/20180206033508-create-transaction.js b/migrations/20180206033508-create-transaction.js
deleted file mode 100644
index 06863a43..00000000
--- a/migrations/20180206033508-create-transaction.js
+++ /dev/null
@@ -1,39 +0,0 @@
-'use strict';
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.createTable('transactions', {
- id: {
- allowNull: false,
- autoIncrement: true,
- primaryKey: true,
- type: Sequelize.INTEGER
- },
- hash: {
- type: Sequelize.STRING
- },
- address: {
- type: Sequelize.STRING
- },
- date: {
- type: Sequelize.DATE
- },
- amount: {
- type: Sequelize.FLOAT
- },
- rate: {
- type: Sequelize.FLOAT
- },
- createdAt: {
- allowNull: false,
- type: Sequelize.DATE
- },
- updatedAt: {
- allowNull: false,
- type: Sequelize.DATE
- }
- });
- },
- down: (queryInterface, Sequelize) => {
- return queryInterface.dropTable('transactions');
- }
-};
diff --git a/migrations/20180214033702-addUserBalance.js b/migrations/20180214033702-addUserBalance.js
deleted file mode 100644
index 06ef5adb..00000000
--- a/migrations/20180214033702-addUserBalance.js
+++ /dev/null
@@ -1,11 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.addColumn('users', 'balance', { type: Sequelize.INTEGER });
- },
-
- down: (queryInterface, Sequelize) => {
- return queryInterface.removeColumn('users', 'balance');
- }
-};
diff --git a/migrations/20180215052148-addChannelPoint.js b/migrations/20180215052148-addChannelPoint.js
deleted file mode 100644
index 3c175713..00000000
--- a/migrations/20180215052148-addChannelPoint.js
+++ /dev/null
@@ -1,11 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.addColumn('users', 'channel', { type: Sequelize.STRING })
- },
-
- down: (queryInterface, Sequelize) => {
- return queryInterface.removeColumn('users', 'channel')
- }
-};
diff --git a/migrations/20180217065619-addChannelBalance.js b/migrations/20180217065619-addChannelBalance.js
deleted file mode 100644
index fc909f53..00000000
--- a/migrations/20180217065619-addChannelBalance.js
+++ /dev/null
@@ -1,11 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.addColumn('users', 'channelbalance', { type: Sequelize.INTEGER })
- },
-
- down: (queryInterface, Sequelize) => {
- return queryInterface.removeColumn('users', 'channelbalance')
- }
-};
diff --git a/migrations/20180221010609-createInvoices.js b/migrations/20180221010609-createInvoices.js
deleted file mode 100644
index 3fbcfa21..00000000
--- a/migrations/20180221010609-createInvoices.js
+++ /dev/null
@@ -1,32 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.createTable('invoices', {
- id: {
- allowNull: false,
- autoIncrement: true,
- primaryKey: true,
- type: Sequelize.INTEGER,
- },
- user_id: {
- type: Sequelize.INTEGER,
- },
- payreq: {
- type: Sequelize.STRING,
- },
- createdAt: {
- allowNull: false,
- type: Sequelize.DATE
- },
- updatedAt: {
- allowNull: false,
- type: Sequelize.DATE
- },
- })
- },
-
- down: (queryInterface, Sequelize) => {
- return queryInterface.dropTable('invoices')
- },
-};
diff --git a/migrations/20180312160019-addInvoiceRateAndCurrency.js b/migrations/20180312160019-addInvoiceRateAndCurrency.js
deleted file mode 100644
index 97dbc6ea..00000000
--- a/migrations/20180312160019-addInvoiceRateAndCurrency.js
+++ /dev/null
@@ -1,13 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- queryInterface.addColumn('invoices', 'rate', { type: Sequelize.DOUBLE })
- return queryInterface.addColumn('invoices', 'currency', { type: Sequelize.STRING })
- },
-
- down: (queryInterface, Sequelize) => {
- queryInterface.removeColumn('invoices', 'rate')
- return queryInterface.removeColumn('invoices', 'currency')
- }
-};
diff --git a/migrations/20180315232457-renameInvoices.js b/migrations/20180315232457-renameInvoices.js
deleted file mode 100644
index 9e06e56d..00000000
--- a/migrations/20180315232457-renameInvoices.js
+++ /dev/null
@@ -1,15 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- queryInterface.renameTable('invoices', 'payments')
- queryInterface.addColumn('payments', 'address', { type: Sequelize.INTEGER });
- queryInterface.addColumn('payments', 'received', { type: Sequelize.BOOLEAN });
- },
-
- down: (queryInterface, Sequelize) => {
- queryInterface.removeColumn('payments', 'received');
- queryInterface.removeColumn('payments', 'address');
- queryInterface.renameTable('payments', 'invoices')
- }
-};
diff --git a/migrations/20180316032817-addPaymentsAmount.js b/migrations/20180316032817-addPaymentsAmount.js
deleted file mode 100644
index 89356ea3..00000000
--- a/migrations/20180316032817-addPaymentsAmount.js
+++ /dev/null
@@ -1,11 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.addColumn('payments', 'amount', { type: Sequelize.DOUBLE });
- },
-
- down: (queryInterface, Sequelize) => {
- return queryInterface.removeColumn('payments', 'amount');
- }
-};
diff --git a/migrations/20180322163730-addTipToPayments.js b/migrations/20180322163730-addTipToPayments.js
deleted file mode 100644
index a482c7d4..00000000
--- a/migrations/20180322163730-addTipToPayments.js
+++ /dev/null
@@ -1,11 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.addColumn('payments', 'tip', { type: Sequelize.DOUBLE })
- },
-
- down: (queryInterface, Sequelize) => {
- return queryInterface.removeColumn('payments', 'tip');
- }
-};
diff --git a/migrations/20181008052713-addUserChannels.js b/migrations/20181008052713-addUserChannels.js
deleted file mode 100644
index 29692445..00000000
--- a/migrations/20181008052713-addUserChannels.js
+++ /dev/null
@@ -1,11 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.createTable('users_channels', { user_id: Sequelize.INTEGER, channel_id: Sequelize.INTEGER });
- },
-
- down: (queryInterface, Sequelize) => {
- return queryInterface.dropTable('users_channels');
- }
-};
diff --git a/migrations/20181008053428-addUsersBalances.js b/migrations/20181008053428-addUsersBalances.js
deleted file mode 100644
index 5f528322..00000000
--- a/migrations/20181008053428-addUsersBalances.js
+++ /dev/null
@@ -1,11 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.createTable('users_balances', { user_id: Sequelize.INTEGER, symbol: Sequelize.STRING, balance: Sequelize.INTEGER, pending: Sequelize.INTEGER });
- },
-
- down: (queryInterface, Sequelize) => {
- return queryInterface.dropTable('users_balances');
- }
-};
diff --git a/migrations/20190113193839-create_orders.js b/migrations/20190113193839-create_orders.js
deleted file mode 100644
index 01e1ffb1..00000000
--- a/migrations/20190113193839-create_orders.js
+++ /dev/null
@@ -1,25 +0,0 @@
-'use strict';
-
-module.exports = {
- up: (queryInterface, Sequelize) => {
- return queryInterface.createTable('orders', {
- id: {
- allowNull: false,
- autoIncrement: true,
- primaryKey: true,
- type: Sequelize.INTEGER
- },
- amount: { type: Sequelize.INTEGER },
- price: { type: Sequelize.INTEGER },
- type: { type: Sequelize.STRING },
- pair: { type: Sequelize.STRING },
- createdAt: {
- allowNull: false,
- type: Sequelize.DATE
- },
- });
- },
- down: (queryInterface, Sequelize) => {
- return queryInterface.dropTable('orders');
- },
-};