X-Git-Url: http://repos.xcallymotion.com/?a=blobdiff_plain;f=server%2Fmigrations%2F20160622150457-tools_schedule.js;h=7fff8d14c89b4955dce55c1518897018987c8fab;hb=9c67eff8b98f3784e4fa1b031a29d4590547e055;hp=5faaada549c96c4480670b564ce2b29022fcaa1f;hpb=2c028dc81dced7b7435dd16e21e89e4178a6b18c;p=motion.git

diff --git a/server/migrations/20160622150457-tools_schedule.js b/server/migrations/20160622150457-tools_schedule.js
index 5faaada..7fff8d1 100644
--- a/server/migrations/20160622150457-tools_schedule.js
+++ b/server/migrations/20160622150457-tools_schedule.js
@@ -1 +1,21 @@
-var _0xe3f6=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x74\x6F\x6F\x6C\x73\x5F\x73\x63\x68\x65\x64\x75\x6C\x65\x73\x20\x44\x52\x4F\x50\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x60\x74\x6F\x6F\x6C\x73\x5F\x73\x63\x68\x65\x64\x75\x6C\x65\x73\x5F\x69\x62\x66\x6B\x5F\x31\x60\x3B","\x71\x75\x65\x72\x79","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x74\x6F\x6F\x6C\x73\x5F\x73\x63\x68\x65\x64\x75\x6C\x65\x73","\x4D\x61\x69\x6C\x41\x63\x63\x6F\x75\x6E\x74\x49\x64","\x72\x65\x6D\x6F\x76\x65\x43\x6F\x6C\x75\x6D\x6E","\x4D\x61\x69\x6C\x53\x65\x72\x76\x65\x72\x4F\x75\x74\x49\x64","\x61\x64\x64\x43\x6F\x6C\x75\x6D\x6E","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x74\x6F\x6F\x6C\x73\x5F\x73\x63\x68\x65\x64\x75\x6C\x65\x73\x20\x41\x44\x44\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x74\x6F\x6F\x6C\x73\x5F\x73\x63\x68\x65\x64\x75\x6C\x65\x73\x5F\x69\x62\x66\x6B\x5F\x31\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x4D\x61\x69\x6C\x53\x65\x72\x76\x65\x72\x4F\x75\x74\x49\x64\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x6D\x6F\x74\x69\x6F\x6E\x2E\x6D\x61\x69\x6C\x5F\x73\x65\x72\x76\x65\x72\x73\x5F\x6F\x75\x74\x28\x69\x64\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\x74\x6F\x6F\x6C\x73\x5F\x73\x63\x68\x65\x64\x75\x6C\x65\x73\x20\x41\x44\x44\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x74\x6F\x6F\x6C\x73\x5F\x73\x63\x68\x65\x64\x75\x6C\x65\x73\x5F\x69\x62\x66\x6B\x5F\x31\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x4D\x61\x69\x6C\x41\x63\x63\x6F\x75\x6E\x74\x49\x64\x29\x20\x52\x45\x46\x45\x52\x45\x4E\x43\x45\x53\x20\x6D\x6F\x74\x69\x6F\x6E\x2E\x6D\x61\x69\x6C\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73\x28\x69\x64\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"];_0xe3f6[0];module[_0xe3f6[1]]= {up:function(_0xcd73x1,_0xcd73x2){_0xcd73x1[_0xe3f6[4]][_0xe3f6[3]](_0xe3f6[2]);_0xcd73x1[_0xe3f6[7]](_0xe3f6[5],_0xe3f6[6]);_0xcd73x1[_0xe3f6[9]](_0xe3f6[5],_0xe3f6[8],_0xcd73x2.INTEGER);_0xcd73x1[_0xe3f6[4]][_0xe3f6[3]](_0xe3f6[10])},down:function(_0xcd73x1,_0xcd73x2){_0xcd73x1[_0xe3f6[4]][_0xe3f6[3]](_0xe3f6[2]);_0xcd73x1[_0xe3f6[7]](_0xe3f6[5],_0xe3f6[8]);_0xcd73x1[_0xe3f6[9]](_0xe3f6[5],_0xe3f6[6],_0xcd73x2.INTEGER);_0xcd73x1[_0xe3f6[4]][_0xe3f6[3]](_0xe3f6[11])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query('ALTER TABLE tools_schedules DROP FOREIGN KEY `tools_schedules_ibfk_1`;');
+    queryInterface.removeColumn('tools_schedules', 'MailAccountId');
+    queryInterface.addColumn('tools_schedules', 'MailServerOutId', Sequelize.INTEGER);
+    queryInterface.sequelize.query(
+      "ALTER TABLE tools_schedules ADD CONSTRAINT tools_schedules_ibfk_1 FOREIGN KEY (MailServerOutId) REFERENCES motion.mail_servers_out(id) ON DELETE SET NULL ON UPDATE CASCADE;"
+    );
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.sequelize.query('ALTER TABLE tools_schedules DROP FOREIGN KEY `tools_schedules_ibfk_1`;');
+    queryInterface.removeColumn('tools_schedules', 'MailServerOutId');
+    queryInterface.addColumn('tools_schedules', 'MailAccountId', Sequelize.INTEGER);
+    queryInterface.sequelize.query(
+      "ALTER TABLE tools_schedules ADD CONSTRAINT tools_schedules_ibfk_1 FOREIGN KEY (MailAccountId) REFERENCES motion.mail_accounts(id) ON DELETE SET NULL ON UPDATE CASCADE;"
+    );
+  }
+};