package models

//删除用户角色
var SqlDeleteUserRoles = `delete from sys_user_role where user_id=?`

//获取用户角色
var SqlSelectUserRoles = `select 
						  sys_user_role.*,
						  GROUP_CONCAT(sys_role.name) role_name,
						  GROUP_CONCAT(sys_role.id) user_role 
						from
						  sys_user_role 
						LEFT JOIN
						  sys_role
						on
						  sys_user_role.role_id = sys_role.id
						where sys_user_role.user_id = ? 
						  and sys_user_role.del_flag = 0 `