4 up: function(queryInterface, Sequelize) {
5 queryInterface.addColumn('tools_schedules', 'MailAccountId', Sequelize.INTEGER);
6 queryInterface.sequelize.query(
7 "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;"
9 queryInterface.addColumn('analytics_extracted_reports', 'MailMessageId', Sequelize.INTEGER);
10 queryInterface.sequelize.query(
11 "ALTER TABLE analytics_extracted_reports ADD CONSTRAINT analytics_extracted_reports_ibfk_1 FOREIGN KEY (MailMessageId) REFERENCES motion.mail_messages(id) ON DELETE SET NULL ON UPDATE CASCADE;"
15 down: function(queryInterface, Sequelize) {
16 queryInterface.sequelize.query('ALTER TABLE tools_schedules DROP CONSTRAINT tools_schedules_ibfk_1;');
17 queryInterface.removeColumn('tools_schedules', 'MailAccountId');
18 queryInterface.sequelize.query('ALTER TABLE analytics_extracted_reports DROP CONSTRAINT analytics_extracted_reports_ibfk_1;');
19 queryInterface.removeColumn('analytics_extracted_reports', 'MailMessageId');