Calculation/sql/update20210715.sql

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`;