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