39 lines
989 B
SQL
39 lines
989 B
SQL
USE youlai_admin;
|
|
|
|
-- 代理平台主管演示角色
|
|
SET @proxy_role_code = 'PROXY_MANAGER';
|
|
|
|
INSERT INTO `sys_role`
|
|
(`name`, `code`, `sort`, `status`, `data_scope`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`)
|
|
SELECT '代理平台主管', @proxy_role_code, 80, 1, 1, 1, now(), 1, now(), 0
|
|
FROM DUAL
|
|
WHERE NOT EXISTS (
|
|
SELECT 1
|
|
FROM `sys_role`
|
|
WHERE `code` = @proxy_role_code
|
|
);
|
|
|
|
SET @proxy_role_id = (
|
|
SELECT `id`
|
|
FROM `sys_role`
|
|
WHERE `code` = @proxy_role_code
|
|
LIMIT 1
|
|
);
|
|
|
|
INSERT IGNORE INTO `sys_role_menu` (`role_id`, `menu_id`)
|
|
SELECT @proxy_role_id, `id`
|
|
FROM `sys_menu`
|
|
WHERE `id` IN (
|
|
1100,
|
|
1110, 11101, 11102, 11103, 11104,
|
|
1120, 11201, 11202, 11203, 11204,
|
|
1130, 11301, 11302, 11303, 11304,
|
|
1140, 11401, 11402, 11403, 11404,
|
|
1150, 11501, 11502, 11503,
|
|
1160, 11601, 11602, 11603,
|
|
1170, 11701, 11702,
|
|
1180, 11801, 11802, 11803, 11804,
|
|
1190, 11901, 11902,
|
|
1200, 12001, 12002, 12003
|
|
);
|