[github/Chocobozzz/PeerTube.git] / server / initializers / migrations / 0625-latest-versions-notification.ts

import * as Sequelize from 'sequelize'

async function up (utils: {
  transaction: Sequelize.Transaction
  queryInterface: Sequelize.QueryInterface
  sequelize: Sequelize.Sequelize
  db: any
}): Promise<void> {

  {
    await utils.sequelize.query(`
      ALTER TABLE "userNotification"
      ADD COLUMN "applicationId" INTEGER REFERENCES "application" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
      ADD COLUMN "pluginId" INTEGER REFERENCES "plugin" ("id") ON DELETE SET NULL ON UPDATE CASCADE
    `)
  }
}

function down (options) {
  throw new Error('Not implemented.')
}

export {
  up,
  down
}
Commit	Line	Data
	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	}