1 import * as Sequelize from 'sequelize'
2 import { VideoBlacklistType } from '../../../shared/models/videos'
4 async function up (utils: {
5 transaction: Sequelize.Transaction
6 queryInterface: Sequelize.QueryInterface
7 sequelize: Sequelize.Sequelize
12 type: Sequelize.INTEGER,
17 await utils.queryInterface.addColumn('videoBlacklist', 'type', data)
21 const query = 'UPDATE "videoBlacklist" SET "type" = ' + VideoBlacklistType.MANUAL
22 await utils.sequelize.query(query)
27 type: Sequelize.INTEGER,
31 await utils.queryInterface.changeColumn('videoBlacklist', 'type', data)
36 type: Sequelize.INTEGER,
40 await utils.queryInterface.addColumn('userNotificationSetting', 'videoAutoBlacklistAsModerator', data)
44 const query = 'UPDATE "userNotificationSetting" SET "videoAutoBlacklistAsModerator" = 3'
45 await utils.sequelize.query(query)
50 type: Sequelize.INTEGER,
54 await utils.queryInterface.changeColumn('userNotificationSetting', 'videoAutoBlacklistAsModerator', data)
57 function down (options) {
58 throw new Error('Not implemented.')