Built motion from commit c56b56e.|0.0.125

[motion.git] / server / migrations / 20160419162305-sms_message.js

diff --git a/server/migrations/20160419162305-sms_message.js b/server/migrations/20160419162305-sms_message.js
index 69a28f6..c437efe 100644 (file)
--- a/server/migrations/20160419162305-sms_message.js
+++ b/server/migrations/20160419162305-sms_message.js
@@ -1 +1,81 @@
-var _0xc34d=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x65\x78\x70\x6F\x72\x74\x73","\x73\x6D\x73\x5F\x6D\x65\x73\x73\x61\x67\x65\x73","\x66\x72\x6F\x6D","\x53\x54\x52\x49\x4E\x47","\x63\x68\x61\x6E\x67\x65\x43\x6F\x6C\x75\x6D\x6E","\x74\x6F","\x6D\x65\x74\x68\x6F\x64","\x72\x65\x6D\x6F\x76\x65\x43\x6F\x6C\x75\x6D\x6E","\x73\x74\x61\x74\x75\x73","\x53\x45\x4E\x44\x49\x4E\x47","\x65\x72\x72\x6F\x72\x63\x6F\x64\x65","\x61\x64\x64\x43\x6F\x6C\x75\x6D\x6E","\x73\x6B\x65\x62\x62\x79\x5F\x6D\x65\x73\x73\x61\x67\x65\x5F\x69\x64","\x72\x65\x73\x5F\x64\x61\x74\x61","\x49\x4E\x54\x45\x47\x45\x52","\x49\x4E","\x4F\x55\x54","\x53\x45\x4E\x54","\x52\x45\x43\x45\x49\x56\x45\x44","\x46\x41\x49\x4C\x45\x44","\x4E\x4F\x54\x45"];_0xc34d[0];module[_0xc34d[1]]= {up:function(_0x3ba2x1,_0x3ba2x2){_0x3ba2x1[_0xc34d[5]](_0xc34d[2],_0xc34d[3],{type:_0x3ba2x2[_0xc34d[4]],allowNull:false,validate:{notEmpty:true,is:/^[0-9]+$/}});_0x3ba2x1[_0xc34d[5]](_0xc34d[2],_0xc34d[6],{type:_0x3ba2x2[_0xc34d[4]],allowNull:false,validate:{notEmpty:true,is:/^[0-9]+$/}});_0x3ba2x1[_0xc34d[8]](_0xc34d[2],_0xc34d[7]);_0x3ba2x1[_0xc34d[5]](_0xc34d[2],_0xc34d[9],{type:_0x3ba2x2[_0xc34d[4]],defaultValue:_0xc34d[10]});_0x3ba2x1[_0xc34d[12]](_0xc34d[2],_0xc34d[11],_0x3ba2x2.STRING);_0x3ba2x1[_0xc34d[12]](_0xc34d[2],_0xc34d[13],_0x3ba2x2.INTEGER);_0x3ba2x1[_0xc34d[12]](_0xc34d[2],_0xc34d[14],_0x3ba2x2.STRING)},down:function(_0x3ba2x1,_0x3ba2x2){_0x3ba2x1[_0xc34d[5]](_0xc34d[2],_0xc34d[3],{type:_0x3ba2x2[_0xc34d[15]],allowNull:false,validate:{notEmpty:true}});_0x3ba2x1[_0xc34d[5]](_0xc34d[2],_0xc34d[6],{type:_0x3ba2x2[_0xc34d[15]],allowNull:false,validate:{notEmpty:true}});_0x3ba2x1[_0xc34d[12]](_0xc34d[2],_0xc34d[7],{type:_0x3ba2x2.ENUM(_0xc34d[16],_0xc34d[17])});_0x3ba2x1[_0xc34d[5]](_0xc34d[2],_0xc34d[9],{type:_0x3ba2x2.ENUM(_0xc34d[18],_0xc34d[10],_0xc34d[19],_0xc34d[20],_0xc34d[21]),defaultValue:_0xc34d[10]});_0x3ba2x1[_0xc34d[8]](_0xc34d[2],_0xc34d[11]);_0x3ba2x1[_0xc34d[8]](_0xc34d[2],_0xc34d[13]);_0x3ba2x1[_0xc34d[8]](_0xc34d[2],_0xc34d[14])}}
\ No newline at end of file
+'use strict';
+
+module.exports = {
+  up: function(queryInterface, Sequelize) {
+    queryInterface.changeColumn(
+      'sms_messages',
+      'from', {
+        type: Sequelize.STRING,
+        allowNull: false,
+        validate: {
+          notEmpty: true,
+          is: /^[0-9]+$/
+        }
+      }
+    );
+    queryInterface.changeColumn(
+      'sms_messages',
+      'to', {
+        type: Sequelize.STRING,
+        allowNull: false,
+        validate: {
+          notEmpty: true,
+          is: /^[0-9]+$/
+        }
+      }
+    );
+    queryInterface.removeColumn('sms_messages', 'method');
+    queryInterface.changeColumn(
+      'sms_messages',
+      'status', {
+        type: Sequelize.STRING,
+        defaultValue: 'SENDING'
+      }
+    );
+    queryInterface.addColumn('sms_messages', 'errorcode', Sequelize.STRING);
+    queryInterface.addColumn('sms_messages', 'skebby_message_id', Sequelize
+      .INTEGER);
+    queryInterface.addColumn('sms_messages', 'res_data', Sequelize.STRING);
+
+  },
+
+  down: function(queryInterface, Sequelize) {
+    queryInterface.changeColumn(
+      'sms_messages',
+      'from', {
+        type: Sequelize.INTEGER,
+        allowNull: false,
+        validate: {
+          notEmpty: true,
+        }
+      }
+    );
+    queryInterface.changeColumn(
+      'sms_messages',
+      'to', {
+        type: Sequelize.INTEGER,
+        allowNull: false,
+        validate: {
+          notEmpty: true,
+        }
+      }
+    );
+    queryInterface.addColumn('sms_messages', 'method', {
+      type: Sequelize.ENUM('IN', 'OUT')
+    });
+    queryInterface.changeColumn(
+      'sms_messages',
+      'status', {
+        type: Sequelize.ENUM('SENT', 'SENDING', 'RECEIVED', 'FAILED',
+          'NOTE'),
+        defaultValue: 'SENDING'
+      }
+    );
+
+    queryInterface.removeColumn('sms_messages', 'errorcode');
+    queryInterface.removeColumn('sms_messages', 'skebby_message_id');
+    queryInterface.removeColumn('sms_messages', 'res_data');
+
+
+  }
+};