update20210715.sql 731 B

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