use `qc`;

ALTER TABLE `med_qcresult_info` ADD `have_home_page` tinyint(4) DEFAULT '0' COMMENT '是否有病案首页(0：无，1：有)' AFTER `score_res`;

DELETE FROM sys_user_pageset WHERE user_id = -1;

INSERT INTO `sys_user_pageset` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病历等级', 'level', '1', '1', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病历得分', 'scoreRes', '1', '2', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病人住院序号', 'behospitalCode', '1', '3', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病案号', 'fileCode', '1', '5', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '病人姓名', 'name', '1', '6', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '性别', 'sex', '1', '7', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '年龄', 'age', '1', '8', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '床号', 'bedCode', '1', '9', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '入院日期', 'behospitalDate', '1', '10', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '出院日期', 'leaveHospitalDate', '1', '11', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '归档日期', 'placefileDate', '1', '12', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '主诊断', 'diagnose', '1', '13', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '住院医生', 'behDoctorName', '1', '14', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '主管医生', 'doctorName', '1', '15', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '主任医生', 'directorDoctorName', '1', '16', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '科室', 'behDeptName', '1', '17', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '评分时间', 'gradeTime', '1', '18', NULL);
INSERT INTO `sys_user_pageset` (  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '核查状态', 'checkStatus', '1', '4', NULL);

-- 找出没有”核查状态“的人员并给加上
 INSERT INTO sys_user_pageset
(  `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `user_id`, `page_type`, `name`, `val`, `status`, `order_no`, `remark`)
 SELECT is_deleted,
gmt_create,
 gmt_modified,
 creator,
MODIFIER,
 user_id,
 page_type,
 CASE WHEN ISNULL(NAME) THEN "核查状态" ELSE "核查状态" END NAME,
 CASE WHEN ISNULL(userId) THEN "checkStatus" ELSE "checkStatus" END val,
 CASE WHEN ISNULL(STATUS) THEN 0 ELSE 0 END STATUS,
 CASE WHEN ISNULL(order_no) THEN 4 ELSE 4 END order_no,
 remark
 FROM (SELECT * FROM  sys_user_pageset  WHERE user_id <> -1) b LEFT JOIN  (SELECT c.user_id AS userId FROM  sys_user_pageset c  WHERE user_id <> -1 AND val = "checkStatus") p ON b.user_id = p.userId
WHERE  userId IS NULL
 GROUP BY user_id ;


-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
  `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
  `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '菜单名称',
  `parent_id` bigint(20) NOT NULL DEFAULT '-1' COMMENT '-1：表示顶级,其他值表示上级菜单的id',
  `code` varchar(255) NOT NULL DEFAULT '' COMMENT '编码，与前端对应',
  `show_status` int(11) NOT NULL DEFAULT '0' COMMENT '是否在右侧菜单显示(0:不显示，1：显示)',
  `maintain_status` int(11) NOT NULL DEFAULT '0' COMMENT '是否可以维护(0:不可维护，1：可以维护)',
  `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序，从小到大',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='系统菜单';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '控制台', '-1', 'YH-KZT', '1', '1', '-10', '用户-控制台');
INSERT INTO `sys_menu` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '基础数据维护', '-1', 'YH-JCSJWH', '1', '1', '2', '用户-基础数据维护');
INSERT INTO `sys_menu` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案质控', '-1', 'YH-BLZK', '1', '1', '3', '用户-病历质控');
INSERT INTO `sys_menu` VALUES ('4', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '统计分析', '-1', 'YH-TJFX', '1', '1', '4', '用户-统计分析');
INSERT INTO `sys_menu` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '模块数据维护', '2', 'YH-JCSJWH-MKSJWH', '1', '1', '1', '用户-基础数据维护-模块数据维护');
INSERT INTO `sys_menu` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目数据维护', '2', 'YH-JCSJWH-TMSJWH', '1', '1', '2', '用户-基础数据维护-条目数据维护');
INSERT INTO `sys_menu` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', '3', 'YH-BLZK-ZKPF', '1', '1', '1', '用户-病历质控-质控评分');
INSERT INTO `sys_menu` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '基础功能', '-1', 'YH-QBYH-JCGN', '0', '1', '0', '用户-基础功能');
INSERT INTO `sys_menu` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分(科室)', '3', 'YH-BLZK-ZKPFKS', '1', '1', '2', '用户-病历质控-质控评分(科室)');
INSERT INTO `sys_menu` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分(个人)', '3', 'YH-BLZK-ZKPFGR', '1', '1', '3', '用户-病历质控-质控评分(个人)');
INSERT INTO `sys_menu` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '权限管理', '-1', 'YH-QXGL', '1', '0', '5', '用户-权限管理');
INSERT INTO `sys_menu` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '用户管理', '12', 'YH-QXGL-YHGL', '1', '0', '1', '用户-权限管理-用户管理');
INSERT INTO `sys_menu` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '角色管理', '12', 'YH-QXGL-JSGL', '1', '0', '2', '用户-权限管理-角色管理');
INSERT INTO `sys_menu` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '控制台(科室)', '-1', 'YH-KZTKS', '1', '1', '-9', '用户-控制台（科室）');
INSERT INTO `sys_menu` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '异常数据监控', '-1', 'YH-YCSJJK', '1', '0', '10', '用户-异常数据监控');
INSERT INTO `sys_menu` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '数据报表明细', '-1', 'YH-ZKK', '1', '1', '-8', '用户-质控科');
INSERT INTO `sys_menu` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '数据报表明细(科室)', '-1', 'YH-KSZR', '1', '1', '-7', '用户-科室主任');
INSERT INTO `sys_menu` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比', '17', 'YH-ZKK-GMKQXZB_XQ', '1', '1', '2', '用户-质控科-各模块缺陷占比_详情');
INSERT INTO `sys_menu` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比', '17', 'YH-ZKK-TMQXZB_XQ', '1', '1', '3', '用户-质控科-条目缺陷占比_详情');
INSERT INTO `sys_menu` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室平均住院天数', '17', 'YH-ZKK-KSPJZYTS_XQ', '1', '1', '4', '用户-质控科-科室平均住院天数_详情');
INSERT INTO `sys_menu` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室平均住院花费', '17', 'YH-ZKK-KSPJZYHF_XQ', '1', '1', '5', '用户-质控科-科室平均住院花费_详情');
INSERT INTO `sys_menu` VALUES ('23', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室质控平均分', '17', 'YH-ZKK-GKSZKPJF_XQ', '1', '1', '6', '用户-质控科-各科室质控平均分_详情');
INSERT INTO `sys_menu` VALUES ('24', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '缺陷详情', '17', 'YH-ZKK-GKSQXZB', '1', '1', '7', '用户-质控科-各科室缺陷占比_详情');
INSERT INTO `sys_menu` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室甲级病历占比', '17', 'YH-ZKK-GKSJJBLZB_XQ', '1', '1', '8', '用户-质控科-各科室甲级病历占比_详情');
INSERT INTO `sys_menu` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比', '18', 'YH-KSZR-GMKQXZB_XQ', '1', '1', '2', '用户-科室主任-各模块缺陷占比_详情');
INSERT INTO `sys_menu` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比', '18', 'YH-KSZR-TMQXZB_XQ', '1', '1', '3', '用户-科室主任-条目缺陷占比_详情');
INSERT INTO `sys_menu` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比', '17', 'YH-ZKK-BASYHGLZB_XQ', '1', '1', '1', '用户-质控科-病案首页合格率占比_详情');
INSERT INTO `sys_menu` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比', '18', 'YH-KSZR-BASYHGLZB_XQ', '1', '1', '1', '用户-科室主任-病案首页合格率占比_详情');
INSERT INTO `sys_menu` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室缺陷占比', '18', 'YH-KSZR-KSQXZB_XQ', '1', '1', '4', '用户-科室主任-科室缺陷占比_详情');
INSERT INTO `sys_menu` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比', '17', 'YH-ZKK-GKSQXZB_XQ', '1', '1', '9', '用户-质控科-各科室缺陷占比_详情');
INSERT INTO `sys_menu` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控类型维护', '2', 'YH-JCSJWH-ZKLXWH', '1', '0', '3', '用户-基础数据维护-质控类型维护');
INSERT INTO `sys_menu` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分(医疗组)', '3', 'YH-BLZK-ZKPFYLZ', '1', '1', '4', '用户-病历质控-质控评分(医疗组)');
INSERT INTO `sys_menu` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '关键条目缺陷占比', '17', 'YH-ZKK-GJTMQXZB', '1', '1', '10', '用户-质控科-关键条目缺陷占比');
INSERT INTO `sys_menu` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计', '17', 'YH-ZKK-CYRSTJ', '1', '1', '11', '用户-质控科-出院人数统计');
INSERT INTO `sys_menu` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控核查统计', '17', 'YH-ZKK-ZKHCTJ', '1', '1', '12', '用户-质控科-质控核查统计');

-- ----------------------------
-- Table structure for sys_menu_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_permission`;
CREATE TABLE `sys_menu_permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
  `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
  `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  `menu_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '菜单id',
  `permission_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '系统资源id',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='菜单和系统资源的映射表';

