1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
| INSERT INTO sys_menu (uuid, version, pid, menu_type, menu_name, perm_code, sort_order, route_path, del_flag)
| SELECT REPLACE(UUID(), '-', ''), 1, p.id, 3, '详情', 'sys:users:detail', 10, NULL, 0
| FROM sys_menu p
| WHERE p.route_path = '/users' AND p.del_flag = 0
| AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perm_code = 'sys:users:detail' AND del_flag = 0);
|
| INSERT INTO sys_menu (uuid, version, pid, menu_type, menu_name, perm_code, sort_order, route_path, del_flag)
| SELECT REPLACE(UUID(), '-', ''), 1, p.id, 3, '新增', 'sys:users:create', 20, NULL, 0
| FROM sys_menu p
| WHERE p.route_path = '/users' AND p.del_flag = 0
| AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perm_code = 'sys:users:create' AND del_flag = 0);
|
| INSERT INTO sys_menu (uuid, version, pid, menu_type, menu_name, perm_code, sort_order, route_path, del_flag)
| SELECT REPLACE(UUID(), '-', ''), 1, p.id, 3, '编辑', 'sys:users:update', 30, NULL, 0
| FROM sys_menu p
| WHERE p.route_path = '/users' AND p.del_flag = 0
| AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perm_code = 'sys:users:update' AND del_flag = 0);
|
| INSERT INTO sys_menu (uuid, version, pid, menu_type, menu_name, perm_code, sort_order, route_path, del_flag)
| SELECT REPLACE(UUID(), '-', ''), 1, p.id, 3, '启停账号', 'sys:users:status', 40, NULL, 0
| FROM sys_menu p
| WHERE p.route_path = '/users' AND p.del_flag = 0
| AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perm_code = 'sys:users:status' AND del_flag = 0);
|
| INSERT INTO sys_menu (uuid, version, pid, menu_type, menu_name, perm_code, sort_order, route_path, del_flag)
| SELECT REPLACE(UUID(), '-', ''), 1, p.id, 3, '重置密码', 'sys:users:password', 50, NULL, 0
| FROM sys_menu p
| WHERE p.route_path = '/users' AND p.del_flag = 0
| AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perm_code = 'sys:users:password' AND del_flag = 0);
|
| INSERT INTO sys_menu (uuid, version, pid, menu_type, menu_name, perm_code, sort_order, route_path, del_flag)
| SELECT REPLACE(UUID(), '-', ''), 1, p.id, 3, '删除', 'sys:users:delete', 60, NULL, 0
| FROM sys_menu p
| WHERE p.route_path = '/users' AND p.del_flag = 0
| AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perm_code = 'sys:users:delete' AND del_flag = 0);
|
| INSERT INTO sys_role_menu (uuid, version, role_id, menu_id, del_flag)
| SELECT LOWER(MD5(CONCAT(r.id, ':', m.id, ':', RAND()))), 1, r.id, m.id, 0
| FROM sys_role r
| JOIN sys_menu m ON m.del_flag = 0
| LEFT JOIN sys_role_menu rm ON rm.role_id = r.id AND rm.menu_id = m.id AND rm.del_flag = 0
| WHERE r.role_code = 'ADMIN'
| AND r.del_flag = 0
| AND m.perm_code IN (
| 'sys:users:detail',
| 'sys:users:create',
| 'sys:users:update',
| 'sys:users:status',
| 'sys:users:password',
| 'sys:users:delete'
| )
| AND rm.id IS NULL;
|
|
