update.sql 704 B

123456789101112131415161718
  1. -- 请按如下分类提交sql!!!
  2. -- Version V3.5.50.xxxx
  3. -- uat 2025-xx-xx
  4. -- prod 2025-xx-xx
  5. ------------------------------------
  6. -- 表结构
  7. ------------------------------------
  8. ALTER TABLE `zh_construction_unit`
  9. MODIFY COLUMN `sign_path` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '签章图片地址,以逗号分隔' AFTER `basic`,
  10. ADD COLUMN `sign_permission` tinyint(1) NULL DEFAULT 1 COMMENT '授权所有人使用单位章' AFTER `sign_path`;
  11. ALTER TABLE `zh_project_account`
  12. ADD COLUMN `unit_sign_path` mediumtext NULL COMMENT '单位章图片地址' AFTER `stamp_path`;
  13. ------------------------------------
  14. -- 表数据
  15. ------------------------------------