-- lixingjia 2021-12-01 授权企业表主键corp_id ===> 主键 (corp_id,suite_id)
ALTER TABLE `we_auth_corp_info`
  DROP PRIMARY KEY,
  ADD PRIMARY KEY (`corp_id`, `suite_id`) USING BTREE;
-- lixingjia 授权企业拓展表主键corp_id ===> 主键 (corp_id,suite_id)
ALTER TABLE `we_auth_corp_info_extend`
  DROP PRIMARY KEY,
  ADD PRIMARY KEY (`corp_id`, `suite_id`) USING BTREE;

-- lixingjia 2021-12-01 企业配置表中增加三方应用企业ID =>用于判断该配置应用于那个三方授权企
ALTER TABLE `we_corp_account`
  ADD COLUMN `external_corp_id` VARCHAR(255) NOT NULL DEFAULT ''
COMMENT '三方应用企业ID'
  AFTER `corp_id`;
-- lixingjia 2021-12-01 补偿旧数据记录中的external_corp_id字段
UPDATE we_corp_account
SET external_corp_id = corp_id
WHERE external_corp_id = '';
-- lixingjia 2021-12-01 增加三方员工ID和内部员工ID映射关系表
CREATE TABLE `we_external_user_mapping_user` (
  `external_corp_id` VARCHAR(255) NOT NULL DEFAULT ''
  COMMENT '三方应用企业ID',
  `external_user_id` VARCHAR(255) NOT NULL DEFAULT ''
  COMMENT '三方应用员工ID',
  `corp_id`          VARCHAR(255) NOT NULL DEFAULT ''
  COMMENT '内部应用企业ID',
  `user_id`          VARCHAR(255) NOT NULL DEFAULT ''
  COMMENT '内部应用员工ID',
  PRIMARY KEY (`external_corp_id`, `external_user_id`)
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COMMENT ='三方应用员工映射表';