4 up: function(queryInterface, Sequelize) {
5 queryInterface.sequelize.query("UPDATE openchannel_rooms SET status='NEW' WHERE status='UNMANAGED';");
6 queryInterface.changeColumn('openchannel_rooms', 'status', {
7 type: Sequelize.ENUM('NEW', 'OPEN', 'PENDING', 'CLOSED'),
10 queryInterface.addColumn('openchannel_rooms', 'arrivedAt', Sequelize.DATE);
11 queryInterface.addColumn('openchannel_rooms', 'closedAt', Sequelize.DATE);
12 queryInterface.addColumn('openchannel_rooms', 'lastEvent', {
13 type: Sequelize.ENUM('SENDING', 'SENT', 'RECEIVED', 'FAILED', 'NOTE')
15 queryInterface.addColumn('openchannel_rooms', 'lastEventAt', Sequelize.DATE);
16 queryInterface.addColumn('openchannel_rooms', 'openchannelIn', Sequelize.INTEGER);
17 queryInterface.addColumn('openchannel_rooms', 'openchannelOut', Sequelize.INTEGER);
18 queryInterface.addColumn('openchannel_rooms', 'waiting', {
19 type: Sequelize.BOOLEAN,
22 queryInterface.renameColumn('report_openchannel_session', 'unmanaged', 'timeout');
23 queryInterface.renameColumn('openchannel_rooms', 'from', 'contact');
24 queryInterface.addColumn('openchannel_rooms', 'openReason', Sequelize.STRING);
29 down: function(queryInterface, Sequelize) {
30 queryInterface.sequelize.query("UPDATE openchannel_rooms SET status='UNMANAGED' WHERE status='NEW';");
31 queryInterface.changeColumn('openchannel_rooms', 'status', {
32 type: Sequelize.ENUM('NEW', 'OPEN', 'UNMANAGED', 'CLOSED'),
35 queryInterface.removeColumn('openchannel_rooms', 'arrivedAt');
36 queryInterface.removeColumn('openchannel_rooms', 'closedAt');
37 queryInterface.removeColumn('openchannel_rooms', 'lastEventAt');
38 queryInterface.removeColumn('openchannel_rooms', 'lastEvent');
39 queryInterface.removeColumn('openchannel_rooms', 'openchannelIn');
40 queryInterface.removeColumn('openchannel_rooms', 'openchannelOut');
41 queryInterface.removeColumn('openchannel_rooms', 'waiting');
42 queryInterface.renameColumn('report_openchannel_session', 'timeout', 'unmanaged');
43 queryInterface.renameColumn('openchannel_rooms', 'contact', 'from');
44 queryInterface.removeColumn('openchannel_rooms', 'openReason');