-- ----------------------------
-- Records of sys_menu_permission
-- ----------------------------
INSERT INTO `sys_menu_permission` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '1', '基础功能-获取用户、机构、菜单信息');
INSERT INTO `sys_menu_permission` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '2', '基础功能-修改密码');
INSERT INTO `sys_menu_permission` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '9', '控制台-病历相关统计');
INSERT INTO `sys_menu_permission` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '15', '控制台-缺陷相关统计');
INSERT INTO `sys_menu_permission` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '16', '控制台-医院运营相关统计');
INSERT INTO `sys_menu_permission` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '3', '用户-基础数据维护-获取医院模块数据信息');
INSERT INTO `sys_menu_permission` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '4', '用户-基础数据维护-批量更新模块数据');
INSERT INTO `sys_menu_permission` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '6', '用户-条目数据维护-分页获取医院条目数据信息');
INSERT INTO `sys_menu_permission` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '7', '用户-条目数据维护-修改医院条目数据信息');
INSERT INTO `sys_menu_permission` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '8', '用户-条目数据维护-获取医院模块数据下拉列表');
INSERT INTO `sys_menu_permission` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '30', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息');
INSERT INTO `sys_menu_permission` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '17', '用户-质控评分-评分');
INSERT INTO `sys_menu_permission` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '5', '用户-质控评分-分页');
INSERT INTO `sys_menu_permission` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '11', '用户-质控评分-新增质控条目');
INSERT INTO `sys_menu_permission` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '12', '用户-质控评分-删除质控条目');
INSERT INTO `sys_menu_permission` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '13', '用户-质控评分-修改质控条目');
INSERT INTO `sys_menu_permission` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '14', '用户-质控评分-获取详情');
INSERT INTO `sys_menu_permission` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '31', '用户-质控评分(科室)-获取病历质控一览下用户科室下拉列表信息');
INSERT INTO `sys_menu_permission` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '34', '用户-质控评分(科室)-评分');
INSERT INTO `sys_menu_permission` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '32', '用户-质控评分(科室)-分页');
INSERT INTO `sys_menu_permission` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '35', '用户-质控评分(科室)-新增质控条目');
INSERT INTO `sys_menu_permission` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '36', '用户-质控评分(科室)-删除质控条目');
INSERT INTO `sys_menu_permission` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '37', '用户-质控评分(科室)-修改质控条目');
INSERT INTO `sys_menu_permission` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '38', '用户-质控评分(科室)-获取详情');
INSERT INTO `sys_menu_permission` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '39', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息');
INSERT INTO `sys_menu_permission` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '40', '用户-质控评分(个人)-评分');
INSERT INTO `sys_menu_permission` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '33', '用户-质控评分(个人)-分页');
INSERT INTO `sys_menu_permission` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '41', '用户-质控评分(个人)-新增质控条目');
INSERT INTO `sys_menu_permission` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '42', '用户-质控评分(个人)-删除质控条目');
INSERT INTO `sys_menu_permission` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '43', '用户-质控评分(个人)-修改质控条目');
INSERT INTO `sys_menu_permission` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '44', '用户-质控评分(个人)-获取详情');
INSERT INTO `sys_menu_permission` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '45', '控制台-平均住院天数');
INSERT INTO `sys_menu_permission` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '46', '控制台-平均住院费用');
INSERT INTO `sys_menu_permission` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '47', '控制台-质控平均分按科室统计');
INSERT INTO `sys_menu_permission` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '48', '控制台-各科室甲级病历占比');
INSERT INTO `sys_menu_permission` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '49', '控制台-出院人数统计');
INSERT INTO `sys_menu_permission` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '50', '控制台-质控病历统计');
INSERT INTO `sys_menu_permission` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '51', '控制台-各模块缺陷占比排行');
INSERT INTO `sys_menu_permission` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '52', '控制台-条目缺陷占比');
INSERT INTO `sys_menu_permission` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '53', '控制台-各科室缺陷占比');
INSERT INTO `sys_menu_permission` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '54', '控制台（科室）-出院人数统计（科室）');
INSERT INTO `sys_menu_permission` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '55', '控制台（科室）-质控病历数统计（科室）');
INSERT INTO `sys_menu_permission` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '56', '控制台（科室）-各模块缺陷占比排行（科室）');
INSERT INTO `sys_menu_permission` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '57', '控制台（科室）-条目缺陷占比（科室）');
INSERT INTO `sys_menu_permission` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '58', '控制台（科室）-查询用户关联科室');
INSERT INTO `sys_menu_permission` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '19', '59', '控制台-各模块缺陷占比_详情');
INSERT INTO `sys_menu_permission` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '20', '60', '控制台-条目缺陷占比_详情');
INSERT INTO `sys_menu_permission` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '21', '64', '控制台-科室平均住院天数_详情');
INSERT INTO `sys_menu_permission` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '22', '65', '控制台-科室平均住院花费_详情');
INSERT INTO `sys_menu_permission` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '66', '控制台-各科室质控平均分_详情');
INSERT INTO `sys_menu_permission` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31', '67', '控制台-各科室缺陷占比-缺陷详情');
INSERT INTO `sys_menu_permission` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '25', '68', '控制台-各科室甲级病历占比_详情');
INSERT INTO `sys_menu_permission` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '26', '69', '控制台（科室）-各模块缺陷占比_详情');
INSERT INTO `sys_menu_permission` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '27', '70', '控制台（科室）-条目缺陷占比_详情');
INSERT INTO `sys_menu_permission` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31', '71', '控制台-各科室缺陷占比（组合）');
INSERT INTO `sys_menu_permission` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '28', '72', '控制台-病案首页合格率占比');
INSERT INTO `sys_menu_permission` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '30', '73', '控制台（科室）-各科室缺陷占比（科室）');
INSERT INTO `sys_menu_permission` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '29', '74', '控制台（科室）-病案首页合格率占比（科室）');
INSERT INTO `sys_menu_permission` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '75', '控制台-病案首页合格率占比（首页）');
INSERT INTO `sys_menu_permission` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '76', '控制台（科室）-病案首页合格率占比（首页）');
INSERT INTO `sys_menu_permission` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '30', '77', '控制台（科室）-科室缺陷占比-缺陷明细');
INSERT INTO `sys_menu_permission` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '20', '89', '控制台-条目缺陷占比（内页）');
INSERT INTO `sys_menu_permission` VALUES ('63', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '27', '90', '控制台（科室）-条目缺陷占比-科室（内页）');
INSERT INTO `sys_menu_permission` VALUES ('64', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '91', '控制台-各科室质控平均分（首页）-根据内外科系统统计');
INSERT INTO `sys_menu_permission` VALUES ('65', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31', '92', '控制台-各科室缺陷占比（内页）-根据内外科系统统计');
INSERT INTO `sys_menu_permission` VALUES ('66', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '20', '94', '数据报表明细-条目缺陷占比-条目缺陷占比质控详情页（全院）');
INSERT INTO `sys_menu_permission` VALUES ('67', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '27', '95', '数据报表明细（科室）-条目缺陷占比-条目缺陷占比质控详情页（科室）');
INSERT INTO `sys_menu_permission` VALUES ('68', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '96', '用户-医疗组-分页');
INSERT INTO `sys_menu_permission` VALUES ('69', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '97', '用户-医疗组-新增质控条目');
INSERT INTO `sys_menu_permission` VALUES ('70', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '98', '用户-医疗组-删除质控条目');
INSERT INTO `sys_menu_permission` VALUES ('71', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '99', '用户-医疗组-修改质控条目');
INSERT INTO `sys_menu_permission` VALUES ('72', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '34', '100', '数据报表明细-关键条目缺陷占比');
INSERT INTO `sys_menu_permission` VALUES ('73', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '101', '用户-质控评分-核查数据接口');
INSERT INTO `sys_menu_permission` VALUES ('74', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '101', '用户-质控评分(科室)-核查数据接口');
INSERT INTO `sys_menu_permission` VALUES ('75', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '101', '用户-质控评分(个人)-核查数据接口');
INSERT INTO `sys_menu_permission` VALUES ('76', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '101', '用户-医疗组-核查数据接口');
INSERT INTO `sys_menu_permission` VALUES ('77', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '35', '102', '数据报表明细-出院人数统计');
INSERT INTO `sys_menu_permission` VALUES ('78', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '36', '103', '数据报表明细-质控核查统计');

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '资源ID',
  `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
  `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
  `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '资源名称',
  `code` varchar(20) NOT NULL DEFAULT '' COMMENT '资源编码',
  `permissionUrl` varchar(255) NOT NULL DEFAULT '' COMMENT '资源Url',
  `method` varchar(255) NOT NULL DEFAULT 'ALL' COMMENT '资源允许的请求方式',
  `descritpion` varchar(255) NOT NULL DEFAULT '' COMMENT '资源描述',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8 COMMENT='系统资源表';

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
INSERT INTO `sys_permission` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户、机构、菜单信息', 'FUNC000001', '/sys/user/getUserOrgMenu', 'ALL', '基础功能-获取用户、机构、菜单信息', null);
INSERT INTO `sys_permission` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改密码', 'FUNC000002', '/sys/user/midifyPassword', 'ALL', '基础功能-修改密码', null);
INSERT INTO `sys_permission` VALUES ('3', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院模块数据信息', 'FUNC000003', '/qc/cases/getQcCases', 'ALL', '用户-基础数据维护-获取医院模块数据信息', '无需加密');
INSERT INTO `sys_permission` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改医院模块数据', 'FUNC000004', '/qc/cases/saveQcCases', 'ALL', '用户-基础数据维护-修改医院模块数据', null);
INSERT INTO `sys_permission` VALUES ('5', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页查询', 'FUNC000005', '/qc/behospitalInfo/page', 'ALL', '用户-质控评分-分页', '无需加密');
INSERT INTO `sys_permission` VALUES ('6', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页获取医院条目数据信息', 'FUNC000006', '/qc/casesEntryHospital/getQcCasesEntryAll', 'ALL', '用户-条目数据维护-分页获取医院条目数据信息', '无需加密');
INSERT INTO `sys_permission` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改医院条目数据信息', 'FUNC000007', '/qc/casesEntryHospital/updataQcCasesEntry', 'ALL', '用户-条目数据维护-修改医院条目数据信息', null);
INSERT INTO `sys_permission` VALUES ('8', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院模块下拉数据列表', 'FUNC000008', '/qc/casesEntryHospital/getQcCasesAll', 'ALL', '获取医院模块数据列表', '无需加密');
INSERT INTO `sys_permission` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病历相关统计', 'FUNC000009', '/console/mrStatistics', 'ALL', '控制台-病历相关统计', null);
INSERT INTO `sys_permission` VALUES ('10', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '模糊查询医院模块条目列表', 'FUNC000010', '/qc/casesEntryHospital/findQcCasesEntry', 'ALL', '用户-条目数据维护-模糊查询医院模块条目列表', null);
INSERT INTO `sys_permission` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增质控条目', 'FUNC000011', '/qc/behospitalInfo/addCase', 'ALL', '用户-质控评分-新增质控条目', null);
INSERT INTO `sys_permission` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除质控条目', 'FUNC000012', '/qc/behospitalInfo/delCase', 'ALL', '用户-质控评分-删除质控条目', null);
INSERT INTO `sys_permission` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改质控条目', 'FUNC000013', '/qc/behospitalInfo/updCase', 'ALL', '用户-质控评分-修改质控条目', null);
INSERT INTO `sys_permission` VALUES ('14', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取质控评分详情', 'FUNC000014', '/qc/behospitalInfo/getByBehospitalCode', 'ALL', '用户-质控评分-获取详情', '无需加密');
INSERT INTO `sys_permission` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '缺陷相关统计', 'FUNC000015', '/console/resultStatistics', 'ALL', '控制台-缺陷相关统计', null);
INSERT INTO `sys_permission` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '平均值相关统计', 'FUNC000016', '/console/averageStatistics', 'ALL', '控制台-平均值相关统计', null);
INSERT INTO `sys_permission` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', 'FUNC000017', '/qc/behospitalInfo/analyze', 'ALL', '用户-质控评分-评分', null);
INSERT INTO `sys_permission` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取角色列表信息', 'FUNC000018', '/sys/role/list', 'ALL', '用户-权限管理-角色管理-获取角色列表信息', null);
INSERT INTO `sys_permission` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取角色菜权限单等数据', 'FUNC000019', '/sys/role/getRoleMenu', 'ALL', '用户-权限管理-角色管理-获取角色菜权限单等数据', null);
INSERT INTO `sys_permission` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改角色菜单权限数据', 'FUNC000020', '/sys/role/saveRoleMenu', 'ALL', '用户-权限管理-角色管理-修改角色菜单权限数据', null);
INSERT INTO `sys_permission` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院科室下拉列表信息', 'FUNC000021', '/bas/dept/listForUser', 'ALL', '用户-权限管理-用户管理-获取用户管理下医院科室下拉列表信息', null);
INSERT INTO `sys_permission` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取角色下拉列表信息', 'FUNC000022', '/sys/role/listForUser', 'ALL', '用户-权限管理-用户管理-获取角色下拉列表信息', null);
INSERT INTO `sys_permission` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '用户列表翻页信息查询', 'FUNC000023', '/sys/user/userPage', 'ALL', '用户-权限管理-用户管理-用户列表翻页信息查询', null);
INSERT INTO `sys_permission` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户科室', 'FUNC000024', '/sys/user/getUserDepts', 'ALL', '用户-权限管理-用户管理-获取用户科室', null);
INSERT INTO `sys_permission` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户角色', 'FUNC000025', '/sys/user/getUserRoles', 'ALL', '用户-权限管理-用户管理-获取用户角色', null);
INSERT INTO `sys_permission` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '用户启用', 'FUNC000026', '/sys/user/enable', 'ALL', '用户-权限管理-用户管理-用户启用', null);
INSERT INTO `sys_permission` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '用户停用', 'FUNC000027', '/sys/user/disable', 'ALL', '用户-权限管理-用户管理-用户停用', null);
INSERT INTO `sys_permission` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '编辑用户科室', 'FUNC000028', '/sys/user/editUserDepts', 'ALL', '用户-权限管理-用户管理-编辑用户科室', null);
INSERT INTO `sys_permission` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '编辑用户角色', 'FUNC000029', '/sys/user/editUserRoles', 'ALL', '用户-权限管理-用户管理-编辑用户角色', null);
INSERT INTO `sys_permission` VALUES ('30', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院科室下拉列表信息', 'FUNC000030', '/bas/dept/getList', 'ALL', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息', '无需加密');
INSERT INTO `sys_permission` VALUES ('31', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户科室下拉列表信息', 'FUNC000031', '/bas/dept/getListUser', 'ALL', '用户-质控评分(科室)-获取病历质控一览下用户科室下拉列表信息', '无需加密');
INSERT INTO `sys_permission` VALUES ('32', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页查询', 'FUNC000032', '/qc/behospitalInfo/page_dept', 'ALL', '用户-质控评分(科室)-分页', '无需加密');
INSERT INTO `sys_permission` VALUES ('33', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页查询', 'FUNC000033', '/qc/behospitalInfo/page_person', 'ALL', '用户-质控评分(个人)-分页', '无需加密');
INSERT INTO `sys_permission` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', 'FUNC000017', '/qc/behospitalInfo/analyze', 'ALL', '用户-质控评分(科室)-评分', null);
INSERT INTO `sys_permission` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增质控条目', 'FUNC000011', '/qc/behospitalInfo/addCase', 'ALL', '用户-质控评分(科室)-新增质控条目', null);
INSERT INTO `sys_permission` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除质控条目', 'FUNC000012', '/qc/behospitalInfo/delCase', 'ALL', '用户-质控评分(科室)-删除质控条目', null);
INSERT INTO `sys_permission` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改质控条目', 'FUNC000013', '/qc/behospitalInfo/updCase', 'ALL', '用户-质控评分(科室)-修改质控条目', null);
INSERT INTO `sys_permission` VALUES ('38', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取质控评分详情', 'FUNC000014', '/qc/behospitalInfo/getByBehospitalCode', 'ALL', '用户-质控评分(科室)-获取详情', '无需加密');
INSERT INTO `sys_permission` VALUES ('39', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取用户科室下拉列表信息', 'FUNC000031', '/bas/dept/getListUser', 'ALL', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息', '无需加密');
INSERT INTO `sys_permission` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', 'FUNC000017', '/qc/behospitalInfo/analyze', 'ALL', '用户-质控评分(个人)-评分', null);
INSERT INTO `sys_permission` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增质控条目', 'FUNC000011', '/qc/behospitalInfo/addCase', 'ALL', '用户-质控评分(个人)-新增质控条目', null);
INSERT INTO `sys_permission` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除质控条目', 'FUNC000012', '/qc/behospitalInfo/delCase', 'ALL', '用户-质控评分(个人)-删除质控条目', null);
INSERT INTO `sys_permission` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改质控条目', 'FUNC000013', '/qc/behospitalInfo/updCase', 'ALL', '用户-质控评分(个人)-修改质控条目', null);
INSERT INTO `sys_permission` VALUES ('44', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取质控评分详情', 'FUNC000014', '/qc/behospitalInfo/getByBehospitalCode', 'ALL', '用户-质控评分(个人)-获取详情', '无需加密');
INSERT INTO `sys_permission` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '平均住院天数', 'FUNC000045', '/console/getAverageDayNum', 'ALL', '控制台-平均住院天数', null);
INSERT INTO `sys_permission` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '平均住院费用', 'FUNC000046', '/console/getAverageFee', 'ALL', '控制台-平均住院费用', null);
INSERT INTO `sys_permission` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控平均分按科室统计', 'FUNC000047', '/console/getAverageScore', 'ALL', '控制台-质控平均分按科室统计', null);
INSERT INTO `sys_permission` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室甲级病历占比', 'FUNC000048', '/console/getLevelResultDept', 'ALL', '控制台-各科室甲级病历占比', null);
INSERT INTO `sys_permission` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计', 'FUNC000049', '/console/leaveHosCount', 'ALL', '控制台-出院人数统计', null);
INSERT INTO `sys_permission` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控病历统计', 'FUNC000050', '/console/mrCount', 'ALL', '控制台-质控病历统计', null);
INSERT INTO `sys_permission` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比排行', 'FUNC000051', '/console/entryCountGroupByCase', 'ALL', '控制台-各模块缺陷占比排行', null);
INSERT INTO `sys_permission` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比', 'FUNC000052', '/console/entryCountGroupByEntry', 'ALL', '控制台-条目缺陷占比', null);
INSERT INTO `sys_permission` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比', 'FUNC000053', '/console/entryByDept', 'ALL', '控制台-各科室缺陷占比', null);
INSERT INTO `sys_permission` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计（科室）', 'FUNC000054', '/consoleByDept/leaveHosCountByDept', 'ALL', '控制台（科室）-出院人数统计（科室）', null);
INSERT INTO `sys_permission` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控病历数统计（科室）', 'FUNC000055', '/consoleByDept/mrCountByDept', 'ALL', '控制台（科室）-质控病历数统计（科室）', null);
INSERT INTO `sys_permission` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比排行（科室）', 'FUNC000056', '/consoleByDept/entryCountGroupByCaseAndDept', 'ALL', '控制台（科室）-各模块缺陷占比排行（科室）', null);
INSERT INTO `sys_permission` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比（科室）', 'FUNC000057', '/consoleByDept/entryCountGroupByEntryAndDept', 'ALL', '控制台（科室）-条目缺陷占比（科室）', null);
INSERT INTO `sys_permission` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '查询用户关联科室', 'FUNC000058', '/consoleByDept/getDept', 'ALL', '控制台（科室）-查询用户关联科室', null);
INSERT INTO `sys_permission` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比_详情', 'FUNC000059', '/console/entryCountGroupByCasePage', 'ALL', '控制台-各模块缺陷占比_详情', null);
INSERT INTO `sys_permission` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比_详情', 'FUNC000060', '/console/entryCountGroupByEntryPage', 'ALL', '控制台-条目缺陷占比_详情', null);
INSERT INTO `sys_permission` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '查询异常数据监控信息', 'FUNC000061', '/qc/abnormal/getQcAnnormal', 'ALL', '异常数据监控-查询异常数据监控信息', null);
INSERT INTO `sys_permission` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '更新异常数据监控信息', 'FUNC000062', '/qc/abnormal/saveQcAnnormal', 'ALL', '异常数据监控-异常数据监控-查询异常数据监控信息', null);
INSERT INTO `sys_permission` VALUES ('63', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除异常数据监控信息', 'FUNC000063', '/qc/abnormal/delQcAnnormal', 'ALL', '异常数据监控-异常数据监控-删除异常数据监控信息', null);
INSERT INTO `sys_permission` VALUES ('64', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室平均住院天数_详情', 'FUNC000064', '/console/getAverageDayNumPage', 'ALL', '控制台-科室平均住院天数_详情', null);
INSERT INTO `sys_permission` VALUES ('65', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室平均住院花费_详情', 'FUNC000065', '/console/getAverageFeePage', 'ALL', '控制台-科室平均住院花费_详情', null);
INSERT INTO `sys_permission` VALUES ('66', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室质控平均分_详情', 'FUNC000066', '/console/getAverageScoreByDeptPage', 'ALL', '控制台-各科室质控平均分_详情', null);
INSERT INTO `sys_permission` VALUES ('67', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比-缺陷详情', 'FUNC000067', '/console/resultStatisticsByDeptPage', 'ALL', '控制台-各科室缺陷占比-缺陷详情', null);
INSERT INTO `sys_permission` VALUES ('68', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室甲级病历占比_详情', 'FUNC000068', '/console/levelPercentGroupByDeptPage', 'ALL', '控制台-各科室甲级病历占比_详情', null);
INSERT INTO `sys_permission` VALUES ('69', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各模块缺陷占比_详情', 'FUNC000069', '/consoleByDept/entryCountGroupByCaseAndDeptPage', 'ALL', '控制台（科室）-各模块缺陷占比_详情', null);
INSERT INTO `sys_permission` VALUES ('70', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比_详情', 'FUNC000070', '/consoleByDept/entryCountGroupByEntryAndDeptPage', 'ALL', '控制台（科室）-条目缺陷占比_详情', null);
INSERT INTO `sys_permission` VALUES ('71', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比（组合）', 'FUNC000071', '/console/levelStatistics', 'ALL', '控制台-各科室缺陷占比（组合）', null);
INSERT INTO `sys_permission` VALUES ('72', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比', 'FUNC000072', '/console/homePageLevelStatistics', 'ALL', '控制台-病案首页合格率占比', null);
INSERT INTO `sys_permission` VALUES ('73', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比', 'FUNC000073', '/consoleByDept/levelStatisticsByDept', 'ALL', '控制台（科室）-各科室缺陷占比（科室）', null);
INSERT INTO `sys_permission` VALUES ('74', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比', 'FUNC000074', '/consoleByDept/homePageLevelStatisticsByDept', 'ALL', '控制台（科室）-病案首页合格率占比（科室）', null);
INSERT INTO `sys_permission` VALUES ('75', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比（首页）', 'FUNC000075', '/console/homePageLevelLimit', 'ALL', '控制台-病案首页合格率占比（首页）', null);
INSERT INTO `sys_permission` VALUES ('76', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病案首页合格率占比（首页）', 'FUNC000076', '/consoleByDept/homePageLevelByDeptLimit', 'ALL', '控制台（科室）-病案首页合格率占比（首页）', null);
INSERT INTO `sys_permission` VALUES ('77', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '科室缺陷占比-缺陷明细', 'FUNC000077', '/consoleByDept/resultStatisticsByDeptAndDoctorPage', 'ALL', '控制台（科室）-科室缺陷占比-缺陷明细', null);
INSERT INTO `sys_permission` VALUES ('78', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分页列表', 'FUNC000078', '/qc/qcType/page', 'ALL', '用户-质控类型维护-分页列表', null);
INSERT INTO `sys_permission` VALUES ('79', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增或更新', 'FUNC000079', '/qc/qcType/saveOrUpdate', 'ALL', '用户-质控类型维护-新增或更新', null);
INSERT INTO `sys_permission` VALUES ('80', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增时质控条目分组信息', 'FUNC000080', '/qc/qcType/getEntryByHospital', 'ALL', '用户-质控类型维护-新增时质控条目分组信息', null);
INSERT INTO `sys_permission` VALUES ('81', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控条目检索', 'FUNC000081', '/qc/qcType/index', 'ALL', '用户-质控类型维护-质控条目检索', null);
INSERT INTO `sys_permission` VALUES ('82', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除', 'FUNC000082', '/qc/qcType/delete', 'ALL', '用户-质控类型维护-删除', null);
INSERT INTO `sys_permission` VALUES ('83', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '根据id返回内容', 'FUNC000083', '/qc/qcType/getById', 'ALL', '用户-质控类型维护-根据id返回内容', null);
INSERT INTO `sys_permission` VALUES ('84', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院数据全部条目', 'FUNC000084', '/qc/modelHospital/getModelHospitalAll', 'ALL', '用户-质控类型维护-获取医院数据全部条目', null);
INSERT INTO `sys_permission` VALUES ('85', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '根据id获取医院数据', 'FUNC000085', '/qc/modelHospital/getModelHospitalById', 'ALL', '用户-质控类型维护-根据id获取医院数据', null);
INSERT INTO `sys_permission` VALUES ('86', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '添加和修改医院数据模块', 'FUNC000086', '/qc/modelHospital/saveAndupdataModel', 'ALL', '用户-质控类型维护-添加和修改医院数据模块', null);
INSERT INTO `sys_permission` VALUES ('87', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除医院数据模块', 'FUNC000087', '/qc/modelHospital/clearModelHospital', 'ALL', '用户-质控类型维护-删除医院数据模块', null);
INSERT INTO `sys_permission` VALUES ('88', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '获取医院全部模块', 'FUNC0000888', '/qc/mode/getModes', 'ALL', '用户-质控类型维护-获取医院全部模块', null);
INSERT INTO `sys_permission` VALUES ('89', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比（内页）', 'FUNC000089', '/console/entryGroupByEntryInnerPage', 'ALL', '控制台-条目缺陷占比（内页）', null);
INSERT INTO `sys_permission` VALUES ('90', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比-科室（内页）', 'FUNC000090', '/consoleByDept/entryGroupByEntryAndDeptInnerPage', 'ALL', '控制台（科室）-条目缺陷占比-科室（内页）', null);
INSERT INTO `sys_permission` VALUES ('91', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室质控平均分（首页）-根据内外科系统统计', 'FUNC000091', '/console/getAverageScoreByDeptClass', 'ALL', '控制台-各科室质控平均分（首页）-根据内外科系统统计', null);
INSERT INTO `sys_permission` VALUES ('92', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各科室缺陷占比（内页）-根据内外科系统统计', 'FUNC000092', '/console/levelStatisticsByDeptClass', 'ALL', '控制台-各科室缺陷占比（内页）-根据内外科系统统计', null);
INSERT INTO `sys_permission` VALUES ('93', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '根据id查询数据模块信息', 'FUNC000093', '/qc/abnormal/getQcAnnormalMode', 'ALL', '异常数据监控-异常数据监控-根据id查询数据模块信息', null);
INSERT INTO `sys_permission` VALUES ('94', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比质控详情页（全院）', 'FUNC000094', '/console/qcResultShortPage', 'ALL', '数据报表明细-条目缺陷占比-条目缺陷占比质控详情页（全院）', null);
INSERT INTO `sys_permission` VALUES ('95', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目缺陷占比质控详情页（科室）', 'FUNC000095', '/consoleByDept/qcResultShortByDeptPage', 'ALL', '数据报表明细（科室）-条目缺陷占比-条目缺陷占比质控详情页（科室）', null);
INSERT INTO `sys_permission` VALUES ('96', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控评分', 'FUNC000017', '/qc/behospitalInfo/analyze', 'ALL', '用户-医疗组-评分', null);
INSERT INTO `sys_permission` VALUES ('97', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '新增质控条目', 'FUNC000011', '/qc/behospitalInfo/addCase', 'ALL', '用户-医疗组-新增质控条目', null);
INSERT INTO `sys_permission` VALUES ('98', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '删除质控条目', 'FUNC000012', '/qc/behospitalInfo/delCase', 'ALL', '用户-医疗组-删除质控条目', null);
INSERT INTO `sys_permission` VALUES ('99', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '修改质控条目', 'FUNC000013', '/qc/behospitalInfo/updCase', 'ALL', '用户-医疗组-修改质控条目', null);
INSERT INTO `sys_permission` VALUES ('100', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '关键条目缺陷占比', 'FUNC000100', '/console/entryStatistics', 'ALL', '数据报表明细-关键条目缺陷占比', null);
INSERT INTO `sys_permission` VALUES ('101', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '核查数据接口', 'FUNC000014', '/qc/medCheckInfo/addMedCheckInfo', 'ALL', '用户-核查数据接口', null);
INSERT INTO `sys_permission` VALUES ('102', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '出院人数统计', 'FUNC000102', '/console/leaveHosMRPage', 'ALL', '数据报表明细-出院人数统计', null);
INSERT INTO `sys_permission` VALUES ('103', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控核查统计', 'FUNC000103', '/console/qcCheckStatistics', 'ALL', '数据表白明细-质控核查统计', null);

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
  `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
  `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '角色名称',
  `roleLevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级',
  `descritpion` varchar(255) NOT NULL DEFAULT '' COMMENT '角色描述',
  `menuItems` varchar(255) NOT NULL DEFAULT '' COMMENT '菜单ID：对应角色ID(暂无用处)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('-1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '超级管理员', '0', '', '', '');
