server/initializers/migrations/0365-user-admin-flags.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   db: any
   8 }): Promise<void> {
   9   {
  10     const data = {
  11       type: Sequelize.INTEGER,
  12       defaultValue: null,
  13       allowNull: true
  14     }
  15     await utils.queryInterface.addColumn('user', 'adminFlags', data)
  16   }
  17
  18   {
  19     const query = 'UPDATE "user" SET "adminFlags" = 0'
  20     await utils.sequelize.query(query)
  21   }
  22
  23   {
  24     const data = {
  25       type: Sequelize.INTEGER,
  26       defaultValue: null,
  27       allowNull: false
  28     }
  29     await utils.queryInterface.changeColumn('user', 'adminFlags', data)
  30   }
  31 }
  32
  33 function down (options) {
  34   throw new Error('Not implemented.')
  35 }
  36
  37 export {
  38   up,
  39   down
  40 }