SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单为0', `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单URL', `perms` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)', `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `type` int(5) NOT NULL COMMENT '类型 0：目录 1：菜单 2：按钮', `icon` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标', `orderNum` int(11) NULL DEFAULT NULL COMMENT '排序', `created` datetime NOT NULL, `updated` datetime NULL DEFAULT NULL, `statu` int(5) NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT '菜单表'; DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称', `code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编码', `remark` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `created` datetime NULL DEFAULT NULL, `updated` datetime NULL DEFAULT NULL, `statu` int(5) NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name`(`name`) USING BTREE, UNIQUE INDEX `code`(`code`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT '角色表'; DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `role_id` bigint(20) NOT NULL, `menu_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 162 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic COMMENT '角色&菜单关联表'; DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称(登录账号)', `username_show` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称(显示名称)', `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统头像', `email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `created` datetime NULL DEFAULT NULL, `updated` datetime NULL DEFAULT NULL, `last_login` datetime NULL DEFAULT NULL COMMENT '上次登录时间', `statu` int(5) NOT NULL, `phone` varchar(16) DEFAULT NULL COMMENT '手机号', `open_id` varchar(256) DEFAULT NULL COMMENT '普通用户的标识，对当前开发者帐号唯一', `nick_name` varchar(256) DEFAULT NULL COMMENT '普通用户昵称', `sex` varchar(8) DEFAULT NULL COMMENT '普通用户性别，1为男性，2为女性', `province` varchar(256) DEFAULT NULL COMMENT '普通用户个人资料填写的省份', `city` varchar(256) DEFAULT NULL COMMENT '普通用户个人资料填写的城市', `country` varchar(256) DEFAULT NULL COMMENT '国家，如中国为CN', `head_img_url` varchar(1024) DEFAULT NULL COMMENT '用户头像，最后一个数值代表正方形头像大小（有0、46、64、96、132数值可选，0代表640*640正方形头像），用户没有头像时该项为空', `union_id` varchar(256) DEFAULT NULL COMMENT '用户统一标识。针对一个微信开放平台帐号下的应用，同一用户的unionid是唯一的。', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `UK_USERNAME`(`username`) USING BTREE, UNIQUE INDEX `PHONE`(`phone`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT '用户表'; DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `role_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic COMMENT '用户&角色关联表'; SET FOREIGN_KEY_CHECKS = 1; #菜单基础数据 INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('1', '0', '系统管理', '', 'sys:manage', '', '0', 'el-icon-s-operation', '1', '2021-01-15 18:58:18', '2022-01-19 23:03:35', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('2', '1', '用户管理', '/sys/users', 'sys:user:list', 'sys/User', '1', 'el-icon-s-custom', '1', '2021-01-15 19:03:45', '2022-04-09 03:35:14', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('3', '1', '角色管理', '/sys/roles', 'sys:role:list', 'sys/Role', '1', 'el-icon-rank', '2', '2021-01-15 19:03:45', '2021-01-15 19:03:48', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('4', '1', '菜单管理', '/sys/menus', 'sys:menu:list', 'sys/Menu', '1', 'el-icon-menu', '3', '2021-01-15 19:03:45', '2021-01-15 19:03:48', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('5', '3', '添加角色', '', 'sys:role:save', '', '2', '', '1', '2021-01-15 23:02:25', '2022-04-09 03:18:40', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('6', '2', '添加用户', NULL, 'sys:user:save', NULL, '2', NULL, '1', '2021-01-17 21:48:32', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('7', '2', '修改用户', NULL, 'sys:user:update', NULL, '2', NULL, '2', '2021-01-17 21:49:03', '2021-01-17 21:53:04', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('8', '2', '删除用户', NULL, 'sys:user:delete', NULL, '2', NULL, '3', '2021-01-17 21:49:21', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('9', '2', '分配角色', NULL, 'sys:user:role', NULL, '2', NULL, '4', '2021-01-17 21:49:58', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('10', '2', '重置密码', NULL, 'sys:user:repass', NULL, '2', NULL, '5', '2021-01-17 21:50:36', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('11', '3', '修改角色', NULL, 'sys:role:update', NULL, '2', NULL, '2', '2021-01-17 21:51:14', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('12', '3', '删除角色', NULL, 'sys:role:delete', NULL, '2', NULL, '3', '2021-01-17 21:51:39', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('13', '3', '分配权限', NULL, 'sys:role:perm', NULL, '2', NULL, '5', '2021-01-17 21:52:02', '2022-01-19 21:38:53', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('14', '4', '添加菜单', NULL, 'sys:menu:save', NULL, '2', NULL, '1', '2021-01-17 21:53:53', '2021-01-17 21:55:28', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('15', '4', '修改菜单', NULL, 'sys:menu:update', NULL, '2', NULL, '2', '2021-01-17 21:56:12', '2022-01-19 21:18:49', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('16', '4', '删除菜单', NULL, 'sys:menu:delete', NULL, '2', NULL, '3', '2021-01-17 21:56:36', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('17', '0', '业务管理', NULL, 'biz:manage', NULL, '0', 'el-icon-s-operation', '2', '2022-04-11 16:30:03', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('18', '17', '会议管理', '/page/meetingManage', 'biz:meeting:list', 'page/meetingManage', '1', NULL, '1', '2022-04-11 16:33:29', '2022-04-20 16:09:00', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('19', '17', '巡检项目管理', '/page/inspectionProjectManage', 'biz:inspectionProject', 'page/inspectionProjectManage', '1', NULL, '3', '2022-04-11 16:58:18', '2022-04-20 16:09:44', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('20', '17', '巡检记录管理', '/page/inspectionRecord', 'biz:inspectionRecord:list', 'page/inspectionRecord', '1', NULL, '4', '2022-04-11 18:22:02', '2022-04-20 16:10:04', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('21', '17', '公告管理', '/page/noticeManage', 'biz:notice:list', 'page/noticeManage', '1', NULL, '5', '2022-04-11 19:18:38', '2022-04-20 16:10:15', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('22', '17', '群聊管理', '/page/groupManage', 'biz:group:list', 'page/groupManage', '1', NULL, '6', '2022-04-12 09:34:42', '2022-04-20 16:10:21', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('23', '22', '新增群聊', NULL, 'biz:group:save', NULL, '2', NULL, NULL, '2022-04-14 15:24:12', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('24', '22', '编辑群聊', NULL, 'biz:group:update', NULL, '2', NULL, NULL, '2022-04-14 15:41:39', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('25', '22', '删除群聊', NULL, 'biz:group:delete', NULL, '2', NULL, NULL, '2022-04-14 15:42:36', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('26', '22', '管理群成员', NULL, 'biz:group:manageUser', NULL, '2', NULL, NULL, '2022-04-14 15:42:56', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('27', '17', '巡检模板管理', '/page/inspectionTemplateManage', 'biz:inspectionTemplateManage:list', 'page/inspectionTemplateManage', '1', NULL, '2', '2022-04-20 13:47:02', '2022-04-20 16:09:31', '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('28', '17', '故障处理', '/page/faultHandlingManage', 'biz:faultHandling:list', 'page/faultHandlingManage', '1', NULL, '8', '2022-04-29 10:32:29', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('29', '17', '二维码管理', '/page/qrcodeShowConfig', 'qrcode:list', 'page/qrcodeShowConfig', '1', NULL, '9', '2022-05-07 11:12:21', NULL, '1'); INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('30', '17', '配置管理', '/page/configManage', 'biz:config:list', 'page/configManage', 1, NULL, 10, '2022-05-13 14:26:04', NULL, 1); #角色基础数据 INSERT INTO `light_application_db`.`sys_role` (`id`, `name`, `code`, `remark`, `created`, `updated`, `statu`) VALUES ('1', '工作人员', 'ADMIN', '工作人员，默认最高权限', '2021-01-04 10:09:14', '2022-04-21 10:49:26', '1'); INSERT INTO `light_application_db`.`sys_role` (`id`, `name`, `code`, `remark`, `created`, `updated`, `statu`) VALUES ('2', '运维人员', 'OPERATION', '运维人员', '2021-01-16 13:29:03', '2022-04-21 10:49:10', '1'); INSERT INTO `light_application_db`.`sys_role` (`id`, `name`, `code`, `remark`, `created`, `updated`, `statu`) VALUES ('3', '来宾', 'GUEST', '来宾角色', '2022-04-21 10:48:04', '2022-04-21 10:48:07', '1'); #用户基础数据 INSERT INTO `light_application_db`.`sys_user` (`id`, `username`, `username_show`, `password`, `avatar`, `email`, `created`, `updated`, `last_login`, `statu`, `phone`, `open_id`, `nick_name`, `sex`, `province`, `city`, `country`, `head_img_url`, `union_id`) VALUES ('1', 'admin', NULL, '$2a$10$yc0TxjbAanMGJuoJ6ItI2OjcTn2U10GHsmOW7HLNQcLpf5ulbXDLq', 'https://blog20211013.oss-cn-shenzhen.aliyuncs.com/%E6%9C%BA%E5%99%A8%E4%BA%BA.png?versionId=CAEQMxiBgIC1geHI8xciIGI3NDY5NjRiMjExYTQxMmI5NTRlN2FlZGE4Yjc0ZTAx', '1231@qq.com', '2021-01-12 22:13:53', '2022-04-09 02:32:20', '2020-12-30 08:38:37', '1', NULL, NULL, NULL, NULL, NULL, '广州', NULL, NULL, NULL); INSERT INTO `light_application_db`.`sys_user` (`id`, `username`, `username_show`, `password`, `avatar`, `email`, `created`, `updated`, `last_login`, `statu`, `phone`, `open_id`, `nick_name`, `sex`, `province`, `city`, `country`, `head_img_url`, `union_id`) VALUES ('2', 'test', 'mengchen', '$2a$10$ip1K.fCDAWOQVJO0kqgvGO32Vj.ferpGZWndbTO928m8vEYm4cBvq', 'https://blog20211013.oss-cn-shenzhen.aliyuncs.com/%E6%9C%BA%E5%99%A8%E4%BA%BA%20(1).png?versionId=CAEQMxiBgIC5geHI8xciIGMxYjNlYWRhNTBmMzQxZTlhM2VhOTAxMTI3ODI1ZjM4', '953071241@qq.com', '2022-04-09 01:34:19', '2022-04-28 14:46:52', NULL, '1', '15736203112', NULL, 'mengchen', NULL, NULL, NULL, NULL, 'https://thirdwx.qlogo.cn/mmopen/vi_32/vbzMORicKk5iaABUQmkPAf1Xn74ZkY3y5m7MicHUHhSnzfwUSl7Op2M0XJD6h3r1aHjcVCXsuLIQ9GHOXnEsHVKpw/132', NULL); #用户&角色关联数据 INSERT INTO `light_application_db`.`sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('1', '1', '1'); INSERT INTO `light_application_db`.`sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('2', '2', '2'); #角色&菜单关联数据 INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (1, 1, 1); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (2, 1, 2); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3, 1, 6); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (4, 1, 7); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (5, 1, 8); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (6, 1, 9); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (7, 1, 10); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (8, 1, 3); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (9, 1, 5); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (10, 1, 11); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (11, 1, 12); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (12, 1, 13); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (13, 1, 4); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (14, 1, 14); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (15, 1, 15); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (16, 1, 16); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (17, 1, 17); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (18, 1, 18); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (19, 1, 27); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (20, 1, 19); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (21, 1, 20); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (22, 1, 21); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (23, 1, 22); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (24, 1, 23); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (25, 1, 24); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (26, 1, 25); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (27, 1, 26); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (28, 1, 28); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (29, 1, 29); INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (30, 1, 30);