Calculation/sql/update.sql

ALTER TABLE `zh_project_account` ADD `qywx_corpid` VARCHAR(255) NULL DEFAULT NULL COMMENT '已绑定的企业微信id' AFTER `wx_name`;
ALTER TABLE `zh_project_account` ADD `qywx_userid` VARCHAR(255) NULL DEFAULT NULL COMMENT '已绑定企业微信用户id' AFTER `qywx_corpid`;
ALTER TABLE `zh_project_account` ADD `qywx_user_info` VARCHAR(1000) NULL DEFAULT NULL COMMENT '已绑定的企业微信用户信息' AFTER `qywx_userid`;

CREATE TABLE `zh_wx_work` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agentid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '应用id',
  `corpid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '企业id',
  `corp_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '企业名称',
  `permanent_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '企业secret',
  `auth_user_info` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '授权人信息json',
  `in_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  NIQUE KEY `corpid` (`corpid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='企业微信信息表';