首页 发现 帮助
注册 登录
root
/
zhhf
1
0
派生 0
文件
目录树: 1b0f29e392
分支列表 标签列表
zhhf
/
zhhf_back
/
sql
/
sys_menu.sql

sys_menu.sql 22 KB
文件历史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 本机
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50726
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : zhhf
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50726
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 25/05/2026 16:05:32
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for sys_menu
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `sys_menu`;
    24. 

  24. CREATE TABLE `sys_menu`  (
    25. 

  25.   `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
    26. 

  26.   `menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称',
    27. 

  27.   `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父菜单ID',
    28. 

  28.   `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
    29. 

  29.   `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#' COMMENT '请求地址',
    30. 

  30.   `target` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）',
    31. 

  31.   `menu_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    32. 

  32.   `visible` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
    33. 

  33.   `is_refresh` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '是否刷新（0刷新 1不刷新）',
    34. 

  34.   `perms` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识',
    35. 

  35.   `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#' COMMENT '菜单图标',
    36. 

  36.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
    37. 

  37.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    38. 

  38.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
    39. 

  39.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    40. 

  40.   `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
    41. 

  41.   PRIMARY KEY (`menu_id`) USING BTREE
    42. 

  42. ) ENGINE = InnoDB AUTO_INCREMENT = 2032 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;
    43. 

  43. 

  44. -- ----------------------------
    45. 

  45. -- Records of sys_menu
    46. 

  46. -- ----------------------------
    47. 

  47. INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 19, '#', 'menuItem', 'M', '0', '1', '', 'fa fa-gear', 'admin', '2026-05-25 09:14:28', 'admin', '2026-05-25 10:49:02', '系统管理目录');
    48. 

  48. INSERT INTO `sys_menu` VALUES (2, '系统监控', 0, 20, '#', 'menuItem', 'M', '0', '1', '', 'fa fa-video-camera', 'admin', '2026-05-25 09:14:28', 'admin', '2026-05-25 10:48:23', '系统监控目录');
    49. 

  49. INSERT INTO `sys_menu` VALUES (3, '系统工具', 0, 21, '#', 'menuItem', 'M', '0', '1', '', 'fa fa-bars', 'admin', '2026-05-25 09:14:28', 'admin', '2026-05-25 10:48:14', '系统工具目录');
    50. 

  50. INSERT INTO `sys_menu` VALUES (4, '备用链接', 0, 22, '#', 'menuItem', 'C', '1', '1', '', 'fa fa-location-arrow', 'admin', '2026-05-25 09:14:28', 'admin', '2026-05-25 10:48:38', '若依官网地址');
    51. 

  51. INSERT INTO `sys_menu` VALUES (100, '用户管理', 1, 1, '/system/user', '', 'C', '0', '1', 'system:user:view', 'fa fa-user-o', 'admin', '2026-05-25 09:14:28', '', NULL, '用户管理菜单');
    52. 

  52. INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 2, '/system/role', '', 'C', '0', '1', 'system:role:view', 'fa fa-user-secret', 'admin', '2026-05-25 09:14:28', '', NULL, '角色管理菜单');
    53. 

  53. INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 3, '/system/menu', '', 'C', '0', '1', 'system:menu:view', 'fa fa-th-list', 'admin', '2026-05-25 09:14:28', '', NULL, '菜单管理菜单');
    54. 

  54. INSERT INTO `sys_menu` VALUES (103, '部门管理', 1, 4, '/system/dept', '', 'C', '0', '1', 'system:dept:view', 'fa fa-outdent', 'admin', '2026-05-25 09:14:28', '', NULL, '部门管理菜单');
    55. 

  55. INSERT INTO `sys_menu` VALUES (104, '岗位管理', 1, 5, '/system/post', '', 'C', '0', '1', 'system:post:view', 'fa fa-address-card-o', 'admin', '2026-05-25 09:14:28', '', NULL, '岗位管理菜单');
    56. 

  56. INSERT INTO `sys_menu` VALUES (105, '字典管理', 1, 6, '/system/dict', '', 'C', '0', '1', 'system:dict:view', 'fa fa-bookmark-o', 'admin', '2026-05-25 09:14:28', '', NULL, '字典管理菜单');
    57. 

  57. INSERT INTO `sys_menu` VALUES (106, '参数设置', 1, 7, '/system/config', '', 'C', '0', '1', 'system:config:view', 'fa fa-sun-o', 'admin', '2026-05-25 09:14:28', '', NULL, '参数设置菜单');
    58. 

  58. INSERT INTO `sys_menu` VALUES (107, '通知公告', 1, 8, '/system/notice', '', 'C', '0', '1', 'system:notice:view', 'fa fa-bullhorn', 'admin', '2026-05-25 09:14:28', '', NULL, '通知公告菜单');
    59. 

  59. INSERT INTO `sys_menu` VALUES (108, '日志管理', 1, 9, '#', '', 'M', '0', '1', '', 'fa fa-pencil-square-o', 'admin', '2026-05-25 09:14:28', '', NULL, '日志管理菜单');
    60. 

  60. INSERT INTO `sys_menu` VALUES (109, '在线用户', 2, 1, '/monitor/online', '', 'C', '0', '1', 'monitor:online:view', 'fa fa-user-circle', 'admin', '2026-05-25 09:14:28', '', NULL, '在线用户菜单');
    61. 

  61. INSERT INTO `sys_menu` VALUES (110, '定时任务', 2, 2, '/monitor/job', '', 'C', '0', '1', 'monitor:job:view', 'fa fa-tasks', 'admin', '2026-05-25 09:14:28', '', NULL, '定时任务菜单');
    62. 

  62. INSERT INTO `sys_menu` VALUES (111, '数据监控', 2, 3, '/monitor/data', '', 'C', '0', '1', 'monitor:data:view', 'fa fa-bug', 'admin', '2026-05-25 09:14:28', '', NULL, '数据监控菜单');
    63. 

  63. INSERT INTO `sys_menu` VALUES (112, '服务监控', 2, 4, '/monitor/server', '', 'C', '0', '1', 'monitor:server:view', 'fa fa-server', 'admin', '2026-05-25 09:14:28', '', NULL, '服务监控菜单');
    64. 

  64. INSERT INTO `sys_menu` VALUES (113, '缓存监控', 2, 5, '/monitor/cache', '', 'C', '0', '1', 'monitor:cache:view', 'fa fa-cube', 'admin', '2026-05-25 09:14:28', '', NULL, '缓存监控菜单');
    65. 

  65. INSERT INTO `sys_menu` VALUES (114, '表单构建', 3, 1, '/tool/build', '', 'C', '0', '1', 'tool:build:view', 'fa fa-wpforms', 'admin', '2026-05-25 09:14:28', '', NULL, '表单构建菜单');
    66. 

  66. INSERT INTO `sys_menu` VALUES (115, '代码生成', 3, 2, '/tool/gen', '', 'C', '0', '1', 'tool:gen:view', 'fa fa-code', 'admin', '2026-05-25 09:14:28', '', NULL, '代码生成菜单');
    67. 

  67. INSERT INTO `sys_menu` VALUES (116, '系统接口', 3, 3, '/tool/swagger', '', 'C', '0', '1', 'tool:swagger:view', 'fa fa-gg', 'admin', '2026-05-25 09:14:28', '', NULL, '系统接口菜单');
    68. 

  68. INSERT INTO `sys_menu` VALUES (500, '操作日志', 108, 1, '/monitor/operlog', '', 'C', '0', '1', 'monitor:operlog:view', 'fa fa-address-book', 'admin', '2026-05-25 09:14:28', '', NULL, '操作日志菜单');
    69. 

  69. INSERT INTO `sys_menu` VALUES (501, '登录日志', 108, 2, '/monitor/logininfor', '', 'C', '0', '1', 'monitor:logininfor:view', 'fa fa-file-image-o', 'admin', '2026-05-25 09:14:28', '', NULL, '登录日志菜单');
    70. 

  70. INSERT INTO `sys_menu` VALUES (1000, '用户查询', 100, 1, '#', '', 'F', '0', '1', 'system:user:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    71. 

  71. INSERT INTO `sys_menu` VALUES (1001, '用户新增', 100, 2, '#', '', 'F', '0', '1', 'system:user:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    72. 

  72. INSERT INTO `sys_menu` VALUES (1002, '用户修改', 100, 3, '#', '', 'F', '0', '1', 'system:user:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    73. 

  73. INSERT INTO `sys_menu` VALUES (1003, '用户删除', 100, 4, '#', '', 'F', '0', '1', 'system:user:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    74. 

  74. INSERT INTO `sys_menu` VALUES (1004, '用户导出', 100, 5, '#', '', 'F', '0', '1', 'system:user:export', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    75. 

  75. INSERT INTO `sys_menu` VALUES (1005, '用户导入', 100, 6, '#', '', 'F', '0', '1', 'system:user:import', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    76. 

  76. INSERT INTO `sys_menu` VALUES (1006, '重置密码', 100, 7, '#', '', 'F', '0', '1', 'system:user:resetPwd', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    77. 

  77. INSERT INTO `sys_menu` VALUES (1007, '角色查询', 101, 1, '#', '', 'F', '0', '1', 'system:role:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    78. 

  78. INSERT INTO `sys_menu` VALUES (1008, '角色新增', 101, 2, '#', '', 'F', '0', '1', 'system:role:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    79. 

  79. INSERT INTO `sys_menu` VALUES (1009, '角色修改', 101, 3, '#', '', 'F', '0', '1', 'system:role:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    80. 

  80. INSERT INTO `sys_menu` VALUES (1010, '角色删除', 101, 4, '#', '', 'F', '0', '1', 'system:role:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    81. 

  81. INSERT INTO `sys_menu` VALUES (1011, '角色导出', 101, 5, '#', '', 'F', '0', '1', 'system:role:export', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    82. 

  82. INSERT INTO `sys_menu` VALUES (1012, '菜单查询', 102, 1, '#', '', 'F', '0', '1', 'system:menu:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    83. 

  83. INSERT INTO `sys_menu` VALUES (1013, '菜单新增', 102, 2, '#', '', 'F', '0', '1', 'system:menu:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    84. 

  84. INSERT INTO `sys_menu` VALUES (1014, '菜单修改', 102, 3, '#', '', 'F', '0', '1', 'system:menu:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    85. 

  85. INSERT INTO `sys_menu` VALUES (1015, '菜单删除', 102, 4, '#', '', 'F', '0', '1', 'system:menu:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    86. 

  86. INSERT INTO `sys_menu` VALUES (1016, '部门查询', 103, 1, '#', '', 'F', '0', '1', 'system:dept:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    87. 

  87. INSERT INTO `sys_menu` VALUES (1017, '部门新增', 103, 2, '#', '', 'F', '0', '1', 'system:dept:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    88. 

  88. INSERT INTO `sys_menu` VALUES (1018, '部门修改', 103, 3, '#', '', 'F', '0', '1', 'system:dept:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    89. 

  89. INSERT INTO `sys_menu` VALUES (1019, '部门删除', 103, 4, '#', '', 'F', '0', '1', 'system:dept:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    90. 

  90. INSERT INTO `sys_menu` VALUES (1020, '岗位查询', 104, 1, '#', '', 'F', '0', '1', 'system:post:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    91. 

  91. INSERT INTO `sys_menu` VALUES (1021, '岗位新增', 104, 2, '#', '', 'F', '0', '1', 'system:post:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    92. 

  92. INSERT INTO `sys_menu` VALUES (1022, '岗位修改', 104, 3, '#', '', 'F', '0', '1', 'system:post:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    93. 

  93. INSERT INTO `sys_menu` VALUES (1023, '岗位删除', 104, 4, '#', '', 'F', '0', '1', 'system:post:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    94. 

  94. INSERT INTO `sys_menu` VALUES (1024, '岗位导出', 104, 5, '#', '', 'F', '0', '1', 'system:post:export', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    95. 

  95. INSERT INTO `sys_menu` VALUES (1025, '字典查询', 105, 1, '#', '', 'F', '0', '1', 'system:dict:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    96. 

  96. INSERT INTO `sys_menu` VALUES (1026, '字典新增', 105, 2, '#', '', 'F', '0', '1', 'system:dict:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    97. 

  97. INSERT INTO `sys_menu` VALUES (1027, '字典修改', 105, 3, '#', '', 'F', '0', '1', 'system:dict:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    98. 

  98. INSERT INTO `sys_menu` VALUES (1028, '字典删除', 105, 4, '#', '', 'F', '0', '1', 'system:dict:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    99. 

  99. INSERT INTO `sys_menu` VALUES (1029, '字典导出', 105, 5, '#', '', 'F', '0', '1', 'system:dict:export', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    100. 

  100. INSERT INTO `sys_menu` VALUES (1030, '参数查询', 106, 1, '#', '', 'F', '0', '1', 'system:config:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    101. 

  101. INSERT INTO `sys_menu` VALUES (1031, '参数新增', 106, 2, '#', '', 'F', '0', '1', 'system:config:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    102. 

  102. INSERT INTO `sys_menu` VALUES (1032, '参数修改', 106, 3, '#', '', 'F', '0', '1', 'system:config:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    103. 

  103. INSERT INTO `sys_menu` VALUES (1033, '参数删除', 106, 4, '#', '', 'F', '0', '1', 'system:config:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    104. 

  104. INSERT INTO `sys_menu` VALUES (1034, '参数导出', 106, 5, '#', '', 'F', '0', '1', 'system:config:export', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    105. 

  105. INSERT INTO `sys_menu` VALUES (1035, '公告查询', 107, 1, '#', '', 'F', '0', '1', 'system:notice:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    106. 

  106. INSERT INTO `sys_menu` VALUES (1036, '公告新增', 107, 2, '#', '', 'F', '0', '1', 'system:notice:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    107. 

  107. INSERT INTO `sys_menu` VALUES (1037, '公告修改', 107, 3, '#', '', 'F', '0', '1', 'system:notice:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    108. 

  108. INSERT INTO `sys_menu` VALUES (1038, '公告删除', 107, 4, '#', '', 'F', '0', '1', 'system:notice:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    109. 

  109. INSERT INTO `sys_menu` VALUES (1039, '操作查询', 500, 1, '#', '', 'F', '0', '1', 'monitor:operlog:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    110. 

  110. INSERT INTO `sys_menu` VALUES (1040, '操作删除', 500, 2, '#', '', 'F', '0', '1', 'monitor:operlog:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    111. 

  111. INSERT INTO `sys_menu` VALUES (1041, '详细信息', 500, 3, '#', '', 'F', '0', '1', 'monitor:operlog:detail', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    112. 

  112. INSERT INTO `sys_menu` VALUES (1042, '日志导出', 500, 4, '#', '', 'F', '0', '1', 'monitor:operlog:export', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    113. 

  113. INSERT INTO `sys_menu` VALUES (1043, '登录查询', 501, 1, '#', '', 'F', '0', '1', 'monitor:logininfor:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    114. 

  114. INSERT INTO `sys_menu` VALUES (1044, '登录删除', 501, 2, '#', '', 'F', '0', '1', 'monitor:logininfor:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    115. 

  115. INSERT INTO `sys_menu` VALUES (1045, '日志导出', 501, 3, '#', '', 'F', '0', '1', 'monitor:logininfor:export', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    116. 

  116. INSERT INTO `sys_menu` VALUES (1046, '账户解锁', 501, 4, '#', '', 'F', '0', '1', 'monitor:logininfor:unlock', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    117. 

  117. INSERT INTO `sys_menu` VALUES (1047, '在线查询', 109, 1, '#', '', 'F', '0', '1', 'monitor:online:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    118. 

  118. INSERT INTO `sys_menu` VALUES (1048, '批量强退', 109, 2, '#', '', 'F', '0', '1', 'monitor:online:batchForceLogout', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    119. 

  119. INSERT INTO `sys_menu` VALUES (1049, '单条强退', 109, 3, '#', '', 'F', '0', '1', 'monitor:online:forceLogout', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    120. 

  120. INSERT INTO `sys_menu` VALUES (1050, '任务查询', 110, 1, '#', '', 'F', '0', '1', 'monitor:job:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    121. 

  121. INSERT INTO `sys_menu` VALUES (1051, '任务新增', 110, 2, '#', '', 'F', '0', '1', 'monitor:job:add', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    122. 

  122. INSERT INTO `sys_menu` VALUES (1052, '任务修改', 110, 3, '#', '', 'F', '0', '1', 'monitor:job:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    123. 

  123. INSERT INTO `sys_menu` VALUES (1053, '任务删除', 110, 4, '#', '', 'F', '0', '1', 'monitor:job:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    124. 

  124. INSERT INTO `sys_menu` VALUES (1054, '状态修改', 110, 5, '#', '', 'F', '0', '1', 'monitor:job:changeStatus', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    125. 

  125. INSERT INTO `sys_menu` VALUES (1055, '任务详细', 110, 6, '#', '', 'F', '0', '1', 'monitor:job:detail', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    126. 

  126. INSERT INTO `sys_menu` VALUES (1056, '任务导出', 110, 7, '#', '', 'F', '0', '1', 'monitor:job:export', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    127. 

  127. INSERT INTO `sys_menu` VALUES (1057, '生成查询', 115, 1, '#', '', 'F', '0', '1', 'tool:gen:list', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    128. 

  128. INSERT INTO `sys_menu` VALUES (1058, '生成修改', 115, 2, '#', '', 'F', '0', '1', 'tool:gen:edit', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    129. 

  129. INSERT INTO `sys_menu` VALUES (1059, '生成删除', 115, 3, '#', '', 'F', '0', '1', 'tool:gen:remove', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    130. 

  130. INSERT INTO `sys_menu` VALUES (1060, '预览代码', 115, 4, '#', '', 'F', '0', '1', 'tool:gen:preview', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    131. 

  131. INSERT INTO `sys_menu` VALUES (1061, '生成代码', 115, 5, '#', '', 'F', '0', '1', 'tool:gen:code', '#', 'admin', '2026-05-25 09:14:28', '', NULL, '');
    132. 

  132. INSERT INTO `sys_menu` VALUES (2000, '商谈管理', 0, 1, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-address-book', 'admin', '2026-05-25 10:42:11', '', NULL, '');
    133. 

  133. INSERT INTO `sys_menu` VALUES (2001, '客户管理', 0, 2, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-address-book-o', 'admin', '2026-05-25 10:42:42', '', NULL, '');
    134. 

  134. INSERT INTO `sys_menu` VALUES (2002, '知识库管理', 0, 3, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-address-card', 'admin', '2026-05-25 10:43:06', '', NULL, '');
    135. 

  135. INSERT INTO `sys_menu` VALUES (2003, '问题库管理', 0, 4, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-address-card-o', 'admin', '2026-05-25 10:43:29', '', NULL, '');
    136. 

  136. INSERT INTO `sys_menu` VALUES (2004, '计划管理', 0, 5, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-adjust', 'admin', '2026-05-25 10:43:47', '', NULL, '');
    137. 

  137. INSERT INTO `sys_menu` VALUES (2005, '消息管理', 0, 6, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-adjust', 'admin', '2026-05-25 10:44:00', '', NULL, '');
    138. 

  138. INSERT INTO `sys_menu` VALUES (2006, '语音管理', 0, 7, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-american-sign-language-interpreting', 'admin', '2026-05-25 10:44:15', '', NULL, '');
    139. 

  139. INSERT INTO `sys_menu` VALUES (2007, '报表管理', 0, 8, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-anchor', 'admin', '2026-05-25 10:44:30', '', NULL, '');
    140. 

  140. INSERT INTO `sys_menu` VALUES (2008, '个人中心', 0, 9, '#', 'menuItem', 'M', '0', '1', NULL, 'fa fa-archive', 'admin', '2026-05-25 10:44:57', '', NULL, '');
    141. 

  141. INSERT INTO `sys_menu` VALUES (2009, '商谈中心', 2000, 1, '/system/call', 'menuItem', 'C', '0', '1', 'system:call:view', '#', 'admin', '2026-05-25 11:02:04', '', NULL, '');
    142. 

  142. INSERT INTO `sys_menu` VALUES (2010, '销售网点查询', 2000, 2, '/system/branch', 'menuItem', 'C', '0', '1', 'system:branch:view', '#', 'admin', '2026-05-25 11:03:59', '', NULL, '');
    143. 

  143. INSERT INTO `sys_menu` VALUES (2011, '邮政编码管理', 2000, 3, '/system/mail', 'menuItem', 'C', '0', '1', 'system:mail:view', '#', 'admin', '2026-05-25 11:07:16', '', NULL, '');
    144. 

  144. INSERT INTO `sys_menu` VALUES (2012, '商谈类型项', 2000, 4, '/system/calltype', 'menuItem', 'C', '0', '1', 'system:calltype:view', '#', 'admin', '2026-05-25 11:09:40', '', NULL, '');
    145. 

  145. INSERT INTO `sys_menu` VALUES (2013, '客户信息', 2001, 1, '/system/client', 'menuItem', 'C', '0', '1', 'system:client:view', '#', 'admin', '2026-05-25 11:13:00', '', NULL, '');
    146. 

  146. INSERT INTO `sys_menu` VALUES (2014, '导入客户信息', 2001, 2, '/system/intoclient', 'menuItem', 'C', '0', '1', 'system:intoclient:view', '#', 'admin', '2026-05-25 11:14:53', '', NULL, '');
    147. 

  147. INSERT INTO `sys_menu` VALUES (2015, '知识库分类', 2002, 1, '/system/knowledgetype', 'menuItem', 'C', '0', '1', 'system:knowledgetype:view', '#', 'admin', '2026-05-25 11:17:56', '', NULL, '');
    148. 

  148. INSERT INTO `sys_menu` VALUES (2016, '知识库信息', 2002, 2, '/system/knowledgeinfo', 'menuItem', 'C', '0', '1', 'system:knowledgeinfo:view', '#', 'admin', '2026-05-25 11:18:55', '', NULL, '');
    149. 

  149. INSERT INTO `sys_menu` VALUES (2017, '知识库查询', 2002, 3, '/system/knowledgequery', 'menuItem', 'C', '0', '1', 'system:knowledgequery:view', '#', 'admin', '2026-05-25 11:24:23', '', NULL, '');
    150. 

  150. INSERT INTO `sys_menu` VALUES (2018, '问题库分类', 2003, 1, '/system/questiontype', 'menuItem', 'C', '0', '1', 'system:questiontype:view', '#', 'admin', '2026-05-25 11:26:57', '', NULL, '');
    151. 

  151. INSERT INTO `sys_menu` VALUES (2019, '我的问题', 2003, 2, '/system/myquestion', 'menuItem', 'C', '0', '1', 'system:myquestion:view', '#', 'admin', '2026-05-25 11:29:04', '', NULL, '');
    152. 

  152. INSERT INTO `sys_menu` VALUES (2020, '待解决问题', 2003, 3, '/system/undoques', 'menuItem', 'C', '0', '1', 'system:undoques:view', '#', 'admin', '2026-05-25 11:36:12', '', NULL, '');
    153. 

  153. INSERT INTO `sys_menu` VALUES (2021, '已解决问题', 2003, 4, '/sytem/doneques', 'menuItem', 'C', '0', '1', 'system:doneques:view', '#', 'admin', '2026-05-25 11:39:12', '', NULL, '');
    154. 

  154. INSERT INTO `sys_menu` VALUES (2022, '我的日历', 2004, 1, '/system/calendar', 'menuItem', 'C', '0', '1', 'system:calendar:view', '#', 'admin', '2026-05-25 11:40:45', '', NULL, '');
    155. 

  155. INSERT INTO `sys_menu` VALUES (2023, '内部公告', 2005, 1, '/system/notice', 'menuItem', 'C', '0', '1', 'system:notice:view', '#', 'admin', '2026-05-25 11:42:53', '', NULL, '');
    156. 

  156. INSERT INTO `sys_menu` VALUES (2024, '语音留言', 2006, 1, '/system/voice', 'menuItem', 'C', '0', '1', 'system:voice:view', '#', 'admin', '2026-05-25 11:44:37', '', NULL, '');
    157. 

  157. INSERT INTO `sys_menu` VALUES (2025, '来电内容', 2007, 1, '/system/callcontent', 'menuItem', 'C', '0', '1', 'system:callcontent:view', '#', 'admin', '2026-05-25 11:47:33', '', NULL, '');
    158. 

  158. INSERT INTO `sys_menu` VALUES (2026, '来电地区', 2007, 2, '/system/callarea', 'menuItem', 'C', '0', '1', 'system:callarea:view', '#', 'admin', '2026-05-25 11:49:42', '', NULL, '');
    159. 

  159. INSERT INTO `sys_menu` VALUES (2027, '咨询内容', 2007, 3, '/system/consultcontent', 'menuItem', 'C', '0', '1', 'system:consultcontent:view', '#', 'admin', '2026-05-25 11:53:46', 'admin', '2026-05-25 11:54:00', '');
    160. 

  160. INSERT INTO `sys_menu` VALUES (2028, '咨询内容明细', 2007, 4, '/system/consultcontentdetail', 'menuItem', 'C', '0', '1', 'system:consultcontentdetail:view', '#', 'admin', '2026-05-25 11:54:49', '', NULL, '');
    161. 

  161. INSERT INTO `sys_menu` VALUES (2029, '施肥技术', 2007, 5, '/system/fertilize', 'menuItem', 'C', '0', '1', 'system:fertilize:view', '#', 'admin', '2026-05-25 11:56:48', 'admin', '2026-05-25 11:57:01', '');
    162. 

  162. INSERT INTO `sys_menu` VALUES (2030, '信件内容', 2007, 6, '/system/letter', 'menuItem', 'C', '0', '1', 'system:letter:view', '#', 'admin', '2026-05-25 11:58:37', '', NULL, '');
    163. 

  163. INSERT INTO `sys_menu` VALUES (2031, '信件地区', 2007, 7, '/system/letterarea', 'menuItem', 'C', '0', '1', 'system:letterarea:view', '#', 'admin', '2026-05-25 11:59:54', '', NULL, '');
    164. 

  164. 

  165. SET FOREIGN_KEY_CHECKS = 1;
    166.