4 up: function(queryInterface, Sequelize) {
5 queryInterface.addColumn('cm_companies', 'emailDomain', Sequelize.STRING);
6 queryInterface.addColumn('mail_accounts', 'TemplateId', Sequelize.INTEGER);
7 queryInterface.addColumn('mail_rooms', 'ParentId', Sequelize.INTEGER);
8 queryInterface.sequelize.query(
9 "ALTER TABLE mail_accounts ADD CONSTRAINT `mail_accounts_ibfk_2` FOREIGN KEY (`TemplateId`) REFERENCES `tools_templates` (`id`) ON DELETE SET NULL ON UPDATE CASCADE");
13 down: function(queryInterface, Sequelize) {
14 queryInterface.sequelize.query('ALTER TABLE mail_accounts DROP FOREIGN KEY `mail_accounts_ibfk_2`;');
15 queryInterface.removeColumn('mail_accounts', 'TemplateId');
16 queryInterface.removeColumn('mail_rooms', 'ParentId');
17 queryInterface.removeColumn('cm_companies', 'emailDomain');