Inicio Explorar Axuda
Rexistro Iniciar sesión
lyhzzz
/
4dkankan-center-manage
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: 3bb4f35e47
Ramas Etiquetas
4dkankan-cen...
/
doc
/
update.2.7.2.sql

update.2.7.2.sql 1.3 KB
Histórico Raw

1234567891011121314151617181920 
  1. ALTER TABLE `4dkankan_v4`.`t_download_order_mg`
    2. 

  2.     ADD COLUMN `company_name` varchar(255) NULL COMMENT '合同所属公司' AFTER `agent_id`,
    3. 

  3. ADD COLUMN `business_dept` varchar(255) NULL COMMENT '业务部门' AFTER `company_name`,
    4. 

  4. ADD COLUMN `business_name` varchar(255) NULL COMMENT '业务员' AFTER `business_dept`,
    5. 

  5. ADD COLUMN `customer_pay_time` varchar(255) NULL COMMENT '客户付款时间' AFTER `business_name`;
    6. 

  6. 

  7. 

  8. ALTER TABLE `4dkankan_v4`.`t_increment_order_mg`
    9. 

  9.     ADD COLUMN `company_name` varchar(255) NULL COMMENT '合同所属公司' AFTER `agent_id`,
    10. 

  10. ADD COLUMN `business_dept` varchar(255) NULL COMMENT '业务部门' AFTER `company_name`,
    11. 

  11. ADD COLUMN `business_name` varchar(255) NULL COMMENT '业务员' AFTER `business_dept`,
    12. 

  12. ADD COLUMN `customer_pay_time` varchar(255) NULL COMMENT '客户付款时间' AFTER `business_name`;
    13. 

  13. 

  14. 

  15. ALTER TABLE `4dkankan_v4`.`t_authorize_camera`
    16. 

  16.     ADD COLUMN `company_name` varchar(255) NULL COMMENT '合同所属公司' AFTER `remark`,
    17. 

  17. ADD COLUMN `business_dept` varchar(255) NULL COMMENT '业务部门' AFTER `company_name`,
    18. 

  18. ADD COLUMN `business_name` varchar(255) NULL COMMENT '业务员' AFTER `business_dept`,
    19. 

  19. ADD COLUMN `customer_pay_time` varchar(255) NULL COMMENT '客户付款时间' AFTER `business_name`,
    20. 

  20. ADD COLUMN `model_auth_code` varchar(255) NULL COMMENT '算法授权码' AFTER `customer_pay_time`;
    21.