1 import * as Sequelize from 'sequelize'
3 async function up (utils: {
4 transaction: Sequelize.Transaction
5 queryInterface: Sequelize.QueryInterface
6 sequelize: Sequelize.Sequelize
10 const notificationSettingColumns = [ 'newPeerTubeVersion', 'newPluginVersion' ]
12 for (const column of notificationSettingColumns) {
14 type: Sequelize.INTEGER,
18 await utils.queryInterface.addColumn('userNotificationSetting', column, data)
22 const query = 'UPDATE "userNotificationSetting" SET "newPeerTubeVersion" = 3, "newPluginVersion" = 1'
23 await utils.sequelize.query(query)
26 for (const column of notificationSettingColumns) {
28 type: Sequelize.INTEGER,
32 await utils.queryInterface.changeColumn('userNotificationSetting', column, data)
37 function down (options) {
38 throw new Error('Not implemented.')