Calculation/sql/update20210420.sql

ALTER TABLE `zh_project_account` ADD `wx_unionid` VARCHAR(50) NULL COMMENT '微信绑定unionid(同一个开放平台共用)' AFTER `wx_openid`;

--
-- 报表归档表
--
CREATE TABLE `calculation`.`zh_rpt_archive` (
  `archive_id` INT NOT NULL,
  `prj_id` INT NULL,
  `stage_id` INT NULL,
  `content` VARCHAR(4000) NULL,
  PRIMARY KEY (`archive_id`),
  INDEX `PRJ_STG` (`prj_id` ASC, `stage_id` ASC))
COMMENT = '报表归档表;\n只考虑项目id及期id，其他信息全部归入content';

-- 项目设置-功能设置
ALTER TABLE `zh_project`
ADD COLUMN `fun_rela`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '功能设置(json.stringify)' AFTER `rpt_nature`;