Built motion from commit c56b56e.|0.0.125

[motion.git] / server / migrations / 20160701142744-sms-rooms.js

diff --git a/server/migrations/20160701142744-sms-rooms.js b/server/migrations/20160701142744-sms-rooms.js
index 4c212f3..51d5544 100644 (file)
--- a/server/migrations/20160701142744-sms-rooms.js
+++ b/server/migrations/20160701142744-sms-rooms.js
@@ -1 +1,33 @@
-var _0x7ce6=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x55\x50\x44\x41\x54\x45\x20\x73\x6D\x73\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","\x73\x6D\x73\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","\x73\x6D\x73\x49\x6E","\x73\x6D\x73\x4F\x75\x74","\x55\x50\x44\x41\x54\x45\x20\x73\x6D\x73\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"];_0x7ce6[0];module[_0x7ce6[1]]= {up:function(_0x9278x1,_0x9278x2){_0x9278x1[_0x7ce6[4]][_0x7ce6[3]](_0x7ce6[2]);_0x9278x1[_0x7ce6[11]](_0x7ce6[5],_0x7ce6[6],{type:_0x9278x2.ENUM(_0x7ce6[7],_0x7ce6[8],_0x7ce6[9],_0x7ce6[10]),defaultValue:_0x7ce6[7]});_0x9278x1[_0x7ce6[13]](_0x7ce6[5],_0x7ce6[12],_0x9278x2.DATE);_0x9278x1[_0x7ce6[13]](_0x7ce6[5],_0x7ce6[14],_0x9278x2.DATE);_0x9278x1[_0x7ce6[13]](_0x7ce6[5],_0x7ce6[15],{type:_0x9278x2.ENUM(_0x7ce6[16],_0x7ce6[17],_0x7ce6[18],_0x7ce6[19],_0x7ce6[20])});_0x9278x1[_0x7ce6[13]](_0x7ce6[5],_0x7ce6[21],_0x9278x2.DATE);_0x9278x1[_0x7ce6[13]](_0x7ce6[5],_0x7ce6[22],_0x9278x2.INTEGER);_0x9278x1[_0x7ce6[13]](_0x7ce6[5],_0x7ce6[23],_0x9278x2.INTEGER)},down:function(_0x9278x1,_0x9278x2){_0x9278x1[_0x7ce6[4]][_0x7ce6[3]](_0x7ce6[24]);_0x9278x1[_0x7ce6[11]](_0x7ce6[5],_0x7ce6[6],{type:_0x9278x2.ENUM(_0x7ce6[7],_0x7ce6[8],_0x7ce6[25],_0x7ce6[10]),defaultValue:_0x7ce6[7]});_0x9278x1[_0x7ce6[26]](_0x7ce6[5],_0x7ce6[12]);_0x9278x1[_0x7ce6[26]](_0x7ce6[5],_0x7ce6[14]);_0x9278x1[_0x7ce6[26]](_0x7ce6[5],_0x7ce6[21]);_0x9278x1[_0x7ce6[26]](_0x7ce6[5],_0x7ce6[15]);_0x9278x1[_0x7ce6[26]](_0x7ce6[5],_0x7ce6[22]);_0x9278x1[_0x7ce6[26]](_0x7ce6[5],_0x7ce6[23])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query("UPDATE sms_rooms SET status='NEW' WHERE status='UNMANAGED';");
+    queryInterface.changeColumn('sms_rooms', 'status', {
+      type: Sequelize.ENUM('NEW', 'OPEN', 'PENDING', 'CLOSED'),
+      defaultValue: 'NEW'
+    });
+    queryInterface.addColumn('sms_rooms', 'arrivedAt', Sequelize.DATE);
+    queryInterface.addColumn('sms_rooms', 'closedAt', Sequelize.DATE);
+    queryInterface.addColumn('sms_rooms', 'lastEvent', {
+      type: Sequelize.ENUM('SENDING', 'SENT', 'RECEIVED', 'FAILED', 'NOTE')
+    });
+    queryInterface.addColumn('sms_rooms', 'lastEventAt', Sequelize.DATE);
+    queryInterface.addColumn('sms_rooms', 'smsIn', Sequelize.INTEGER);
+    queryInterface.addColumn('sms_rooms', 'smsOut', Sequelize.INTEGER);
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query("UPDATE sms_rooms SET status='UNMANAGED' WHERE status='NEW';");
+    queryInterface.changeColumn('sms_rooms', 'status', {
+      type: Sequelize.ENUM('NEW', 'OPEN', 'UNMANAGED', 'CLOSED'),
+      defaultValue: 'NEW'
+    });
+    queryInterface.removeColumn('sms_rooms', 'arrivedAt');
+    queryInterface.removeColumn('sms_rooms', 'closedAt');
+    queryInterface.removeColumn('sms_rooms', 'lastEventAt');
+    queryInterface.removeColumn('sms_rooms', 'lastEvent');
+    queryInterface.removeColumn('sms_rooms', 'smsIn');
+    queryInterface.removeColumn('sms_rooms', 'smsOut');
+  }
+};