1 import * as Sequelize from 'sequelize'
3 async function up (utils: {
4 transaction: Sequelize.Transaction,
5 queryInterface: Sequelize.QueryInterface,
6 sequelize: Sequelize.Sequelize,
9 const q = utils.queryInterface
11 await q.renameColumn('Users', 'role', 'oldRole')
14 type: Sequelize.INTEGER,
17 await q.addColumn('Users', 'role', data)
19 let query = 'UPDATE "Users" SET "role" = 0 WHERE "oldRole" = \'admin\''
20 await utils.sequelize.query(query)
22 query = 'UPDATE "Users" SET "role" = 2 WHERE "oldRole" = \'user\''
23 await utils.sequelize.query(query)
25 data.allowNull = false
26 await q.changeColumn('Users', 'role', data)
28 await q.removeColumn('Users', 'oldRole')
31 function down (options) {
32 throw new Error('Not implemented.')