Calculation/sql/update.sql

-- 请按如下分类提交sql！！！
-- Version V3.5.50.xxxx
-- uat 2025-xx-xx
-- prod 2025-xx-xx

------------------------------------
-- 表结构
------------------------------------
ALTER TABLE `zh_construction_unit`
MODIFY COLUMN `sign_path` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '签章图片地址，以逗号分隔' AFTER `basic`,
ADD COLUMN `sign_permission` tinyint(1) NULL DEFAULT 1 COMMENT '授权所有人使用单位章' AFTER `sign_path`;

ALTER TABLE `zh_project_account`
ADD COLUMN `unit_sign_path` mediumtext NULL COMMENT '单位章图片地址' AFTER `stamp_path`;

ALTER TABLE `zh_filing`
ADD COLUMN `file_company` varchar(100) NOT NULL DEFAULT '' COMMENT '归档单位' AFTER `tips`;

ALTER TABLE `zh_filing_template`
ADD COLUMN `file_company` varchar(100) NOT NULL DEFAULT '' COMMENT '归档单位' AFTER `tips`;

ALTER TABLE `zh_sub_project_permission`
ADD COLUMN `last_time` timestamp NULL DEFAULT NULL COMMENT '最近使用时间' AFTER `tp_cache_time`;

------------------------------------
-- 表数据
------------------------------------