X-Git-Url: http://repos.xcallymotion.com/?a=blobdiff_plain;f=server%2Fmigrations%2F20160414162957-sms_account.js;h=500aaf81394dcc494bc190e8a67253b90fe977e6;hb=9c67eff8b98f3784e4fa1b031a29d4590547e055;hp=492bf91583d23dbecbfe557cc0e0924e71eaf950;hpb=2c028dc81dced7b7435dd16e21e89e4178a6b18c;p=motion.git

diff --git a/server/migrations/20160414162957-sms_account.js b/server/migrations/20160414162957-sms_account.js
index 492bf91..500aaf8 100644
--- a/server/migrations/20160414162957-sms_account.js
+++ b/server/migrations/20160414162957-sms_account.js
@@ -1 +1,55 @@
-var _0xa8b9=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x73\x6D\x73\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73","\x73\x6D\x73\x74\x79\x70\x65","\x62\x61\x73\x69\x63","\x63\x6C\x61\x73\x73\x69\x63","\x63\x6C\x61\x73\x73\x69\x63\x2B","\x61\x64\x64\x43\x6F\x6C\x75\x6D\x6E","\x72\x65\x6D\x6F\x74\x65","\x53\x54\x52\x49\x4E\x47","\x74\x79\x70\x65","\x74\x77\x69\x6C\x69\x6F","\x73\x6B\x65\x62\x62\x79","\x63\x68\x61\x6E\x67\x65\x43\x6F\x6C\x75\x6D\x6E","\x70\x68\x6F\x6E\x65","\x73\x6D\x73\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73","\x53\x6D\x73\x41\x63\x63\x6F\x75\x6E\x74\x49\x64","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x73\x6D\x73\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\x73\x6D\x73\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x31\x20\x46\x4F\x52\x45\x49\x47\x4E\x20\x4B\x45\x59\x20\x28\x53\x6D\x73\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\x73\x6D\x73\x5F\x61\x63\x63\x6F\x75\x6E\x74\x73\x28\x69\x64\x29\x20\x4F\x4E\x20\x44\x45\x4C\x45\x54\x45\x20\x43\x41\x53\x43\x41\x44\x45\x20\x4F\x4E\x20\x55\x50\x44\x41\x54\x45\x20\x43\x41\x53\x43\x41\x44\x45\x3B","\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","\x49\x4E\x54\x45\x47\x45\x52","\x41\x4C\x54\x45\x52\x20\x54\x41\x42\x4C\x45\x20\x73\x6D\x73\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x20\x44\x52\x4F\x50\x20\x43\x4F\x4E\x53\x54\x52\x41\x49\x4E\x54\x20\x73\x6D\x73\x5F\x61\x70\x70\x6C\x69\x63\x61\x74\x69\x6F\x6E\x73\x5F\x69\x62\x66\x6B\x5F\x31\x3B"];_0xa8b9[0];module[_0xa8b9[1]]= {up:function(_0x66d5x1,_0x66d5x2){_0x66d5x1[_0xa8b9[7]](_0xa8b9[2],_0xa8b9[3],{type:_0x66d5x2.ENUM(_0xa8b9[4],_0xa8b9[5],_0xa8b9[6])});_0x66d5x1[_0xa8b9[7]](_0xa8b9[2],_0xa8b9[8],{type:_0x66d5x2[_0xa8b9[9]]});_0x66d5x1[_0xa8b9[13]](_0xa8b9[2],_0xa8b9[10],{type:_0x66d5x2.ENUM(_0xa8b9[11],_0xa8b9[12])});_0x66d5x1[_0xa8b9[13]](_0xa8b9[2],_0xa8b9[14],{type:_0x66d5x2[_0xa8b9[9]],unique:true,validate:{is:/^[0-9]+$/}});_0x66d5x1[_0xa8b9[7]](_0xa8b9[15],_0xa8b9[16],_0x66d5x2.INTEGER);_0x66d5x1[_0xa8b9[19]][_0xa8b9[18]](_0xa8b9[17])},down:function(_0x66d5x1,_0x66d5x2){_0x66d5x1[_0xa8b9[20]](_0xa8b9[2],_0xa8b9[3]);_0x66d5x1[_0xa8b9[20]](_0xa8b9[2],_0xa8b9[8]);_0x66d5x1[_0xa8b9[13]](_0xa8b9[2],_0xa8b9[10],{type:_0x66d5x2[_0xa8b9[9]]});_0x66d5x1[_0xa8b9[13]](_0xa8b9[2],_0xa8b9[14],{type:_0x66d5x2[_0xa8b9[21]],unique:true});_0x66d5x1[_0xa8b9[20]](_0xa8b9[15],_0xa8b9[16]);_0x66d5x1[_0xa8b9[19]][_0xa8b9[18]](_0xa8b9[22])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.addColumn('sms_accounts', 'smstype', {
+      type: Sequelize.ENUM('basic', 'classic', 'classic+')
+    });
+    queryInterface.addColumn('sms_accounts', 'remote', {
+      type: Sequelize.STRING
+    });
+    queryInterface.changeColumn(
+      'sms_accounts',
+      'type', {
+        type: Sequelize.ENUM('twilio', 'skebby')
+      }
+    );
+    queryInterface.changeColumn(
+      'sms_accounts',
+      'phone', {
+        type: Sequelize.STRING,
+        unique: true,
+        validate: {
+          is: /^[0-9]+$/
+        }
+      }
+    );
+    queryInterface.addColumn('sms_applications', 'SmsAccountId', Sequelize.INTEGER);
+    queryInterface.sequelize.query(
+      "ALTER TABLE sms_applications ADD CONSTRAINT sms_applications_ibfk_1 FOREIGN KEY (SmsAccountId) REFERENCES motion.sms_accounts(id) ON DELETE CASCADE ON UPDATE CASCADE;"
+    );
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.removeColumn('sms_accounts', 'smstype');
+    queryInterface.removeColumn('sms_accounts', 'remote');
+    queryInterface.changeColumn(
+      'sms_accounts',
+      'type', {
+        type: Sequelize.STRING
+      }
+    );
+    queryInterface.changeColumn(
+      'sms_accounts',
+      'phone', {
+        type: Sequelize.INTEGER,
+        unique: true
+      }
+    );
+    queryInterface.removeColumn('sms_applications', 'SmsAccountId');
+    queryInterface.sequelize.query(
+      'ALTER TABLE sms_applications DROP CONSTRAINT sms_applications_ibfk_1;'
+    );
+
+  }
+};