server/initializers/migrations/0625-latest-versions-notification.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   {
  11     await utils.sequelize.query(`
  12       ALTER TABLE "userNotification"
  13       ADD COLUMN "applicationId" INTEGER REFERENCES "application" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
  14       ADD COLUMN "pluginId" INTEGER REFERENCES "plugin" ("id") ON DELETE SET NULL ON UPDATE CASCADE
  15     `)
  16   }
  17 }
  18
  19 function down (options) {
  20   throw new Error('Not implemented.')
  21 }
  22
  23 export {
  24   up,
  25   down
  26 }