X-Git-Url: http://repos.xcallymotion.com/?a=blobdiff_plain;f=server%2Fmigrations%2F20160705145005-openchannel_rooms.js;h=4b6e96dacef0fb3c6673212cb3e218907bee8f0f;hb=9c67eff8b98f3784e4fa1b031a29d4590547e055;hp=671c4c267d01cd8ddec2ec1a7ec6e7205d0a7292;hpb=2c028dc81dced7b7435dd16e21e89e4178a6b18c;p=motion.git

diff --git a/server/migrations/20160705145005-openchannel_rooms.js b/server/migrations/20160705145005-openchannel_rooms.js
index 671c4c2..4b6e96d 100644
--- a/server/migrations/20160705145005-openchannel_rooms.js
+++ b/server/migrations/20160705145005-openchannel_rooms.js
@@ -1 +1,48 @@
-var _0xcc07=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x55\x50\x44\x41\x54\x45\x20\x6F\x70\x65\x6E\x63\x68\x61\x6E\x6E\x65\x6C\x5F\x72\x6F\x6F\x6D\x73\x20\x53\x45\x54\x20\x73\x74\x61\x74\x75\x73\x3D\x27\x4E\x45\x57\x27\x20\x57\x48\x45\x52\x45\x20\x73\x74\x61\x74\x75\x73\x3D\x27\x55\x4E\x4D\x41\x4E\x41\x47\x45\x44\x27\x3B","\x71\x75\x65\x72\x79","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x6F\x70\x65\x6E\x63\x68\x61\x6E\x6E\x65\x6C\x5F\x72\x6F\x6F\x6D\x73","\x73\x74\x61\x74\x75\x73","\x4E\x45\x57","\x4F\x50\x45\x4E","\x50\x45\x4E\x44\x49\x4E\x47","\x43\x4C\x4F\x53\x45\x44","\x63\x68\x61\x6E\x67\x65\x43\x6F\x6C\x75\x6D\x6E","\x61\x72\x72\x69\x76\x65\x64\x41\x74","\x61\x64\x64\x43\x6F\x6C\x75\x6D\x6E","\x63\x6C\x6F\x73\x65\x64\x41\x74","\x6C\x61\x73\x74\x45\x76\x65\x6E\x74","\x53\x45\x4E\x44\x49\x4E\x47","\x53\x45\x4E\x54","\x52\x45\x43\x45\x49\x56\x45\x44","\x46\x41\x49\x4C\x45\x44","\x4E\x4F\x54\x45","\x6C\x61\x73\x74\x45\x76\x65\x6E\x74\x41\x74","\x6F\x70\x65\x6E\x63\x68\x61\x6E\x6E\x65\x6C\x49\x6E","\x6F\x70\x65\x6E\x63\x68\x61\x6E\x6E\x65\x6C\x4F\x75\x74","\x77\x61\x69\x74\x69\x6E\x67","\x42\x4F\x4F\x4C\x45\x41\x4E","\x72\x65\x70\x6F\x72\x74\x5F\x6F\x70\x65\x6E\x63\x68\x61\x6E\x6E\x65\x6C\x5F\x73\x65\x73\x73\x69\x6F\x6E","\x75\x6E\x6D\x61\x6E\x61\x67\x65\x64","\x74\x69\x6D\x65\x6F\x75\x74","\x72\x65\x6E\x61\x6D\x65\x43\x6F\x6C\x75\x6D\x6E","\x66\x72\x6F\x6D","\x63\x6F\x6E\x74\x61\x63\x74","\x6F\x70\x65\x6E\x52\x65\x61\x73\x6F\x6E","\x55\x50\x44\x41\x54\x45\x20\x6F\x70\x65\x6E\x63\x68\x61\x6E\x6E\x65\x6C\x5F\x72\x6F\x6F\x6D\x73\x20\x53\x45\x54\x20\x73\x74\x61\x74\x75\x73\x3D\x27\x55\x4E\x4D\x41\x4E\x41\x47\x45\x44\x27\x20\x57\x48\x45\x52\x45\x20\x73\x74\x61\x74\x75\x73\x3D\x27\x4E\x45\x57\x27\x3B","\x55\x4E\x4D\x41\x4E\x41\x47\x45\x44","\x72\x65\x6D\x6F\x76\x65\x43\x6F\x6C\x75\x6D\x6E"];_0xcc07[0];module[_0xcc07[1]]= {up:function(_0x66d5x1,_0x66d5x2){_0x66d5x1[_0xcc07[4]][_0xcc07[3]](_0xcc07[2]);_0x66d5x1[_0xcc07[11]](_0xcc07[5],_0xcc07[6],{type:_0x66d5x2.ENUM(_0xcc07[7],_0xcc07[8],_0xcc07[9],_0xcc07[10]),defaultValue:_0xcc07[7]});_0x66d5x1[_0xcc07[13]](_0xcc07[5],_0xcc07[12],_0x66d5x2.DATE);_0x66d5x1[_0xcc07[13]](_0xcc07[5],_0xcc07[14],_0x66d5x2.DATE);_0x66d5x1[_0xcc07[13]](_0xcc07[5],_0xcc07[15],{type:_0x66d5x2.ENUM(_0xcc07[16],_0xcc07[17],_0xcc07[18],_0xcc07[19],_0xcc07[20])});_0x66d5x1[_0xcc07[13]](_0xcc07[5],_0xcc07[21],_0x66d5x2.DATE);_0x66d5x1[_0xcc07[13]](_0xcc07[5],_0xcc07[22],_0x66d5x2.INTEGER);_0x66d5x1[_0xcc07[13]](_0xcc07[5],_0xcc07[23],_0x66d5x2.INTEGER);_0x66d5x1[_0xcc07[13]](_0xcc07[5],_0xcc07[24],{type:_0x66d5x2[_0xcc07[25]],defaultValue:false});_0x66d5x1[_0xcc07[29]](_0xcc07[26],_0xcc07[27],_0xcc07[28]);_0x66d5x1[_0xcc07[29]](_0xcc07[5],_0xcc07[30],_0xcc07[31]);_0x66d5x1[_0xcc07[13]](_0xcc07[5],_0xcc07[32],_0x66d5x2.STRING)},down:function(_0x66d5x1,_0x66d5x2){_0x66d5x1[_0xcc07[4]][_0xcc07[3]](_0xcc07[33]);_0x66d5x1[_0xcc07[11]](_0xcc07[5],_0xcc07[6],{type:_0x66d5x2.ENUM(_0xcc07[7],_0xcc07[8],_0xcc07[34],_0xcc07[10]),defaultValue:_0xcc07[7]});_0x66d5x1[_0xcc07[35]](_0xcc07[5],_0xcc07[12]);_0x66d5x1[_0xcc07[35]](_0xcc07[5],_0xcc07[14]);_0x66d5x1[_0xcc07[35]](_0xcc07[5],_0xcc07[21]);_0x66d5x1[_0xcc07[35]](_0xcc07[5],_0xcc07[15]);_0x66d5x1[_0xcc07[35]](_0xcc07[5],_0xcc07[22]);_0x66d5x1[_0xcc07[35]](_0xcc07[5],_0xcc07[23]);_0x66d5x1[_0xcc07[35]](_0xcc07[5],_0xcc07[24]);_0x66d5x1[_0xcc07[29]](_0xcc07[26],_0xcc07[28],_0xcc07[27]);_0x66d5x1[_0xcc07[29]](_0xcc07[5],_0xcc07[31],_0xcc07[30]);_0x66d5x1[_0xcc07[35]](_0xcc07[5],_0xcc07[32])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query("UPDATE openchannel_rooms SET status='NEW' WHERE status='UNMANAGED';");
+    queryInterface.changeColumn('openchannel_rooms', 'status', {
+      type: Sequelize.ENUM('NEW', 'OPEN', 'PENDING', 'CLOSED'),
+      defaultValue: 'NEW'
+    });
+    queryInterface.addColumn('openchannel_rooms', 'arrivedAt', Sequelize.DATE);
+    queryInterface.addColumn('openchannel_rooms', 'closedAt', Sequelize.DATE);
+    queryInterface.addColumn('openchannel_rooms', 'lastEvent', {
+      type: Sequelize.ENUM('SENDING', 'SENT', 'RECEIVED', 'FAILED', 'NOTE')
+    });
+    queryInterface.addColumn('openchannel_rooms', 'lastEventAt', Sequelize.DATE);
+    queryInterface.addColumn('openchannel_rooms', 'openchannelIn', Sequelize.INTEGER);
+    queryInterface.addColumn('openchannel_rooms', 'openchannelOut', Sequelize.INTEGER);
+    queryInterface.addColumn('openchannel_rooms', 'waiting', {
+      type: Sequelize.BOOLEAN,
+      defaultValue: false
+    });
+    queryInterface.renameColumn('report_openchannel_session', 'unmanaged', 'timeout');
+    queryInterface.renameColumn('openchannel_rooms', 'from', 'contact');
+    queryInterface.addColumn('openchannel_rooms', 'openReason', Sequelize.STRING);
+
+
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query("UPDATE openchannel_rooms SET status='UNMANAGED' WHERE status='NEW';");
+    queryInterface.changeColumn('openchannel_rooms', 'status', {
+      type: Sequelize.ENUM('NEW', 'OPEN', 'UNMANAGED', 'CLOSED'),
+      defaultValue: 'NEW'
+    });
+    queryInterface.removeColumn('openchannel_rooms', 'arrivedAt');
+    queryInterface.removeColumn('openchannel_rooms', 'closedAt');
+    queryInterface.removeColumn('openchannel_rooms', 'lastEventAt');
+    queryInterface.removeColumn('openchannel_rooms', 'lastEvent');
+    queryInterface.removeColumn('openchannel_rooms', 'openchannelIn');
+    queryInterface.removeColumn('openchannel_rooms', 'openchannelOut');
+    queryInterface.removeColumn('openchannel_rooms', 'waiting');
+    queryInterface.renameColumn('report_openchannel_session', 'timeout', 'unmanaged');
+    queryInterface.renameColumn('openchannel_rooms', 'contact', 'from');
+    queryInterface.removeColumn('openchannel_rooms', 'openReason');
+
+
+  }
+};