Built motion from commit c56b56e.|0.0.125

[motion.git] / server / migrations / 20160520135050-mail-rooms.js

diff --git a/server/migrations/20160520135050-mail-rooms.js b/server/migrations/20160520135050-mail-rooms.js
index 829c09c..ca1bc9e 100644 (file)
--- a/server/migrations/20160520135050-mail-rooms.js
+++ b/server/migrations/20160520135050-mail-rooms.js
@@ -1 +1,34 @@
-var _0xc11e=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x6D\x61\x69\x6C\x5F\x72\x6F\x6F\x6D\x73","\x6D\x61\x69\x6C\x49\x6E","\x49\x4E\x54\x45\x47\x45\x52","\x61\x64\x64\x43\x6F\x6C\x75\x6D\x6E","\x6D\x61\x69\x6C\x4F\x75\x74","\x6C\x61\x73\x74\x45\x76\x65\x6E\x74\x41\x74","\x64\x65\x6C\x65\x74\x65\x64","\x42\x4F\x4F\x4C\x45\x41\x4E","\x64\x69\x73\x70\x6F\x73\x69\x74\x69\x6F\x6E","\x6D\x61\x69\x6C\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73","\x4C\x69\x73\x74\x49\x64","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x6D\x61\x69\x6C\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73\x20\x41\x44\x44\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x60\x6D\x61\x69\x6C\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73\x5F\x69\x62\x66\x6B\x5F\x31\x60\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x60\x4C\x69\x73\x74\x49\x64\x60\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x60\x63\x6D\x5F\x6C\x69\x73\x74\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","\x71\x75\x65\x72\x79","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x72\x65\x6D\x6F\x76\x65\x43\x6F\x6C\x75\x6D\x6E","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x6D\x61\x69\x6C\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73\x20\x44\x52\x4F\x50\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x60\x6D\x61\x69\x6C\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73\x5F\x69\x62\x66\x6B\x5F\x31\x60\x3B"];_0xc11e[0];module[_0xc11e[1]]= {up:function(_0xcef1x1,_0xcef1x2){_0xcef1x1[_0xc11e[5]](_0xc11e[2],_0xc11e[3],{type:_0xcef1x2[_0xc11e[4]],defaultValue:0});_0xcef1x1[_0xc11e[5]](_0xc11e[2],_0xc11e[6],{type:_0xcef1x2[_0xc11e[4]],defaultValue:0});_0xcef1x1[_0xc11e[5]](_0xc11e[2],_0xc11e[7],_0xcef1x2.DATE);_0xcef1x1[_0xc11e[5]](_0xc11e[2],_0xc11e[8],{type:_0xcef1x2[_0xc11e[9]],defaultValue:false});_0xcef1x1[_0xc11e[5]](_0xc11e[2],_0xc11e[10],_0xcef1x2.STRING);_0xcef1x1[_0xc11e[5]](_0xc11e[11],_0xc11e[12],_0xcef1x2.INTEGER);_0xcef1x1[_0xc11e[15]][_0xc11e[14]](_0xc11e[13])},down:function(_0xcef1x1,_0xcef1x2){_0xcef1x1[_0xc11e[16]](_0xc11e[2],_0xc11e[3]);_0xcef1x1[_0xc11e[16]](_0xc11e[2],_0xc11e[6]);_0xcef1x1[_0xc11e[16]](_0xc11e[2],_0xc11e[7]);_0xcef1x1[_0xc11e[16]](_0xc11e[2],_0xc11e[8]);_0xcef1x1[_0xc11e[16]](_0xc11e[2],_0xc11e[10]);_0xcef1x1[_0xc11e[15]][_0xc11e[14]](_0xc11e[17]);_0xcef1x1[_0xc11e[16]](_0xc11e[11],_0xc11e[12])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.addColumn('mail_rooms', 'mailIn', {
+      type: Sequelize.INTEGER,
+      defaultValue: 0
+    });
+    queryInterface.addColumn('mail_rooms', 'mailOut', {
+      type: Sequelize.INTEGER,
+      defaultValue: 0
+    });
+    queryInterface.addColumn('mail_rooms', 'lastEventAt', Sequelize.DATE);
+    queryInterface.addColumn('mail_rooms', 'deleted', {
+      type: Sequelize.BOOLEAN,
+      defaultValue: false
+    });
+    queryInterface.addColumn('mail_rooms', 'disposition', Sequelize.STRING);
+    queryInterface.addColumn('mail_accounts', 'ListId', Sequelize.INTEGER);
+
+    queryInterface.sequelize.query("ALTER TABLE mail_accounts ADD CONSTRAINT `mail_accounts_ibfk_1` FOREIGN KEY (`ListId`) REFERENCES `cm_lists` (`id`) ON DELETE SET NULL ON UPDATE CASCADE");
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.removeColumn('mail_rooms', 'mailIn');
+    queryInterface.removeColumn('mail_rooms', 'mailOut');
+    queryInterface.removeColumn('mail_rooms', 'lastEventAt');
+    queryInterface.removeColumn('mail_rooms', 'deleted');
+    queryInterface.removeColumn('mail_rooms', 'disposition');
+
+    queryInterface.sequelize.query('ALTER TABLE mail_accounts DROP FOREIGN KEY `mail_accounts_ibfk_1`;');
+    queryInterface.removeColumn('mail_accounts', 'ListId');
+  }
+};