4 up: function(queryInterface, Sequelize) {
5 queryInterface.sequelize.query('ALTER TABLE `tools_schedules` DROP FOREIGN KEY `tools_schedules_ibfk_1`;');
6 queryInterface.removeIndex('tools_schedules', 'MailAccountId');
7 queryInterface.addColumn('tools_schedules', 'MailServerOutId', Sequelize.INTEGER);
8 queryInterface.sequelize.query(
9 'ALTER TABLE `tools_schedules` ADD FOREIGN KEY (`MailServerOutId`) REFERENCES `mail_servers_out` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;'
11 queryInterface.sequelize.query('ALTER TABLE `tools_schedules` DROP COLUMN `MailAccountId`;');
14 down: function(queryInterface, Sequelize) {
15 queryInterface.sequelize.query('ALTER TABLE `tools_schedules` DROP FOREIGN KEY `tools_schedules_ibfk_1`;');
16 queryInterface.removeIndex('tools_schedules', 'MailServerOutId');
17 queryInterface.addColumn('tools_schedules', 'MailAccountId', Sequelize.INTEGER);
18 queryInterface.sequelize.query(
19 'ALTER TABLE `tools_schedules` ADD FOREIGN KEY (`MailAccountId`) REFERENCES `mail_accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;'
21 queryInterface.sequelize.query('ALTER TABLE `tools_schedules` DROP COLUMN `MailServerOutId`;');