4 up: function(queryInterface, Sequelize) {
5 queryInterface.addColumn('mail_rooms', 'mailIn', {
6 type: Sequelize.INTEGER,
9 queryInterface.addColumn('mail_rooms', 'mailOut', {
10 type: Sequelize.INTEGER,
13 queryInterface.addColumn('mail_rooms', 'lastEventAt', Sequelize.DATE);
14 queryInterface.addColumn('mail_rooms', 'deleted', {
15 type: Sequelize.BOOLEAN,
18 queryInterface.addColumn('mail_rooms', 'disposition', Sequelize.STRING);
19 queryInterface.addColumn('mail_accounts', 'ListId', Sequelize.INTEGER);
21 queryInterface.sequelize.query("ALTER TABLE mail_accounts ADD CONSTRAINT `mail_accounts_ibfk_1` FOREIGN KEY (`ListId`) REFERENCES `cm_lists` (`id`) ON DELETE SET NULL ON UPDATE CASCADE");
24 down: function(queryInterface, Sequelize) {
25 queryInterface.removeColumn('mail_rooms', 'mailIn');
26 queryInterface.removeColumn('mail_rooms', 'mailOut');
27 queryInterface.removeColumn('mail_rooms', 'lastEventAt');
28 queryInterface.removeColumn('mail_rooms', 'deleted');
29 queryInterface.removeColumn('mail_rooms', 'disposition');
31 queryInterface.sequelize.query('ALTER TABLE mail_accounts DROP FOREIGN KEY `mail_accounts_ibfk_1`;');
32 queryInterface.removeColumn('mail_accounts', 'ListId');