-var _0x7458=["\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"];_0x7458[0];module[_0x7458[1]]={up:function(_0x9062x1,_0x9062x2){_0x9062x1[_0x7458[7]](_0x7458[2],_0x7458[3],{type:_0x9062x2.ENUM(_0x7458[4],_0x7458[5],_0x7458[6])});_0x9062x1[_0x7458[7]](_0x7458[2],_0x7458[8],{type:_0x9062x2[_0x7458[9]]});_0x9062x1[_0x7458[13]](_0x7458[2],_0x7458[10],{type:_0x9062x2.ENUM(_0x7458[11],_0x7458[12])});_0x9062x1[_0x7458[13]](_0x7458[2],_0x7458[14],{type:_0x9062x2[_0x7458[9]],unique:true,validate:{is:/^[0-9]+$/}});_0x9062x1[_0x7458[7]](_0x7458[15],_0x7458[16],_0x9062x2.INTEGER);_0x9062x1[_0x7458[19]][_0x7458[18]](_0x7458[17])},down:function(_0x9062x1,_0x9062x2){_0x9062x1[_0x7458[20]](_0x7458[2],_0x7458[3]);_0x9062x1[_0x7458[20]](_0x7458[2],_0x7458[8]);_0x9062x1[_0x7458[13]](_0x7458[2],_0x7458[10],{type:_0x9062x2[_0x7458[9]]});_0x9062x1[_0x7458[13]](_0x7458[2],_0x7458[14],{type:_0x9062x2[_0x7458[21]],unique:true});_0x9062x1[_0x7458[20]](_0x7458[15],_0x7458[16]);_0x9062x1[_0x7458[19]][_0x7458[18]](_0x7458[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;'
+ );
+
+ }
+};