4dkankan-center-manage/doc/update.2.7.2.sql

ALTER TABLE `4dkankan_v4`.`t_download_order_mg`
    ADD COLUMN `company_name` varchar(255) NULL COMMENT '合同所属公司' AFTER `agent_id`,
ADD COLUMN `business_dept` varchar(255) NULL COMMENT '业务部门' AFTER `company_name`,
ADD COLUMN `business_name` varchar(255) NULL COMMENT '业务员' AFTER `business_dept`,
ADD COLUMN `customer_pay_time` varchar(255) NULL COMMENT '客户付款时间' AFTER `business_name`;


ALTER TABLE `4dkankan_v4`.`t_increment_order_mg`
    ADD COLUMN `company_name` varchar(255) NULL COMMENT '合同所属公司' AFTER `agent_id`,
ADD COLUMN `business_dept` varchar(255) NULL COMMENT '业务部门' AFTER `company_name`,
ADD COLUMN `business_name` varchar(255) NULL COMMENT '业务员' AFTER `business_dept`,
ADD COLUMN `customer_pay_time` varchar(255) NULL COMMENT '客户付款时间' AFTER `business_name`;


ALTER TABLE `4dkankan_v4`.`t_authorize_camera`
    ADD COLUMN `company_name` varchar(255) NULL COMMENT '合同所属公司' AFTER `remark`,
ADD COLUMN `business_dept` varchar(255) NULL COMMENT '业务部门' AFTER `company_name`,
ADD COLUMN `business_name` varchar(255) NULL COMMENT '业务员' AFTER `business_dept`,
ADD COLUMN `customer_pay_time` varchar(255) NULL COMMENT '客户付款时间' AFTER `business_name`,
ADD COLUMN `model_auth_code` varchar(255) NULL COMMENT '算法授权码' AFTER `customer_pay_time`;


UPDATE t_user set download_num_total = download_num_total + (ss_download_num_total - ss_download_num) WHERE rec_status = 'A' and (ss_download_num_total != 10 or   ss_download_num_total - ss_download_num!=10);