用户角色迁移

– 新增角色资源

insert into sys_role_resource 
select 1 as role_id,id as resource_id from sys_resource where id not in(
select resource_id from sys_role_resource where role_id=1
)

– 新增用户角色

insert into sys_user_role select user_id,role_id from user_info 

– 迁移角色表

insert into sys_role(id,name,description,deleted,privilege) select role_id as id ,role_name as name,role_desc as description,display as deleted,privilege from role_info 

– 迁移用户表

insert into sys_user(id,code,password,real_name,user_name,deleted,user_type)
select user_id as id,user_code as code,user_password as password,user_full_name as real_name,user_name,display as deleted,user_type from user_info