v5.3 v5.3.1更新说明

fs配置   /usr/local/freeswitch/conf/autoload_configs/fastcall.conf.xml    cdr  增加account_sn



语音测试数据重新统计（以下顺序执行）

删除6月10号到前一天数据（2019-07-18为升级前一天日期）
delete from counts_hour where operated_at >= '2019-06-13';

delete from counts_hour_classify where operated_at >= '2019-06-13';

delete from counts_day where operated_at >= '2019-06-13';

delete from counts_day_classify where operated_at >= '2019-06-13';

手动执行初始化命令，一条执行完再执行第二条（不手动执行可升级前修改定时任务时间）
/opt/lampp/bin/php /opt/lampp/test/xiaoa2/artisan command:SyncCountsHoursBinit all

/opt/lampp/bin/php /opt/lampp/test/xiaoa2/artisan command:SyncCountsDaysBinit all

后同步大数据页面数据，升级后（初始化文件执行完成）第二天 执行以下命令
/root/redis-2.8.17/src/redis-cli -p 8293 -a 5gwW1hWM7xAtFdKxxbeAhzDpW50MOdimAMMw keys "usersInfo:counts:realsAll:*" | xargs /root/redis-2.8.17/src/redis-cli -p 8293 -a 5gwW1hWM7xAtFdKxxbeAhzDpW50MOdimAMMw  del




ALTER TABLE counts_hour DROP CONSTRAINT tdohpu;

ALTER TABLE counts_day DROP CONSTRAINT tdopu;

ALTER TABLE counts_hour_classify DROP CONSTRAINT classify_dohpust;

ALTER TABLE counts_day_classify DROP CONSTRAINT classify_dopust;




alter table counts_hour add constraint tdohpup unique(type,dial_task_main_sn,operated_at, hour,parent_sn,user_sn,project_sn);

alter table counts_day add constraint tdopup unique(type,dial_task_main_sn,operated_at, parent_sn,user_sn,project_sn);

alter table counts_hour_classify add constraint classify_dohpustp unique(dial_task_main_sn,operated_at, hour,parent_sn,user_sn,status,type,project_sn);

alter table counts_day_classify add constraint classify_dopustp unique(dial_task_main_sn,operated_at, parent_sn,user_sn,status,type,project_sn);

