-- 数据授权结果表
create table sys_auth_result_20201212 as select * from sys_auth_result;
update sys_auth_result a inner join 
(select identity_id,identity_id_back from epu_bid.sys_user) b 
on a.owner_id = b.identity_id_back set a.owner_id = b.identity_id
-- 分级授权结果表
create table sys_classified_auth_result_20201212 as select * from sys_classified_auth_result;
update sys_classified_auth_result a inner join 
(select identity_id,identity_id_back from epu_bid.sys_user) b 
on a.owner_id = b.identity_id_back set a.owner_id = b.identity_id
-- 用户岗位关联表
create table sys_user_job_20201212 as select * from sys_user_job;
update sys_user_job a inner join 
(select identity_id,identity_id_back from epu_bid.sys_user) b 
on a.user_id = b.identity_id_back set a.user_id = b.identity_id
-- 系统管理员预制表
create table sys_system_user_20201212 as select * from sys_system_user;
update sys_system_user a inner join 
(select identity_id,identity_id_back from epu_bid.sys_user) b 
on a.identity_id = b.identity_id_back set a.identity_id = b.identity_id