123456789101112131415 |
- 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='企业微信信息表';
|