fix:menu、role_menu表数据更新

2 files changed, 57 insertions, 39 deletions

diff --git a/cn-admin/src/main/resources/db/R__AZ_sys_menu.sql b/cn-admin/src/main/resources/db/R__AZ_sys_menu.sql
index 9a68cd5..5c0d174 100644
--- a/cn-admin/src/main/resources/db/R__AZ_sys_menu.sql
+++ b/cn-admin/src/main/resources/db/R__AZ_sys_menu.sql
@@ -24,37 +24,43 @@ CREATE TABLE `sys_menu`  (
 -- ----------------------------
 -- Records of sys_menu
 -- ----------------------------
-INSERT INTO `sys_menu` VALUES (1, 'Network Analytics', 'networkAnalytics', 'overall.networkAnalytics', 0, 'sys:user:add,sys:user:list', 1, '', 'cn-icon cn-icon-dashboard', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (2, 'Network Overview', 'networkOverview', 'networkOverview.networkOverview', 1, 'sys:user:add,sys:user:list', 1, '/panel/networkOverview', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (3, 'Network and app performance', 'networkAppPerformance', 'networkAppPerformance.networkAppPerformance', 1, 'sys:user:add,sys:user:list', 1, '/panel/networkAppPerformance', '', NULL, 11, 1);
-INSERT INTO `sys_menu` VALUES (4, 'DNS service insights', 'dnsServiceInsights', 'overall.dnsServiceInsights', 1, 'sys:user:add,sys:user:list', 1, '/panel/dnsServiceInsights', '', NULL, 21, 1);
-INSERT INTO `sys_menu` VALUES (5, 'Setting', 'setting', 'overall.setting', 0, NULL, 1, '/setting', 'cn-icon cn-icon-setting2', NULL, 31, 0);
-INSERT INTO `sys_menu` VALUES (6, 'User', 'user', 'overall.user', 26, NULL, 1, '/administration/user', 'cn-icon cn-icon-user2', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (7, 'Role', 'role', 'overall.role', 26, NULL, 1, '/administration/role', 'cn-icon cn-icon-role2', NULL, 11, 1);
-INSERT INTO `sys_menu` VALUES (8, 'Operation log', 'operationLog', 'overall.operationLog', 26, NULL, 1, '/administration/operationLog', 'cn-icon cn-icon-operation-log', NULL, 21, 1);
-INSERT INTO `sys_menu` VALUES (9, 'Entity', 'entity', 'overall.entity', 0, NULL, 1, '/entityExplorer', 'cn-icon cn-icon-entity', NULL, 11, 1);
-INSERT INTO `sys_menu` VALUES (10, 'Entity explorer', 'entityExplorer', 'overall.entityExplorer', 9, NULL, 1, '/entityExplorer', '', NULL, 11, 1);
-INSERT INTO `sys_menu` VALUES (11, 'I18n', 'I18N', 'I18N', 0, NULL, 1, '/i18n', 'cn-icon cn-icon-i18n', NULL, 31, 1);
-INSERT INTO `sys_menu` VALUES (12, 'Detections', 'detections', 'overall.detections', 0, '', 1, '/detection', 'cn-icon cn-icon-detection1', NULL, 21, 1);
-INSERT INTO `sys_menu` VALUES (13, 'Security events', 'securityEvents', 'entities.securityEvents', 12, NULL, 1, '/detection/securityEvent', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (14, 'Performance events', 'performanceEvents', 'overall.performanceEvents', 12, NULL, 1, '/detection/performanceEvent', '', NULL, 11, 1);
-INSERT INTO `sys_menu` VALUES (15, 'Galaxy proxy', 'galaxyProxy', 'galaxyProxy.galaxyProxy', 26, NULL, 1, '/administration/galaxyProxy', '', NULL, 41, 0);
-INSERT INTO `sys_menu` VALUES (16, 'Crypto currency', 'cryptocurrency', 'overall.cryptocurrency', 1, NULL, 1, '/panel/cryptocurrency', '', NULL, 41, 0);
-INSERT INTO `sys_menu` VALUES (17, 'Temp', 'temp', 'temp', 0, NULL, 1, '/test', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (18, 'Chart', 'chart', 'overall.chart', 0, NULL, 1, '/chart', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (19, 'Report', 'report', 'overall.report', 0, NULL, 1, '/report/builtIn', 'cn-icon cn-icon-report1', NULL, 26, 1);
-INSERT INTO `sys_menu` VALUES (20, 'Built-in report', 'builtInReport', 'report.builtInReport', 19, 'report:job:add,report:job:delete,report:temp:add,report:temp:update,report:temp:delete', 1, '/report/builtIn', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (21, 'Appearance', 'appearance', 'appearance.appearance', 26, 'sys:appearance:update', 1, '/administration/appearance', 'cn-icon cn-icon-preview', NULL, 28, 1);
-INSERT INTO `sys_menu` VALUES (25, 'Link monitor', 'linkMonitor', 'overall.linkMonitor', 1, NULL, 1, '/panel/linkMonitor', '', NULL, 41, 1);
-INSERT INTO `sys_menu` VALUES (26, 'Administration', 'administration', 'overall.administration', 0, NULL, 1, '/administration', 'cn-icon cn-icon-administrations', NULL, 61, 1);
-INSERT INTO `sys_menu` VALUES (27, 'Knowledge base', 'knowledgeBase', 'overall.knowledgeBase', 0, NULL, 1, '/knowledgeBase', 'cn-icon cn-icon-knowledge-base', NULL, 41, 1);
-INSERT INTO `sys_menu` VALUES (28, 'Create knowledge base', 'createKnowledgeBase', 'overall.create', 31, NULL, 2, '/knowledgeBase/userDefinedLibrary/create', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (29, 'Edit knowledge base', 'editKnowledgeBase', 'overall.edit', 31, NULL, 2, '/knowledgeBase/userDefinedLibrary/edit', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (30, 'Entity detail', 'entityDetail', 'overall.detail', 0, NULL, 1, '/entityDetail', '', NULL, 30, 1);
-INSERT INTO `sys_menu` VALUES (31, 'User-defined Library', 'userDefinedLibrary', 'knowledgeBase.userDefinedLibrary', 27, NULL, 1, '/knowledgeBase/userDefinedLibrary', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (32, 'Entity graph', 'entityGraph', 'entities.graph', 0, NULL, 1, '/entityGraph', '', NULL, 32, 1);
-INSERT INTO `sys_menu` VALUES (33, 'Detection policy', 'detectionPolicy', 'overall.policies', 12, NULL, 1, '/detectionPolicy', '', NULL, 21, 1);
-INSERT INTO `sys_menu` VALUES (34, 'Create detection policy', 'createDetectionPolicy', 'detection.createEventPolicies', 33, NULL, 1, '/detectionPolicy/create', '', NULL, 1, 1);
-INSERT INTO `sys_menu` VALUES (35, 'Edit detection policy', 'editDetectionPolicy', 'detection.editEventPolicies', 33, NULL, 1, '/detectionPolicy/edit', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (1, 'Network Analytics', 'networkAnalytics', 'overall.networkAnalytics', 0, NULL, 1, 'redirect:/panel', 'cn-icon cn-icon-dashboard', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (2, 'Network Overview', 'networkOverview', 'networkOverview.networkOverview', 1, NULL, 1, '/panel/networkOverview', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (3, 'Network and app performance', 'networkAppPerformance', 'networkAppPerformance.networkAppPerformance', 1, NULL, 1, '/panel/networkAppPerformance', '', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (4, 'DNS service insights', 'dnsServiceInsights', 'overall.dnsServiceInsights', 1, NULL, 1, '/panel/dnsServiceInsights', '', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (5, 'Entity', 'entity', 'overall.entity', 0, NULL, 1, '/entity', 'cn-icon cn-icon-entity', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (6, 'Entity detail', 'entityDetail', 'overall.detail', 5, NULL, 1, '/entity/detail', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (7, 'Entity graph', 'entityGraph', 'entities.graph', 5, NULL, 1, '/entity/graph', '', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (8, 'Detections', 'detections', 'overall.detections', 0, '', 1, 'redirect:/detection', 'cn-icon cn-icon-detection1', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (9, 'Security events', 'securityEvents', 'entities.securityEvents', 8, NULL, 1, '/detection/securityEvent', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (10, 'Performance events', 'performanceEvents', 'overall.performanceEvents', 8, NULL, 1, '/detection/performanceEvent', '', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (11, 'Detection policy', 'detectionPolicy', 'overall.policies', 8, NULL, 1, '/detection/policy', '', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (12, 'Create detection policy', 'createDetectionPolicy', 'overall.create', 11, NULL, 1, '/detection/policy/create', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (13, 'Edit detection policy', 'editDetectionPolicy', 'overall.edit', 11, NULL, 1, '/detection/policy/edit', '', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (14, 'Delete detection policy', 'deleteDetectionPolicy', 'overall.delete', 11, NULL, 2, '', '', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (15, 'Report', 'report', 'overall.report', 0, NULL, 1, '/report', 'cn-icon cn-icon-report1', NULL, 31, 1);
+INSERT INTO `sys_menu` VALUES (16, 'Create report', 'createReport', 'overall.create', 15, NULL, 2, '', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (17, 'Edit report', 'editReport', 'overall.edit', 15, NULL, 2, '', '', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (18, 'Delete report', 'deleteReport', 'overall.delete', 15, NULL, 2, '', '', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (19, 'Knowledge base', 'knowledgeBase', 'overall.knowledgeBase', 0, NULL, 1, '/knowledgeBase', 'cn-icon cn-icon-knowledge-base', NULL, 41, 1);
+INSERT INTO `sys_menu` VALUES (20, 'Edit built-in knowledge base', 'editBuiltInKnowledgeBase', 'overall.edit', 19, NULL, 2, '', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (21, 'User-defined library', 'userDefinedLibrary', 'knowledgeBase.userDefinedLibrary', 19, NULL, 1, '/knowledgeBase/userDefined', '', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (22, 'Create user-defined library', 'createUserDefinedLibrary', 'overall.create', 21, NULL, 1, '/knowledgeBase/userDefined/create', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (23, 'Edit user-defined library', 'editUserDefinedLibrary', 'overall.edit', 21, NULL, 1, '/knowledgeBase/userDefined/edit', '', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (24, 'Delete user-defined library', 'deleteUserDefinedLibrary', 'overall.delete', 21, NULL, 2, '', '', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (25, 'Administration', 'administration', 'overall.administration', 0, NULL, 1, 'redirect:/administration', 'cn-icon cn-icon-administrations', NULL, 51, 1);
+INSERT INTO `sys_menu` VALUES (26, 'User', 'user', 'overall.user', 25, NULL, 1, '/administration/user', 'cn-icon cn-icon-user2', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (27, 'Create user', 'createUser', 'overall.create', 26, NULL, 2, '', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (28, 'Edit user', 'editUser', 'overall.edit', 26, NULL, 2, '', '', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (29, 'Delete user', 'deleteUser', 'overall.delete', 26, NULL, 2, '', '', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (30, 'Role', 'role', 'overall.role', 25, NULL, 1, '/administration/role', 'cn-icon cn-icon-role2', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (31, 'Create role', 'createRole', 'overall.create', 30, NULL, 2, '', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (32, 'Edit role', 'editRole', 'overall.edit', 30, NULL, 2, '', '', NULL, 11, 1);
+INSERT INTO `sys_menu` VALUES (33, 'Delete role', 'deleteRole', 'overall.delete', 30, NULL, 2, '', '', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (34, 'Operation log', 'operationLog', 'overall.operationLog', 25, NULL, 1, '/administration/operationLog', 'cn-icon cn-icon-operation-log', NULL, 21, 1);
+INSERT INTO `sys_menu` VALUES (35, 'Appearance', 'appearance', 'appearance.appearance', 25, NULL, 1, '/administration/appearance', 'cn-icon cn-icon-preview', NULL, 31, 1);
+INSERT INTO `sys_menu` VALUES (36, 'Edit appearence', 'editAppearence', 'overall.edit', 35, NULL, 2, '', '', NULL, 1, 1);
+INSERT INTO `sys_menu` VALUES (37, 'I18n', 'I18N', 'I18N', 0, NULL, 1, '/i18n', 'cn-icon cn-icon-i18n', NULL, 91, 1);
+INSERT INTO `sys_menu` VALUES (38, 'Link monitor', 'linkMonitor', 'overall.linkMonitor', 1, NULL, 1, '/panel/linkMonitor', '', NULL, 31, 1);
 
 SET FOREIGN_KEY_CHECKS = 1;
diff --git a/cn-admin/src/main/resources/db/R__AZ_sys_role_menu.sql b/cn-admin/src/main/resources/db/R__AZ_sys_role_menu.sql
index c3da419..97ca674 100644
--- a/cn-admin/src/main/resources/db/R__AZ_sys_role_menu.sql
+++ b/cn-admin/src/main/resources/db/R__AZ_sys_role_menu.sql
@@ -7,36 +7,48 @@
 delete from sys_role_menu where role_id in (1,2);
 
 INSERT INTO `sys_role_menu` VALUES (null, 1, 1);
-INSERT INTO `sys_role_menu` VALUES (null, 2, 2);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 2);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 3);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 4);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 5);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 6);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 7);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 8);
-INSERT INTO `sys_role_menu` VALUES (null, 1, 11);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 9);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 10);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 11);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 12);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 13);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 14);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 15);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 16);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 17);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 18);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 19);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 20);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 21);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 22);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 23);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 24);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 25);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 26);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 27);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 28);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 29);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 30);
-INSERT INTO `sys_role_menu` VALUES (null, 2, 2);
-INSERT INTO `sys_role_menu` VALUES (null, 2, 18);
-INSERT INTO `sys_role_menu` VALUES (null, 11, 8);
-INSERT INTO `sys_role_menu` VALUES (null, 11, 21);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 31);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 32);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 33);
 INSERT INTO `sys_role_menu` VALUES (null, 1, 34);
-INSERT INTO `sys_role_menu` VALUES (null, 1, 35);
\ No newline at end of file
+INSERT INTO `sys_role_menu` VALUES (null, 1, 35);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 36);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 37);
+INSERT INTO `sys_role_menu` VALUES (null, 1, 38);
+INSERT INTO `sys_role_menu` VALUES (null, 2, 2);
+INSERT INTO `sys_role_menu` VALUES (null, 2, 3);
+INSERT INTO `sys_role_menu` VALUES (null, 2, 4);
+INSERT INTO `sys_role_menu` VALUES (null, 2, 38);
+INSERT INTO `sys_role_menu` VALUES (null, 2, 6);
+INSERT INTO `sys_role_menu` VALUES (null, 2, 7);
+INSERT INTO `sys_role_menu` VALUES (null, 2, 9);
+INSERT INTO `sys_role_menu` VALUES (null, 2, 10);
\ No newline at end of file