cmc-coding
/
cmc-oa
ウォッチ 3
スター 0
フォーク 0
コード 課題 0 プルリクエスト 0 リリース 0 Wiki アクティビティ
综合办公系统
選択できるのは25トピックまでです。 トピックは、先頭が英数字で、英数字とダッシュ('-')を使用した35文字以内のものにしてください。
715 コミット
1 ブランチ
ブランチ: master
ブランチ タグ
${ item.name }
ブランチ ${ searchTerm } を作成
'master' から
${ noResults }
cmc-oa/oa-back/sql/sys_menu.sql

sys_menu.sql 59KB
パーマリンク 履歴 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545 
  1. /*

  2.  Navicat MySQL Data Transfer

  3. 

  4.  Source Server         : database

  5.  Source Server Type    : MySQL

  6.  Source Server Version : 50723

  7.  Source Host           : localhost:3306

  8.  Source Schema         : cmc_oa

  9. 

  10.  Target Server Type    : MySQL

  11.  Target Server Version : 50723

  12.  File Encoding         : 65001

  13. 

  14.  Date: 14/06/2024 09:47:56

  15. */

  16. 

  17. SET NAMES utf8mb4;

  18. SET FOREIGN_KEY_CHECKS = 0;

  19. 

  20. -- ----------------------------

  21. -- Table structure for sys_menu

  22. -- ----------------------------

  23. DROP TABLE IF EXISTS `sys_menu`;

  24. CREATE TABLE `sys_menu`  (

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

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

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

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

  29.   `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '路由地址',

  30.   `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件路径',

  31.   `query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由参数',

  32.   `is_frame` int(1) NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）',

  33.   `is_cache` int(1) NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',

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

  35.   `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',

  36.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',

  37.   `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识',

  38.   `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标',

  39.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',

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

  41.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',

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

  43.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',

  44.   PRIMARY KEY (`menu_id`) USING BTREE

  45. ) ENGINE = InnoDB AUTO_INCREMENT = 2051 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;

  46. 

  47. -- ----------------------------

  48. -- Records of sys_menu

  49. -- ----------------------------

  50. INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 6, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:35:17', '系统管理目录');

  51. INSERT INTO `sys_menu` VALUES (2, '系统监控', 0, 5, 'monitor', NULL, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:35:29', '系统监控目录');

  52. INSERT INTO `sys_menu` VALUES (3, '系统工具', 0, 7, 'tool', NULL, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:35:52', '系统工具目录');

  53. INSERT INTO `sys_menu` VALUES (4, '人事管理', 2048, 4, 'staff', NULL, '', 1, 0, 'M', '0', '0', '', 'user', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:24:54', '人事管理菜单');

  54. INSERT INTO `sys_menu` VALUES (5, '设备管理', 2048, 5, 'device', NULL, '', 1, 0, 'M', '0', '0', '', 'equipment', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:25:16', '设备管理菜单');

  55. INSERT INTO `sys_menu` VALUES (6, '车辆管理', 2048, 6, 'car', NULL, '', 1, 0, 'M', '0', '0', '', 'car', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:25:26', '车辆管理菜单');

  56. INSERT INTO `sys_menu` VALUES (7, '合同管理', 2049, 22, 'contract', NULL, '', 1, 0, 'M', '0', '0', '', 'documentation', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:38:39', '合同管理菜单');

  57. INSERT INTO `sys_menu` VALUES (8, '保证金管理', 2049, 23, 'deposit', NULL, '', 1, 0, 'M', '0', '0', '', 'cost', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:38:46', '保证金管理菜单');

  58. INSERT INTO `sys_menu` VALUES (9, '产值结算', 2050, 13, 'settle', NULL, '', 1, 0, 'M', '0', '0', '', 'money', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:37:20', '产值结算菜单');

  59. INSERT INTO `sys_menu` VALUES (10, '资料成果', 2050, 12, 'archive', NULL, '', 1, 0, 'M', '0', '0', '', 'education', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:37:16', '产值结算菜单');

  60. INSERT INTO `sys_menu` VALUES (11, '投标管理', 2049, 21, 'tender', 'oa/tender/index', '', 1, 0, 'C', '0', '0', 'oa:tender:list', 'guide', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:38:30', '投标管理菜单');

  61. INSERT INTO `sys_menu` VALUES (12, '合作单位', 2049, 24, 'partner', 'oa/partner/index', '', 1, 0, 'C', '0', '0', 'oa:partner:list', 'titles', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:38:53', '合作单位管理菜单');

  62. INSERT INTO `sys_menu` VALUES (13, '品牌项目台账', 2050, 9, 'brand', 'oa/brand/brandProject', '', 1, 0, 'C', '0', '0', 'oa:brand:list', 'Branding', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:36:38', '品牌项目台账菜单');

  63. INSERT INTO `sys_menu` VALUES (14, '测绘项目台账', 2050, 8, 'project', 'oa/project/index', '', 1, 0, 'C', '0', '0', 'oa:project:list', 'project', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:36:24', '测绘项目台账菜单');

  64. INSERT INTO `sys_menu` VALUES (15, '预算管理', 2050, 10, 'budget', 'oa/budget/index', '', 1, 0, 'C', '0', '0', 'oa:budget:list', 'build', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:36:52', '预算管理菜单');

  65. INSERT INTO `sys_menu` VALUES (16, '借款管理', 2050, 11, 'borrow', 'oa/borrow/index', '', 1, 0, 'C', '0', '0', 'oa:borrow:list', 'money', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:37:06', '借款管理菜单');

  66. INSERT INTO `sys_menu` VALUES (17, '安全交底', 2050, 14, 'safe', 'oa/safe/index', '', 1, 0, 'C', '0', '0', 'oa:safe:list', 'validCode', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:37:29', '安全交底菜单');

  67. INSERT INTO `sys_menu` VALUES (18, '技术方案', 2050, 15, 'technical', 'oa/technical/index', '', 1, 0, 'C', '0', '0', 'oa:technical:list', 'nested', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:37:34', '技术方案菜单');

  68. INSERT INTO `sys_menu` VALUES (19, '考核管理', 0, 4, 'assess', 'oa/assess/index', '', 1, 0, 'C', '0', '0', 'oa:assess:list', 'logininfor', 'admin', '2024-06-14 08:55:07', 'admin', '2024-06-14 09:35:42', '考核管理菜单');

  69. INSERT INTO `sys_menu` VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2024-06-14 08:55:07', '', NULL, '用户管理菜单');

  70. INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2024-06-14 08:55:07', '', NULL, '角色管理菜单');

  71. INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2024-06-14 08:55:07', '', NULL, '菜单管理菜单');

  72. INSERT INTO `sys_menu` VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2024-06-14 08:55:07', '', NULL, '部门管理菜单');

  73. INSERT INTO `sys_menu` VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2024-06-14 08:55:07', '', NULL, '岗位管理菜单');

  74. INSERT INTO `sys_menu` VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2024-06-14 08:55:07', '', NULL, '字典管理菜单');

  75. INSERT INTO `sys_menu` VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2024-06-14 08:55:07', '', NULL, '参数设置菜单');

  76. INSERT INTO `sys_menu` VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2024-06-14 08:55:07', '', NULL, '通知公告菜单');

  77. INSERT INTO `sys_menu` VALUES (108, '日志管理', 1, 9, 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', '2024-06-14 08:55:07', '', NULL, '日志管理菜单');

  78. INSERT INTO `sys_menu` VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2024-06-14 08:55:07', '', NULL, '在线用户菜单');

  79. INSERT INTO `sys_menu` VALUES (110, '定时任务', 2, 2, 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2024-06-14 08:55:07', '', NULL, '定时任务菜单');

  80. INSERT INTO `sys_menu` VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2024-06-14 08:55:07', '', NULL, '数据监控菜单');

  81. INSERT INTO `sys_menu` VALUES (112, '服务监控', 2, 4, 'server', 'monitor/server/index', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2024-06-14 08:55:07', '', NULL, '服务监控菜单');

  82. INSERT INTO `sys_menu` VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2024-06-14 08:55:07', '', NULL, '缓存监控菜单');

  83. INSERT INTO `sys_menu` VALUES (114, '缓存列表', 2, 6, 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', '2024-06-14 08:55:07', '', NULL, '缓存列表菜单');

  84. INSERT INTO `sys_menu` VALUES (115, '表单构建', 3, 1, 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2024-06-14 08:55:07', '', NULL, '表单构建菜单');

  85. INSERT INTO `sys_menu` VALUES (116, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2024-06-14 08:55:07', '', NULL, '代码生成菜单');

  86. INSERT INTO `sys_menu` VALUES (117, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2024-06-14 08:55:07', '', NULL, '系统接口菜单');

  87. INSERT INTO `sys_menu` VALUES (118, '人员信息', 4, 1, 'people', 'oa/staff/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'peoples', 'admin', '2024-06-14 08:55:07', '', NULL, '人员信息菜单');

  88. INSERT INTO `sys_menu` VALUES (119, '岗位工资', 4, 2, 'salary', 'oa/staff/salary', '', 1, 0, 'C', '0', '0', 'oa:salary:list', 'cost', 'admin', '2024-06-14 08:55:07', '', NULL, '岗位工资菜单');

  89. INSERT INTO `sys_menu` VALUES (120, '仪器设备', 5, 1, 'equipment', 'oa/device/index', '', 1, 0, 'C', '0', '0', 'oa:device:list', 'component', 'admin', '2024-06-14 08:55:07', '', NULL, '仪器设备菜单');

  90. INSERT INTO `sys_menu` VALUES (121, '办公设备', 5, 2, 'supply', 'oa/supply/index', '', 1, 0, 'C', '0', '0', 'oa:supply:list', 'desktop', 'admin', '2024-06-14 08:55:07', '', NULL, '办公设备菜单');

  91. INSERT INTO `sys_menu` VALUES (122, '申领记录', 5, 3, 'approval', 'oa/device/approval', '', 1, 0, 'C', '0', '0', 'oa:deviceApproval:list', 'form', 'admin', '2024-06-14 08:55:07', '', NULL, '申领记录菜单');

  92. INSERT INTO `sys_menu` VALUES (123, '维保检定', 5, 4, 'expense', 'oa/device/expense', '', 1, 0, 'C', '0', '0', 'oa:deviceExpense:list', 'flower', 'admin', '2024-06-14 08:55:07', '', NULL, '维保检定菜单');

  93. INSERT INTO `sys_menu` VALUES (124, '移交记录', 5, 5, 'handover', 'oa/supply/handover', '', 1, 0, 'C', '0', '0', 'oa:deviceHandover:list', 'pass', 'admin', '2024-06-14 08:55:07', '', NULL, '移交记录菜单');

  94. INSERT INTO `sys_menu` VALUES (125, '设备报废', 5, 6, 'scrap', 'oa/device/scrap', '', 1, 0, 'C', '0', '0', 'oa:deviceScrap:list', 'delete', 'admin', '2024-06-14 08:55:07', '', NULL, '设备报废菜单');

  95. INSERT INTO `sys_menu` VALUES (126, '车辆信息', 6, 1, 'index', 'oa/car/index', '', 1, 0, 'C', '0', '0', 'oa:car:list', 'car', 'admin', '2024-06-14 08:55:07', '', NULL, '车辆信息菜单');

  96. INSERT INTO `sys_menu` VALUES (127, '用车记录', 6, 2, 'approval', 'oa/car/approval', '', 1, 0, 'C', '0', '0', 'oa:carApproval:list', 'form', 'admin', '2024-06-14 08:55:07', '', NULL, '用车记录菜单');

  97. INSERT INTO `sys_menu` VALUES (128, '维保记录', 6, 3, 'expense', 'oa/car/expense', '', 1, 0, 'C', '0', '0', 'oa:carExpense:list', 'flower', 'admin', '2024-06-14 08:55:07', '', NULL, '维保记录菜单');

  98. INSERT INTO `sys_menu` VALUES (129, '车辆报废', 6, 4, 'scrap', 'oa/car/scrap', '', 1, 0, 'C', '0', '0', 'oa:deviceScrap:list', 'delete', 'admin', '2024-06-14 08:55:07', '', NULL, '车辆报废菜单');

  99. INSERT INTO `sys_menu` VALUES (130, '承接合同', 7, 1, 'contract', 'oa/contract/index', '', 1, 0, 'C', '0', '0', 'oa:contract:list', 'documentation', 'admin', '2024-06-14 08:55:07', '', NULL, '承包合同菜单');

  100. INSERT INTO `sys_menu` VALUES (131, '分包合同', 7, 2, 'subContract', 'oa/contract/subContract', '', 1, 0, 'C', '0', '0', 'oa:subContract:list', 'documentation', 'admin', '2024-06-14 08:55:07', '', NULL, '分包合同菜单');

  101. INSERT INTO `sys_menu` VALUES (132, '投标保证金', 8, 1, 'tender', 'oa/deposit/index', '', 1, 0, 'C', '0', '0', 'oa:deposit:list', 'cost', 'admin', '2024-06-14 08:55:07', '', NULL, '投标保证金菜单');

  102. INSERT INTO `sys_menu` VALUES (133, '合同保证金', 8, 2, 'contract', 'oa/deposit/index', '', 1, 0, 'C', '0', '0', 'oa:deposit:list', 'cost', 'admin', '2024-06-14 08:55:07', '', NULL, '合同保证金菜单');

  103. INSERT INTO `sys_menu` VALUES (134, '结算管理', 9, 1, 'settle', 'oa/settle/index', '', 1, 0, 'C', '0', '0', 'oa:settle:list', 'money', 'admin', '2024-06-14 08:55:07', '', NULL, '结算管理菜单');

  104. INSERT INTO `sys_menu` VALUES (135, '结算单价', 9, 2, 'price', 'oa/price/index', '', 1, 0, 'C', '0', '0', 'oa:price:list', 'money', 'admin', '2024-06-14 08:55:07', '', NULL, '结算单价菜单');

  105. INSERT INTO `sys_menu` VALUES (136, '成果归档', 10, 1, 'archive', 'oa/archive/index', '', 1, 0, 'C', '0', '0', 'oa:archive:list', 'education', 'admin', '2024-06-14 08:55:07', '', NULL, '成果归档菜单');

  106. INSERT INTO `sys_menu` VALUES (137, '资料管理', 10, 2, 'file', 'file/filesProject/index', '', 1, 0, 'C', '0', '0', 'oa:archive:list', 'education', 'admin', '2024-06-14 08:55:07', '', NULL, '资料管理菜单');

  107. INSERT INTO `sys_menu` VALUES (138, '一张图', 10, 3, 'gis', 'file/index', '', 1, 0, 'C', '0', '0', '', 'international', 'admin', '2024-06-14 08:55:07', '', NULL, '一张图菜单');

  108. INSERT INTO `sys_menu` VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2024-06-14 08:55:07', '', NULL, '操作日志菜单');

  109. INSERT INTO `sys_menu` VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2024-06-14 08:55:07', '', NULL, '登录日志菜单');

  110. INSERT INTO `sys_menu` VALUES (1000, '用户列表', 100, 0, '', '', '', 1, 0, 'F', '0', '0', 'system:user:list', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  111. INSERT INTO `sys_menu` VALUES (1001, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  112. INSERT INTO `sys_menu` VALUES (1002, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  113. INSERT INTO `sys_menu` VALUES (1003, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  114. INSERT INTO `sys_menu` VALUES (1004, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  115. INSERT INTO `sys_menu` VALUES (1005, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  116. INSERT INTO `sys_menu` VALUES (1006, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  117. INSERT INTO `sys_menu` VALUES (1007, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  118. INSERT INTO `sys_menu` VALUES (1008, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  119. INSERT INTO `sys_menu` VALUES (1009, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  120. INSERT INTO `sys_menu` VALUES (1010, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  121. INSERT INTO `sys_menu` VALUES (1011, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  122. INSERT INTO `sys_menu` VALUES (1012, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  123. INSERT INTO `sys_menu` VALUES (1013, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  124. INSERT INTO `sys_menu` VALUES (1014, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  125. INSERT INTO `sys_menu` VALUES (1015, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  126. INSERT INTO `sys_menu` VALUES (1016, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  127. INSERT INTO `sys_menu` VALUES (1017, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:list', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  128. INSERT INTO `sys_menu` VALUES (1018, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  129. INSERT INTO `sys_menu` VALUES (1019, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  130. INSERT INTO `sys_menu` VALUES (1020, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  131. INSERT INTO `sys_menu` VALUES (1021, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  132. INSERT INTO `sys_menu` VALUES (1022, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  133. INSERT INTO `sys_menu` VALUES (1023, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  134. INSERT INTO `sys_menu` VALUES (1024, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  135. INSERT INTO `sys_menu` VALUES (1025, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  136. INSERT INTO `sys_menu` VALUES (1026, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  137. INSERT INTO `sys_menu` VALUES (1027, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  138. INSERT INTO `sys_menu` VALUES (1028, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  139. INSERT INTO `sys_menu` VALUES (1029, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  140. INSERT INTO `sys_menu` VALUES (1030, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  141. INSERT INTO `sys_menu` VALUES (1031, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  142. INSERT INTO `sys_menu` VALUES (1032, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  143. INSERT INTO `sys_menu` VALUES (1033, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  144. INSERT INTO `sys_menu` VALUES (1034, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  145. INSERT INTO `sys_menu` VALUES (1035, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  146. INSERT INTO `sys_menu` VALUES (1036, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  147. INSERT INTO `sys_menu` VALUES (1037, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  148. INSERT INTO `sys_menu` VALUES (1038, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  149. INSERT INTO `sys_menu` VALUES (1039, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  150. INSERT INTO `sys_menu` VALUES (1040, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  151. INSERT INTO `sys_menu` VALUES (1041, '操作查询', 500, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  152. INSERT INTO `sys_menu` VALUES (1042, '操作删除', 500, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  153. INSERT INTO `sys_menu` VALUES (1043, '日志导出', 500, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  154. INSERT INTO `sys_menu` VALUES (1044, '登录查询', 501, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  155. INSERT INTO `sys_menu` VALUES (1045, '登录删除', 501, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  156. INSERT INTO `sys_menu` VALUES (1046, '日志导出', 501, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  157. INSERT INTO `sys_menu` VALUES (1047, '账户解锁', 501, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  158. INSERT INTO `sys_menu` VALUES (1048, '在线查询', 109, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  159. INSERT INTO `sys_menu` VALUES (1049, '批量强退', 109, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  160. INSERT INTO `sys_menu` VALUES (1050, '单条强退', 109, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  161. INSERT INTO `sys_menu` VALUES (1051, '任务查询', 110, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  162. INSERT INTO `sys_menu` VALUES (1052, '任务新增', 110, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  163. INSERT INTO `sys_menu` VALUES (1053, '任务修改', 110, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  164. INSERT INTO `sys_menu` VALUES (1054, '任务删除', 110, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  165. INSERT INTO `sys_menu` VALUES (1055, '状态修改', 110, 5, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  166. INSERT INTO `sys_menu` VALUES (1056, '任务导出', 110, 6, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  167. INSERT INTO `sys_menu` VALUES (1057, '生成查询', 116, 1, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  168. INSERT INTO `sys_menu` VALUES (1058, '生成修改', 116, 2, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  169. INSERT INTO `sys_menu` VALUES (1059, '生成删除', 116, 3, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  170. INSERT INTO `sys_menu` VALUES (1060, '导入代码', 116, 4, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  171. INSERT INTO `sys_menu` VALUES (1061, '预览代码', 116, 5, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  172. INSERT INTO `sys_menu` VALUES (1062, '生成代码', 116, 6, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  173. INSERT INTO `sys_menu` VALUES (1063, '工资查询', 119, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:salary:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  174. INSERT INTO `sys_menu` VALUES (1064, '工资新增', 119, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:salary:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  175. INSERT INTO `sys_menu` VALUES (1065, '工资修改', 119, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:salary:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  176. INSERT INTO `sys_menu` VALUES (1066, '工资删除', 119, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:salary:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  177. INSERT INTO `sys_menu` VALUES (1067, '工资导出', 119, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:salary:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  178. INSERT INTO `sys_menu` VALUES (1068, '设备查询', 5, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:device:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  179. INSERT INTO `sys_menu` VALUES (1069, '设备新增', 5, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:device:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  180. INSERT INTO `sys_menu` VALUES (1070, '设备修改', 5, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:device:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  181. INSERT INTO `sys_menu` VALUES (1071, '设备删除', 5, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:device:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  182. INSERT INTO `sys_menu` VALUES (1072, '设备导出', 5, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:device:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  183. INSERT INTO `sys_menu` VALUES (1073, '记录查询', 5, 3, '#', '', '', 1, 0, 'F', '0', '0', 'device:record:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  184. INSERT INTO `sys_menu` VALUES (1074, '记录新增', 5, 4, '#', '', '', 1, 0, 'F', '0', '0', 'device:record:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  185. INSERT INTO `sys_menu` VALUES (1075, '记录修改', 5, 5, '#', '', '', 1, 0, 'F', '0', '0', 'device:record:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  186. INSERT INTO `sys_menu` VALUES (1076, '记录删除', 5, 6, '#', '', '', 1, 0, 'F', '0', '0', 'device:record:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  187. INSERT INTO `sys_menu` VALUES (1077, '记录导出', 5, 7, '#', '', '', 1, 0, 'F', '0', '0', 'device:record:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  188. INSERT INTO `sys_menu` VALUES (1078, '车辆查询', 6, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:car:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  189. INSERT INTO `sys_menu` VALUES (1079, '车辆新增', 6, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:car:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  190. INSERT INTO `sys_menu` VALUES (1080, '车辆修改', 6, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:car:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  191. INSERT INTO `sys_menu` VALUES (1081, '车辆删除', 6, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:car:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  192. INSERT INTO `sys_menu` VALUES (1082, '车辆导出', 6, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:car:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  193. INSERT INTO `sys_menu` VALUES (1083, '记录查询', 6, 6, '#', '', '', 1, 0, 'F', '0', '0', 'car:record:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  194. INSERT INTO `sys_menu` VALUES (1084, '记录新增', 6, 7, '#', '', '', 1, 0, 'F', '0', '0', 'car:record:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  195. INSERT INTO `sys_menu` VALUES (1085, '记录修改', 6, 8, '#', '', '', 1, 0, 'F', '0', '0', 'car:record:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  196. INSERT INTO `sys_menu` VALUES (1086, '记录删除', 6, 9, '#', '', '', 1, 0, 'F', '0', '0', 'car:record:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  197. INSERT INTO `sys_menu` VALUES (1087, '记录导出', 6, 10, '#', '', '', 1, 0, 'F', '0', '0', 'car:record:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  198. INSERT INTO `sys_menu` VALUES (1088, '承包合同查询', 130, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:contract:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  199. INSERT INTO `sys_menu` VALUES (1089, '承包合同新增', 130, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:contract:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  200. INSERT INTO `sys_menu` VALUES (1090, '承包合同修改', 130, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:contract:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  201. INSERT INTO `sys_menu` VALUES (1091, '承包合同删除', 130, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:contract:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  202. INSERT INTO `sys_menu` VALUES (1092, '承包合同导出', 130, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:contract:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  203. INSERT INTO `sys_menu` VALUES (1093, '分包合同查询', 131, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:subContract:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  204. INSERT INTO `sys_menu` VALUES (1094, '分包合同新增', 131, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:subContract:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  205. INSERT INTO `sys_menu` VALUES (1095, '分包合同修改', 131, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:subContract:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  206. INSERT INTO `sys_menu` VALUES (1096, '分包合同删除', 131, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:subContract:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  207. INSERT INTO `sys_menu` VALUES (1097, '分包合同导出', 131, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:subContract:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  208. INSERT INTO `sys_menu` VALUES (1098, '保证金查询', 8, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:deposit:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  209. INSERT INTO `sys_menu` VALUES (1099, '保证金新增', 8, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:deposit:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  210. INSERT INTO `sys_menu` VALUES (1100, '保证金修改', 8, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:deposit:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  211. INSERT INTO `sys_menu` VALUES (1101, '保证金删除', 8, 6, '#', '', '', 1, 0, 'F', '0', '0', 'oa:deposit:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  212. INSERT INTO `sys_menu` VALUES (1102, '保证金导出', 8, 7, '#', '', '', 1, 0, 'F', '0', '0', 'oa:deposit:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  213. INSERT INTO `sys_menu` VALUES (1103, '投标查询', 11, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:tender:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  214. INSERT INTO `sys_menu` VALUES (1104, '投标新增', 11, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:tender:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  215. INSERT INTO `sys_menu` VALUES (1105, '投标修改', 11, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:tender:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  216. INSERT INTO `sys_menu` VALUES (1106, '投标删除', 11, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:tender:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  217. INSERT INTO `sys_menu` VALUES (1107, '投标导出', 11, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:tender:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  218. INSERT INTO `sys_menu` VALUES (1108, '合作单位查询', 12, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:partner:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  219. INSERT INTO `sys_menu` VALUES (1109, '合作单位新增', 12, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:partner:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  220. INSERT INTO `sys_menu` VALUES (1110, '合作单位修改', 12, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:partner:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  221. INSERT INTO `sys_menu` VALUES (1111, '合作单位删除', 12, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:partner:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  222. INSERT INTO `sys_menu` VALUES (1112, '合作单位导出', 12, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:partner:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  223. INSERT INTO `sys_menu` VALUES (1113, '品牌项目查询', 13, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:brandProject:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  224. INSERT INTO `sys_menu` VALUES (1114, '品牌项目新增', 13, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:brandProject:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  225. INSERT INTO `sys_menu` VALUES (1115, '品牌项目修改', 13, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:brandProject:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  226. INSERT INTO `sys_menu` VALUES (1116, '品牌项目删除', 13, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:brandProject:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  227. INSERT INTO `sys_menu` VALUES (1117, '品牌项目导出', 13, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:brandProject:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  228. INSERT INTO `sys_menu` VALUES (1118, '项目查询', 14, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:project:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  229. INSERT INTO `sys_menu` VALUES (1119, '项目新增', 14, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:project:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  230. INSERT INTO `sys_menu` VALUES (1120, '项目修改', 14, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:project:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  231. INSERT INTO `sys_menu` VALUES (1121, '项目删除', 14, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:project:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  232. INSERT INTO `sys_menu` VALUES (1122, '项目导出', 14, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:project:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  233. INSERT INTO `sys_menu` VALUES (1123, '结算查询', 134, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:settle:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  234. INSERT INTO `sys_menu` VALUES (1124, '结算新增', 134, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:settle:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  235. INSERT INTO `sys_menu` VALUES (1125, '结算修改', 134, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:settle:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  236. INSERT INTO `sys_menu` VALUES (1126, '结算删除', 134, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:settle:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  237. INSERT INTO `sys_menu` VALUES (1127, '结算导出', 134, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:settle:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  238. INSERT INTO `sys_menu` VALUES (1128, '单价查询', 135, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  239. INSERT INTO `sys_menu` VALUES (1129, '单价新增', 135, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  240. INSERT INTO `sys_menu` VALUES (1130, '单价修改', 135, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  241. INSERT INTO `sys_menu` VALUES (1131, '单价删除', 135, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  242. INSERT INTO `sys_menu` VALUES (1132, '单价导出', 135, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  243. INSERT INTO `sys_menu` VALUES (1133, '归档查询', 136, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:archive:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  244. INSERT INTO `sys_menu` VALUES (1134, '归档新增', 136, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:archive:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  245. INSERT INTO `sys_menu` VALUES (1135, '归档修改', 136, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:archive:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  246. INSERT INTO `sys_menu` VALUES (1136, '归档删除', 136, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:archive:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  247. INSERT INTO `sys_menu` VALUES (1137, '归档导出', 136, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:archive:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  248. INSERT INTO `sys_menu` VALUES (1138, '资料查询', 137, 1, '#', '', '', 1, 0, 'F', '0', '0', 'file:achievement:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  249. INSERT INTO `sys_menu` VALUES (1139, '资料新增', 137, 2, '#', '', '', 1, 0, 'F', '0', '0', 'file:achievement:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  250. INSERT INTO `sys_menu` VALUES (1140, '资料修改', 137, 3, '#', '', '', 1, 0, 'F', '0', '0', 'file:achievement:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  251. INSERT INTO `sys_menu` VALUES (1141, '资料删除', 137, 4, '#', '', '', 1, 0, 'F', '0', '0', 'file:achievement:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  252. INSERT INTO `sys_menu` VALUES (1142, '资料导出', 137, 5, '#', '', '', 1, 0, 'F', '0', '0', 'file:achievement:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  253. INSERT INTO `sys_menu` VALUES (1143, '预算查询', 15, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  254. INSERT INTO `sys_menu` VALUES (1144, '预算新增', 15, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  255. INSERT INTO `sys_menu` VALUES (1145, '预算修改', 15, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  256. INSERT INTO `sys_menu` VALUES (1146, '预算删除', 15, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  257. INSERT INTO `sys_menu` VALUES (1147, '预算导出', 15, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:price:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  258. INSERT INTO `sys_menu` VALUES (1148, '借款查询', 16, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:borrow:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  259. INSERT INTO `sys_menu` VALUES (1149, '借款新增', 16, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:borrow:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  260. INSERT INTO `sys_menu` VALUES (1150, '借款修改', 16, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:borrow:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  261. INSERT INTO `sys_menu` VALUES (1151, '借款删除', 16, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:borrow:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  262. INSERT INTO `sys_menu` VALUES (1152, '借款导出', 16, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:borrow:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  263. INSERT INTO `sys_menu` VALUES (1153, '交底查询', 17, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:safe:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  264. INSERT INTO `sys_menu` VALUES (1154, '交底新增', 17, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:safe:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  265. INSERT INTO `sys_menu` VALUES (1155, '交底修改', 17, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:safe:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  266. INSERT INTO `sys_menu` VALUES (1156, '交底删除', 17, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:safe:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  267. INSERT INTO `sys_menu` VALUES (1157, '交底导出', 17, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:safe:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  268. INSERT INTO `sys_menu` VALUES (1158, '方案查询', 18, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:technical:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  269. INSERT INTO `sys_menu` VALUES (1159, '方案新增', 18, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:technical:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  270. INSERT INTO `sys_menu` VALUES (1160, '方案修改', 18, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:technical:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  271. INSERT INTO `sys_menu` VALUES (1161, '方案删除', 18, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:technical:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  272. INSERT INTO `sys_menu` VALUES (1162, '方案导出', 18, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:technical:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  273. INSERT INTO `sys_menu` VALUES (1163, '考核查询', 19, 1, '#', '', '', 1, 0, 'F', '0', '0', 'oa:assess:query', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  274. INSERT INTO `sys_menu` VALUES (1164, '考核新增', 19, 2, '#', '', '', 1, 0, 'F', '0', '0', 'oa:assess:add', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  275. INSERT INTO `sys_menu` VALUES (1165, '考核修改', 19, 3, '#', '', '', 1, 0, 'F', '0', '0', 'oa:assess:edit', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  276. INSERT INTO `sys_menu` VALUES (1166, '考核删除', 19, 4, '#', '', '', 1, 0, 'F', '0', '0', 'oa:assess:remove', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  277. INSERT INTO `sys_menu` VALUES (1167, '考核导出', 19, 5, '#', '', '', 1, 0, 'F', '0', '0', 'oa:assess:export', '#', 'admin', '2024-06-14 08:55:07', '', NULL, '');

  278. INSERT INTO `sys_menu` VALUES (2021, '流程管理', 0, 8, 'flowable', NULL, NULL, 1, 0, 'M', '0', '0', '', 'cascader', 'tony', '2021-03-25 11:35:09', 'admin', '2024-06-14 09:36:05', '');

  279. INSERT INTO `sys_menu` VALUES (2022, '流程定义', 2021, 2, 'definition', 'flowable/definition/index', NULL, 1, 0, 'C', '0', '0', '', 'job', 'tony', '2021-03-25 13:53:55', 'admin', '2021-03-29 09:39:07', '');

  280. INSERT INTO `sys_menu` VALUES (2023, '任务管理', 0, 0, 'task', NULL, NULL, 1, 0, 'M', '0', '0', '', 'dict', 'tony', '2021-03-26 10:53:10', 'admin', '2024-06-14 09:19:52', '');

  281. INSERT INTO `sys_menu` VALUES (2024, '待办任务', 2023, 2, 'todo', 'flowable/task/todo/index', NULL, 1, 1, 'C', '0', '0', '', 'cascader', 'admin', '2021-03-26 10:55:52', 'admin', '2021-03-30 09:26:36', '');

  282. INSERT INTO `sys_menu` VALUES (2025, '已办任务', 2023, 3, 'finished', 'flowable/task/finished/index', NULL, 1, 1, 'C', '0', '0', '', 'time-range', 'admin', '2021-03-26 10:57:54', 'admin', '2021-03-30 09:26:50', '');

  283. INSERT INTO `sys_menu` VALUES (2026, '我的流程', 2023, 1, 'process', 'flowable/task/myProcess/index', NULL, 1, 1, 'C', '0', '0', '', 'guide', 'admin', '2021-03-30 09:26:23', 'admin', '2022-12-12 09:58:07', '');

  284. INSERT INTO `sys_menu` VALUES (2027, '表单配置', 2021, 2, 'form', 'flowable/task/form/index', NULL, 1, 0, 'C', '0', '0', 'flowable:form:list', 'form', 'admin', '2021-03-30 22:55:12', 'admin', '2021-04-03 18:50:54', '');

  285. INSERT INTO `sys_menu` VALUES (2028, '新增', 2027, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'flowable:form:add', '#', 'admin', '2021-07-07 14:23:37', '', NULL, '');

  286. INSERT INTO `sys_menu` VALUES (2029, '删除', 2027, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'flowable:form:remove', '#', 'admin', '2021-07-07 14:24:10', '', NULL, '');

  287. INSERT INTO `sys_menu` VALUES (2030, '编辑', 2027, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'flowable:form:edit', '#', 'admin', '2021-07-07 14:24:31', '', NULL, '');

  288. INSERT INTO `sys_menu` VALUES (2031, '新增', 2026, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:deployment:add', '#', 'admin', '2021-07-07 14:25:22', '', NULL, '');

  289. INSERT INTO `sys_menu` VALUES (2032, '编辑', 2026, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:deployment:edit', '#', 'admin', '2021-07-07 14:25:47', '', NULL, '');

  290. INSERT INTO `sys_menu` VALUES (2033, '删除', 2026, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:deployment:remove', '#', 'admin', '2021-07-07 14:26:02', '', NULL, '');

  291. INSERT INTO `sys_menu` VALUES (2034, '查询', 2027, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'flowable:form:query', '#', 'admin', '2021-07-08 14:05:22', '', NULL, '');

  292. INSERT INTO `sys_menu` VALUES (2035, '修改密码', 100, 8, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:updatePwd', '#', 'admin', '2022-04-29 11:27:13', '', NULL, '');

  293. INSERT INTO `sys_menu` VALUES (2036, '流程表达式', 2021, 3, 'expression', 'system/expression/index', NULL, 1, 1, 'C', '0', '0', 'system:expression:list', 'list', 'admin', '2022-12-12 17:12:19', 'admin', '2022-12-12 17:13:44', '流程达式菜单');

  294. INSERT INTO `sys_menu` VALUES (2037, '流程达式查询', 2036, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:expression:query', '#', 'admin', '2022-12-12 17:12:19', '', NULL, '');

  295. INSERT INTO `sys_menu` VALUES (2038, '流程达式新增', 2036, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:expression:add', '#', 'admin', '2022-12-12 17:12:19', '', NULL, '');

  296. INSERT INTO `sys_menu` VALUES (2039, '流程达式修改', 2036, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:expression:edit', '#', 'admin', '2022-12-12 17:12:19', '', NULL, '');

  297. INSERT INTO `sys_menu` VALUES (2040, '流程达式删除', 2036, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:expression:remove', '#', 'admin', '2022-12-12 17:12:19', '', NULL, '');

  298. INSERT INTO `sys_menu` VALUES (2041, '流程达式导出', 2036, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:expression:export', '#', 'admin', '2022-12-12 17:12:19', '', NULL, '');

  299. INSERT INTO `sys_menu` VALUES (2042, '流程监听', 2021, 1, 'listener', 'system/listener/index', NULL, 1, 0, 'C', '0', '0', 'system:listener:list', '#', 'admin', '2022-12-25 11:44:16', '', NULL, '流程监听菜单');

  300. INSERT INTO `sys_menu` VALUES (2043, '流程监听查询', 2042, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:listener:query', '#', 'admin', '2022-12-25 11:44:16', '', NULL, '');

  301. INSERT INTO `sys_menu` VALUES (2044, '流程监听新增', 2042, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:listener:add', '#', 'admin', '2022-12-25 11:44:16', '', NULL, '');

  302. INSERT INTO `sys_menu` VALUES (2045, '流程监听修改', 2042, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:listener:edit', '#', 'admin', '2022-12-25 11:44:16', '', NULL, '');

  303. INSERT INTO `sys_menu` VALUES (2046, '流程监听删除', 2042, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:listener:remove', '#', 'admin', '2022-12-25 11:44:16', '', NULL, '');

  304. INSERT INTO `sys_menu` VALUES (2047, '流程监听导出', 2042, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:listener:export', '#', 'admin', '2022-12-25 11:44:16', '', NULL, '');

  305. INSERT INTO `sys_menu` VALUES (2048, '办公管理', 0, 3, 'oa', NULL, NULL, 1, 0, 'M', '0', '0', '', 'component', 'admin', '2024-06-14 09:24:28', 'admin', '2024-06-14 09:35:05', '');

  306. INSERT INTO `sys_menu` VALUES (2049, '经营管理', 0, 2, 'business', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'cost', 'admin', '2024-06-14 09:27:00', '', NULL, '');

  307. INSERT INTO `sys_menu` VALUES (2050, '生产管理', 0, 1, 'product', NULL, NULL, 1, 0, 'M', '0', '0', '', 'date-range', 'admin', '2024-06-14 09:28:21', 'admin', '2024-06-14 09:34:59', '');

  308. 

  309. -- ----------------------------

  310. -- Table structure for sys_role_menu

  311. -- ----------------------------

  312. DROP TABLE IF EXISTS `sys_role_menu`;

  313. CREATE TABLE `sys_role_menu`  (

  314.   `role_id` bigint(20) NOT NULL COMMENT '角色ID',

  315.   `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',

  316.   PRIMARY KEY (`role_id`, `menu_id`) USING BTREE

  317. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;

  318. 

  319. -- ----------------------------

  320. -- Records of sys_role_menu

  321. -- ----------------------------

  322. INSERT INTO `sys_role_menu` VALUES (2, 5);

  323. INSERT INTO `sys_role_menu` VALUES (2, 6);

  324. INSERT INTO `sys_role_menu` VALUES (2, 14);

  325. INSERT INTO `sys_role_menu` VALUES (2, 100);

  326. INSERT INTO `sys_role_menu` VALUES (2, 103);

  327. INSERT INTO `sys_role_menu` VALUES (2, 122);

  328. INSERT INTO `sys_role_menu` VALUES (2, 1000);

  329. INSERT INTO `sys_role_menu` VALUES (2, 1001);

  330. INSERT INTO `sys_role_menu` VALUES (2, 1017);

  331. INSERT INTO `sys_role_menu` VALUES (2, 1018);

  332. INSERT INTO `sys_role_menu` VALUES (2, 1068);

  333. INSERT INTO `sys_role_menu` VALUES (2, 1078);

  334. INSERT INTO `sys_role_menu` VALUES (2, 1083);

  335. INSERT INTO `sys_role_menu` VALUES (2, 1118);

  336. INSERT INTO `sys_role_menu` VALUES (2, 2023);

  337. INSERT INTO `sys_role_menu` VALUES (2, 2024);

  338. INSERT INTO `sys_role_menu` VALUES (2, 2025);

  339. INSERT INTO `sys_role_menu` VALUES (2, 2026);

  340. INSERT INTO `sys_role_menu` VALUES (2, 2031);

  341. INSERT INTO `sys_role_menu` VALUES (2, 2032);

  342. INSERT INTO `sys_role_menu` VALUES (2, 2033);

  343. INSERT INTO `sys_role_menu` VALUES (2, 2048);

  344. INSERT INTO `sys_role_menu` VALUES (2, 2050);

  345. INSERT INTO `sys_role_menu` VALUES (3, 4);

  346. INSERT INTO `sys_role_menu` VALUES (3, 100);

  347. INSERT INTO `sys_role_menu` VALUES (3, 118);

  348. INSERT INTO `sys_role_menu` VALUES (3, 119);

  349. INSERT INTO `sys_role_menu` VALUES (3, 1002);

  350. INSERT INTO `sys_role_menu` VALUES (3, 1003);

  351. INSERT INTO `sys_role_menu` VALUES (3, 1004);

  352. INSERT INTO `sys_role_menu` VALUES (3, 1005);

  353. INSERT INTO `sys_role_menu` VALUES (3, 1006);

  354. INSERT INTO `sys_role_menu` VALUES (3, 1007);

  355. INSERT INTO `sys_role_menu` VALUES (3, 1063);

  356. INSERT INTO `sys_role_menu` VALUES (3, 1064);

  357. INSERT INTO `sys_role_menu` VALUES (3, 1065);

  358. INSERT INTO `sys_role_menu` VALUES (3, 1066);

  359. INSERT INTO `sys_role_menu` VALUES (3, 1067);

  360. INSERT INTO `sys_role_menu` VALUES (3, 2048);

  361. INSERT INTO `sys_role_menu` VALUES (4, 5);

  362. INSERT INTO `sys_role_menu` VALUES (4, 120);

  363. INSERT INTO `sys_role_menu` VALUES (4, 121);

  364. INSERT INTO `sys_role_menu` VALUES (4, 122);

  365. INSERT INTO `sys_role_menu` VALUES (4, 123);

  366. INSERT INTO `sys_role_menu` VALUES (4, 124);

  367. INSERT INTO `sys_role_menu` VALUES (4, 125);

  368. INSERT INTO `sys_role_menu` VALUES (4, 1068);

  369. INSERT INTO `sys_role_menu` VALUES (4, 1069);

  370. INSERT INTO `sys_role_menu` VALUES (4, 1070);

  371. INSERT INTO `sys_role_menu` VALUES (4, 1071);

  372. INSERT INTO `sys_role_menu` VALUES (4, 1072);

  373. INSERT INTO `sys_role_menu` VALUES (4, 1073);

  374. INSERT INTO `sys_role_menu` VALUES (4, 1074);

  375. INSERT INTO `sys_role_menu` VALUES (4, 1075);

  376. INSERT INTO `sys_role_menu` VALUES (4, 1076);

  377. INSERT INTO `sys_role_menu` VALUES (4, 1077);

  378. INSERT INTO `sys_role_menu` VALUES (5, 6);

  379. INSERT INTO `sys_role_menu` VALUES (5, 126);

  380. INSERT INTO `sys_role_menu` VALUES (5, 127);

  381. INSERT INTO `sys_role_menu` VALUES (5, 128);

  382. INSERT INTO `sys_role_menu` VALUES (5, 129);

  383. INSERT INTO `sys_role_menu` VALUES (5, 1078);

  384. INSERT INTO `sys_role_menu` VALUES (5, 1079);

  385. INSERT INTO `sys_role_menu` VALUES (5, 1080);

  386. INSERT INTO `sys_role_menu` VALUES (5, 1081);

  387. INSERT INTO `sys_role_menu` VALUES (5, 1082);

  388. INSERT INTO `sys_role_menu` VALUES (5, 1083);

  389. INSERT INTO `sys_role_menu` VALUES (5, 1084);

  390. INSERT INTO `sys_role_menu` VALUES (5, 1085);

  391. INSERT INTO `sys_role_menu` VALUES (5, 1086);

  392. INSERT INTO `sys_role_menu` VALUES (5, 1087);

  393. INSERT INTO `sys_role_menu` VALUES (6, 10);

  394. INSERT INTO `sys_role_menu` VALUES (6, 136);

  395. INSERT INTO `sys_role_menu` VALUES (6, 137);

  396. INSERT INTO `sys_role_menu` VALUES (6, 138);

  397. INSERT INTO `sys_role_menu` VALUES (6, 1133);

  398. INSERT INTO `sys_role_menu` VALUES (6, 1137);

  399. INSERT INTO `sys_role_menu` VALUES (6, 1138);

  400. INSERT INTO `sys_role_menu` VALUES (6, 1139);

  401. INSERT INTO `sys_role_menu` VALUES (6, 1140);

  402. INSERT INTO `sys_role_menu` VALUES (6, 1141);

  403. INSERT INTO `sys_role_menu` VALUES (6, 1142);

  404. INSERT INTO `sys_role_menu` VALUES (7, 4);

  405. INSERT INTO `sys_role_menu` VALUES (7, 5);

  406. INSERT INTO `sys_role_menu` VALUES (7, 6);

  407. INSERT INTO `sys_role_menu` VALUES (7, 7);

  408. INSERT INTO `sys_role_menu` VALUES (7, 8);

  409. INSERT INTO `sys_role_menu` VALUES (7, 9);

  410. INSERT INTO `sys_role_menu` VALUES (7, 10);

  411. INSERT INTO `sys_role_menu` VALUES (7, 11);

  412. INSERT INTO `sys_role_menu` VALUES (7, 12);

  413. INSERT INTO `sys_role_menu` VALUES (7, 13);

  414. INSERT INTO `sys_role_menu` VALUES (7, 14);

  415. INSERT INTO `sys_role_menu` VALUES (7, 15);

  416. INSERT INTO `sys_role_menu` VALUES (7, 16);

  417. INSERT INTO `sys_role_menu` VALUES (7, 17);

  418. INSERT INTO `sys_role_menu` VALUES (7, 18);

  419. INSERT INTO `sys_role_menu` VALUES (7, 19);

  420. INSERT INTO `sys_role_menu` VALUES (7, 100);

  421. INSERT INTO `sys_role_menu` VALUES (7, 118);

  422. INSERT INTO `sys_role_menu` VALUES (7, 119);

  423. INSERT INTO `sys_role_menu` VALUES (7, 120);

  424. INSERT INTO `sys_role_menu` VALUES (7, 121);

  425. INSERT INTO `sys_role_menu` VALUES (7, 122);

  426. INSERT INTO `sys_role_menu` VALUES (7, 123);

  427. INSERT INTO `sys_role_menu` VALUES (7, 124);

  428. INSERT INTO `sys_role_menu` VALUES (7, 125);

  429. INSERT INTO `sys_role_menu` VALUES (7, 126);

  430. INSERT INTO `sys_role_menu` VALUES (7, 127);

  431. INSERT INTO `sys_role_menu` VALUES (7, 128);

  432. INSERT INTO `sys_role_menu` VALUES (7, 129);

  433. INSERT INTO `sys_role_menu` VALUES (7, 130);

  434. INSERT INTO `sys_role_menu` VALUES (7, 131);

  435. INSERT INTO `sys_role_menu` VALUES (7, 132);

  436. INSERT INTO `sys_role_menu` VALUES (7, 133);

  437. INSERT INTO `sys_role_menu` VALUES (7, 134);

  438. INSERT INTO `sys_role_menu` VALUES (7, 135);

  439. INSERT INTO `sys_role_menu` VALUES (7, 136);

  440. INSERT INTO `sys_role_menu` VALUES (7, 137);

  441. INSERT INTO `sys_role_menu` VALUES (7, 138);

  442. INSERT INTO `sys_role_menu` VALUES (7, 1000);

  443. INSERT INTO `sys_role_menu` VALUES (7, 1001);

  444. INSERT INTO `sys_role_menu` VALUES (7, 1005);

  445. INSERT INTO `sys_role_menu` VALUES (7, 1063);

  446. INSERT INTO `sys_role_menu` VALUES (7, 1067);

  447. INSERT INTO `sys_role_menu` VALUES (7, 1068);

  448. INSERT INTO `sys_role_menu` VALUES (7, 1072);

  449. INSERT INTO `sys_role_menu` VALUES (7, 1073);

  450. INSERT INTO `sys_role_menu` VALUES (7, 1077);

  451. INSERT INTO `sys_role_menu` VALUES (7, 1078);

  452. INSERT INTO `sys_role_menu` VALUES (7, 1082);

  453. INSERT INTO `sys_role_menu` VALUES (7, 1083);

  454. INSERT INTO `sys_role_menu` VALUES (7, 1087);

  455. INSERT INTO `sys_role_menu` VALUES (7, 1088);

  456. INSERT INTO `sys_role_menu` VALUES (7, 1092);

  457. INSERT INTO `sys_role_menu` VALUES (7, 1093);

  458. INSERT INTO `sys_role_menu` VALUES (7, 1097);

  459. INSERT INTO `sys_role_menu` VALUES (7, 1098);

  460. INSERT INTO `sys_role_menu` VALUES (7, 1102);

  461. INSERT INTO `sys_role_menu` VALUES (7, 1103);

  462. INSERT INTO `sys_role_menu` VALUES (7, 1107);

  463. INSERT INTO `sys_role_menu` VALUES (7, 1108);

  464. INSERT INTO `sys_role_menu` VALUES (7, 1112);

  465. INSERT INTO `sys_role_menu` VALUES (7, 1113);

  466. INSERT INTO `sys_role_menu` VALUES (7, 1117);

  467. INSERT INTO `sys_role_menu` VALUES (7, 1118);

  468. INSERT INTO `sys_role_menu` VALUES (7, 1122);

  469. INSERT INTO `sys_role_menu` VALUES (7, 1123);

  470. INSERT INTO `sys_role_menu` VALUES (7, 1127);

  471. INSERT INTO `sys_role_menu` VALUES (7, 1128);

  472. INSERT INTO `sys_role_menu` VALUES (7, 1129);

  473. INSERT INTO `sys_role_menu` VALUES (7, 1130);

  474. INSERT INTO `sys_role_menu` VALUES (7, 1131);

  475. INSERT INTO `sys_role_menu` VALUES (7, 1132);

  476. INSERT INTO `sys_role_menu` VALUES (7, 1133);

  477. INSERT INTO `sys_role_menu` VALUES (7, 1137);

  478. INSERT INTO `sys_role_menu` VALUES (7, 1138);

  479. INSERT INTO `sys_role_menu` VALUES (7, 1142);

  480. INSERT INTO `sys_role_menu` VALUES (7, 1143);

  481. INSERT INTO `sys_role_menu` VALUES (7, 1147);

  482. INSERT INTO `sys_role_menu` VALUES (7, 1148);

  483. INSERT INTO `sys_role_menu` VALUES (7, 1152);

  484. INSERT INTO `sys_role_menu` VALUES (7, 1153);

  485. INSERT INTO `sys_role_menu` VALUES (7, 1157);

  486. INSERT INTO `sys_role_menu` VALUES (7, 1158);

  487. INSERT INTO `sys_role_menu` VALUES (7, 1162);

  488. INSERT INTO `sys_role_menu` VALUES (7, 1163);

  489. INSERT INTO `sys_role_menu` VALUES (7, 1167);

  490. INSERT INTO `sys_role_menu` VALUES (7, 2023);

  491. INSERT INTO `sys_role_menu` VALUES (7, 2024);

  492. INSERT INTO `sys_role_menu` VALUES (7, 2025);

  493. INSERT INTO `sys_role_menu` VALUES (7, 2026);

  494. INSERT INTO `sys_role_menu` VALUES (7, 2031);

  495. INSERT INTO `sys_role_menu` VALUES (7, 2032);

  496. INSERT INTO `sys_role_menu` VALUES (7, 2033);

  497. INSERT INTO `sys_role_menu` VALUES (7, 2048);

  498. INSERT INTO `sys_role_menu` VALUES (7, 2049);

  499. INSERT INTO `sys_role_menu` VALUES (7, 2050);

  500. INSERT INTO `sys_role_menu` VALUES (8, 7);

  501. INSERT INTO `sys_role_menu` VALUES (8, 8);

  502. INSERT INTO `sys_role_menu` VALUES (8, 11);

  503. INSERT INTO `sys_role_menu` VALUES (8, 130);

  504. INSERT INTO `sys_role_menu` VALUES (8, 132);

  505. INSERT INTO `sys_role_menu` VALUES (8, 133);

  506. INSERT INTO `sys_role_menu` VALUES (8, 1088);

  507. INSERT INTO `sys_role_menu` VALUES (8, 1092);

  508. INSERT INTO `sys_role_menu` VALUES (8, 1098);

  509. INSERT INTO `sys_role_menu` VALUES (8, 1102);

  510. INSERT INTO `sys_role_menu` VALUES (8, 1103);

  511. INSERT INTO `sys_role_menu` VALUES (8, 1104);

  512. INSERT INTO `sys_role_menu` VALUES (8, 1105);

  513. INSERT INTO `sys_role_menu` VALUES (8, 1106);

  514. INSERT INTO `sys_role_menu` VALUES (8, 1107);

  515. INSERT INTO `sys_role_menu` VALUES (9, 7);

  516. INSERT INTO `sys_role_menu` VALUES (9, 12);

  517. INSERT INTO `sys_role_menu` VALUES (9, 13);

  518. INSERT INTO `sys_role_menu` VALUES (9, 15);

  519. INSERT INTO `sys_role_menu` VALUES (9, 131);

  520. INSERT INTO `sys_role_menu` VALUES (9, 1093);

  521. INSERT INTO `sys_role_menu` VALUES (9, 1097);

  522. INSERT INTO `sys_role_menu` VALUES (9, 1108);

  523. INSERT INTO `sys_role_menu` VALUES (9, 1109);

  524. INSERT INTO `sys_role_menu` VALUES (9, 1110);

  525. INSERT INTO `sys_role_menu` VALUES (9, 1111);

  526. INSERT INTO `sys_role_menu` VALUES (9, 1112);

  527. INSERT INTO `sys_role_menu` VALUES (9, 1113);

  528. INSERT INTO `sys_role_menu` VALUES (9, 1114);

  529. INSERT INTO `sys_role_menu` VALUES (9, 1115);

  530. INSERT INTO `sys_role_menu` VALUES (9, 1116);

  531. INSERT INTO `sys_role_menu` VALUES (9, 1117);

  532. INSERT INTO `sys_role_menu` VALUES (9, 1118);

  533. INSERT INTO `sys_role_menu` VALUES (9, 1143);

  534. INSERT INTO `sys_role_menu` VALUES (9, 1147);

  535. INSERT INTO `sys_role_menu` VALUES (10, 16);

  536. INSERT INTO `sys_role_menu` VALUES (10, 1148);

  537. INSERT INTO `sys_role_menu` VALUES (10, 1152);

  538. INSERT INTO `sys_role_menu` VALUES (11, 18);

  539. INSERT INTO `sys_role_menu` VALUES (11, 1158);

  540. INSERT INTO `sys_role_menu` VALUES (11, 1162);

  541. INSERT INTO `sys_role_menu` VALUES (12, 17);

  542. INSERT INTO `sys_role_menu` VALUES (12, 1153);

  543. INSERT INTO `sys_role_menu` VALUES (12, 1167);

  544. 

  545. SET FOREIGN_KEY_CHECKS = 1;