4 up: function(queryInterface, Sequelize) {
5 queryInterface.sequelize.query("UPDATE sms_rooms SET status='NEW' WHERE status='UNMANAGED';");
6 queryInterface.changeColumn('sms_rooms', 'status', {
7 type: Sequelize.ENUM('NEW', 'OPEN', 'PENDING', 'CLOSED'),
10 queryInterface.addColumn('sms_rooms', 'arrivedAt', Sequelize.DATE);
11 queryInterface.addColumn('sms_rooms', 'closedAt', Sequelize.DATE);
12 queryInterface.addColumn('sms_rooms', 'lastEvent', {
13 type: Sequelize.ENUM('SENDING', 'SENT', 'RECEIVED', 'FAILED', 'NOTE')
15 queryInterface.addColumn('sms_rooms', 'lastEventAt', Sequelize.DATE);
16 queryInterface.addColumn('sms_rooms', 'smsIn', Sequelize.INTEGER);
17 queryInterface.addColumn('sms_rooms', 'smsOut', Sequelize.INTEGER);
20 down: function(queryInterface, Sequelize) {
21 queryInterface.sequelize.query("UPDATE sms_rooms SET status='UNMANAGED' WHERE status='NEW';");
22 queryInterface.changeColumn('sms_rooms', 'status', {
23 type: Sequelize.ENUM('NEW', 'OPEN', 'UNMANAGED', 'CLOSED'),
26 queryInterface.removeColumn('sms_rooms', 'arrivedAt');
27 queryInterface.removeColumn('sms_rooms', 'closedAt');
28 queryInterface.removeColumn('sms_rooms', 'lastEventAt');
29 queryInterface.removeColumn('sms_rooms', 'lastEvent');
30 queryInterface.removeColumn('sms_rooms', 'smsIn');
31 queryInterface.removeColumn('sms_rooms', 'smsOut');