1 import * as Sequelize from 'sequelize'
2 import * as uuidv4 from 'uuid/v4'
4 async function up (utils: {
5 transaction: Sequelize.Transaction,
6 queryInterface: Sequelize.QueryInterface,
7 sequelize: Sequelize.Sequelize,
10 const q = utils.queryInterface
12 await q.renameColumn('Users', 'role', 'oldRole')
15 type: Sequelize.INTEGER,
18 await q.addColumn('Users', 'role', data)
20 let query = 'UPDATE "Users" SET "role" = 0 WHERE "oldRole" = \'admin\''
21 await utils.sequelize.query(query)
23 query = 'UPDATE "Users" SET "role" = 2 WHERE "oldRole" = \'user\''
24 await utils.sequelize.query(query)
26 data.allowNull = false
27 await q.changeColumn('Users', 'role', data)
29 await q.removeColumn('Users', 'oldRole')
32 function down (options) {
33 throw new Error('Not implemented.')