1-update.sql 2.1 KB

1234567891011121314151617181920212223242526272829303132333435
  1. -- USE hnqzx;
  2. ALTER TABLE `sys_user` ADD `id_card_number` VARCHAR (18) COMMENT '身份证' ;
  3. ALTER TABLE `sys_user` ADD `user_sign` VARCHAR (255) COMMENT '签名' ;
  4. ALTER TABLE `sys_user` ADD `cert_status` int(2) DEFAULT NULL COMMENT '认证状态';
  5. ALTER TABLE `sys_user` ADD `cert_remark` VARCHAR(255) DEFAULT NULL COMMENT '认证结果描述';
  6. ALTER TABLE `sys_dept` ADD `app_id` VARCHAR (32) COMMENT '' ;
  7. ALTER TABLE `sys_dept` ADD `app_secret` VARCHAR (32) COMMENT '' ;
  8. ALTER TABLE `sys_dept` ADD `rsa_public_key` VARCHAR(256) COMMENT '';
  9. ALTER TABLE `sys_dept` ADD `query_url` VARCHAR(32) COMMENT '';
  10. ALTER TABLE `sys_dept` ADD `subject_name` VARCHAR(128) COMMENT '结算主体';
  11. ALTER TABLE `wm_score_package` ADD `statement_no` VARCHAR(64) DEFAULT NULL COMMENT '结算单号';
  12. ALTER TABLE `wm_score_package` ADD `settle_status` int(2) DEFAULT NULL COMMENT '结算状态';
  13. ALTER TABLE `wm_score_package` ADD `remark` VARCHAR(255) DEFAULT NULL COMMENT '结算结果描述';
  14. ALTER TABLE `wm_score_package` ADD `invoice_category` varchar(50) DEFAULT NULL COMMENT '发票类目';
  15. ALTER TABLE `wm_score_package` ADD `settle_amount` decimal(30,8) DEFAULT NULL COMMENT '实际结算金额';
  16. ALTER TABLE `wm_score_package` ADD `discount` decimal(11,4) DEFAULT NULL COMMENT '折扣';
  17. ALTER TABLE `wm_da_agent` ADD `js_account` VARCHAR(32) DEFAULT NULL COMMENT '结算账号 ';
  18. ALTER TABLE `wm_wk_article` ADD `read_num` int(11) DEFAULT 0 COMMENT '阅读数';
  19. ALTER TABLE `wm_wk_article` ADD `new_flag` int(1) DEFAULT 0 COMMENT '新标签';
  20. ALTER TABLE `wm_wk_article` ADD `hot_flag` int(1) DEFAULT 0 COMMENT '热门标签';
  21. UPDATE wm_wk_article set read_num = 0
  22. UPDATE wm_wk_article set new_flag = 0
  23. UPDATE wm_wk_article set hot_flag = 0
  24. ALTER TABLE `wm_task` ADD `compare_result` VARCHAR(2) DEFAULT NULL COMMENT '对比结果';
  25. ALTER TABLE `wm_task` ADD `approval_opinion` VARCHAR(2) DEFAULT NULL COMMENT '审批意见';
  26. ALTER TABLE `wm_task` ADD `approval_info` VARCHAR(500) DEFAULT NULL COMMENT '审批说明';
  27. ALTER TABLE `wm_task` ADD `real_flag` char(2) DEFAULT '0' COMMENT '是否真实';
  28. UPDATE wm_task set real_flag = '0'