Built motion from commit c56b56e.|0.0.125

[motion.git] / server / migrations / 20160630122603-fax-rooms.js

diff --git a/server/migrations/20160630122603-fax-rooms.js b/server/migrations/20160630122603-fax-rooms.js
index 8fadb0b..3c55a06 100644 (file)
--- a/server/migrations/20160630122603-fax-rooms.js
+++ b/server/migrations/20160630122603-fax-rooms.js
@@ -1 +1,29 @@
-var _0x334d=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x55\x50\x44\x41\x54\x45\x20\x66\x61\x78\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","\x66\x61\x78\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\x41\x74","\x66\x61\x78\x49\x6E","\x66\x61\x78\x4F\x75\x74","\x55\x50\x44\x41\x54\x45\x20\x66\x61\x78\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"];_0x334d[0];module[_0x334d[1]]= {up:function(_0x1afax1,_0x1afax2){_0x1afax1[_0x334d[4]][_0x334d[3]](_0x334d[2]);_0x1afax1[_0x334d[11]](_0x334d[5],_0x334d[6],{type:_0x1afax2.ENUM(_0x334d[7],_0x334d[8],_0x334d[9],_0x334d[10]),defaultValue:_0x334d[7]});_0x1afax1[_0x334d[13]](_0x334d[5],_0x334d[12],_0x1afax2.DATE);_0x1afax1[_0x334d[13]](_0x334d[5],_0x334d[14],_0x1afax2.DATE);_0x1afax1[_0x334d[13]](_0x334d[5],_0x334d[15],_0x1afax2.DATE);_0x1afax1[_0x334d[13]](_0x334d[5],_0x334d[16],_0x1afax2.INTEGER);_0x1afax1[_0x334d[13]](_0x334d[5],_0x334d[17],_0x1afax2.INTEGER)},down:function(_0x1afax1,_0x1afax2){_0x1afax1[_0x334d[4]][_0x334d[3]](_0x334d[18]);_0x1afax1[_0x334d[11]](_0x334d[5],_0x334d[6],{type:_0x1afax2.ENUM(_0x334d[7],_0x334d[8],_0x334d[19],_0x334d[10]),defaultValue:_0x334d[7]});_0x1afax1[_0x334d[20]](_0x334d[5],_0x334d[12]);_0x1afax1[_0x334d[20]](_0x334d[5],_0x334d[14]);_0x1afax1[_0x334d[20]](_0x334d[5],_0x334d[15]);_0x1afax1[_0x334d[20]](_0x334d[5],_0x334d[16]);_0x1afax1[_0x334d[20]](_0x334d[5],_0x334d[17])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query("UPDATE fax_rooms SET status='NEW' WHERE status='UNMANAGED';");
+    queryInterface.changeColumn('fax_rooms', 'status', {
+      type: Sequelize.ENUM('NEW', 'OPEN', 'PENDING', 'CLOSED'),
+      defaultValue: 'NEW'
+    });
+    queryInterface.addColumn('fax_rooms', 'arrivedAt', Sequelize.DATE);
+    queryInterface.addColumn('fax_rooms', 'closedAt', Sequelize.DATE);
+    queryInterface.addColumn('fax_rooms', 'lastEventAt', Sequelize.DATE);
+    queryInterface.addColumn('fax_rooms', 'faxIn', Sequelize.INTEGER);
+    queryInterface.addColumn('fax_rooms', 'faxOut', Sequelize.INTEGER);
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query("UPDATE fax_rooms SET status='UNMANAGED' WHERE status='NEW';");
+    queryInterface.changeColumn('fax_rooms', 'status', {
+      type: Sequelize.ENUM('NEW', 'OPEN', 'UNMANAGED', 'CLOSED'),
+      defaultValue: 'NEW'
+    });
+    queryInterface.removeColumn('fax_rooms', 'arrivedAt');
+    queryInterface.removeColumn('fax_rooms', 'closedAt');
+    queryInterface.removeColumn('fax_rooms', 'lastEventAt');
+    queryInterface.removeColumn('fax_rooms', 'faxIn');
+    queryInterface.removeColumn('fax_rooms', 'faxOut');
+  }
+};