server/initializers/migrations/0245-user-blocked.ts

   1 import * as Sequelize from 'sequelize'
   2
   3 async function up (utils: {
   4   transaction: Sequelize.Transaction
   5   queryInterface: Sequelize.QueryInterface
   6   sequelize: Sequelize.Sequelize
   7 }): Promise<any> {
   8   {
   9     const data = {
  10       type: Sequelize.BOOLEAN,
  11       allowNull: true,
  12       defaultValue: null
  13     }
  14     await utils.queryInterface.addColumn('user', 'blocked', data)
  15   }
  16
  17   {
  18     const query = 'UPDATE "user" SET "blocked" = false'
  19     await utils.sequelize.query(query)
  20   }
  21
  22   {
  23     const data = {
  24       type: Sequelize.BOOLEAN,
  25       allowNull: false,
  26       defaultValue: null
  27     }
  28     await utils.queryInterface.changeColumn('user', 'blocked', data)
  29   }
  30
  31   {
  32     const data = {
  33       type: Sequelize.STRING(250),
  34       allowNull: true,
  35       defaultValue: null
  36     }
  37     await utils.queryInterface.addColumn('user', 'blockedReason', data)
  38   }
  39 }
  40
  41 function down (options) {
  42   throw new Error('Not implemented.')
  43 }
  44
  45 export { up, down }