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