/*
角色菜单索引处理
*/
ALTER TABLE `sys_role_menu`
ADD INDEX `SYS_ROLE_MENU_ROLE_ID` (`role_id`, `menu_id`) ;

/*
菜单数据管理
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(1000) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('1', '0', '系统管理', null, null, '0', 'setting', '6');
INSERT INTO `sys_menu` VALUES ('2', '1', '管理员列表', '/n/user', null, '1', 'fa fa-user', '1');
INSERT INTO `sys_menu` VALUES ('3', '1', '角色管理', '/n/role', null, '1', 'fa fa-user-secret', '2');
INSERT INTO `sys_menu` VALUES ('4', '1', '菜单管理', '/n/menu', null, '1', 'fa fa-th-list', '3');
INSERT INTO `sys_menu` VALUES ('15', '2', '查看', null, 'sys:user:list,sys:user:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('16', '2', '新增', null, 'sys:user:save,sys:role:select', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('17', '2', '修改', null, 'sys:user:update,sys:role:select', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('18', '2', '删除', null, 'sys:user:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('19', '3', '查看', null, 'sys:role:list,sys:role:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('20', '3', '新增', null, 'sys:role:save,sys:menu:list', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('21', '3', '修改', null, 'sys:role:update,sys:menu:list', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('22', '3', '删除', null, 'sys:role:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('23', '4', '查看', null, 'sys:menu:list,sys:menu:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('24', '4', '新增', null, 'sys:menu:save,sys:menu:select', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('25', '4', '修改', null, 'sys:menu:update,sys:menu:select', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('26', '4', '删除', null, 'sys:menu:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('29', '1', '系统日志', '/n/log', 'sys:log:list', '1', 'fa fa-file-text-o', '4');
INSERT INTO `sys_menu` VALUES ('77', '0', '现场管理', null, null, '0', 'video_resource', '1');
INSERT INTO `sys_menu` VALUES ('78', '77', '我的现场', '/v/myscene', 'live:livescene:page,live:livescene:info,live:livescene:save,live:livescene:update,live:livescene:submit,live:livescene:delete,live:livescene:index:rebuild', '1', null, '1');
INSERT INTO `sys_menu` VALUES ('79', '77', '现场审核', '/v/reviewscene', 'live:livescene:page', '1', null, '2');
INSERT INTO `sys_menu` VALUES ('80', '77', '成品现场', '/v/finishscene', 'modules/scene/finishScene.html\', \'live:livescene:page,live:livescene:info,live:livescene:caster,live:livescene:direct,live:livescene:stream:list,live:livescene:update,live:livescene:delete,live:livescene:stream:createOrUpdate,live:livescene:stream:delete,live:livescene:stream:create,live:livescene:stream:update,live:livescene:stream:info,live:livescene:stream:reporters,live:livescenerecord:page,live:livescenerecord:info,live:livescenerecord:update,live:livescenerecord:delete,live:livescene:startLive,live:livescene:stopLive,live:livescene:stream:streamDefault,live:livescene:streamPlay,live:livescenerecord:save,live:livescene:streamShow,live:livescene:index:rebuild,live:caster:all', '1', null, '3');
INSERT INTO `sys_menu` VALUES ('81', '0', '素材库', '/r/library', null, '1', 'video_release', '2');
INSERT INTO `sys_menu` VALUES ('82', '0', '在线剪辑', '/c/qkvideo', null, '1', 'spread', '3');
INSERT INTO `sys_menu` VALUES ('89', '1', '敏感词管理', '/n/word', 'sensitive:word:list,sensitive:word:save,sensitive:word:info,sensitive:word:update,sensitive:word:delete,sensitive:word:replace,sensitive:stopword:list,sensitive:stopword:info,sensitive:stopword:save,sensitive:stopword:update,sensitive:stopword:delete', '1', null, '5');
INSERT INTO `sys_menu` VALUES ('91', '79', 'app现场审核', null, 'app:live:scene:page,app:live:scene:check', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('93', '0', '考核管理', '/n/Assess', null, '1', 'left_assess', '4');
INSERT INTO `sys_menu` VALUES ('94', '0', '接口管理', '/n/InterfaceTimedTask', null, '1', 'left_interface', '5');
INSERT INTO `sys_menu` VALUES ('95', '77', '现场回收站', '/v/cyclescene', null, '1', null, '4');
INSERT INTO `sys_menu` VALUES ('96', '1', '栏目管理', '/n/channel', null, '1', null, '6');
INSERT INTO `sys_menu` VALUES ('97', '78', '新建现场', null, 'live:livescene:save,live:livescene:channels', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('98', '78', '现场查询', null, 'live:livescene:page', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('99', '78', '现场修改', null, 'live:livescene:update,live:livescene:channels', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('100', '78', '现场详情', null, 'live:livescene:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('101', '78', '现场送审', null, 'live:livescene:submit', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('102', '79', '现场查询', null, 'live:livescene:page', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('103', '79', '现场修改', null, 'live:livescene:update', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('104', '79', '现场详情', null, 'live:livescene:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('105', '79', '现场审核', null, 'live:livescene:check', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('106', '79', '现场删除', null, 'live:livescene:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('107', '78', '现场删除', null, 'live:livescene:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('108', '80', '现场删除', null, 'live:livescene:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('109', '80', '现场详情', null, 'live:livescene:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('110', '80', '现场修改', null, 'live:livescene:update', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('111', '80', '流管理-列表', null, 'live:livescene:stream:list', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('112', '80', '流管理-创建', null, 'live:livescene:stream:create', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('113', '80', '流管理-更新', null, 'live:livescene:stream:update', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('114', '80', '流管理-详情', null, 'live:livescene:stream:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('115', '80', '流管理-删除', null, 'live:livescene:stream:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('116', '80', '流管理-记者列表', null, 'live:livescene:stream:reporters', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('117', '80', '流管理-显示/不显示', null, 'live:livescene:streamShow', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('118', '80', '回顾-列表', null, 'live:livescenerecord:page', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('119', '80', '回顾-详情', null, 'live:livescenerecord:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('120', '80', '回顾-创建', null, 'live:livescenerecord:save', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('121', '80', '回顾-修改', null, 'live:livescenerecord:update', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('122', '80', '回顾-删除', null, 'live:livescenerecord:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('123', '80', '回顾-排序', null, 'live:livescenerecord:priority', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('124', '80', '报道-列表', null, 'live:report:list', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('125', '80', '报道-详情', null, 'live:report:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('126', '80', '报道-创建', null, 'live:report:save', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('127', '80', '报道-修改', null, 'live:report:update', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('128', '80', '报道-删除', null, 'live:report:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('129', '80', '报道-发布', null, 'live:report:release', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('130', '80', '报道-取消发布', null, 'live:report:cancelRelease', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('131', '80', '报道-置顶', null, 'live:report:top', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('132', '80', '报道-取消置顶', null, 'live:report:cancelTop', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('133', '80', '报道-排序', null, 'live:report:priority', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('134', '80', '评论-列表', null, 'live:comment:list', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('135', '80', '评论-详情', null, 'live:comment:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('136', '80', '评论-创建', null, 'live:comment:save', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('137', '80', '评论-修改', null, 'live:comment:update', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('138', '80', '评论-删除', null, 'live:comment:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('139', '80', '评论-发布', null, 'live:comment:release', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('140', '80', '评论-取消发布', null, 'live:comment:cancelRelease', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('141', '80', '评论-app审核', null, 'app:live:scene:comment:check', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('142', '95', '列表', null, 'live:livescene:page', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('143', '95', '详情', null, 'live:livescene:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('144', '95', '还原', null, 'live:livescene:cycle:recycle', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('145', '95', '删除', null, 'live:livescene:cycle:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('146', '81', '列表', null, 'live:multimedia:list', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('147', '81', '详情', null, 'live:multimedia:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('148', '81', '上传', null, 'live:multimedia:save', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('149', '81', '修改', null, 'live:multimedia:update', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('150', '81', '删除', null, 'live:multimedia:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('151', '0', '首页', '/home', null, '1', 'home', '0');
INSERT INTO `sys_menu` VALUES ('152', '96', '查看', null, 'live:channel:list,live:channel:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('153', '96', '新增', null, 'live:channel:save', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('154', '96', '修改', null, 'live:channel:update,live:channel:info', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('155', '96', '删除', null, 'live:channel:list,live:channel:delete', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('156', '96', '批量显示', null, 'live:channel:list,live:channel:display', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('157', '96', '取消显示', null, 'live:channel:list,live:channel:cancelDisplay', '2', null, '0');
INSERT INTO `sys_menu` VALUES ('158', '96', '排序', null, 'live:channel:list,live:channel:priority', '2', null, '0');

-- ----------------------------
-- Table structure for `sys_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`),
  KEY `SYS_ROLE_MENU_ROLE_ID` (`role_id`,`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1204 DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('822', '1', '1');
INSERT INTO `sys_role_menu` VALUES ('823', '1', '2');
INSERT INTO `sys_role_menu` VALUES ('828', '1', '3');
INSERT INTO `sys_role_menu` VALUES ('833', '1', '4');
INSERT INTO `sys_role_menu` VALUES ('824', '1', '15');
INSERT INTO `sys_role_menu` VALUES ('825', '1', '16');
INSERT INTO `sys_role_menu` VALUES ('826', '1', '17');
INSERT INTO `sys_role_menu` VALUES ('827', '1', '18');
INSERT INTO `sys_role_menu` VALUES ('829', '1', '19');
INSERT INTO `sys_role_menu` VALUES ('830', '1', '20');
INSERT INTO `sys_role_menu` VALUES ('831', '1', '21');
INSERT INTO `sys_role_menu` VALUES ('832', '1', '22');
INSERT INTO `sys_role_menu` VALUES ('834', '1', '23');
INSERT INTO `sys_role_menu` VALUES ('835', '1', '24');
INSERT INTO `sys_role_menu` VALUES ('836', '1', '25');
INSERT INTO `sys_role_menu` VALUES ('837', '1', '26');
INSERT INTO `sys_role_menu` VALUES ('838', '1', '29');
INSERT INTO `sys_role_menu` VALUES ('760', '1', '77');
INSERT INTO `sys_role_menu` VALUES ('761', '1', '78');
INSERT INTO `sys_role_menu` VALUES ('768', '1', '79');
INSERT INTO `sys_role_menu` VALUES ('775', '1', '80');
INSERT INTO `sys_role_menu` VALUES ('815', '1', '81');
INSERT INTO `sys_role_menu` VALUES ('821', '1', '82');
INSERT INTO `sys_role_menu` VALUES ('839', '1', '89');
INSERT INTO `sys_role_menu` VALUES ('769', '1', '91');
INSERT INTO `sys_role_menu` VALUES ('810', '1', '95');
INSERT INTO `sys_role_menu` VALUES ('840', '1', '96');
INSERT INTO `sys_role_menu` VALUES ('762', '1', '97');
INSERT INTO `sys_role_menu` VALUES ('763', '1', '98');
INSERT INTO `sys_role_menu` VALUES ('764', '1', '99');
INSERT INTO `sys_role_menu` VALUES ('765', '1', '100');
INSERT INTO `sys_role_menu` VALUES ('766', '1', '101');
INSERT INTO `sys_role_menu` VALUES ('770', '1', '102');
INSERT INTO `sys_role_menu` VALUES ('771', '1', '103');
INSERT INTO `sys_role_menu` VALUES ('772', '1', '104');
INSERT INTO `sys_role_menu` VALUES ('773', '1', '105');
INSERT INTO `sys_role_menu` VALUES ('774', '1', '106');
INSERT INTO `sys_role_menu` VALUES ('767', '1', '107');
INSERT INTO `sys_role_menu` VALUES ('776', '1', '108');
INSERT INTO `sys_role_menu` VALUES ('777', '1', '109');
INSERT INTO `sys_role_menu` VALUES ('778', '1', '110');
INSERT INTO `sys_role_menu` VALUES ('779', '1', '111');
INSERT INTO `sys_role_menu` VALUES ('780', '1', '112');
INSERT INTO `sys_role_menu` VALUES ('781', '1', '113');
INSERT INTO `sys_role_menu` VALUES ('782', '1', '114');
INSERT INTO `sys_role_menu` VALUES ('783', '1', '115');
INSERT INTO `sys_role_menu` VALUES ('784', '1', '116');
INSERT INTO `sys_role_menu` VALUES ('785', '1', '117');
INSERT INTO `sys_role_menu` VALUES ('786', '1', '118');
INSERT INTO `sys_role_menu` VALUES ('787', '1', '119');
INSERT INTO `sys_role_menu` VALUES ('788', '1', '120');
INSERT INTO `sys_role_menu` VALUES ('789', '1', '121');
INSERT INTO `sys_role_menu` VALUES ('790', '1', '122');
INSERT INTO `sys_role_menu` VALUES ('791', '1', '123');
INSERT INTO `sys_role_menu` VALUES ('792', '1', '124');
INSERT INTO `sys_role_menu` VALUES ('793', '1', '125');
INSERT INTO `sys_role_menu` VALUES ('794', '1', '126');
INSERT INTO `sys_role_menu` VALUES ('795', '1', '127');
INSERT INTO `sys_role_menu` VALUES ('796', '1', '128');
INSERT INTO `sys_role_menu` VALUES ('797', '1', '129');
INSERT INTO `sys_role_menu` VALUES ('798', '1', '130');
INSERT INTO `sys_role_menu` VALUES ('799', '1', '131');
INSERT INTO `sys_role_menu` VALUES ('800', '1', '132');
INSERT INTO `sys_role_menu` VALUES ('801', '1', '133');
INSERT INTO `sys_role_menu` VALUES ('802', '1', '134');
INSERT INTO `sys_role_menu` VALUES ('803', '1', '135');
INSERT INTO `sys_role_menu` VALUES ('804', '1', '136');
INSERT INTO `sys_role_menu` VALUES ('805', '1', '137');
INSERT INTO `sys_role_menu` VALUES ('806', '1', '138');
INSERT INTO `sys_role_menu` VALUES ('807', '1', '139');
INSERT INTO `sys_role_menu` VALUES ('808', '1', '140');
INSERT INTO `sys_role_menu` VALUES ('809', '1', '141');
INSERT INTO `sys_role_menu` VALUES ('811', '1', '142');
INSERT INTO `sys_role_menu` VALUES ('812', '1', '143');
INSERT INTO `sys_role_menu` VALUES ('813', '1', '144');
INSERT INTO `sys_role_menu` VALUES ('814', '1', '145');
INSERT INTO `sys_role_menu` VALUES ('816', '1', '146');
INSERT INTO `sys_role_menu` VALUES ('817', '1', '147');
INSERT INTO `sys_role_menu` VALUES ('818', '1', '148');
INSERT INTO `sys_role_menu` VALUES ('819', '1', '149');
INSERT INTO `sys_role_menu` VALUES ('820', '1', '150');
INSERT INTO `sys_role_menu` VALUES ('759', '1', '151');
INSERT INTO `sys_role_menu` VALUES ('841', '1', '152');
INSERT INTO `sys_role_menu` VALUES ('842', '1', '153');
INSERT INTO `sys_role_menu` VALUES ('843', '1', '154');
INSERT INTO `sys_role_menu` VALUES ('844', '1', '155');
INSERT INTO `sys_role_menu` VALUES ('845', '1', '156');
INSERT INTO `sys_role_menu` VALUES ('846', '1', '157');
INSERT INTO `sys_role_menu` VALUES ('847', '1', '158');
INSERT INTO `sys_role_menu` VALUES ('1138', '2', '78');
INSERT INTO `sys_role_menu` VALUES ('1146', '2', '80');
INSERT INTO `sys_role_menu` VALUES ('1186', '2', '81');
INSERT INTO `sys_role_menu` VALUES ('1192', '2', '82');
INSERT INTO `sys_role_menu` VALUES ('1195', '2', '89');
INSERT INTO `sys_role_menu` VALUES ('1193', '2', '93');
INSERT INTO `sys_role_menu` VALUES ('1194', '2', '94');
INSERT INTO `sys_role_menu` VALUES ('1181', '2', '95');
INSERT INTO `sys_role_menu` VALUES ('1196', '2', '96');
INSERT INTO `sys_role_menu` VALUES ('1139', '2', '97');
INSERT INTO `sys_role_menu` VALUES ('1140', '2', '98');
INSERT INTO `sys_role_menu` VALUES ('1141', '2', '99');
INSERT INTO `sys_role_menu` VALUES ('1142', '2', '100');
INSERT INTO `sys_role_menu` VALUES ('1143', '2', '101');
INSERT INTO `sys_role_menu` VALUES ('1145', '2', '102');
INSERT INTO `sys_role_menu` VALUES ('1144', '2', '107');
INSERT INTO `sys_role_menu` VALUES ('1147', '2', '108');
INSERT INTO `sys_role_menu` VALUES ('1148', '2', '109');
INSERT INTO `sys_role_menu` VALUES ('1149', '2', '110');
INSERT INTO `sys_role_menu` VALUES ('1150', '2', '111');
INSERT INTO `sys_role_menu` VALUES ('1151', '2', '112');
INSERT INTO `sys_role_menu` VALUES ('1152', '2', '113');
INSERT INTO `sys_role_menu` VALUES ('1153', '2', '114');
INSERT INTO `sys_role_menu` VALUES ('1154', '2', '115');
INSERT INTO `sys_role_menu` VALUES ('1155', '2', '116');
INSERT INTO `sys_role_menu` VALUES ('1156', '2', '117');
INSERT INTO `sys_role_menu` VALUES ('1157', '2', '118');
INSERT INTO `sys_role_menu` VALUES ('1158', '2', '119');
INSERT INTO `sys_role_menu` VALUES ('1159', '2', '120');
INSERT INTO `sys_role_menu` VALUES ('1160', '2', '121');
INSERT INTO `sys_role_menu` VALUES ('1161', '2', '122');
INSERT INTO `sys_role_menu` VALUES ('1162', '2', '123');
INSERT INTO `sys_role_menu` VALUES ('1163', '2', '124');
INSERT INTO `sys_role_menu` VALUES ('1164', '2', '125');
INSERT INTO `sys_role_menu` VALUES ('1165', '2', '126');
INSERT INTO `sys_role_menu` VALUES ('1166', '2', '127');
INSERT INTO `sys_role_menu` VALUES ('1167', '2', '128');
INSERT INTO `sys_role_menu` VALUES ('1168', '2', '129');
INSERT INTO `sys_role_menu` VALUES ('1169', '2', '130');
INSERT INTO `sys_role_menu` VALUES ('1170', '2', '131');
INSERT INTO `sys_role_menu` VALUES ('1171', '2', '132');
INSERT INTO `sys_role_menu` VALUES ('1172', '2', '133');
INSERT INTO `sys_role_menu` VALUES ('1173', '2', '134');
INSERT INTO `sys_role_menu` VALUES ('1174', '2', '135');
INSERT INTO `sys_role_menu` VALUES ('1175', '2', '136');
INSERT INTO `sys_role_menu` VALUES ('1176', '2', '137');
INSERT INTO `sys_role_menu` VALUES ('1177', '2', '138');
INSERT INTO `sys_role_menu` VALUES ('1178', '2', '139');
INSERT INTO `sys_role_menu` VALUES ('1179', '2', '140');
INSERT INTO `sys_role_menu` VALUES ('1180', '2', '141');
INSERT INTO `sys_role_menu` VALUES ('1182', '2', '142');
INSERT INTO `sys_role_menu` VALUES ('1183', '2', '143');
INSERT INTO `sys_role_menu` VALUES ('1184', '2', '144');
INSERT INTO `sys_role_menu` VALUES ('1185', '2', '145');
INSERT INTO `sys_role_menu` VALUES ('1187', '2', '146');
INSERT INTO `sys_role_menu` VALUES ('1188', '2', '147');
INSERT INTO `sys_role_menu` VALUES ('1189', '2', '148');
INSERT INTO `sys_role_menu` VALUES ('1190', '2', '149');
INSERT INTO `sys_role_menu` VALUES ('1191', '2', '150');
INSERT INTO `sys_role_menu` VALUES ('1137', '2', '151');
INSERT INTO `sys_role_menu` VALUES ('1197', '2', '152');
INSERT INTO `sys_role_menu` VALUES ('1198', '2', '153');
INSERT INTO `sys_role_menu` VALUES ('1199', '2', '154');
INSERT INTO `sys_role_menu` VALUES ('1200', '2', '155');
INSERT INTO `sys_role_menu` VALUES ('1201', '2', '156');
INSERT INTO `sys_role_menu` VALUES ('1202', '2', '157');
INSERT INTO `sys_role_menu` VALUES ('1203', '2', '158');
INSERT INTO `sys_role_menu` VALUES ('849', '3', '77');
INSERT INTO `sys_role_menu` VALUES ('850', '3', '78');
INSERT INTO `sys_role_menu` VALUES ('857', '3', '79');
INSERT INTO `sys_role_menu` VALUES ('864', '3', '80');
INSERT INTO `sys_role_menu` VALUES ('904', '3', '81');
INSERT INTO `sys_role_menu` VALUES ('910', '3', '82');
INSERT INTO `sys_role_menu` VALUES ('913', '3', '89');
INSERT INTO `sys_role_menu` VALUES ('858', '3', '91');
INSERT INTO `sys_role_menu` VALUES ('911', '3', '93');
INSERT INTO `sys_role_menu` VALUES ('912', '3', '94');
INSERT INTO `sys_role_menu` VALUES ('899', '3', '95');
INSERT INTO `sys_role_menu` VALUES ('914', '3', '96');
INSERT INTO `sys_role_menu` VALUES ('851', '3', '97');
INSERT INTO `sys_role_menu` VALUES ('852', '3', '98');
INSERT INTO `sys_role_menu` VALUES ('853', '3', '99');
INSERT INTO `sys_role_menu` VALUES ('854', '3', '100');
INSERT INTO `sys_role_menu` VALUES ('855', '3', '101');
INSERT INTO `sys_role_menu` VALUES ('859', '3', '102');
INSERT INTO `sys_role_menu` VALUES ('860', '3', '103');
INSERT INTO `sys_role_menu` VALUES ('861', '3', '104');
INSERT INTO `sys_role_menu` VALUES ('862', '3', '105');
INSERT INTO `sys_role_menu` VALUES ('863', '3', '106');
INSERT INTO `sys_role_menu` VALUES ('856', '3', '107');
INSERT INTO `sys_role_menu` VALUES ('865', '3', '108');
INSERT INTO `sys_role_menu` VALUES ('866', '3', '109');
INSERT INTO `sys_role_menu` VALUES ('867', '3', '110');
INSERT INTO `sys_role_menu` VALUES ('868', '3', '111');
INSERT INTO `sys_role_menu` VALUES ('869', '3', '112');
INSERT INTO `sys_role_menu` VALUES ('870', '3', '113');
INSERT INTO `sys_role_menu` VALUES ('871', '3', '114');
INSERT INTO `sys_role_menu` VALUES ('872', '3', '115');
INSERT INTO `sys_role_menu` VALUES ('873', '3', '116');
INSERT INTO `sys_role_menu` VALUES ('874', '3', '117');
INSERT INTO `sys_role_menu` VALUES ('875', '3', '118');
INSERT INTO `sys_role_menu` VALUES ('876', '3', '119');
INSERT INTO `sys_role_menu` VALUES ('877', '3', '120');
INSERT INTO `sys_role_menu` VALUES ('878', '3', '121');
INSERT INTO `sys_role_menu` VALUES ('879', '3', '122');
INSERT INTO `sys_role_menu` VALUES ('880', '3', '123');
INSERT INTO `sys_role_menu` VALUES ('881', '3', '124');
INSERT INTO `sys_role_menu` VALUES ('882', '3', '125');
INSERT INTO `sys_role_menu` VALUES ('883', '3', '126');
INSERT INTO `sys_role_menu` VALUES ('884', '3', '127');
INSERT INTO `sys_role_menu` VALUES ('885', '3', '128');
INSERT INTO `sys_role_menu` VALUES ('886', '3', '129');
INSERT INTO `sys_role_menu` VALUES ('887', '3', '130');
INSERT INTO `sys_role_menu` VALUES ('888', '3', '131');
INSERT INTO `sys_role_menu` VALUES ('889', '3', '132');
INSERT INTO `sys_role_menu` VALUES ('890', '3', '133');
INSERT INTO `sys_role_menu` VALUES ('891', '3', '134');
INSERT INTO `sys_role_menu` VALUES ('892', '3', '135');
INSERT INTO `sys_role_menu` VALUES ('893', '3', '136');
INSERT INTO `sys_role_menu` VALUES ('894', '3', '137');
INSERT INTO `sys_role_menu` VALUES ('895', '3', '138');
INSERT INTO `sys_role_menu` VALUES ('896', '3', '139');
INSERT INTO `sys_role_menu` VALUES ('897', '3', '140');
INSERT INTO `sys_role_menu` VALUES ('898', '3', '141');
INSERT INTO `sys_role_menu` VALUES ('900', '3', '142');
INSERT INTO `sys_role_menu` VALUES ('901', '3', '143');
INSERT INTO `sys_role_menu` VALUES ('902', '3', '144');
INSERT INTO `sys_role_menu` VALUES ('903', '3', '145');
INSERT INTO `sys_role_menu` VALUES ('905', '3', '146');
INSERT INTO `sys_role_menu` VALUES ('906', '3', '147');
INSERT INTO `sys_role_menu` VALUES ('907', '3', '148');
INSERT INTO `sys_role_menu` VALUES ('908', '3', '149');
INSERT INTO `sys_role_menu` VALUES ('909', '3', '150');
INSERT INTO `sys_role_menu` VALUES ('848', '3', '151');
INSERT INTO `sys_role_menu` VALUES ('915', '3', '152');
INSERT INTO `sys_role_menu` VALUES ('916', '3', '153');
INSERT INTO `sys_role_menu` VALUES ('917', '3', '154');
INSERT INTO `sys_role_menu` VALUES ('918', '3', '155');
INSERT INTO `sys_role_menu` VALUES ('919', '3', '156');
INSERT INTO `sys_role_menu` VALUES ('920', '3', '157');
INSERT INTO `sys_role_menu` VALUES ('921', '3', '158');
INSERT INTO `sys_role_menu` VALUES ('924', '4', '81');
INSERT INTO `sys_role_menu` VALUES ('922', '4', '91');
INSERT INTO `sys_role_menu` VALUES ('923', '4', '141');
INSERT INTO `sys_role_menu` VALUES ('925', '4', '146');
INSERT INTO `sys_role_menu` VALUES ('926', '4', '147');
INSERT INTO `sys_role_menu` VALUES ('927', '4', '148');
INSERT INTO `sys_role_menu` VALUES ('928', '4', '149');
INSERT INTO `sys_role_menu` VALUES ('929', '4', '150');