| ÎļþÃû´Ó sql/ry_20210731.sql ÐÞ¸Ä |
| | |
|---|
| | | order_num int(4) default 0 comment 'æ¾ç¤ºé¡ºåº',
|
|---|
| | | path varchar(200) default '' comment 'è·¯ç±å°å',
|
|---|
| | | component varchar(255) default null comment 'ç»ä»¶è·¯å¾',
|
|---|
| | | query varchar(255) default null comment 'è·¯ç±åæ°',
|
|---|
| | | is_frame int(1) default 1 comment 'æ¯å¦ä¸ºå¤é¾ï¼0æ¯ 1å¦ï¼',
|
|---|
| | | is_cache int(1) default 0 comment 'æ¯å¦ç¼åï¼0ç¼å 1ä¸ç¼åï¼',
|
|---|
| | | menu_type char(1) default '' comment 'èåç±»åï¼Mç®å½ Cèå Fæé®ï¼',
|
|---|
| | |
|---|
| | | -- åå§å-èåä¿¡æ¯è¡¨æ°æ®
|
|---|
| | | -- ----------------------------
|
|---|
| | | -- ä¸çº§èå
|
|---|
| | | insert into sys_menu values('1', 'ç³»ç»ç®¡ç', '0', '1', 'system', null, 1, 0, 'M', '0', '0', '', 'system', 'admin', sysdate(), '', null, 'ç³»ç»ç®¡çç®å½');
|
|---|
| | | insert into sys_menu values('2', 'ç³»ç»çæ§', '0', '2', 'monitor', null, 1, 0, 'M', '0', '0', '', 'monitor', 'admin', sysdate(), '', null, 'ç³»ç»çæ§ç®å½');
|
|---|
| | | insert into sys_menu values('3', 'ç³»ç»å·¥å
·', '0', '3', 'tool', null, 1, 0, 'M', '0', '0', '', 'tool', 'admin', sysdate(), '', null, 'ç³»ç»å·¥å
·ç®å½');
|
|---|
| | | insert into sys_menu values('4', 'è¥ä¾å®ç½', '0', '4', 'http://ruoyi.vip', null , 0, 0, 'M', '0', '0', '', 'guide', 'admin', sysdate(), '', null, 'è¥ä¾å®ç½å°å');
|
|---|
| | | insert into sys_menu values('1', 'ç³»ç»ç®¡ç', '0', '1', 'system', null, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', sysdate(), '', null, 'ç³»ç»ç®¡çç®å½');
|
|---|
| | | insert into sys_menu values('2', 'ç³»ç»çæ§', '0', '2', 'monitor', null, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', sysdate(), '', null, 'ç³»ç»çæ§ç®å½');
|
|---|
| | | insert into sys_menu values('3', 'ç³»ç»å·¥å
·', '0', '3', 'tool', null, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', sysdate(), '', null, 'ç³»ç»å·¥å
·ç®å½');
|
|---|
| | | insert into sys_menu values('4', 'è¥ä¾å®ç½', '0', '4', 'http://ruoyi.vip', null, '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', sysdate(), '', null, 'è¥ä¾å®ç½å°å');
|
|---|
| | | -- äºçº§èå
|
|---|
| | | insert into sys_menu values('100', 'ç¨æ·ç®¡ç', '1', '1', 'user', 'system/user/index', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', sysdate(), '', null, 'ç¨æ·ç®¡çèå');
|
|---|
| | | insert into sys_menu values('101', 'è§è²ç®¡ç', '1', '2', 'role', 'system/role/index', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', sysdate(), '', null, 'è§è²ç®¡çèå');
|
|---|
| | | insert into sys_menu values('102', 'èå管ç', '1', '3', 'menu', 'system/menu/index', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', sysdate(), '', null, 'èå管çèå');
|
|---|
| | | insert into sys_menu values('103', 'é¨é¨ç®¡ç', '1', '4', 'dept', 'system/dept/index', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', sysdate(), '', null, 'é¨é¨ç®¡çèå');
|
|---|
| | | insert into sys_menu values('104', 'å²ä½ç®¡ç', '1', '5', 'post', 'system/post/index', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', sysdate(), '', null, 'å²ä½ç®¡çèå');
|
|---|
| | | insert into sys_menu values('105', 'åå
¸ç®¡ç', '1', '6', 'dict', 'system/dict/index', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', sysdate(), '', null, 'åå
¸ç®¡çèå');
|
|---|
| | | insert into sys_menu values('106', 'åæ°è®¾ç½®', '1', '7', 'config', 'system/config/index', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', sysdate(), '', null, 'åæ°è®¾ç½®èå');
|
|---|
| | | insert into sys_menu values('107', 'éç¥å
¬å', '1', '8', 'notice', 'system/notice/index', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', sysdate(), '', null, 'éç¥å
¬åèå');
|
|---|
| | | insert into sys_menu values('108', 'æ¥å¿ç®¡ç', '1', '9', 'log', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', sysdate(), '', null, 'æ¥å¿ç®¡çèå');
|
|---|
| | | insert into sys_menu values('109', 'å¨çº¿ç¨æ·', '2', '1', 'online', 'monitor/online/index', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, 'å¨çº¿ç¨æ·èå');
|
|---|
| | | insert into sys_menu values('110', 'å®æ¶ä»»å¡', '2', '2', 'job', 'monitor/job/index', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, 'å®æ¶ä»»å¡èå');
|
|---|
| | | insert into sys_menu values('111', 'æ°æ®çæ§', '2', '3', 'druid', 'monitor/druid/index', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', sysdate(), '', null, 'æ°æ®çæ§èå');
|
|---|
| | | insert into sys_menu values('112', 'æå¡çæ§', '2', '4', 'server', 'monitor/server/index', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', sysdate(), '', null, 'æå¡çæ§èå');
|
|---|
| | | insert into sys_menu values('113', 'ç¼åçæ§', '2', '5', 'cache', 'monitor/cache/index', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', sysdate(), '', null, 'ç¼åçæ§èå');
|
|---|
| | | insert into sys_menu values('114', '表åæ建', '3', '1', 'build', 'tool/build/index', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', sysdate(), '', null, '表åæ建èå');
|
|---|
| | | insert into sys_menu values('115', '代ç çæ', '3', '2', 'gen', 'tool/gen/index', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', sysdate(), '', null, '代ç çæèå');
|
|---|
| | | insert into sys_menu values('116', 'ç³»ç»æ¥å£', '3', '3', 'swagger', 'tool/swagger/index', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', sysdate(), '', null, 'ç³»ç»æ¥å£èå');
|
|---|
| | | insert into sys_menu values('100', 'ç¨æ·ç®¡ç', '1', '1', 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', sysdate(), '', null, 'ç¨æ·ç®¡çèå');
|
|---|
| | | insert into sys_menu values('101', 'è§è²ç®¡ç', '1', '2', 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', sysdate(), '', null, 'è§è²ç®¡çèå');
|
|---|
| | | insert into sys_menu values('102', 'èå管ç', '1', '3', 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', sysdate(), '', null, 'èå管çèå');
|
|---|
| | | insert into sys_menu values('103', 'é¨é¨ç®¡ç', '1', '4', 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', sysdate(), '', null, 'é¨é¨ç®¡çèå');
|
|---|
| | | insert into sys_menu values('104', 'å²ä½ç®¡ç', '1', '5', 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', sysdate(), '', null, 'å²ä½ç®¡çèå');
|
|---|
| | | insert into sys_menu values('105', 'åå
¸ç®¡ç', '1', '6', 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', sysdate(), '', null, 'åå
¸ç®¡çèå');
|
|---|
| | | insert into sys_menu values('106', 'åæ°è®¾ç½®', '1', '7', 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', sysdate(), '', null, 'åæ°è®¾ç½®èå');
|
|---|
| | | insert into sys_menu values('107', 'éç¥å
¬å', '1', '8', 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', sysdate(), '', null, 'éç¥å
¬åèå');
|
|---|
| | | insert into sys_menu values('108', 'æ¥å¿ç®¡ç', '1', '9', 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', sysdate(), '', null, 'æ¥å¿ç®¡çèå');
|
|---|
| | | insert into sys_menu values('109', 'å¨çº¿ç¨æ·', '2', '1', 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, 'å¨çº¿ç¨æ·èå');
|
|---|
| | | insert into sys_menu values('110', 'å®æ¶ä»»å¡', '2', '2', 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, 'å®æ¶ä»»å¡èå');
|
|---|
| | | insert into sys_menu values('111', 'æ°æ®çæ§', '2', '3', 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', sysdate(), '', null, 'æ°æ®çæ§èå');
|
|---|
| | | insert into sys_menu values('112', 'æå¡çæ§', '2', '4', 'server', 'monitor/server/index', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', sysdate(), '', null, 'æå¡çæ§èå');
|
|---|
| | | insert into sys_menu values('113', 'ç¼åçæ§', '2', '5', 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', sysdate(), '', null, 'ç¼åçæ§èå');
|
|---|
| | | insert into sys_menu values('114', '表åæ建', '3', '1', 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', sysdate(), '', null, '表åæ建èå');
|
|---|
| | | insert into sys_menu values('115', '代ç çæ', '3', '2', 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', sysdate(), '', null, '代ç çæèå');
|
|---|
| | | insert into sys_menu values('116', 'ç³»ç»æ¥å£', '3', '3', 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', sysdate(), '', null, 'ç³»ç»æ¥å£èå');
|
|---|
| | | -- ä¸çº§èå
|
|---|
| | | insert into sys_menu values('500', 'æä½æ¥å¿', '108', '1', 'operlog', 'monitor/operlog/index', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', sysdate(), '', null, 'æä½æ¥å¿èå');
|
|---|
| | | insert into sys_menu values('501', 'ç»å½æ¥å¿', '108', '2', 'logininfor', 'monitor/logininfor/index', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', sysdate(), '', null, 'ç»å½æ¥å¿èå');
|
|---|
| | | insert into sys_menu values('500', 'æä½æ¥å¿', '108', '1', 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', sysdate(), '', null, 'æä½æ¥å¿èå');
|
|---|
| | | insert into sys_menu values('501', 'ç»å½æ¥å¿', '108', '2', 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', sysdate(), '', null, 'ç»å½æ¥å¿èå');
|
|---|
| | | -- ç¨æ·ç®¡çæé®
|
|---|
| | | insert into sys_menu values('1001', 'ç¨æ·æ¥è¯¢', '100', '1', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1002', 'ç¨æ·æ°å¢', '100', '2', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1003', 'ç¨æ·ä¿®æ¹', '100', '3', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1004', 'ç¨æ·å é¤', '100', '4', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1005', 'ç¨æ·å¯¼åº', '100', '5', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1006', 'ç¨æ·å¯¼å
¥', '100', '6', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1007', 'éç½®å¯ç ', '100', '7', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1001', 'ç¨æ·æ¥è¯¢', '100', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1002', 'ç¨æ·æ°å¢', '100', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1003', 'ç¨æ·ä¿®æ¹', '100', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1004', 'ç¨æ·å é¤', '100', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1005', 'ç¨æ·å¯¼åº', '100', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1006', 'ç¨æ·å¯¼å
¥', '100', '6', '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1007', 'éç½®å¯ç ', '100', '7', '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- è§è²ç®¡çæé®
|
|---|
| | | insert into sys_menu values('1008', 'è§è²æ¥è¯¢', '101', '1', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1009', 'è§è²æ°å¢', '101', '2', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1010', 'è§è²ä¿®æ¹', '101', '3', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1011', 'è§è²å é¤', '101', '4', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1012', 'è§è²å¯¼åº', '101', '5', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1008', 'è§è²æ¥è¯¢', '101', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1009', 'è§è²æ°å¢', '101', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1010', 'è§è²ä¿®æ¹', '101', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1011', 'è§è²å é¤', '101', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1012', 'è§è²å¯¼åº', '101', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- èå管çæé®
|
|---|
| | | insert into sys_menu values('1013', 'èåæ¥è¯¢', '102', '1', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1014', 'èåæ°å¢', '102', '2', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1015', 'èåä¿®æ¹', '102', '3', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1016', 'èåå é¤', '102', '4', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1013', 'èåæ¥è¯¢', '102', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1014', 'èåæ°å¢', '102', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1015', 'èåä¿®æ¹', '102', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1016', 'èåå é¤', '102', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- é¨é¨ç®¡çæé®
|
|---|
| | | insert into sys_menu values('1017', 'é¨é¨æ¥è¯¢', '103', '1', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1018', 'é¨é¨æ°å¢', '103', '2', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1019', 'é¨é¨ä¿®æ¹', '103', '3', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1020', 'é¨é¨å é¤', '103', '4', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1017', 'é¨é¨æ¥è¯¢', '103', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1018', 'é¨é¨æ°å¢', '103', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1019', 'é¨é¨ä¿®æ¹', '103', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1020', 'é¨é¨å é¤', '103', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- å²ä½ç®¡çæé®
|
|---|
| | | insert into sys_menu values('1021', 'å²ä½æ¥è¯¢', '104', '1', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1022', 'å²ä½æ°å¢', '104', '2', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1023', 'å²ä½ä¿®æ¹', '104', '3', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1024', 'å²ä½å é¤', '104', '4', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1025', 'å²ä½å¯¼åº', '104', '5', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1021', 'å²ä½æ¥è¯¢', '104', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1022', 'å²ä½æ°å¢', '104', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1023', 'å²ä½ä¿®æ¹', '104', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1024', 'å²ä½å é¤', '104', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1025', 'å²ä½å¯¼åº', '104', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- åå
¸ç®¡çæé®
|
|---|
| | | insert into sys_menu values('1026', 'åå
¸æ¥è¯¢', '105', '1', '#', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1027', 'åå
¸æ°å¢', '105', '2', '#', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1028', 'åå
¸ä¿®æ¹', '105', '3', '#', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1029', 'åå
¸å é¤', '105', '4', '#', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1030', 'åå
¸å¯¼åº', '105', '5', '#', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1026', 'åå
¸æ¥è¯¢', '105', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1027', 'åå
¸æ°å¢', '105', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1028', 'åå
¸ä¿®æ¹', '105', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1029', 'åå
¸å é¤', '105', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1030', 'åå
¸å¯¼åº', '105', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- åæ°è®¾ç½®æé®
|
|---|
| | | insert into sys_menu values('1031', 'åæ°æ¥è¯¢', '106', '1', '#', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1032', 'åæ°æ°å¢', '106', '2', '#', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1033', 'åæ°ä¿®æ¹', '106', '3', '#', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1034', 'åæ°å é¤', '106', '4', '#', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1035', 'åæ°å¯¼åº', '106', '5', '#', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1031', 'åæ°æ¥è¯¢', '106', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1032', 'åæ°æ°å¢', '106', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1033', 'åæ°ä¿®æ¹', '106', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1034', 'åæ°å é¤', '106', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1035', 'åæ°å¯¼åº', '106', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- éç¥å
¬åæé®
|
|---|
| | | insert into sys_menu values('1036', 'å
¬åæ¥è¯¢', '107', '1', '#', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1037', 'å
¬åæ°å¢', '107', '2', '#', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1038', 'å
¬åä¿®æ¹', '107', '3', '#', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1039', 'å
¬åå é¤', '107', '4', '#', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1036', 'å
¬åæ¥è¯¢', '107', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1037', 'å
¬åæ°å¢', '107', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1038', 'å
¬åä¿®æ¹', '107', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1039', 'å
¬åå é¤', '107', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- æä½æ¥å¿æé®
|
|---|
| | | insert into sys_menu values('1040', 'æä½æ¥è¯¢', '500', '1', '#', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1041', 'æä½å é¤', '500', '2', '#', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1042', 'æ¥å¿å¯¼åº', '500', '4', '#', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1040', 'æä½æ¥è¯¢', '500', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1041', 'æä½å é¤', '500', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1042', 'æ¥å¿å¯¼åº', '500', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- ç»å½æ¥å¿æé®
|
|---|
| | | insert into sys_menu values('1043', 'ç»å½æ¥è¯¢', '501', '1', '#', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1044', 'ç»å½å é¤', '501', '2', '#', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1045', 'æ¥å¿å¯¼åº', '501', '3', '#', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1043', 'ç»å½æ¥è¯¢', '501', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1044', 'ç»å½å é¤', '501', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1045', 'æ¥å¿å¯¼åº', '501', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- å¨çº¿ç¨æ·æé®
|
|---|
| | | insert into sys_menu values('1046', 'å¨çº¿æ¥è¯¢', '109', '1', '#', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1047', 'æ¹é强é', '109', '2', '#', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1048', 'åæ¡å¼ºé', '109', '3', '#', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1046', 'å¨çº¿æ¥è¯¢', '109', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1047', 'æ¹é强é', '109', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1048', 'åæ¡å¼ºé', '109', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- å®æ¶ä»»å¡æé®
|
|---|
| | | insert into sys_menu values('1049', 'ä»»å¡æ¥è¯¢', '110', '1', '#', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1050', 'ä»»å¡æ°å¢', '110', '2', '#', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1051', 'ä»»å¡ä¿®æ¹', '110', '3', '#', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1052', 'ä»»å¡å é¤', '110', '4', '#', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1053', 'ç¶æä¿®æ¹', '110', '5', '#', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1054', 'ä»»å¡å¯¼åº', '110', '7', '#', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1049', 'ä»»å¡æ¥è¯¢', '110', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1050', 'ä»»å¡æ°å¢', '110', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1051', 'ä»»å¡ä¿®æ¹', '110', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1052', 'ä»»å¡å é¤', '110', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1053', 'ç¶æä¿®æ¹', '110', '5', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1054', 'ä»»å¡å¯¼åº', '110', '7', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | -- 代ç çææé®
|
|---|
| | | insert into sys_menu values('1055', 'çææ¥è¯¢', '115', '1', '#', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1056', 'çæä¿®æ¹', '115', '2', '#', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1057', 'çæå é¤', '115', '3', '#', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1058', '导å
¥ä»£ç ', '115', '2', '#', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1059', 'é¢è§ä»£ç ', '115', '4', '#', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1060', 'çæ代ç ', '115', '5', '#', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1055', 'çææ¥è¯¢', '115', '1', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1056', 'çæä¿®æ¹', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1057', 'çæå é¤', '115', '3', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1058', '导å
¥ä»£ç ', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1059', 'é¢è§ä»£ç ', '115', '4', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | | insert into sys_menu values('1060', 'çæ代ç ', '115', '5', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
|
|---|
| | |
|
|---|
| | |
|
|---|
| | | -- ----------------------------
|
|---|