INSERT INTO `sys_role` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(全局)', '0', '', '', '');
INSERT INTO `sys_role` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(科室)', '0', '', '', null);
INSERT INTO `sys_role` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(个人)', '0', '', '', null);

-- ----------------------------
-- 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 COMMENT '主键',
  `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
  `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
  `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id',
  `menu_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '菜单id',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=829 DEFAULT CHARSET=utf8 COMMENT='角色和菜单的映射表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '4', null);
INSERT INTO `sys_role_menu` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '9', null);
INSERT INTO `sys_role_menu` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '10', null);
INSERT INTO `sys_role_menu` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '12', null);
INSERT INTO `sys_role_menu` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '13', null);
INSERT INTO `sys_role_menu` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '14', null);
INSERT INTO `sys_role_menu` VALUES ('499', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '15', null);
INSERT INTO `sys_role_menu` VALUES ('543', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('544', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('545', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('546', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('547', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('548', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('549', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('550', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '16', '用户-异常数据监控');
INSERT INTO `sys_role_menu` VALUES ('551', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '17', '用户-质控科');
INSERT INTO `sys_role_menu` VALUES ('552', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '18', '用户-科室主任');
INSERT INTO `sys_role_menu` VALUES ('553', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '19', '用户-质控科-各模块缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('554', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '20', '用户-质控科-条目缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('555', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '21', '用户-质控科-科室平均住院天数_详情');
INSERT INTO `sys_role_menu` VALUES ('556', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '22', '用户-质控科-科室平均住院花费_详情');
INSERT INTO `sys_role_menu` VALUES ('557', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '23', '用户-质控科-各科室质控平均分_详情');
INSERT INTO `sys_role_menu` VALUES ('558', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '24', '用户-质控科-各科室缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('559', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '25', '用户-质控科-各科室甲级病历占比_详情');
INSERT INTO `sys_role_menu` VALUES ('560', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '26', '用户-科室主任-各模块缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('561', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '27', '用户-科室主任-条目缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('562', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '15', null);
INSERT INTO `sys_role_menu` VALUES ('563', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '8', null);
INSERT INTO `sys_role_menu` VALUES ('564', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '2', null);
INSERT INTO `sys_role_menu` VALUES ('565', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '5', null);
INSERT INTO `sys_role_menu` VALUES ('566', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '6', null);
INSERT INTO `sys_role_menu` VALUES ('567', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '3', null);
INSERT INTO `sys_role_menu` VALUES ('568', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '10', null);
INSERT INTO `sys_role_menu` VALUES ('569', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '15', null);
INSERT INTO `sys_role_menu` VALUES ('570', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '8', null);
INSERT INTO `sys_role_menu` VALUES ('571', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '2', null);
INSERT INTO `sys_role_menu` VALUES ('572', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '5', null);
INSERT INTO `sys_role_menu` VALUES ('573', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '6', null);
INSERT INTO `sys_role_menu` VALUES ('574', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '3', null);
INSERT INTO `sys_role_menu` VALUES ('575', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '9', null);
INSERT INTO `sys_role_menu` VALUES ('576', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '17', '用户-质控科');
INSERT INTO `sys_role_menu` VALUES ('577', 'Y', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '18', '用户-科室主任');
INSERT INTO `sys_role_menu` VALUES ('578', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '19', '用户-质控科-各模块缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('579', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '20', '用户-质控科-条目缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('580', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '21', '用户-质控科-科室平均住院天数_详情');
INSERT INTO `sys_role_menu` VALUES ('581', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '22', '用户-质控科-科室平均住院花费_详情');
INSERT INTO `sys_role_menu` VALUES ('582', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '23', '用户-质控科-各科室质控平均分_详情');
INSERT INTO `sys_role_menu` VALUES ('583', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '24', '用户-质控科-各科室缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('584', 'Y', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '25', '用户-质控科-各科室甲级病历占比_详情');
INSERT INTO `sys_role_menu` VALUES ('585', 'Y', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '26', '用户-科室主任-各模块缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('586', 'Y', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '27', '用户-科室主任-条目缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('587', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '28', '用户-质控科-病案首页合格率占比_详情');
INSERT INTO `sys_role_menu` VALUES ('588', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '29', '用户-科室主任-病案首页合格率占比_详情');
INSERT INTO `sys_role_menu` VALUES ('589', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '30', '用户-科室主任-科室缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('590', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '31', '用户-质控科-各科室缺陷占比_详情');
INSERT INTO `sys_role_menu` VALUES ('591', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('592', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('593', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('594', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('595', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('596', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('597', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('598', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('599', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('600', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('601', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('602', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('603', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('604', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('605', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('606', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('607', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('608', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('609', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('610', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('611', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('612', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('613', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('614', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('615', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('616', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('617', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('618', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('619', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('620', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('621', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('622', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('623', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('624', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('625', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('626', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('627', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('628', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('629', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('630', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('631', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('632', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('633', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('634', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('635', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('636', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('637', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('638', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('639', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('640', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('641', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('642', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('643', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('644', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('645', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('646', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('647', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('648', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('649', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('650', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('651', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '32', '用户-基础数据维护-质控类型维护');
INSERT INTO `sys_role_menu` VALUES ('652', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('653', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '15', null);
INSERT INTO `sys_role_menu` VALUES ('654', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('655', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('656', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('657', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('658', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('659', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('660', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('661', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('662', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '18', null);
INSERT INTO `sys_role_menu` VALUES ('663', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '29', null);
INSERT INTO `sys_role_menu` VALUES ('664', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '26', null);
INSERT INTO `sys_role_menu` VALUES ('665', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '27', null);
INSERT INTO `sys_role_menu` VALUES ('666', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '30', null);
INSERT INTO `sys_role_menu` VALUES ('667', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('668', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('669', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('670', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('671', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('672', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('673', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('674', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '15', null);
INSERT INTO `sys_role_menu` VALUES ('675', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('676', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('677', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('678', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('679', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('680', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('681', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('682', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('683', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '18', null);
INSERT INTO `sys_role_menu` VALUES ('684', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '29', null);
INSERT INTO `sys_role_menu` VALUES ('685', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '26', null);
INSERT INTO `sys_role_menu` VALUES ('686', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '27', null);
INSERT INTO `sys_role_menu` VALUES ('687', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '30', null);
INSERT INTO `sys_role_menu` VALUES ('688', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('689', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('690', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('691', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('692', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('693', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('694', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('695', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '15', null);
INSERT INTO `sys_role_menu` VALUES ('696', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('697', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('698', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('699', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('700', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('701', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('702', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('703', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('704', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '18', null);
INSERT INTO `sys_role_menu` VALUES ('705', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '29', null);
INSERT INTO `sys_role_menu` VALUES ('706', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '26', null);
INSERT INTO `sys_role_menu` VALUES ('707', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '27', null);
INSERT INTO `sys_role_menu` VALUES ('708', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '30', null);
INSERT INTO `sys_role_menu` VALUES ('709', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('710', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('711', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('712', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('713', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('714', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('715', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '1', null);
INSERT INTO `sys_role_menu` VALUES ('716', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '15', null);
INSERT INTO `sys_role_menu` VALUES ('717', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '18', null);
INSERT INTO `sys_role_menu` VALUES ('718', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '26', null);
INSERT INTO `sys_role_menu` VALUES ('719', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '27', null);
INSERT INTO `sys_role_menu` VALUES ('720', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '8', null);
INSERT INTO `sys_role_menu` VALUES ('721', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '2', null);
INSERT INTO `sys_role_menu` VALUES ('722', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '5', null);
INSERT INTO `sys_role_menu` VALUES ('723', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '6', null);
INSERT INTO `sys_role_menu` VALUES ('724', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '3', null);
INSERT INTO `sys_role_menu` VALUES ('725', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '9', null);
INSERT INTO `sys_role_menu` VALUES ('726', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('727', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '15', null);
INSERT INTO `sys_role_menu` VALUES ('728', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('729', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('730', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('731', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('732', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('733', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('734', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('735', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('736', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '18', null);
INSERT INTO `sys_role_menu` VALUES ('737', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '29', null);
INSERT INTO `sys_role_menu` VALUES ('738', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '26', null);
INSERT INTO `sys_role_menu` VALUES ('739', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '27', null);
INSERT INTO `sys_role_menu` VALUES ('740', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '30', null);
INSERT INTO `sys_role_menu` VALUES ('741', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('742', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('743', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('744', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('745', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('746', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('747', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('748', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '15', null);
INSERT INTO `sys_role_menu` VALUES ('749', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('750', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('751', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('752', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('753', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('754', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('755', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('756', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('757', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '18', null);
INSERT INTO `sys_role_menu` VALUES ('758', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '29', null);
INSERT INTO `sys_role_menu` VALUES ('759', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '26', null);
INSERT INTO `sys_role_menu` VALUES ('760', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '27', null);
INSERT INTO `sys_role_menu` VALUES ('761', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '30', null);
INSERT INTO `sys_role_menu` VALUES ('762', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('763', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('764', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('765', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('766', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('767', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('769', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '1', null);
INSERT INTO `sys_role_menu` VALUES ('770', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '15', null);
INSERT INTO `sys_role_menu` VALUES ('771', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '17', null);
INSERT INTO `sys_role_menu` VALUES ('772', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '28', null);
INSERT INTO `sys_role_menu` VALUES ('773', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '19', null);
INSERT INTO `sys_role_menu` VALUES ('774', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '20', null);
INSERT INTO `sys_role_menu` VALUES ('775', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '21', null);
INSERT INTO `sys_role_menu` VALUES ('776', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '22', null);
INSERT INTO `sys_role_menu` VALUES ('777', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '25', null);
INSERT INTO `sys_role_menu` VALUES ('778', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '31', null);
INSERT INTO `sys_role_menu` VALUES ('779', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '33', null);
INSERT INTO `sys_role_menu` VALUES ('780', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '18', null);
INSERT INTO `sys_role_menu` VALUES ('781', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '29', null);
INSERT INTO `sys_role_menu` VALUES ('782', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '26', null);
INSERT INTO `sys_role_menu` VALUES ('783', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '27', null);
INSERT INTO `sys_role_menu` VALUES ('784', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '30', null);
INSERT INTO `sys_role_menu` VALUES ('785', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '8', null);
INSERT INTO `sys_role_menu` VALUES ('786', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '2', null);
INSERT INTO `sys_role_menu` VALUES ('787', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '5', null);
INSERT INTO `sys_role_menu` VALUES ('788', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '6', null);
INSERT INTO `sys_role_menu` VALUES ('789', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '3', null);
INSERT INTO `sys_role_menu` VALUES ('790', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '7', null);
INSERT INTO `sys_role_menu` VALUES ('791', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '8', null);
INSERT INTO `sys_role_menu` VALUES ('792', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '3', null);
INSERT INTO `sys_role_menu` VALUES ('793', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '10', null);
INSERT INTO `sys_role_menu` VALUES ('794', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '8', null);
INSERT INTO `sys_role_menu` VALUES ('795', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '3', null);
INSERT INTO `sys_role_menu` VALUES ('796', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '9', null);
INSERT INTO `sys_role_menu` VALUES ('797', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '1', null);
INSERT INTO `sys_role_menu` VALUES ('798', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '15', null);
INSERT INTO `sys_role_menu` VALUES ('799', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '17', null);
INSERT INTO `sys_role_menu` VALUES ('800', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '28', null);
INSERT INTO `sys_role_menu` VALUES ('801', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '19', null);
INSERT INTO `sys_role_menu` VALUES ('802', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '20', null);
INSERT INTO `sys_role_menu` VALUES ('803', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '21', null);
INSERT INTO `sys_role_menu` VALUES ('804', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '22', null);
INSERT INTO `sys_role_menu` VALUES ('805', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '25', null);
INSERT INTO `sys_role_menu` VALUES ('806', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '31', null);
INSERT INTO `sys_role_menu` VALUES ('807', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '18', null);
INSERT INTO `sys_role_menu` VALUES ('808', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '29', null);
INSERT INTO `sys_role_menu` VALUES ('809', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '26', null);
INSERT INTO `sys_role_menu` VALUES ('810', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '27', null);
INSERT INTO `sys_role_menu` VALUES ('811', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '30', null);
INSERT INTO `sys_role_menu` VALUES ('812', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '8', null);
INSERT INTO `sys_role_menu` VALUES ('813', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '2', null);
INSERT INTO `sys_role_menu` VALUES ('814', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '5', null);
INSERT INTO `sys_role_menu` VALUES ('815', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '6', null);
INSERT INTO `sys_role_menu` VALUES ('816', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '3', null);
INSERT INTO `sys_role_menu` VALUES ('817', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '7', null);
INSERT INTO `sys_role_menu` VALUES ('818', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '9', null);
INSERT INTO `sys_role_menu` VALUES ('819', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '10', null);
INSERT INTO `sys_role_menu` VALUES ('820', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', '33', null);
INSERT INTO `sys_role_menu` VALUES ('821', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '8', null);
INSERT INTO `sys_role_menu` VALUES ('822', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '3', null);
INSERT INTO `sys_role_menu` VALUES ('823', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '10', null);
INSERT INTO `sys_role_menu` VALUES ('824', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '33', null);
INSERT INTO `sys_role_menu` VALUES ('825', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '33', null);
INSERT INTO `sys_role_menu` VALUES ('826', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '34', '用户-质控科-关键条目缺陷占比');
INSERT INTO `sys_role_menu` VALUES ('827', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '35', '用户-质控科-出院人数统计');
INSERT INTO `sys_role_menu` VALUES ('828', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '36', '用户-质控科-质控核查统计');

-- ----------------------------
-- Table structure for sys_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
  `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
  `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id',
  `permission_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '资源id',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1660 DEFAULT CHARSET=utf8 COMMENT='角色和资源的映射表';

-- ----------------------------
-- Records of sys_role_permission
-- ----------------------------
INSERT INTO `sys_role_permission` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '基础功能-获取用户、机构、菜单信息');
INSERT INTO `sys_role_permission` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '2', '基础功能-修改密码');
INSERT INTO `sys_role_permission` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '3', '用户-基础数据维护-获取医院模块数据信息');
INSERT INTO `sys_role_permission` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '4', '用户-基础数据维护-批量更新模块数据');
INSERT INTO `sys_role_permission` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '5', '用户-质控评分-分页');
INSERT INTO `sys_role_permission` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '6', '用户-条目数据维护-分页获取医院条目数据信息');
INSERT INTO `sys_role_permission` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '7', '用户-条目数据维护-修改医院条目数据信息');
INSERT INTO `sys_role_permission` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '8', '用户-条目数据维护-获取医院模块数据列表');
INSERT INTO `sys_role_permission` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '9', '控制台-病历相关统计');
INSERT INTO `sys_role_permission` VALUES ('27', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '10', '用户-条目数据维护-模糊查询医院模块条目列表');
INSERT INTO `sys_role_permission` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '11', '用户-质控评分-新增质控条目');
INSERT INTO `sys_role_permission` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '12', '用户-质控评分-删除质控条目');
INSERT INTO `sys_role_permission` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '13', '用户-质控评分-修改质控条目');
INSERT INTO `sys_role_permission` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '14', '用户-质控评分-获取详情');
INSERT INTO `sys_role_permission` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '15', '控制台-缺陷相关统计');
INSERT INTO `sys_role_permission` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '16', '控制台-医院运营相关统计');
INSERT INTO `sys_role_permission` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '17', '用户-质控评分-评分');
INSERT INTO `sys_role_permission` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '18', '用户-权限管理-角色管理-获取角色列表信息');
INSERT INTO `sys_role_permission` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '19', '用户-权限管理-角色管理-获取角色菜权限单等数据');
INSERT INTO `sys_role_permission` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '20', '用户-权限管理-角色管理-修改角色菜单权限数据');
INSERT INTO `sys_role_permission` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '21', '用户-权限管理-用户管理-获取医院科室下拉列表信息');
INSERT INTO `sys_role_permission` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '22', '用户-权限管理-用户管理-获取角色下拉列表信息');
INSERT INTO `sys_role_permission` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '23', '用户-权限管理-用户管理-用户列表翻页信息查询');
INSERT INTO `sys_role_permission` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '24', '用户-权限管理-用户管理-获取用户科室');
INSERT INTO `sys_role_permission` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '25', '用户-权限管理-用户管理-获取用户角色');
INSERT INTO `sys_role_permission` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '26', '用户-权限管理-用户管理-用户启用');
INSERT INTO `sys_role_permission` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '27', '用户-权限管理-用户管理-用户停用');
INSERT INTO `sys_role_permission` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '28', '用户-权限管理-用户管理-编辑用户科室');
INSERT INTO `sys_role_permission` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '29', '用户-权限管理-用户管理-编辑用户角色');
INSERT INTO `sys_role_permission` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '30', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息');
INSERT INTO `sys_role_permission` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '31', '用户-质控评分-获取病历质控一览下用户科室下拉列表信息');
INSERT INTO `sys_role_permission` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '32', '用户-质控评分(科室)-分页');
INSERT INTO `sys_role_permission` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '33', '用户-质控评分(个人)-分页');
INSERT INTO `sys_role_permission` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '34', '用户-质控评分(科室)-评分');
INSERT INTO `sys_role_permission` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '35', '用户-质控评分(科室)-新增质控条目');
INSERT INTO `sys_role_permission` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '36', '用户-质控评分(科室)-删除质控条目');
INSERT INTO `sys_role_permission` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '37', '用户-质控评分(科室)-修改质控条目');
INSERT INTO `sys_role_permission` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '38', '用户-质控评分(科室)-获取详情');
INSERT INTO `sys_role_permission` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '39', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息');
INSERT INTO `sys_role_permission` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '40', '用户-质控评分(科室)-评分');
INSERT INTO `sys_role_permission` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '41', '用户-质控评分(科室)-新增质控条目');
INSERT INTO `sys_role_permission` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '42', '用户-质控评分(科室)-删除质控条目');
INSERT INTO `sys_role_permission` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '43', '用户-质控评分(科室)-修改质控条目');
INSERT INTO `sys_role_permission` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '44', '用户-质控评分(科室)-获取详情');
INSERT INTO `sys_role_permission` VALUES ('502', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '45', '控制台-平均住院天数');
INSERT INTO `sys_role_permission` VALUES ('503', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '46', '控制台-平均住院费用');
INSERT INTO `sys_role_permission` VALUES ('504', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '47', '控制台-质控平均分按科室统计');
INSERT INTO `sys_role_permission` VALUES ('505', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '48', '控制台-各科室甲级病历占比');
INSERT INTO `sys_role_permission` VALUES ('506', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '49', '控制台-出院人数统计');
INSERT INTO `sys_role_permission` VALUES ('507', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '50', '控制台-质控病历统计');
INSERT INTO `sys_role_permission` VALUES ('508', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '51', '控制台-各模块缺陷占比排行');
INSERT INTO `sys_role_permission` VALUES ('509', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '52', '控制台-条目缺陷占比');
INSERT INTO `sys_role_permission` VALUES ('510', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '53', '控制台-各科室缺陷占比');
INSERT INTO `sys_role_permission` VALUES ('511', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '54', '控制台（科室）-出院人数统计（科室）');
INSERT INTO `sys_role_permission` VALUES ('512', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '55', '控制台（科室）-质控病历数统计（科室）');
INSERT INTO `sys_role_permission` VALUES ('513', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '56', '控制台（科室）-各模块缺陷占比排行（科室）');
INSERT INTO `sys_role_permission` VALUES ('514', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '57', '控制台（科室）-条目缺陷占比（科室）');
INSERT INTO `sys_role_permission` VALUES ('1164', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1165', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1166', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1167', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1168', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1169', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1170', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1171', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1172', 'N', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1173', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1174', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1175', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1176', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1177', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1178', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1179', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1180', 'Y', '2020-05-14 13:31:16', '2020-05-21 14:52:33', '1', '12', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1182', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '59', '控制台-各模块缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1183', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '60', '控制台-条目缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1184', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '61', '异常数据监控-查询异常数据监控信息');
INSERT INTO `sys_role_permission` VALUES ('1185', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '62', '异常数据监控-异常数据监控-查询异常数据监控信息');
INSERT INTO `sys_role_permission` VALUES ('1186', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '63', '异常数据监控-异常数据监控-删除异常数据监控信息');
INSERT INTO `sys_role_permission` VALUES ('1187', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '64', '控制台-科室平均住院天数_详情');
INSERT INTO `sys_role_permission` VALUES ('1188', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '65', '控制台-科室平均住院花费_详情');
INSERT INTO `sys_role_permission` VALUES ('1189', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '66', '控制台-各科室质控平均分_详情');
INSERT INTO `sys_role_permission` VALUES ('1190', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '67', '控制台-各科室缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1191', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '68', '控制台-各科室甲级病历占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1192', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '69', '控制台（科室）-各模块缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1193', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '70', '控制台（科室）-条目缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1194', 'Y', '2020-05-18 10:48:43', '2020-06-18 15:07:17', '1', '1', '3', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1195', 'Y', '2020-05-18 10:48:43', '2020-06-18 15:07:17', '1', '1', '3', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1196', 'Y', '2020-05-18 10:48:43', '2020-06-18 15:07:17', '1', '1', '3', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1197', 'Y', '2020-05-18 10:48:43', '2020-06-18 15:07:17', '1', '1', '3', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1199', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1200', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1201', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1202', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1203', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '40', null);
INSERT INTO `sys_role_permission` VALUES ('1204', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '41', null);
INSERT INTO `sys_role_permission` VALUES ('1205', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '42', null);
INSERT INTO `sys_role_permission` VALUES ('1206', 'Y', '2020-05-18 10:48:43', '2020-06-10 12:28:34', '1', '1', '3', '43', null);
INSERT INTO `sys_role_permission` VALUES ('1207', 'N', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1208', 'N', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1209', 'N', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1210', 'N', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1212', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1213', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1214', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1215', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1216', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '34', null);
INSERT INTO `sys_role_permission` VALUES ('1217', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '35', null);
INSERT INTO `sys_role_permission` VALUES ('1218', 'Y', '2020-05-18 10:48:51', '2020-06-03 19:19:39', '1', '1', '2', '36', null);
INSERT INTO `sys_role_permission` VALUES ('1219', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '59', '控制台-各模块缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1220', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '60', '控制台-条目缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1221', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '64', '控制台-科室平均住院天数_详情');
INSERT INTO `sys_role_permission` VALUES ('1222', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '65', '控制台-科室平均住院花费_详情');
INSERT INTO `sys_role_permission` VALUES ('1223', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '66', '控制台-各科室质控平均分_详情');
INSERT INTO `sys_role_permission` VALUES ('1224', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '67', '控制台-各科室缺陷占比-缺陷详情');
INSERT INTO `sys_role_permission` VALUES ('1225', 'N', '1970-01-01 12:00:00', '2020-05-21 14:52:33', '0', '12', '1', '68', '控制台-各科室甲级病历占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1226', 'N', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '69', '控制台（科室）-各模块缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1227', 'N', '1970-01-01 12:00:00', '2020-06-03 19:19:39', '0', '1', '2', '70', '控制台（科室）-条目缺陷占比_详情');
INSERT INTO `sys_role_permission` VALUES ('1228', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '71', '控制台-各科室缺陷占比（组合）');
INSERT INTO `sys_role_permission` VALUES ('1229', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '72', '控制台-病案首页合格率占比');
INSERT INTO `sys_role_permission` VALUES ('1230', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '73', '控制台（科室）-各科室缺陷占比（科室）');
INSERT INTO `sys_role_permission` VALUES ('1231', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '74', '控制台（科室）-病案首页合格率占比（科室）');
INSERT INTO `sys_role_permission` VALUES ('1232', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '75', '控制台-病案首页合格率占比（首页）');
INSERT INTO `sys_role_permission` VALUES ('1233', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '76', '控制台（科室）-病案首页合格率占比（首页）');
INSERT INTO `sys_role_permission` VALUES ('1234', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '77', '控制台（科室）-科室缺陷占比-缺陷明细');
INSERT INTO `sys_role_permission` VALUES ('1235', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1236', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1237', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1238', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1239', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1240', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1241', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1242', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1243', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1244', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1245', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1246', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1247', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1248', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '60', null);
INSERT INTO `sys_role_permission` VALUES ('1249', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1250', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1251', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1252', 'N', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1253', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1254', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1255', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1256', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1257', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1258', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1259', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1260', 'Y', '2020-05-21 14:52:33', '2020-05-21 14:55:27', '12', '1', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1261', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1262', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1263', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1264', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1265', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1266', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1267', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1268', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1269', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1270', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1271', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1272', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1273', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1274', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '60', null);
INSERT INTO `sys_role_permission` VALUES ('1275', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1276', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1277', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1278', 'N', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1279', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1280', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1281', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1282', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1283', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1284', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1285', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1286', 'Y', '2020-05-21 14:55:27', '2020-05-21 14:55:48', '1', '1', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1287', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1288', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1289', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1290', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1291', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1292', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1293', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1294', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1295', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1296', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1297', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1298', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1299', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1300', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '60', null);
INSERT INTO `sys_role_permission` VALUES ('1301', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1302', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1303', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1304', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1305', 'N', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1306', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1307', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1308', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1309', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1310', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1311', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1312', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1313', 'Y', '2020-05-21 14:55:48', '2020-05-21 14:55:59', '1', '1', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1314', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1315', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1316', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1317', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1318', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1319', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1320', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1321', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1322', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1323', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1324', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1325', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1326', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1327', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '60', null);
INSERT INTO `sys_role_permission` VALUES ('1328', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1329', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1330', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1331', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1332', 'N', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1333', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1334', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1335', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1336', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1337', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1338', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1339', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1340', 'Y', '2020-05-21 14:55:59', '2020-05-28 18:51:10', '1', '81', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1341', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '78', '用户-质控类型维护-分页列表');
INSERT INTO `sys_role_permission` VALUES ('1342', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '79', '用户-质控类型维护-新增或更新');
INSERT INTO `sys_role_permission` VALUES ('1343', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '80', '用户-质控类型维护-新增时质控条目分组信息');
INSERT INTO `sys_role_permission` VALUES ('1344', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '81', '用户-质控类型维护-质控条目检索');
INSERT INTO `sys_role_permission` VALUES ('1345', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '82', '用户-质控类型维护-删除');
INSERT INTO `sys_role_permission` VALUES ('1346', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '83', '用户-质控类型维护-根据id返回内容');
INSERT INTO `sys_role_permission` VALUES ('1347', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '84', '用户-质控类型维护-获取医院数据全部条目');
INSERT INTO `sys_role_permission` VALUES ('1348', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '85', '用户-质控类型维护-根据id获取医院数据');
INSERT INTO `sys_role_permission` VALUES ('1349', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '86', '用户-质控类型维护-添加和修改医院数据模块');
INSERT INTO `sys_role_permission` VALUES ('1350', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '87', '用户-质控类型维护-删除医院数据模块');
INSERT INTO `sys_role_permission` VALUES ('1351', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '88', '用户-质控类型维护-获取医院全部模块');
INSERT INTO `sys_role_permission` VALUES ('1352', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '89', '控制台-条目缺陷占比（内页）');
INSERT INTO `sys_role_permission` VALUES ('1353', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '90', '控制台（科室）-条目缺陷占比-科室（内页）');
INSERT INTO `sys_role_permission` VALUES ('1354', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1355', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1356', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1357', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1358', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1359', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1360', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1361', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1362', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1363', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1364', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1365', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1366', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1367', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1368', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1369', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '76', null);
INSERT INTO `sys_role_permission` VALUES ('1370', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1371', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1372', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1373', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1374', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1375', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1376', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1377', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '74', null);
INSERT INTO `sys_role_permission` VALUES ('1378', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '69', null);
INSERT INTO `sys_role_permission` VALUES ('1379', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '90', null);
INSERT INTO `sys_role_permission` VALUES ('1380', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '73', null);
INSERT INTO `sys_role_permission` VALUES ('1381', 'N', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '77', null);
INSERT INTO `sys_role_permission` VALUES ('1382', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1383', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1384', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1385', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1386', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1387', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1388', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1389', 'Y', '2020-05-28 18:51:10', '2020-06-01 15:19:58', '81', '81', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1390', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '91', '控制台-各科室质控平均分（首页）-根据内外科系统统计');
INSERT INTO `sys_role_permission` VALUES ('1391', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '92', '控制台-各科室缺陷占比（内页）-根据内外科系统统计');
INSERT INTO `sys_role_permission` VALUES ('1392', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1393', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1394', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1395', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1396', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1397', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1398', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1399', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1400', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1401', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1402', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1403', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1404', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1405', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1406', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '76', null);
INSERT INTO `sys_role_permission` VALUES ('1407', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1408', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1409', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1410', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1411', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1412', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1413', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1414', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '74', null);
INSERT INTO `sys_role_permission` VALUES ('1415', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '69', null);
INSERT INTO `sys_role_permission` VALUES ('1416', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '90', null);
INSERT INTO `sys_role_permission` VALUES ('1417', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '73', null);
INSERT INTO `sys_role_permission` VALUES ('1418', 'N', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '77', null);
INSERT INTO `sys_role_permission` VALUES ('1419', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1420', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1421', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1422', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1423', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1424', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1425', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1426', 'Y', '2020-06-01 15:19:58', '2020-06-01 17:26:05', '81', '81', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1427', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1428', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1429', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1430', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1431', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1432', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1433', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1434', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1435', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1436', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1437', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1438', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '91', null);
INSERT INTO `sys_role_permission` VALUES ('1439', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1440', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1441', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1442', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1443', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '76', null);
INSERT INTO `sys_role_permission` VALUES ('1444', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1445', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1446', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1447', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1448', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1449', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1450', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1451', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '74', null);
INSERT INTO `sys_role_permission` VALUES ('1452', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '69', null);
INSERT INTO `sys_role_permission` VALUES ('1453', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '90', null);
INSERT INTO `sys_role_permission` VALUES ('1454', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '73', null);
INSERT INTO `sys_role_permission` VALUES ('1455', 'N', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '77', null);
INSERT INTO `sys_role_permission` VALUES ('1456', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1457', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1458', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1459', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1460', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1461', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1462', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1463', 'Y', '2020-06-01 17:26:05', '2020-06-05 17:29:07', '81', '1', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1464', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '93', null);
INSERT INTO `sys_role_permission` VALUES ('1465', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1466', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1467', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1468', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1469', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1470', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1471', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1472', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1473', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1474', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1475', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1476', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '91', null);
INSERT INTO `sys_role_permission` VALUES ('1477', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1478', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1479', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1480', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1481', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '69', null);
INSERT INTO `sys_role_permission` VALUES ('1482', 'N', '2020-06-03 19:19:39', '2020-06-03 19:19:39', '1', '1', '2', '70', null);
INSERT INTO `sys_role_permission` VALUES ('1483', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1484', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1485', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1486', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1487', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '34', null);
INSERT INTO `sys_role_permission` VALUES ('1488', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '35', null);
INSERT INTO `sys_role_permission` VALUES ('1489', 'Y', '2020-06-03 19:19:39', '2020-06-17 11:20:45', '1', '1', '2', '36', null);
INSERT INTO `sys_role_permission` VALUES ('1490', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1491', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1492', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1493', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1494', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1495', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1496', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1497', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1498', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1499', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1500', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1501', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '91', null);
INSERT INTO `sys_role_permission` VALUES ('1502', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1503', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1504', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1505', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1506', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '76', null);
INSERT INTO `sys_role_permission` VALUES ('1507', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1508', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1509', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '60', null);
INSERT INTO `sys_role_permission` VALUES ('1510', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '89', null);
INSERT INTO `sys_role_permission` VALUES ('1511', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1512', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1513', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1514', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1515', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1516', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '74', null);
INSERT INTO `sys_role_permission` VALUES ('1517', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '69', null);
INSERT INTO `sys_role_permission` VALUES ('1518', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '90', null);
INSERT INTO `sys_role_permission` VALUES ('1519', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '73', null);
INSERT INTO `sys_role_permission` VALUES ('1520', 'N', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '77', null);
INSERT INTO `sys_role_permission` VALUES ('1521', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1522', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1523', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1524', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1525', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1526', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1527', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1528', 'Y', '2020-06-05 17:29:07', '2020-06-05 17:29:18', '1', '1', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1529', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1530', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1531', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1532', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1533', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1534', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1535', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1536', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1537', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1538', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1539', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1540', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '91', null);
INSERT INTO `sys_role_permission` VALUES ('1541', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1542', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1543', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1544', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1545', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '76', null);
INSERT INTO `sys_role_permission` VALUES ('1546', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1547', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1548', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '60', null);
INSERT INTO `sys_role_permission` VALUES ('1549', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '89', null);
INSERT INTO `sys_role_permission` VALUES ('1550', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1551', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1552', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1553', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1554', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1555', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '92', null);
INSERT INTO `sys_role_permission` VALUES ('1556', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '74', null);
INSERT INTO `sys_role_permission` VALUES ('1557', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '69', null);
INSERT INTO `sys_role_permission` VALUES ('1558', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '70', null);
INSERT INTO `sys_role_permission` VALUES ('1559', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '90', null);
INSERT INTO `sys_role_permission` VALUES ('1560', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '73', null);
INSERT INTO `sys_role_permission` VALUES ('1561', 'N', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '77', null);
INSERT INTO `sys_role_permission` VALUES ('1562', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1563', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1564', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1565', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1566', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1567', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1568', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1569', 'Y', '2020-06-05 17:29:18', '2020-06-08 20:04:56', '1', '27', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1570', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '45', null);
INSERT INTO `sys_role_permission` VALUES ('1571', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '46', null);
INSERT INTO `sys_role_permission` VALUES ('1572', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '47', null);
INSERT INTO `sys_role_permission` VALUES ('1573', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '48', null);
INSERT INTO `sys_role_permission` VALUES ('1574', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '49', null);
INSERT INTO `sys_role_permission` VALUES ('1575', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '50', null);
INSERT INTO `sys_role_permission` VALUES ('1576', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '51', null);
INSERT INTO `sys_role_permission` VALUES ('1577', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '52', null);
INSERT INTO `sys_role_permission` VALUES ('1578', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '53', null);
INSERT INTO `sys_role_permission` VALUES ('1579', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '66', null);
INSERT INTO `sys_role_permission` VALUES ('1580', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '75', null);
INSERT INTO `sys_role_permission` VALUES ('1581', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '91', null);
INSERT INTO `sys_role_permission` VALUES ('1582', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '54', null);
INSERT INTO `sys_role_permission` VALUES ('1583', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '55', null);
INSERT INTO `sys_role_permission` VALUES ('1584', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '56', null);
INSERT INTO `sys_role_permission` VALUES ('1585', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '57', null);
INSERT INTO `sys_role_permission` VALUES ('1586', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '76', null);
INSERT INTO `sys_role_permission` VALUES ('1587', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '72', null);
INSERT INTO `sys_role_permission` VALUES ('1588', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '59', null);
INSERT INTO `sys_role_permission` VALUES ('1589', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '60', null);
INSERT INTO `sys_role_permission` VALUES ('1590', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '89', null);
INSERT INTO `sys_role_permission` VALUES ('1591', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '64', null);
INSERT INTO `sys_role_permission` VALUES ('1592', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '65', null);
INSERT INTO `sys_role_permission` VALUES ('1593', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '68', null);
INSERT INTO `sys_role_permission` VALUES ('1594', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '67', null);
INSERT INTO `sys_role_permission` VALUES ('1595', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '71', null);
INSERT INTO `sys_role_permission` VALUES ('1596', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '92', null);
INSERT INTO `sys_role_permission` VALUES ('1597', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '74', null);
INSERT INTO `sys_role_permission` VALUES ('1598', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '69', null);
INSERT INTO `sys_role_permission` VALUES ('1599', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '70', null);
INSERT INTO `sys_role_permission` VALUES ('1600', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '90', null);
INSERT INTO `sys_role_permission` VALUES ('1601', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '73', null);
INSERT INTO `sys_role_permission` VALUES ('1602', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '77', null);
INSERT INTO `sys_role_permission` VALUES ('1603', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1604', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1605', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1606', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1607', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1608', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1609', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1610', 'N', '2020-06-08 20:04:56', '2020-06-08 20:04:56', '27', '27', '1', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1611', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1612', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1613', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '40', null);
INSERT INTO `sys_role_permission` VALUES ('1614', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '41', null);
INSERT INTO `sys_role_permission` VALUES ('1615', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '42', null);
INSERT INTO `sys_role_permission` VALUES ('1616', 'Y', '2020-06-10 12:28:34', '2020-06-18 15:07:17', '1', '1', '3', '43', null);
INSERT INTO `sys_role_permission` VALUES ('1617', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1618', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1619', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '34', null);
INSERT INTO `sys_role_permission` VALUES ('1620', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '35', null);
INSERT INTO `sys_role_permission` VALUES ('1621', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '36', null);
INSERT INTO `sys_role_permission` VALUES ('1622', 'N', '2020-06-10 16:02:43', '2020-06-10 16:02:43', '1', '1', '4', '37', null);
INSERT INTO `sys_role_permission` VALUES ('1623', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '94', '数据报表明细-条目缺陷占比-条目缺陷占比质控详情页（全院）');
INSERT INTO `sys_role_permission` VALUES ('1624', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '95', '数据报表明细（科室）-条目缺陷占比-条目缺陷占比质控详情页（科室）');
INSERT INTO `sys_role_permission` VALUES ('1625', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1626', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1627', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '4', null);
INSERT INTO `sys_role_permission` VALUES ('1628', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '7', null);
INSERT INTO `sys_role_permission` VALUES ('1629', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '17', null);
INSERT INTO `sys_role_permission` VALUES ('1630', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '11', null);
INSERT INTO `sys_role_permission` VALUES ('1631', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '12', null);
INSERT INTO `sys_role_permission` VALUES ('1632', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '13', null);
INSERT INTO `sys_role_permission` VALUES ('1633', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '34', null);
INSERT INTO `sys_role_permission` VALUES ('1634', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '35', null);
INSERT INTO `sys_role_permission` VALUES ('1635', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '36', null);
INSERT INTO `sys_role_permission` VALUES ('1636', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '37', null);
INSERT INTO `sys_role_permission` VALUES ('1637', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '40', null);
INSERT INTO `sys_role_permission` VALUES ('1638', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '41', null);
INSERT INTO `sys_role_permission` VALUES ('1639', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '42', null);
INSERT INTO `sys_role_permission` VALUES ('1640', 'N', '2020-06-17 11:20:45', '2020-06-17 11:20:45', '1', '1', '2', '43', null);
INSERT INTO `sys_role_permission` VALUES ('1641', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '1', null);
INSERT INTO `sys_role_permission` VALUES ('1642', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '2', null);
INSERT INTO `sys_role_permission` VALUES ('1643', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '40', null);
INSERT INTO `sys_role_permission` VALUES ('1644', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '41', null);
INSERT INTO `sys_role_permission` VALUES ('1645', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '42', null);
INSERT INTO `sys_role_permission` VALUES ('1646', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '43', null);
INSERT INTO `sys_role_permission` VALUES ('1647', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '96', null);
INSERT INTO `sys_role_permission` VALUES ('1648', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '97', null);
INSERT INTO `sys_role_permission` VALUES ('1649', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '98', null);
INSERT INTO `sys_role_permission` VALUES ('1650', 'N', '2020-06-18 15:07:17', '2020-06-18 15:07:17', '1', '1', '3', '99', null);
INSERT INTO `sys_role_permission` VALUES ('1651', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '96', null);
INSERT INTO `sys_role_permission` VALUES ('1652', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '97', null);
INSERT INTO `sys_role_permission` VALUES ('1653', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '98', null);
INSERT INTO `sys_role_permission` VALUES ('1654', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '99', null);
INSERT INTO `sys_role_permission` VALUES ('1655', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '100', '数据报表明细-关键条目缺陷占比');
INSERT INTO `sys_role_permission` VALUES ('1656', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '101', null);
INSERT INTO `sys_role_permission` VALUES ('1657', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '101', null);
INSERT INTO `sys_role_permission` VALUES ('1658', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '102', '数据报表明细-出院人数统计');
INSERT INTO `sys_role_permission` VALUES ('1659', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '103', '数据报表明细-质控核查统计');