Built motion from commit c56b56e.|0.0.125

[motion.git] / server / migrations / 20160506171353-fax_applications.js

diff --git a/server/migrations/20160506171353-fax_applications.js b/server/migrations/20160506171353-fax_applications.js
index 468118a..b38bdc7 100644 (file)
--- a/server/migrations/20160506171353-fax_applications.js
+++ b/server/migrations/20160506171353-fax_applications.js
@@ -1 +1,38 @@
-var _0x32e3=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73","\x61\x70\x70\x64\x61\x74\x61","\x72\x65\x6D\x6F\x76\x65\x43\x6F\x6C\x75\x6D\x6E","\x69\x6E\x74\x65\x72\x76\x61\x6C","\x53\x54\x52\x49\x4E\x47","\x63\x68\x61\x6E\x67\x65\x43\x6F\x6C\x75\x6D\x6E","\x49\x6E\x74\x65\x72\x76\x61\x6C\x49\x64","\x61\x64\x64\x43\x6F\x6C\x75\x6D\x6E","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x44\x52\x4F\x50\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x60\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x32\x60\x3B","\x71\x75\x65\x72\x79","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x41\x44\x44\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x60\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x32\x60\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x60\x46\x61\x78\x51\x75\x65\x75\x65\x49\x64\x60\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x60\x66\x61\x78\x5F\x71\x75\x65\x75\x65\x73\x60\x20\x28\x60\x69\x64\x60\x29\x20\x4F\x4E\x20\x55\x50\x44\x41\x54\x45\x20\x43\x41\x53\x43\x41\x44\x45\x3B","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x44\x52\x4F\x50\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x60\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x33\x60\x3B","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x41\x44\x44\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x60\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x33\x60\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x60\x55\x73\x65\x72\x49\x64\x60\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x60\x75\x73\x65\x72\x73\x60\x20\x28\x60\x69\x64\x60\x29\x20\x4F\x4E\x20\x55\x50\x44\x41\x54\x45\x20\x43\x41\x53\x43\x41\x44\x45\x3B","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x41\x44\x44\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x60\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x34\x60\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x60\x49\x6E\x74\x65\x72\x76\x61\x6C\x49\x64\x60\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x60\x74\x6F\x6F\x6C\x73\x5F\x69\x6E\x74\x65\x72\x76\x61\x6C\x73\x60\x20\x28\x60\x69\x64\x60\x29\x20\x4F\x4E\x20\x44\x45\x4C\x45\x54\x45\x20\x53\x45\x54\x20\x4E\x55\x4C\x4C\x20\x4F\x4E\x20\x55\x50\x44\x41\x54\x45\x20\x43\x41\x53\x43\x41\x44\x45\x3B","\x2A\x7C\x2A\x7C\x2A\x7C\x2A","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x41\x44\x44\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x60\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x32\x60\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x60\x46\x61\x78\x51\x75\x65\x75\x65\x49\x64\x60\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x60\x66\x61\x78\x5F\x71\x75\x65\x75\x65\x73\x60\x20\x28\x60\x69\x64\x60\x29\x20\x4F\x4E\x20\x44\x45\x4C\x45\x54\x45\x20\x53\x45\x54\x20\x4E\x55\x4C\x4C\x20\x4F\x4E\x20\x55\x50\x44\x41\x54\x45\x20\x43\x41\x53\x43\x41\x44\x45","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x41\x44\x44\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x60\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x33\x60\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x60\x55\x73\x65\x72\x49\x64\x60\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x60\x75\x73\x65\x72\x73\x60\x20\x28\x60\x69\x64\x60\x29\x20\x4F\x4E\x20\x44\x45\x4C\x45\x54\x45\x20\x53\x45\x54\x20\x4E\x55\x4C\x4C\x20\x4F\x4E\x20\x55\x50\x44\x41\x54\x45\x20\x43\x41\x53\x43\x41\x44\x45\x3B","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x44\x52\x4F\x50\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x60\x66\x61\x78\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x34\x60\x3B"];_0x32e3[0];module[_0x32e3[1]]= {up:function(_0xfdbcx1,_0xfdbcx2){_0xfdbcx1[_0x32e3[4]](_0x32e3[2],_0x32e3[3]);_0xfdbcx1[_0x32e3[7]](_0x32e3[2],_0x32e3[5],{type:_0xfdbcx2[_0x32e3[6]]});_0xfdbcx1[_0x32e3[9]](_0x32e3[2],_0x32e3[8],_0xfdbcx2.INTEGER);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[10]);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[13]);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[14]);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[15]);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[16])},down:function(_0xfdbcx1,_0xfdbcx2){_0xfdbcx1[_0x32e3[9]](_0x32e3[2],_0x32e3[3],_0xfdbcx2.INTEGER);_0xfdbcx1[_0x32e3[7]](_0x32e3[2],_0x32e3[5],{type:_0xfdbcx2[_0x32e3[6]],defaultValue:_0x32e3[17]});_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[10]);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[18]);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[14]);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[19]);_0xfdbcx1[_0x32e3[12]][_0x32e3[11]](_0x32e3[20]);_0xfdbcx1[_0x32e3[4]](_0x32e3[2],_0x32e3[8])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.removeColumn('fax_applications', 'appdata');
+    queryInterface.changeColumn('fax_applications', 'interval', {
+      type: Sequelize.STRING
+    });
+    queryInterface.addColumn('fax_applications', 'IntervalId', Sequelize.INTEGER);
+    //Relation with FaxQueue
+    queryInterface.sequelize.query('ALTER TABLE fax_applications DROP FOREIGN KEY `fax_applications_ibfk_2`;');
+    queryInterface.sequelize.query("ALTER TABLE fax_applications ADD CONSTRAINT `fax_applications_ibfk_2` FOREIGN KEY (`FaxQueueId`) REFERENCES `fax_queues` (`id`) ON UPDATE CASCADE;");
+    //Relation with User
+    queryInterface.sequelize.query('ALTER TABLE fax_applications DROP FOREIGN KEY `fax_applications_ibfk_3`;');
+    queryInterface.sequelize.query("ALTER TABLE fax_applications ADD CONSTRAINT `fax_applications_ibfk_3` FOREIGN KEY (`UserId`) REFERENCES `users` (`id`) ON UPDATE CASCADE;");
+    // Relation with Interval
+    queryInterface.sequelize.query(
+      "ALTER TABLE fax_applications ADD CONSTRAINT `fax_applications_ibfk_4` FOREIGN KEY (`IntervalId`) REFERENCES `tools_intervals` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;");
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.addColumn('fax_applications', 'appdata', Sequelize.INTEGER);
+    queryInterface.changeColumn('fax_applications', 'interval', {
+      type: Sequelize.STRING,
+      defaultValue: '*|*|*|*'
+    });
+    //Relation with FaxQueue
+    queryInterface.sequelize.query('ALTER TABLE fax_applications DROP FOREIGN KEY `fax_applications_ibfk_2`;');
+    queryInterface.sequelize.query(
+      "ALTER TABLE fax_applications ADD CONSTRAINT `fax_applications_ibfk_2` FOREIGN KEY (`FaxQueueId`) REFERENCES `fax_queues` (`id`) ON DELETE SET NULL ON UPDATE CASCADE");
+    //Relation with User
+    queryInterface.sequelize.query('ALTER TABLE fax_applications DROP FOREIGN KEY `fax_applications_ibfk_3`;');
+    queryInterface.sequelize.query("ALTER TABLE fax_applications ADD CONSTRAINT `fax_applications_ibfk_3` FOREIGN KEY (`UserId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;");
+    //Relation with Interval
+    queryInterface.sequelize.query('ALTER TABLE fax_applications DROP FOREIGN KEY `fax_applications_ibfk_4`;');
+    queryInterface.removeColumn('fax_applications', 'IntervalId');
+  }
+};