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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
| -- ----------------------------
| -- 菜单权限表
| -- ----------------------------
| DROP TABLE IF EXISTS sys_menu;
|
| CREATE TABLE sys_menu
| (
| menu_id BIGSERIAL NOT NULL PRIMARY KEY,
| menu_name VARCHAR(50) NOT NULL,
| parent_id BIGINT DEFAULT 0,
| order_num INTEGER DEFAULT 0,
| path VARCHAR(200) DEFAULT '',
| component VARCHAR(255) DEFAULT NULL,
| query VARCHAR(255) DEFAULT NULL,
| route_name VARCHAR(50) DEFAULT '',
| is_frame INTEGER DEFAULT 1,
| is_cache INTEGER DEFAULT 0,
| menu_type CHAR(1) DEFAULT '',
| visible CHAR(1) DEFAULT '0',
| status CHAR(1) DEFAULT '0',
| perms VARCHAR(100) DEFAULT NULL,
| icon VARCHAR(100) DEFAULT '#',
| create_by VARCHAR(64) DEFAULT '',
| create_time TIMESTAMP,
| update_by VARCHAR(64) DEFAULT '',
| update_time TIMESTAMP,
| remark VARCHAR(500) DEFAULT ''
| );
|
| COMMENT ON TABLE sys_menu IS '菜单权限表';
|
| -- Optional: Set comments on the columns
| COMMENT ON COLUMN sys_menu.menu_id IS '菜单ID';
| COMMENT ON COLUMN sys_menu.menu_name IS '菜单名称';
| COMMENT ON COLUMN sys_menu.parent_id IS '父菜单ID';
| COMMENT ON COLUMN sys_menu.order_num IS '显示顺序';
| COMMENT ON COLUMN sys_menu.path IS '路由地址';
| COMMENT ON COLUMN sys_menu.component IS '组件路径';
| COMMENT ON COLUMN sys_menu.query IS '路由参数';
| COMMENT ON COLUMN sys_menu.route_name IS '路由名称';
| COMMENT ON COLUMN sys_menu.is_frame IS '是否为外链（0是 1否）';
| COMMENT ON COLUMN sys_menu.is_cache IS '是否缓存（0缓存 1不缓存）';
| COMMENT ON COLUMN sys_menu.menu_type IS '菜单类型（M目录 C菜单 F按钮）';
| COMMENT ON COLUMN sys_menu.visible IS '菜单状态（0显示 1隐藏）';
| COMMENT ON COLUMN sys_menu.status IS '菜单状态（0正常 1停用）';
| COMMENT ON COLUMN sys_menu.perms IS '权限标识';
| COMMENT ON COLUMN sys_menu.icon IS '菜单图标';
| COMMENT ON COLUMN sys_menu.create_by IS '创建者';
| COMMENT ON COLUMN sys_menu.create_time IS '创建时间';
| COMMENT ON COLUMN sys_menu.update_by IS '更新者';
| COMMENT ON COLUMN sys_menu.update_time IS '更新时间';
| COMMENT ON COLUMN sys_menu.remark IS '备注';
|
|
| -- ----------------------------
| -- 初始化-菜单信息表数据
| -- ----------------------------
| -- 一级菜单
| insert into sys_menu (id, name, parent_id, order_num, perms, url, target, icon, visible, status, menu_type, is_frame,
| is_cache, code, create_by, create_time, update_by, update_time, remark)
| values ('1', '系统管理', '0', '1', 'system', null, '', '', 1, 0, 'M', '0', '0', '', 'system', 'admin',
| CURRENT_TIMESTAMP, '', null, '系统管理目录'),
| ('2', '系统监控', '0', '2', 'monitor', null, '', '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin',
| CURRENT_TIMESTAMP, '', null, '系统监控目录'),
| ('3', '系统工具', '0', '3', 'tool', null, '', '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', CURRENT_TIMESTAMP,
| '', null, '系统工具目录'),
| ('4', '若依官网', '0', '4', 'http://ruoyi.vip', null, '', '', 0, 0, 'M', '0', '0', '', 'guide', 'admin',
| CURRENT_TIMESTAMP, '', null, '若依官网地址');
|
| -- 二级菜单
| insert into sys_menu (id, name, parent_id, order_num, perms, url, target, icon, visible, status, menu_type, is_frame,
| is_cache, code, create_by, create_time, update_by, update_time, remark)
| values ('100', '用户管理', '1', '1', 'user', 'system/user/index', '', '', 1, 0, 'C', '0', '0', 'system:user:list',
| 'user', 'admin', CURRENT_TIMESTAMP, '', null, '用户管理菜单'),
| ('101', '角色管理', '1', '2', 'role', 'system/role/index', '', '', 1, 0, 'C', '0', '0', 'system:role:list',
| 'peoples', 'admin', CURRENT_TIMESTAMP, '', null, '角色管理菜单'),
| ('102', '菜单管理', '1', '3', 'menu', 'system/menu/index', '', '', 1, 0, 'C', '0', '0', 'system:menu:list',
| 'tree-table', 'admin', CURRENT_TIMESTAMP, '', null, '菜单管理菜单'),
| ('103', '部门管理', '1', '4', 'dept', 'system/dept/index', '', '', 1, 0, 'C', '0', '0', 'system:dept:list',
| 'tree', 'admin', CURRENT_TIMESTAMP, '', null, '部门管理菜单'),
| ('104', '岗位管理', '1', '5', 'post', 'system/post/index', '', '', 1, 0, 'C', '0', '0', 'system:post:list',
| 'post', 'admin', CURRENT_TIMESTAMP, '', null, '岗位管理菜单'),
| ('105', '字典管理', '1', '6', 'dict', 'system/dict/index', '', '', 1, 0, 'C', '0', '0', 'system:dict:list',
| 'dict', 'admin', CURRENT_TIMESTAMP, '', null, '字典管理菜单'),
| ('106', '参数设置', '1', '7', 'config', 'system/config/index', '', '', 1, 0, 'C', '0', '0', 'system:config:list',
| 'edit', 'admin', CURRENT_TIMESTAMP, '', null, '参数设置菜单'),
| ('107', '通知公告', '1', '8', 'notice', 'system/notice/index', '', '', 1, 0, 'C', '0', '0', 'system:notice:list',
| 'message', 'admin', CURRENT_TIMESTAMP, '', null, '通知公告菜单'),
| ('108', '日志管理', '1', '9', 'log', '', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', CURRENT_TIMESTAMP, '',
| null, '日志管理菜单'),
| ('109', '在线用户', '2', '1', 'online', 'monitor/online/index', '', '', 1, 0, 'C', '0', '0',
| 'monitor:online:list', 'online', 'admin', CURRENT_TIMESTAMP, '', null, '在线用户菜单'),
| ('110', '定时任务', '2', '2', 'job', 'monitor/job/index', '', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job',
| 'admin', CURRENT_TIMESTAMP, '', null, '定时任务菜单'),
| ('111', '数据监控', '2', '3', 'druid', 'monitor/druid/index', '', '', 1, 0, 'C', '0', '0', 'monitor:druid:list',
| 'druid', 'admin', CURRENT_TIMESTAMP, '', null, '数据监控菜单'),
| ('112', '服务监控', '2', '4', 'server', 'monitor/server/index', '', '', 1, 0, 'C', '0', '0',
| 'monitor:server:list', 'server', 'admin', CURRENT_TIMESTAMP, '', null, '服务监控菜单'),
| ('113', '缓存监控', '2', '5', 'cache', 'monitor/cache/index', '', '', 1, 0, 'C', '0', '0', 'monitor:cache:list',
| 'redis', 'admin', CURRENT_TIMESTAMP, '', null, '缓存监控菜单'),
| ('114', '缓存列表', '2', '6', 'cacheList', 'monitor/cache/list', '', '', 1, 0, 'C', '0', '0',
| 'monitor:cache:list', 'redis-list', 'admin', CURRENT_TIMESTAMP, '', null, '缓存列表菜单'),
| ('115', '表单构建', '3', '1', 'build', 'tool/build/index', '', '', 1, 0, 'C', '0', '0', 'tool:build:list',
| 'build', 'admin', CURRENT_TIMESTAMP, '', null, '表单构建菜单'),
| ('116', '代码生成', '3', '2', 'gen', 'tool/gen/index', '', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code',
| 'admin', CURRENT_TIMESTAMP, '', null, '代码生成菜单'),
| ('117', '系统接口', '3', '3', 'swagger', 'tool/swagger/index', '', '', 1, 0, 'C', '0', '0', 'tool:swagger:list',
| 'swagger', 'admin', CURRENT_TIMESTAMP, '', null, '系统接口菜单');
|
| -- 三级菜单
| insert into sys_menu (id, name, parent_id, order_num, perms, url, target, icon, visible, status, menu_type, is_frame,
| is_cache, code, create_by, create_time, update_by, update_time, remark)
| values ('500', '操作日志', '108', '1', 'operlog', 'monitor/operlog/index', '', '', 1, 0, 'C', '0', '0',
| 'monitor:operlog:list', 'form', 'admin', CURRENT_TIMESTAMP, '', null, '操作日志菜单'),
| ('501', '登录日志', '108', '2', 'logininfor', 'monitor/logininfor/index', '', '', 1, 0, 'C', '0', '0',
| 'monitor:logininfor:list', 'logininfor', 'admin', CURRENT_TIMESTAMP, '', null, '登录日志菜单');
|
| -- 用户管理按钮
| insert into sys_menu (id, name, parent_id, order_num, perms, url, target, icon, visible, status, menu_type, is_frame,
| is_cache, code, create_by, create_time, update_by, update_time, remark)
| values ('1000', '用户查询', '100', '1', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1001', '用户新增', '100', '2', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1002', '用户修改', '100', '3', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, '');
|
| insert into sys_menu (menu_id, menu_name, parent_id, order_num, perms, url, target, icon, visible, status, is_cache,
| del_flag, create_by, create_time, update_by, update_time, remarks)
| values ('1003', '用户删除', '100', '4', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1004', '用户导出', '100', '5', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1005', '用户导入', '100', '6', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1006', '重置密码', '100', '7', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 角色管理按钮
| ('1007', '角色查询', '101', '1', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1008', '角色新增', '101', '2', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1009', '角色修改', '101', '3', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1010', '角色删除', '101', '4', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1011', '角色导出', '101', '5', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 菜单管理按钮
| ('1012', '菜单查询', '102', '1', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1013', '菜单新增', '102', '2', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1014', '菜单修改', '102', '3', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1015', '菜单删除', '102', '4', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 部门管理按钮
| ('1016', '部门查询', '103', '1', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1017', '部门新增', '103', '2', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1018', '部门修改', '103', '3', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1019', '部门删除', '103', '4', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 岗位管理按钮
| ('1020', '岗位查询', '104', '1', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1021', '岗位新增', '104', '2', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1022', '岗位修改', '104', '3', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1023', '岗位删除', '104', '4', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1024', '岗位导出', '104', '5', '', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 字典管理按钮
| ('1025', '字典查询', '105', '1', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1026', '字典新增', '105', '2', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1027', '字典修改', '105', '3', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1028', '字典删除', '105', '4', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1029', '字典导出', '105', '5', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 参数设置按钮
| ('1030', '参数查询', '106', '1', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1031', '参数新增', '106', '2', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1032', '参数修改', '106', '3', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1033', '参数删除', '106', '4', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1034', '参数导出', '106', '5', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 通知公告按钮
| ('1035', '公告查询', '107', '1', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1036', '公告新增', '107', '2', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1037', '公告修改', '107', '3', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1038', '公告删除', '107', '4', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 操作日志按钮
| ('1039', '操作查询', '500', '1', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1040', '操作删除', '500', '2', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1041', '日志导出', '500', '3', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 登录日志按钮
| ('1042', '登录查询', '501', '1', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1043', '登录删除', '501', '2', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1044', '日志导出', '501', '3', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1045', '账户解锁', '501', '4', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| -- 在线用户按钮
| ('1046', '在线查询', '109', '1', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, ''),
| ('1047', '批量强退', '109', '2', '#', '', '', '', 1, 0, 'F', '0', 'admin', current_timestamp, '',
| current_timestamp, '');
| insert into sys_menu (menu_id, menu_name, parent_id, order_num, perms, url, target, icon, visible, status, is_cache,
| del_flag, create_by, create_time, update_by, update_time, remarks)
| values ('1048', '单条强退', '109', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#',
| 'admin', CURRENT_TIMESTAMP, '', null, ''),
| ('1049', '任务查询', '110', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1050', '任务新增', '110', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1051', '任务修改', '110', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1052', '任务删除', '110', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1053', '状态修改', '110', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1054', '任务导出', '110', '6', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1055', '生成查询', '116', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1056', '生成修改', '116', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1057', '生成删除', '116', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1058', '导入代码', '116', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1059', '预览代码', '116', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, ''),
| ('1060', '生成代码', '116', '6', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin',
| CURRENT_TIMESTAMP, '', null, '');
|
|
