4 up: function(queryInterface, Sequelize) {
5 queryInterface.addColumn('fax_messages', 'deletedAt', Sequelize.DATE);
6 queryInterface.addColumn('fax_messages', 'from', Sequelize.STRING);
7 queryInterface.addColumn('fax_messages', 'to', Sequelize.STRING);
8 queryInterface.addColumn('fax_messages', 'linkedid', Sequelize.STRING);
9 queryInterface.addColumn('fax_messages', 'text', Sequelize.BLOB);
10 queryInterface.changeColumn('fax_messages', 'status', {
11 type: Sequelize.ENUM('SENT', 'SENDING', 'RECEIVED', 'FAILED', 'NOTE'),
12 defaultValue: 'SENDING'
14 queryInterface.removeColumn('fax_messages', 'actionid');
15 queryInterface.removeColumn('fax_messages', 'language');
16 queryInterface.removeColumn('fax_messages', 'filenamePDF');
17 queryInterface.removeColumn('fax_messages', 'operation');
18 queryInterface.removeColumn('fax_messages', 'uuid');
19 queryInterface.removeColumn('fax_messages', 'laststatus');
20 queryInterface.removeColumn('fax_messages', 'error');
21 queryInterface.removeColumn('fax_messages', 'body');
22 queryInterface.sequelize.query('ALTER TABLE fax_messages DROP FOREIGN KEY `fax_messages_ibfk_1`;');
23 queryInterface.sequelize.query('ALTER TABLE fax_messages DROP FOREIGN KEY `fax_messages_ibfk_2`;');
24 queryInterface.sequelize.query('ALTER TABLE fax_messages DROP FOREIGN KEY `fax_messages_ibfk_3`;');
25 queryInterface.sequelize.query(
26 "ALTER TABLE fax_messages ADD CONSTRAINT `fax_messages_ibfk_1` FOREIGN KEY (`FaxRoomId`) REFERENCES `fax_rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;");
27 queryInterface.removeColumn('fax_messages', 'FromId');
28 queryInterface.removeColumn('fax_messages', 'ToId');
29 queryInterface.addColumn('fax_messages', 'UserId', Sequelize.INTEGER);
30 queryInterface.sequelize.query(
31 "ALTER TABLE fax_messages ADD CONSTRAINT `fax_messages_ibfk_2` FOREIGN KEY (`UserId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;");
34 down: function(queryInterface, Sequelize) {
35 queryInterface.removeColumn('fax_messages', 'deletedAt');
36 queryInterface.removeColumn('fax_messages', 'from');
37 queryInterface.removeColumn('fax_messages', 'to');
38 queryInterface.removeColumn('fax_messages', 'linkedid');
39 queryInterface.removeColumn('fax_messages', 'text');
40 queryInterface.changeColumn('fax_messages', 'status', {
41 type: Sequelize.ENUM('SENT', 'SENDING', 'RECEIVED', 'NOT SENT'),
44 queryInterface.addColumn('fax_messages', 'actionid', Sequelize.STRING);
45 queryInterface.addColumn('fax_messages', 'language', Sequelize.STRING);
46 queryInterface.addColumn('fax_messages', 'filenamePDF', Sequelize.STRING);
47 queryInterface.addColumn('fax_messages', 'operation', Sequelize.STRING);
48 queryInterface.addColumn('fax_messages', 'uuid', Sequelize.STRING);
49 queryInterface.addColumn('fax_messages', 'laststatus', Sequelize.STRING);
50 queryInterface.addColumn('fax_messages', 'error', Sequelize.STRING);
51 queryInterface.addColumn('fax_messages', 'body', Sequelize.TEXT);
52 queryInterface.sequelize.query('ALTER TABLE fax_messages DROP FOREIGN KEY `fax_messages_ibfk_1`;');
53 queryInterface.sequelize.query(
54 "ALTER TABLE fax_messages ADD CONSTRAINT `fax_messages_ibfk_1` FOREIGN KEY (`FaxRoomId`) REFERENCES `fax_rooms` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;");
55 queryInterface.addColumn('fax_messages', 'FromId', Sequelize.INTEGER);
56 queryInterface.addColumn('fax_messages', 'ToId', Sequelize.INTEGER);
57 queryInterface.sequelize.query('ALTER TABLE fax_messages DROP FOREIGN KEY `fax_messages_ibfk_2`;');
58 queryInterface.removeColumn('fax_messages', 'UserId');
59 queryInterface.sequelize.query(
60 "ALTER TABLE fax_messages ADD CONSTRAINT `fax_messages_ibfk_2` FOREIGN KEY (`FromId`) REFERENCES `cm_contacts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;");
61 queryInterface.sequelize.query(
62 "ALTER TABLE fax_messages ADD CONSTRAINT `fax_messages_ibfk_3` FOREIGN KEY (`ToId`) REFERENCES `cm_contacts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;");