diff options
| author | Adam Soltys <[email protected]> | 2020-03-11 15:10:40 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2020-03-11 15:10:40 -0700 |
| commit | c0888fab024cc9f7c99812bfabf9d7774312dbf7 (patch) | |
| tree | cad95683af97432f6092a2c2bae10fbb7a588db5 /migrations | |
| parent | bf2b51f0c2ae9b8f0f330dde6411e45fc0da8a25 (diff) | |
| download | coinos-server-c0888fab024cc9f7c99812bfabf9d7774312dbf7.tar.gz coinos-server-c0888fab024cc9f7c99812bfabf9d7774312dbf7.zip | |
refactor
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/20180128181238-create-user.js | 60 | ||||
| -rw-r--r-- | migrations/20180206033508-create-transaction.js | 39 | ||||
| -rw-r--r-- | migrations/20180214033702-addUserBalance.js | 11 | ||||
| -rw-r--r-- | migrations/20180215052148-addChannelPoint.js | 11 | ||||
| -rw-r--r-- | migrations/20180217065619-addChannelBalance.js | 11 | ||||
| -rw-r--r-- | migrations/20180221010609-createInvoices.js | 32 | ||||
| -rw-r--r-- | migrations/20180312160019-addInvoiceRateAndCurrency.js | 13 | ||||
| -rw-r--r-- | migrations/20180315232457-renameInvoices.js | 15 | ||||
| -rw-r--r-- | migrations/20180316032817-addPaymentsAmount.js | 11 | ||||
| -rw-r--r-- | migrations/20180322163730-addTipToPayments.js | 11 | ||||
| -rw-r--r-- | migrations/20181008052713-addUserChannels.js | 11 | ||||
| -rw-r--r-- | migrations/20181008053428-addUsersBalances.js | 11 | ||||
| -rw-r--r-- | migrations/20190113193839-create_orders.js | 25 |
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'); - }, -}; |
