Built motion from commit a0baffd.|1.0.1

[motion.git] / server / models / history / report_sms_history.js

diff --git a/server/models/history/report_sms_history.js b/server/models/history/report_sms_history.js
index f17b83f..abc8424 100644 (file)
--- a/server/models/history/report_sms_history.js
+++ b/server/models/history/report_sms_history.js
@@ -7,8 +7,10 @@ var moment = require('moment');
 module.exports = function(sequelize, DataTypes) {
 
   var ReportSmsHistory = sequelize.define('ReportSmsHistory', {
+    sourceid: DataTypes.INTEGER,
     uniqueid: DataTypes.STRING,
     timeslot: DataTypes.INTEGER,
+    from: DataTypes.STRING,
     accountid: DataTypes.STRING,
     accountname: DataTypes.STRING,
     accountnumber: DataTypes.STRING,
@@ -31,7 +33,11 @@ module.exports = function(sequelize, DataTypes) {
     rejectedAt: DataTypes.DATE,
     connectedAt: DataTypes.DATE
   }, {
-    tableName: 'report_sms_history'
+    tableName: 'report_sms_history',
+    indexes: [{
+      name: 'sourceid',
+      fields: ['sourceid']
+    }]
   });
   ReportSmsHistory.removeAttribute('id');
   return ReportSmsHistory;