update.sql 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778
  1. -- 请按如下分类提交sql!!!
  2. -- Version V3.5.47.0141
  3. -- uat 2025-1-16/20
  4. -- prod todo
  5. ------------------------------------
  6. -- 表结构
  7. ------------------------------------
  8. ALTER TABLE `zh_sub_project`
  9. ADD COLUMN `page_show` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '{\"bwtz\":\"1\"}' COMMENT '前台页面或功能展示与隐藏' AFTER `lock_file`,
  10. ADD COLUMN `fun_rela` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '功能设置(json.stringify)' AFTER `page_show`,
  11. ADD COLUMN `data_collect` tinyint(1) NOT NULL DEFAULT 0 COMMENT '决策大屏是否显示及对应大屏编号' AFTER `fun_rela`,
  12. ADD COLUMN `data_collect_pages` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '需要展示的大屏字符串,以,分隔' AFTER `data_collect`,
  13. ADD COLUMN `fun_set` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '项目设置页内容json' AFTER `data_collect_pages`,
  14. ADD COLUMN `payment_setting` JSON NULL DEFAULT NULL COMMENT '支付审批模块设置' AFTER `fun_set`;
  15. ALTER TABLE `zh_category`
  16. ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '子项目id(uuid)' AFTER `pid`;
  17. ALTER TABLE `zh_category_value`
  18. ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '子项目id(uuid)' AFTER `pid`;
  19. ALTER TABLE `zh_sub_project_permission`
  20. ADD COLUMN `self_category_level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `update_time`;
  21. ALTER TABLE `zh_project_log`
  22. ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '操作子项目' AFTER `pid`;
  23. ALTER TABLE `zh_sub_project`
  24. MODIFY COLUMN `rela_tender` varchar(5000) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '关联标段id(\',\'分隔)' AFTER `user_id`;
  25. ALTER TABLE `zh_budget`
  26. MODIFY COLUMN `rela_tender` varchar(5000) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '关联标段id(\',\'分隔)' AFTER `std_id`;
  27. ALTER TABLE `zh_sub_project_permission`
  28. ADD COLUMN `info_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '项目概况,权限id列表(\',\'分隔)' AFTER `self_category_level`,
  29. ADD COLUMN `fund_trans_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '资金划拨,权限id列表(\',\'分隔)' AFTER `info_permission`,
  30. ADD COLUMN `fund_pay_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '资金支付,权限id列表(\',\'分隔)' AFTER `fund_trans_permission`,
  31. ADD COLUMN `contract_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '合同管理,权限id列表(\',\'分隔)' AFTER `fund_pay_permission`,
  32. ADD COLUMN `datacollect_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '决策大屏,权限id列表(\',\'分隔)' AFTER `contract_permission`,
  33. ADD COLUMN `payment_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '支付审批,权限id列表(\',\'分隔)' AFTER `datacollect_permission`;
  34. ALTER TABLE `zh_file_reference_list`
  35. ADD COLUMN `file_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '文件类型' AFTER `remark`,
  36. ADD COLUMN `file_type_str` varchar(50) NOT NULL DEFAULT '资料归集' COMMENT '文件类型-文本' AFTER `file_type`;
  37. ALTER TABLE `zh_file_reference`
  38. MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称' AFTER `is_leaf`,
  39. ADD COLUMN `code` varchar(50) NOT NULL DEFAULT '' COMMENT '序号/编号' AFTER `name`,
  40. MODIFY COLUMN `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注' AFTER `name`;
  41. ALTER TABLE `zh_budget_std`
  42. ADD COLUMN `progress_template_id` varchar(255) NOT NULL DEFAULT '' COMMENT '项目概况-阶段进度-新建模板id列表(‘,’分隔)' AFTER `ht_tender_template_id`;
  43. ALTER TABLE `zh_project_col_set`
  44. ADD COLUMN `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'zh_project.id' AFTER `id`,
  45. ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT 'zh_sub_project.id' AFTER `pid`,
  46. ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `info`,
  47. ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间' AFTER `create_time`;
  48. ALTER TABLE `zh_payment_tender`
  49. ADD COLUMN `spid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`;
  50. ALTER TABLE `zh_payment_folder`
  51. MODIFY COLUMN `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL FIRST,
  52. ADD COLUMN `spid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`,
  53. ADD COLUMN `folder_id` int(11) NOT NULL DEFAULT 0 COMMENT '节点id' AFTER `name`;
  54. ------------------------------------
  55. -- 表数据
  56. ------------------------------------
  57. UPDATE zh_project_log pl LEFT JOIN zh_tender t ON pl.tid = t.id SET pl.spid = IF(ISNULL(t.spid),'',t.spid);
  58. Update zh_project_col_set SET pid = id;
  59. Update zh_payment_folder SET folder_id = id;