CREATE TABLE `calculation`.`zh_rpt_archive_encryption` ( `id` INT NOT NULL AUTO_INCREMENT, `prj_id` INT NULL, `stage_id` INT NULL, `content` JSON NULL, PRIMARY KEY (`id`), INDEX `PRJ_STG` (`prj_id` ASC, `stage_id` ASC)) COMMENT = '归档文档的需要加密签名的坐标及其他key信息(如签名角色id,签名角色名称等)'; ALTER TABLE `zh_material_list` ADD `expr` VARCHAR(500) NULL DEFAULT '' COMMENT '公式' AFTER `quantity`; ALTER TABLE `zh_s2b_proj` ADD COLUMN `gxby_ratio_valid` tinyint(1) NULL DEFAULT 0 COMMENT '工序报验,ratio是否生效' AFTER `gxby_status`, ADD COLUMN `dagl_ratio_valid` tinyint(1) NOT NULL DEFAULT 1 COMMENT '工序报验,ratio是否生效' AFTER `dagl_status`;