server/initializers/migrations/0735-video-channel-sync-import-foreign-key.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   await utils.queryInterface.addColumn('videoImport', 'videoChannelSyncId', {
  10     type: Sequelize.INTEGER,
  11     defaultValue: null,
  12     allowNull: true,
  13     references: {
  14       model: 'videoChannelSync',
  15       key: 'id'
  16     },
  17     onUpdate: 'CASCADE',
  18     onDelete: 'SET NULL'
  19   }, { transaction: utils.transaction })
  20 }
  21
  22 async function down (utils: {
  23   queryInterface: Sequelize.QueryInterface
  24   transaction: Sequelize.Transaction
  25 }) {
  26   await utils.queryInterface.dropTable('videoChannelSync', { transaction: utils.transaction })
  27 }
  28
  29 export {
  30   up,
  31   down
  32 }