Built motion from commit c56b56e.|0.0.125

[motion.git] / server / migrations / 20160601110210-mail.js

diff --git a/server/migrations/20160601110210-mail.js b/server/migrations/20160601110210-mail.js
index e5fefba..f091743 100644 (file)
--- a/server/migrations/20160601110210-mail.js
+++ b/server/migrations/20160601110210-mail.js
@@ -1 +1,19 @@
-var _0x2cec=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x63\x6D\x5F\x63\x6F\x6D\x70\x61\x6E\x69\x65\x73","\x65\x6D\x61\x69\x6C\x44\x6F\x6D\x61\x69\x6E","\x61\x64\x64\x43\x6F\x6C\x75\x6D\x6E","\x6D\x61\x69\x6C\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73","\x54\x65\x6D\x70\x6C\x61\x74\x65\x49\x64","\x6D\x61\x69\x6C\x5F\x72\x6F\x6F\x6D\x73","\x50\x61\x72\x65\x6E\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\x32\x60\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x60\x54\x65\x6D\x70\x6C\x61\x74\x65\x49\x64\x60\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x60\x74\x6F\x6F\x6C\x73\x5F\x74\x65\x6D\x70\x6C\x61\x74\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","\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\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\x32\x60\x3B","\x72\x65\x6D\x6F\x76\x65\x43\x6F\x6C\x75\x6D\x6E"];_0x2cec[0];module[_0x2cec[1]]= {up:function(_0x95adx1,_0x95adx2){_0x95adx1[_0x2cec[4]](_0x2cec[2],_0x2cec[3],_0x95adx2.STRING);_0x95adx1[_0x2cec[4]](_0x2cec[5],_0x2cec[6],_0x95adx2.INTEGER);_0x95adx1[_0x2cec[4]](_0x2cec[7],_0x2cec[8],_0x95adx2.INTEGER);_0x95adx1[_0x2cec[11]][_0x2cec[10]](_0x2cec[9])},down:function(_0x95adx1,_0x95adx2){_0x95adx1[_0x2cec[11]][_0x2cec[10]](_0x2cec[12]);_0x95adx1[_0x2cec[13]](_0x2cec[5],_0x2cec[6]);_0x95adx1[_0x2cec[13]](_0x2cec[7],_0x2cec[8]);_0x95adx1[_0x2cec[13]](_0x2cec[2],_0x2cec[3])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.addColumn('cm_companies', 'emailDomain', Sequelize.STRING);
+    queryInterface.addColumn('mail_accounts', 'TemplateId', Sequelize.INTEGER);
+    queryInterface.addColumn('mail_rooms', 'ParentId', Sequelize.INTEGER);
+    queryInterface.sequelize.query(
+      "ALTER TABLE mail_accounts ADD CONSTRAINT `mail_accounts_ibfk_2` FOREIGN KEY (`TemplateId`) REFERENCES `tools_templates` (`id`) ON DELETE SET NULL ON UPDATE CASCADE");
+
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query('ALTER TABLE mail_accounts DROP FOREIGN KEY `mail_accounts_ibfk_2`;');
+    queryInterface.removeColumn('mail_accounts', 'TemplateId');
+    queryInterface.removeColumn('mail_rooms', 'ParentId');
+    queryInterface.removeColumn('cm_companies', 'emailDomain');
+  }
+};