update20210420.sql 704 B

1234567891011121314151617
  1. ALTER TABLE `zh_project_account` ADD `wx_unionid` VARCHAR(50) NULL COMMENT '微信绑定unionid(同一个开放平台共用)' AFTER `wx_openid`;
  2. --
  3. -- 报表归档表
  4. --
  5. CREATE TABLE `calculation`.`zh_rpt_archive` (
  6. `archive_id` INT NOT NULL,
  7. `prj_id` INT NULL,
  8. `stage_id` INT NULL,
  9. `content` VARCHAR(4000) NULL,
  10. PRIMARY KEY (`archive_id`),
  11. INDEX `PRJ_STG` (`prj_id` ASC, `stage_id` ASC))
  12. COMMENT = '报表归档表;\n只考虑项目id及期id,其他信息全部归入content';
  13. -- 项目设置-功能设置
  14. ALTER TABLE `zh_project`
  15. ADD COLUMN `fun_rela` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '功能设置(json.stringify)' AFTER `rpt_nature`;