-
Notifications
You must be signed in to change notification settings - Fork 6
Expand file tree
/
Copy pathsys_menu.sql
More file actions
57 lines (49 loc) · 9.18 KB
/
sys_menu.sql
File metadata and controls
57 lines (49 loc) · 9.18 KB
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
53
54
55
56
57
create table sys_menu
(
id bigint auto_increment comment '主键'
primary key,
menu_name varchar(50) not null comment '菜单名称',
menu_type tinyint default 1 not null comment '菜单类型(1：目录 2：菜单 3：按钮)',
status_id tinyint default 1 not null comment '状态(1:正常，0:禁用)',
sort int default 1 not null comment '排序',
parent_id bigint not null comment '父ID',
menu_url varchar(255) default '' null comment '路由路径',
api_url varchar(255) default '' null comment '接口URL',
menu_icon varchar(255) null comment '菜单图标',
remark varchar(255) null comment '备注',
create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
update_time datetime null on update CURRENT_TIMESTAMP comment '修改时间',
constraint menu_name
unique (menu_name)
)
comment '菜单信息';
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (1, '首页', 1, 1, 0, 0, '/home', '', 'SmileOutlined', '首页', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (2, '权限管理', 1, 1, 1, 0, '/system', '', 'SettingOutlined', '权限管理', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (3, '用户管理', 2, 1, 1, 2, '/system/user/list', '', 'setting', '用户管理', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (4, '角色管理', 2, 1, 2, 2, '/system/role/list', '', '', '角色管理', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (5, '菜单管理', 2, 1, 3, 2, '/system/menu/list', '/api/system/menu/queryMenuList', 'setting', '菜单管理', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (6, '保存用户接口', 3, 1, 1, 3, '', '/api/system/user/addUser', '', '保存用户接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (7, '删除用户接口', 3, 1, 2, 3, '', '/api/system/user/deleteUser', '', '删除用户接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (8, '更新用户接口', 3, 1, 3, 3, '', '/api/system/user/updateUser', '', '更新用户接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (9, '保存用户角色', 3, 1, 4, 3, '', '/api/system/user/updateUserRoleList', '', '保存用户角色接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (10, '用户关联的角色', 3, 1, 5, 3, '', '/api/system/user/queryUserRoleList', '', '获取用户关联的角色', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (11, '查询用户列表', 3, 1, 6, 3, '', '/api/system/user/queryUserList', '', '查询用户列表接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (12, '查询用户菜单接口', 3, 1, 7, 3, '', '/api/system/user/queryUserMenuList', '', '查询用户菜单接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (13, '保存角色接口', 3, 1, 1, 4, '', '/api/system/role/addRole', '', '保存角色接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (14, '删除角色接口', 3, 1, 2, 4, '', '/api/system/role/deleteRole', '', '删除角色接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (15, '更新角色接口', 3, 1, 3, 4, '', '/api/system/role/updateRole', '', '更新角色接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (16, '查询角色列表', 3, 1, 4, 4, '', '/api/system/role/queryRoleList', '', '查询角色列表接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (17, '菜单角色关联', 3, 1, 5, 4, '', '/api/system/role/queryRoleMenuList', '', '菜单角色关联接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (18, '保存角色菜单关联', 3, 6, 1, 4, '', '/api/system/role/updateRoleMenuList', '', '角色菜单关联接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (19, '保存菜单接口', 3, 1, 1, 5, '', '/api/system/menu/addMenu', '', '保存菜单接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (20, '删除菜单接口', 3, 1, 2, 5, '', '/api/system/menu/deleteMenu', '', '删除菜单接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (21, '更新菜单接口', 3, 1, 3, 5, '', '/api/system/menu/updateMenu', '', '更新菜单接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (22, '查询菜单列表', 3, 1, 4, 5, '', '/api/system/menu/queryMenuList', '', '查询菜单列表接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (23, '日志管理', 1, 1, 2, 0, '/logs', '', 'SettingOutlined', '', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (24, '登录日志', 2, 1, 1, 23, '/log/login/list', '', '', '', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (25, '操作日志', 2, 1, 2, 23, '/log/operate/list', '', '', '', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (26, '删除登录日志', 3, 1, 1, 24, '', '/api/log/login/deleteLoginLog', '', '删除登录日志接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (27, '查询登录日志', 3, 1, 2, 24, '', '/api/log/login/queryLoginLogList', '', '查询登录日志列表接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (28, '删除操作日志', 3, 1, 1, 25, '', '/api/log/operate/deleteOperateLog', '', '删除操作日志接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (29, '查询操作日志', 3, 1, 2, 25, '', '/api/log/operate/queryOperateLogList', '', '查询操作日志列表接口', current_timestamp, null);
INSERT INTO sys_menu (id, menu_name, menu_type, status_id, sort, parent_id, menu_url, api_url, menu_icon, remark, create_time, update_time) VALUES (30, '查询登录日志统计', 3, 1, 2, 25, '', '/api/log/login/statisticsLoginLog', '', '查询登录日志统计接口', current_timestamp, null);