qc_init.sql 177 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399
  1. use `qc`;
  2. ALTER TABLE `sys_menu` ADD COLUMN `show_status` int(11) NOT NULL DEFAULT '0' COMMENT '是否在右侧菜单显示(0:不显示,1:显示)' AFTER `code`;
  3. ALTER TABLE `sys_menu` ADD COLUMN `maintain_status` int(11) NOT NULL DEFAULT '0' COMMENT '是否可以维护(0:不可维护,1:可以维护)' AFTER `show_status`;
  4. ALTER TABLE `sys_permission` ADD COLUMN `code` varchar(10) NOT NULL DEFAULT '' COMMENT '资源编码' AFTER `name`;
  5. ALTER TABLE `sys_user` ADD COLUMN `status` int(11) NOT NULL DEFAULT '1' COMMENT '是否启用(0:停用,1:启用)' AFTER `linkman`;
  6. alter table `med_qcresult_detail` add column `info` varchar(500) DEFAULT '' COMMENT '质控返回提示信息' AFTER `msg`;
  7. ALTER TABLE `med_behospital_info` MODIFY COLUMN `doctor_id` varchar(16) DEFAULT '' COMMENT '主治医生ID';
  8. ALTER TABLE `med_behospital_info` MODIFY COLUMN `doctor_name` varchar(50) DEFAULT '' COMMENT '主治医生姓名';
  9. alter table `med_behospital_info` add column `beh_doctor_id` varchar(16) DEFAULT '' COMMENT '住院医生ID' AFTER `doctor_name`;
  10. alter table `med_behospital_info` add column `beh_doctor_name` varchar(50) DEFAULT '' COMMENT '住院医生姓名' AFTER `beh_doctor_id`;
  11. alter table `med_behospital_info` add column `director_doctor_id` varchar(16) DEFAULT '' COMMENT '主任医生ID' AFTER `beh_doctor_name`;
  12. alter table `med_behospital_info` add column `director_doctor_name` varchar(50) DEFAULT '' COMMENT '主任医生姓名' AFTER `director_doctor_id`;
  13. -- ----------------------------
  14. -- Table structure for qc_question_info
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `qc_question_info`;
  17. CREATE TABLE `qc_question_info` (
  18. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  19. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  20. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  21. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  22. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  23. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  24. `hospital_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '医院ID',
  25. `mode_id` bigint(20) DEFAULT NULL COMMENT '数据模块ID',
  26. `tag_name` varchar(100) NOT NULL DEFAULT '' COMMENT '标签名',
  27. `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'key',
  28. `val` varchar(1000) NOT NULL DEFAULT '' COMMENT 'value',
  29. `tag_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '标签标识(1:单标签 4:组合标签)',
  30. `control_type` tinyint(4) DEFAULT '0' COMMENT '控件类型(0:无类型)',
  31. `retract` tinyint(4) DEFAULT '0' COMMENT '缩进(0:不缩进 1:缩进)',
  32. `add_line` tinyint(4) DEFAULT '0' COMMENT '内容换行(0:不换行,1:换行)',
  33. `mono_line` tinyint(4) DEFAULT '0' COMMENT '独占一行(0:不换行,1:换行)',
  34. `bold` tinyint(4) DEFAULT '0' COMMENT '换行(0:不换行,1:加粗)',
  35. `position` tinyint(4) DEFAULT '0' COMMENT '显示位置(1:靠右显示)',
  36. `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  37. PRIMARY KEY (`id`)
  38. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='标签基础表';
  39. -- ----------------------------
  40. -- Table structure for qc_question_mapping
  41. -- ----------------------------
  42. DROP TABLE IF EXISTS `qc_question_mapping`;
  43. CREATE TABLE `qc_question_mapping` (
  44. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  45. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  46. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  47. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  48. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  49. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  50. `parent_question` bigint(20) DEFAULT NULL COMMENT '上级question',
  51. `son_question` bigint(20) DEFAULT NULL COMMENT '下级question',
  52. `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
  53. `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  54. PRIMARY KEY (`id`),
  55. KEY `parent_question` (`parent_question`),
  56. KEY `son_question` (`son_question`)
  57. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='标签映射表';
  58. -- ----------------------------
  59. -- Table structure for qc_question_entry
  60. -- ----------------------------
  61. DROP TABLE IF EXISTS `qc_question_entry`;
  62. CREATE TABLE `qc_question_entry` (
  63. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  64. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  65. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  66. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  67. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  68. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  69. `question_id` bigint(20) DEFAULT NULL COMMENT 'question_id',
  70. `cases_entry_id` bigint(20) DEFAULT NULL COMMENT 'cases_entry_id',
  71. `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
  72. `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  73. PRIMARY KEY (`id`),
  74. KEY `question_id` (`question_id`),
  75. KEY `cases_entry_id` (`cases_entry_id`)
  76. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='标签条目映射表';
  77. -- ----------------------------
  78. -- Table structure for qc_module_info
  79. -- ----------------------------
  80. DROP TABLE IF EXISTS `qc_module_info`;
  81. CREATE TABLE `qc_module_info` (
  82. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  83. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  84. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  85. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  86. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  87. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  88. `name` varchar(100) NOT NULL DEFAULT '' COMMENT '模板名称',
  89. `hospital_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '医院ID',
  90. `mode_id` bigint(20) DEFAULT NULL COMMENT '数据模块ID',
  91. `record_module_id` bigint(20) DEFAULT NULL COMMENT 'med_record_module的id',
  92. `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  93. PRIMARY KEY (`id`),
  94. KEY `INDEX_1` (`hospital_id`,`record_module_id`)
  95. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='模型表';
  96. -- ----------------------------
  97. -- Table structure for qc_module_detail
  98. -- ----------------------------
  99. DROP TABLE IF EXISTS `qc_module_detail`;
  100. CREATE TABLE `qc_module_detail` (
  101. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  102. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  103. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  104. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  105. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  106. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  107. `module_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'module_id',
  108. `group_id` int(11) NOT NULL DEFAULT '0' COMMENT '分组id',
  109. `question_id` bigint(20) DEFAULT NULL COMMENT 'questionId',
  110. `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
  111. `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  112. PRIMARY KEY (`id`),
  113. KEY `module_id` (`module_id`)
  114. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='模型明细表';
  115. DROP TABLE IF EXISTS `sys_user_dept`;
  116. CREATE TABLE `sys_user_dept` (
  117. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  118. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  119. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  120. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  121. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  122. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  123. `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户主键',
  124. `hospital_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '医院ID',
  125. `dept_id` varchar(20) NOT NULL DEFAULT '' COMMENT '科室编码(HIS导入)',
  126. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  127. PRIMARY KEY (`id`)
  128. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户-医院科室映射表';
  129. -- ----------------------------
  130. -- Table structure for sys_dictionary_info
  131. -- ----------------------------
  132. DROP TABLE IF EXISTS `sys_dictionary_info`;
  133. CREATE TABLE `sys_dictionary_info` (
  134. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  135. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  136. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  137. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  138. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  139. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  140. `group_type` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组(值自定义)',
  141. `name` varchar(100) NOT NULL DEFAULT '' COMMENT '内容',
  142. `val` varchar(255) NOT NULL DEFAULT '' COMMENT '值',
  143. `return_type` int(11) NOT NULL DEFAULT '1' COMMENT '返回类型(0: 都返回,1:后台维护返回 2:界面返回)',
  144. `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
  145. `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  146. PRIMARY KEY (`id`)
  147. ) ENGINE=InnoDB AUTO_INCREMENT=286 DEFAULT CHARSET=utf8 COMMENT='系统字典表';
  148. -- ----------------------------
  149. -- Records of sys_dictionary_info
  150. -- ----------------------------
  151. INSERT INTO `sys_dictionary_info` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'doctorAdviceId', '病人医嘱ID', '2', '0', '医嘱信息');
  152. INSERT INTO `sys_dictionary_info` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'behospitalCode', '病人ID', '2', '0', '医嘱信息');
  153. INSERT INTO `sys_dictionary_info` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'orderDoctorName', '医生开单判别', '2', '0', '医嘱信息');
  154. INSERT INTO `sys_dictionary_info` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'frequency', '医嘱频率判别', '2', '0', '医嘱信息');
  155. INSERT INTO `sys_dictionary_info` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'parentTypeId', '父类医嘱ID', '2', '0', '医嘱信息');
  156. INSERT INTO `sys_dictionary_info` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'doctorAdviceType', '医嘱类型判别', '2', '0', '医嘱信息');
  157. INSERT INTO `sys_dictionary_info` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'usageNum', '一次使用数量', '2', '0', '医嘱信息');
  158. INSERT INTO `sys_dictionary_info` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'usageUnit', '一次用量单位', '2', '0', '医嘱信息');
  159. INSERT INTO `sys_dictionary_info` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'dose', '医嘱单次剂量', '2', '0', '医嘱信息');
  160. INSERT INTO `sys_dictionary_info` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'doseUnit', '单次剂量单位', '2', '0', '医嘱信息');
  161. INSERT INTO `sys_dictionary_info` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'medModeType', '给药方式', '2', '0', '医嘱信息');
  162. INSERT INTO `sys_dictionary_info` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daFrequency', '医嘱频率', '2', '0', '医嘱信息');
  163. INSERT INTO `sys_dictionary_info` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daDealType', '医嘱处理类型', '2', '0', '医嘱信息');
  164. INSERT INTO `sys_dictionary_info` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daStartDate', '医嘱开始时间', '2', '0', '医嘱信息');
  165. INSERT INTO `sys_dictionary_info` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daItemName', '医嘱项目名称', '2', '0', '医嘱信息');
  166. INSERT INTO `sys_dictionary_info` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daStatus', '医嘱状态判别', '2', '0', '医嘱信息');
  167. INSERT INTO `sys_dictionary_info` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daStopDate', '医嘱结束时间', '2', '0', '医嘱信息');
  168. INSERT INTO `sys_dictionary_info` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daGroupNo', '医嘱同组序号', '2', '0', '医嘱信息');
  169. INSERT INTO `sys_dictionary_info` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daPrescriptionType', '医嘱处方类型', '2', '0', '医嘱信息');
  170. INSERT INTO `sys_dictionary_info` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'daMedType', '医嘱领药类型', '2', '0', '医嘱信息');
  171. INSERT INTO `sys_dictionary_info` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'doctorNotice', '医生嘱托', '2', '0', '医嘱信息');
  172. INSERT INTO `sys_dictionary_info` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'doctorId', '开单医生ID', '2', '0', '医嘱信息');
  173. INSERT INTO `sys_dictionary_info` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', 'doctorName', '开单医生姓名', '2', '0', '医嘱信息');
  174. INSERT INTO `sys_dictionary_info` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'homePageId', '病案首页编号', '2', '0', '病案首页');
  175. INSERT INTO `sys_dictionary_info` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalCode', '病人住院序号', '2', '0', '病案首页');
  176. INSERT INTO `sys_dictionary_info` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'hospitalCode', '组织机构id', '2', '0', '病案首页');
  177. INSERT INTO `sys_dictionary_info` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'hospitalName', '医疗机构名称', '2', '0', '病案首页');
  178. INSERT INTO `sys_dictionary_info` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'orgCode', '医疗机构代码', '2', '0', '病案首页');
  179. INSERT INTO `sys_dictionary_info` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'payType', '医疗付费方式', '2', '0', '病案首页');
  180. INSERT INTO `sys_dictionary_info` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'healthCard', '健康卡号', '2', '0', '病案首页');
  181. INSERT INTO `sys_dictionary_info` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalNum', '住院次数', '2', '0', '病案首页');
  182. INSERT INTO `sys_dictionary_info` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'fileCode', '病案号', '2', '0', '病案首页');
  183. INSERT INTO `sys_dictionary_info` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'name', '姓名', '2', '0', '病案首页');
  184. INSERT INTO `sys_dictionary_info` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'sex', '性别', '2', '0', '病案首页');
  185. INSERT INTO `sys_dictionary_info` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'birthday', '出生日期', '2', '0', '病案首页');
  186. INSERT INTO `sys_dictionary_info` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'age', '年龄', '2', '0', '病案首页');
  187. INSERT INTO `sys_dictionary_info` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'ageUnit', '年龄单位', '2', '0', '病案首页');
  188. INSERT INTO `sys_dictionary_info` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'nationality', '国籍', '2', '0', '病案首页');
  189. INSERT INTO `sys_dictionary_info` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'newbornMonth', '新生儿出生月数', '2', '0', '病案首页');
  190. INSERT INTO `sys_dictionary_info` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'newbornDay', '新生儿出生天数', '2', '0', '病案首页');
  191. INSERT INTO `sys_dictionary_info` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'newbornWeight', '新生儿出生体重', '2', '0', '病案首页');
  192. INSERT INTO `sys_dictionary_info` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'newbornBehospitalWeight', '新生儿入院体重', '2', '0', '病案首页');
  193. INSERT INTO `sys_dictionary_info` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'bornAddress', '出生地', '2', '0', '病案首页');
  194. INSERT INTO `sys_dictionary_info` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'bornPlace', '籍贯', '2', '0', '病案首页');
  195. INSERT INTO `sys_dictionary_info` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'nation', '民族', '2', '0', '病案首页');
  196. INSERT INTO `sys_dictionary_info` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'identityCardNo', '身份证号', '2', '0', '病案首页');
  197. INSERT INTO `sys_dictionary_info` VALUES ('63', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'jobType', '职业', '2', '0', '病案首页');
  198. INSERT INTO `sys_dictionary_info` VALUES ('64', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'marriage', '婚姻', '2', '0', '病案首页');
  199. INSERT INTO `sys_dictionary_info` VALUES ('65', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'curAddress', '现住址', '2', '0', '病案首页');
  200. INSERT INTO `sys_dictionary_info` VALUES ('66', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'curPhone', '现住址电话', '2', '0', '病案首页');
  201. INSERT INTO `sys_dictionary_info` VALUES ('67', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'curPostCode', '现住址邮编', '2', '0', '病案首页');
  202. INSERT INTO `sys_dictionary_info` VALUES ('68', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'residenceAddress', '户口地址', '2', '0', '病案首页');
  203. INSERT INTO `sys_dictionary_info` VALUES ('69', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'residencePostCode', '户口地址邮编', '2', '0', '病案首页');
  204. INSERT INTO `sys_dictionary_info` VALUES ('70', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'workAddress', '工作单位', '2', '0', '病案首页');
  205. INSERT INTO `sys_dictionary_info` VALUES ('71', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'workPhone', '工作单位电话', '2', '0', '病案首页');
  206. INSERT INTO `sys_dictionary_info` VALUES ('72', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'workPostCode', '工作单位邮编', '2', '0', '病案首页');
  207. INSERT INTO `sys_dictionary_info` VALUES ('73', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'contactName', '联系人姓名', '2', '0', '病案首页');
  208. INSERT INTO `sys_dictionary_info` VALUES ('74', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'contactRelation', '联系人关系', '2', '0', '病案首页');
  209. INSERT INTO `sys_dictionary_info` VALUES ('75', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'contactAddress', '联系人地址', '2', '0', '病案首页');
  210. INSERT INTO `sys_dictionary_info` VALUES ('76', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'contactPhone', '联系人电话', '2', '0', '病案首页');
  211. INSERT INTO `sys_dictionary_info` VALUES ('77', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalWay', '入院途径', '2', '0', '病案首页');
  212. INSERT INTO `sys_dictionary_info` VALUES ('78', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalDate', '入院时间', '2', '0', '病案首页');
  213. INSERT INTO `sys_dictionary_info` VALUES ('79', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalDept', '入院科别', '2', '0', '病案首页');
  214. INSERT INTO `sys_dictionary_info` VALUES ('80', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalWard', '入院病房', '2', '0', '病案首页');
  215. INSERT INTO `sys_dictionary_info` VALUES ('81', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalBedId', '入院床位序号', '2', '0', '病案首页');
  216. INSERT INTO `sys_dictionary_info` VALUES ('82', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalBedCode', '入院床位号码', '2', '0', '病案首页');
  217. INSERT INTO `sys_dictionary_info` VALUES ('83', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'changeDept', '转科科别', '2', '0', '病案首页');
  218. INSERT INTO `sys_dictionary_info` VALUES ('84', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'leaveHospitalDate', '出院时间', '2', '0', '病案首页');
  219. INSERT INTO `sys_dictionary_info` VALUES ('85', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'leaveHospitalDept', '出院科别', '2', '0', '病案首页');
  220. INSERT INTO `sys_dictionary_info` VALUES ('86', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'leaveHospitalWard', '出院病房', '2', '0', '病案首页');
  221. INSERT INTO `sys_dictionary_info` VALUES ('87', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'leaveHospitalBedId', '出院床位序号', '2', '0', '病案首页');
  222. INSERT INTO `sys_dictionary_info` VALUES ('88', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'leaveHospitalBedCode', '出院床位号码', '2', '0', '病案首页');
  223. INSERT INTO `sys_dictionary_info` VALUES ('89', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalDayNum', '实际住院天数', '2', '0', '病案首页');
  224. INSERT INTO `sys_dictionary_info` VALUES ('90', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'outpatientEmrDiagnose', '门急诊诊断', '2', '0', '病案首页');
  225. INSERT INTO `sys_dictionary_info` VALUES ('91', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'outpatientEmrDiagnoseCode', '门急诊诊断编码', '2', '0', '病案首页');
  226. INSERT INTO `sys_dictionary_info` VALUES ('92', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'poisonFactor', '损伤中毒因素', '2', '0', '病案首页');
  227. INSERT INTO `sys_dictionary_info` VALUES ('93', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'poisonFactorCode', '损伤中毒因素编码', '2', '0', '病案首页');
  228. INSERT INTO `sys_dictionary_info` VALUES ('94', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'pathologyDiagnose', '病理诊断', '2', '0', '病案首页');
  229. INSERT INTO `sys_dictionary_info` VALUES ('95', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'pathologyDiagnoseCode', '病理诊断编码', '2', '0', '病案首页');
  230. INSERT INTO `sys_dictionary_info` VALUES ('96', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'pathologyDiagnoseId', '病理诊断编号', '2', '0', '病案首页');
  231. INSERT INTO `sys_dictionary_info` VALUES ('97', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'isMedAllergy', '药物过敏', '2', '0', '病案首页');
  232. INSERT INTO `sys_dictionary_info` VALUES ('98', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'medAllergyName', '过敏药物', '2', '0', '病案首页');
  233. INSERT INTO `sys_dictionary_info` VALUES ('99', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'autopsy', '死亡患者尸检', '2', '0', '病案首页');
  234. INSERT INTO `sys_dictionary_info` VALUES ('100', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'bloodType', '血型', '2', '0', '病案首页');
  235. INSERT INTO `sys_dictionary_info` VALUES ('101', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'rh', 'Rh', '2', '0', '病案首页');
  236. INSERT INTO `sys_dictionary_info` VALUES ('102', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'deptDirector', '科主任', '2', '0', '病案首页');
  237. INSERT INTO `sys_dictionary_info` VALUES ('103', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'directorDoctor', '主任医师', '2', '0', '病案首页');
  238. INSERT INTO `sys_dictionary_info` VALUES ('104', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'attendingDoctor', '主治医师', '2', '0', '病案首页');
  239. INSERT INTO `sys_dictionary_info` VALUES ('105', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'behospitalDoctor', '住院医师', '2', '0', '病案首页');
  240. INSERT INTO `sys_dictionary_info` VALUES ('106', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'responseNurse', '责任护士', '2', '0', '病案首页');
  241. INSERT INTO `sys_dictionary_info` VALUES ('107', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'studyDoctor', '进修医师', '2', '0', '病案首页');
  242. INSERT INTO `sys_dictionary_info` VALUES ('108', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'practiceDoctor', '实习医师', '2', '0', '病案首页');
  243. INSERT INTO `sys_dictionary_info` VALUES ('109', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'encodeMan', '编码员', '2', '0', '病案首页');
  244. INSERT INTO `sys_dictionary_info` VALUES ('110', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'homePageQuality', '病案质量', '2', '0', '病案首页');
  245. INSERT INTO `sys_dictionary_info` VALUES ('111', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'qcDoctor', '质控医师', '2', '0', '病案首页');
  246. INSERT INTO `sys_dictionary_info` VALUES ('112', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'qcNurse', '质控护士', '2', '0', '病案首页');
  247. INSERT INTO `sys_dictionary_info` VALUES ('113', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'qcDate', '质控日期', '2', '0', '病案首页');
  248. INSERT INTO `sys_dictionary_info` VALUES ('114', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'leaveHospitalType', '离院方式', '2', '0', '病案首页');
  249. INSERT INTO `sys_dictionary_info` VALUES ('115', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'acceptOrgCode', '接收机构名称', '2', '0', '病案首页');
  250. INSERT INTO `sys_dictionary_info` VALUES ('116', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'againBehospitalPlan', '31天内再住院计划', '2', '0', '病案首页');
  251. INSERT INTO `sys_dictionary_info` VALUES ('117', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'againBehospitalGoal', '再住院目的', '2', '0', '病案首页');
  252. INSERT INTO `sys_dictionary_info` VALUES ('118', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'tbiBeforeDay', '颅脑损伤患者昏迷前天数', '2', '0', '病案首页');
  253. INSERT INTO `sys_dictionary_info` VALUES ('119', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'tbiBeforeHour', '颅脑损伤患者昏迷前小时', '2', '0', '病案首页');
  254. INSERT INTO `sys_dictionary_info` VALUES ('120', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'tbiBeforeMinute', '颅脑损伤患者昏迷前分钟', '2', '0', '病案首页');
  255. INSERT INTO `sys_dictionary_info` VALUES ('121', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'tbiAfterDay', '颅脑损伤患者昏迷后天数', '2', '0', '病案首页');
  256. INSERT INTO `sys_dictionary_info` VALUES ('122', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'tbiAfterHour', '颅脑损伤患者昏迷后小时', '2', '0', '病案首页');
  257. INSERT INTO `sys_dictionary_info` VALUES ('123', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'tbiAfterMinute', '颅脑损伤患者昏迷后分钟', '2', '0', '病案首页');
  258. INSERT INTO `sys_dictionary_info` VALUES ('124', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'totalFee', '总费用', '2', '0', '病案首页');
  259. INSERT INTO `sys_dictionary_info` VALUES ('125', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'ownFee', '自付金额', '2', '0', '病案首页');
  260. INSERT INTO `sys_dictionary_info` VALUES ('126', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'generalFee', '一般医疗服务费', '2', '0', '病案首页');
  261. INSERT INTO `sys_dictionary_info` VALUES ('127', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'serviceFee', '一般治疗服务费', '2', '0', '病案首页');
  262. INSERT INTO `sys_dictionary_info` VALUES ('128', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'nurseFee', '护理费', '2', '0', '病案首页');
  263. INSERT INTO `sys_dictionary_info` VALUES ('129', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'otherFee', '其他费用', '2', '0', '病案首页');
  264. INSERT INTO `sys_dictionary_info` VALUES ('130', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'pathologyFee', '病理诊断费', '2', '0', '病案首页');
  265. INSERT INTO `sys_dictionary_info` VALUES ('131', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'labFee', '实验室诊断费', '2', '0', '病案首页');
  266. INSERT INTO `sys_dictionary_info` VALUES ('132', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'pacsFee', '影像学诊断费', '2', '0', '病案首页');
  267. INSERT INTO `sys_dictionary_info` VALUES ('133', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'clinicDiagnoseFee', '临床诊断项目费', '2', '0', '病案首页');
  268. INSERT INTO `sys_dictionary_info` VALUES ('134', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'notOperationFee', '非手术治疗项目费', '2', '0', '病案首页');
  269. INSERT INTO `sys_dictionary_info` VALUES ('135', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'clinicPhysicFee', '临床物理治疗费', '2', '0', '病案首页');
  270. INSERT INTO `sys_dictionary_info` VALUES ('136', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'operationTreatFee', '手术治疗费', '2', '0', '病案首页');
  271. INSERT INTO `sys_dictionary_info` VALUES ('137', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'anaesthesiaFee', '麻醉费', '2', '0', '病案首页');
  272. INSERT INTO `sys_dictionary_info` VALUES ('138', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'operationFee', '手术费', '2', '0', '病案首页');
  273. INSERT INTO `sys_dictionary_info` VALUES ('139', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'healthTypeFee', '康复类', '2', '0', '病案首页');
  274. INSERT INTO `sys_dictionary_info` VALUES ('140', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'chnTreatFee', '中医治疗费', '2', '0', '病案首页');
  275. INSERT INTO `sys_dictionary_info` VALUES ('141', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'westernMedFee', '西药费', '2', '0', '病案首页');
  276. INSERT INTO `sys_dictionary_info` VALUES ('142', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'antibiosisFee', '抗菌药物费用', '2', '0', '病案首页');
  277. INSERT INTO `sys_dictionary_info` VALUES ('143', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'chnMedFee', '中成药费', '2', '0', '病案首页');
  278. INSERT INTO `sys_dictionary_info` VALUES ('144', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'chnHerbFee', '中草药费', '2', '0', '病案首页');
  279. INSERT INTO `sys_dictionary_info` VALUES ('145', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'bloodFee', '血费', '2', '0', '病案首页');
  280. INSERT INTO `sys_dictionary_info` VALUES ('146', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'albumenFee', '白蛋白类制品费', '2', '0', '病案首页');
  281. INSERT INTO `sys_dictionary_info` VALUES ('147', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'globulinFee', '球蛋白类制品费', '2', '0', '病案首页');
  282. INSERT INTO `sys_dictionary_info` VALUES ('148', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'bloodFactorFee', '凝血因子类制品费', '2', '0', '病案首页');
  283. INSERT INTO `sys_dictionary_info` VALUES ('149', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'cellFactorFee', '细胞因子类制品费', '2', '0', '病案首页');
  284. INSERT INTO `sys_dictionary_info` VALUES ('150', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'checkMaterialFee', '检查用一次性医用材料费', '2', '0', '病案首页');
  285. INSERT INTO `sys_dictionary_info` VALUES ('151', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'treatMaterialFee', '治疗用一次性医用材料费', '2', '0', '病案首页');
  286. INSERT INTO `sys_dictionary_info` VALUES ('152', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'operationMaterialFee', '手术用一次性医用材料费', '2', '0', '病案首页');
  287. INSERT INTO `sys_dictionary_info` VALUES ('153', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'otherTypeFee', '其他类其他费', '2', '0', '病案首页');
  288. INSERT INTO `sys_dictionary_info` VALUES ('154', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'singleDiagManage', '单病种管理', '2', '0', '病案首页');
  289. INSERT INTO `sys_dictionary_info` VALUES ('155', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'clinicPathwayManage', '临床路径管理', '2', '0', '病案首页');
  290. INSERT INTO `sys_dictionary_info` VALUES ('156', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'isOutpatientBehospital', '门诊与住院', '2', '0', '病案首页');
  291. INSERT INTO `sys_dictionary_info` VALUES ('157', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'isLeaveBehospital', '入院与出院', '2', '0', '病案首页');
  292. INSERT INTO `sys_dictionary_info` VALUES ('158', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'isOperationBeforeAfter', '术前与术后', '2', '0', '病案首页');
  293. INSERT INTO `sys_dictionary_info` VALUES ('159', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'isClinicPathology', '临床与病理', '2', '0', '病案首页');
  294. INSERT INTO `sys_dictionary_info` VALUES ('160', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'isRadiatePathology', '放射与病理', '2', '0', '病案首页');
  295. INSERT INTO `sys_dictionary_info` VALUES ('161', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'rescueNum', '病人抢救次数', '2', '0', '病案首页');
  296. INSERT INTO `sys_dictionary_info` VALUES ('162', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'rescueSuccessNum', '病人抢救成功次数', '2', '0', '病案首页');
  297. INSERT INTO `sys_dictionary_info` VALUES ('163', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'isAutoLeavehospital', '是否为自动出院', '2', '0', '病案首页');
  298. INSERT INTO `sys_dictionary_info` VALUES ('164', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', 'returnToType', '转归情况', '2', '0', '病案首页');
  299. INSERT INTO `sys_dictionary_info` VALUES ('165', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'homePageId', '病案首页ID', '2', '0', '病案首页手术信息');
  300. INSERT INTO `sys_dictionary_info` VALUES ('167', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'operationOrderNo', '手术序号', '2', '0', '病案首页手术信息');
  301. INSERT INTO `sys_dictionary_info` VALUES ('168', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'operationDate', '手术日期', '2', '0', '病案首页手术信息');
  302. INSERT INTO `sys_dictionary_info` VALUES ('169', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'operationCode', '手术编码', '2', '0', '病案首页手术信息');
  303. INSERT INTO `sys_dictionary_info` VALUES ('170', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'operationDoctorId', '手术医生ID', '2', '0', '病案首页手术信息');
  304. INSERT INTO `sys_dictionary_info` VALUES ('171', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'firstAssistantId', '一助医生ID', '2', '0', '病案首页手术信息');
  305. INSERT INTO `sys_dictionary_info` VALUES ('172', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'secondAssistantId', '二助医生ID', '2', '0', '病案首页手术信息');
  306. INSERT INTO `sys_dictionary_info` VALUES ('173', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'cutLevel', '切口等级', '2', '0', '病案首页手术信息');
  307. INSERT INTO `sys_dictionary_info` VALUES ('174', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'healingLevel', '愈合等级', '2', '0', '病案首页手术信息');
  308. INSERT INTO `sys_dictionary_info` VALUES ('175', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'operationName', '手术名称', '2', '0', '病案首页手术信息');
  309. INSERT INTO `sys_dictionary_info` VALUES ('176', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'operationLevel', '手术级别', '2', '0', '病案首页手术信息');
  310. INSERT INTO `sys_dictionary_info` VALUES ('177', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'anaesthesiaName', '麻醉方式', '2', '0', '病案首页手术信息');
  311. INSERT INTO `sys_dictionary_info` VALUES ('178', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', 'shamOperationName', '拟手术名称', '2', '0', '病案首页手术信息');
  312. INSERT INTO `sys_dictionary_info` VALUES ('179', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'homePageId', '病案首页ID', '2', '0', '病案首页诊断信息');
  313. INSERT INTO `sys_dictionary_info` VALUES ('182', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'diagnoseOrderNo', '诊断序号', '2', '0', '病案首页诊断信息');
  314. INSERT INTO `sys_dictionary_info` VALUES ('183', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'diagnoseType', '诊断类别', '2', '0', '病案首页诊断信息');
  315. INSERT INTO `sys_dictionary_info` VALUES ('184', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'diagnoseTypeShort', '诊断判别', '2', '0', null);
  316. INSERT INTO `sys_dictionary_info` VALUES ('185', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'diagnoseName', '诊断名称', '2', '0', null);
  317. INSERT INTO `sys_dictionary_info` VALUES ('186', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'behospitalType', '入院情况', '2', '0', null);
  318. INSERT INTO `sys_dictionary_info` VALUES ('187', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'leaveHospitalType', '出院情况', '2', '0', null);
  319. INSERT INTO `sys_dictionary_info` VALUES ('188', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'pathologyDiagnose', '病理号', '2', '0', null);
  320. INSERT INTO `sys_dictionary_info` VALUES ('189', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', 'icdCode', '诊断编码', '2', '0', null);
  321. INSERT INTO `sys_dictionary_info` VALUES ('231', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '病案首页', '6', '1', '231', '所属模块');
  322. INSERT INTO `sys_dictionary_info` VALUES ('232', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '入院记录', '1', '1', '232', '所属模块');
  323. INSERT INTO `sys_dictionary_info` VALUES ('233', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '首次病程录', '2', '1', '233', '所属模块');
  324. INSERT INTO `sys_dictionary_info` VALUES ('234', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '查房记录', '4', '1', '234', '所属模块');
  325. INSERT INTO `sys_dictionary_info` VALUES ('235', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '疑难病例讨论记录', '19', '1', '235', '所属模块');
  326. INSERT INTO `sys_dictionary_info` VALUES ('236', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '死亡病例讨论记录', '3', '1', '236', '所属模块');
  327. INSERT INTO `sys_dictionary_info` VALUES ('237', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '术前讨论、术前小结', '11', '1', '237', '所属模块');
  328. INSERT INTO `sys_dictionary_info` VALUES ('238', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '手术记录', '17', '1', '238', '所属模块');
  329. INSERT INTO `sys_dictionary_info` VALUES ('239', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '术后首次病程及谈话记录', '18', '1', '239', '所属模块');
  330. INSERT INTO `sys_dictionary_info` VALUES ('240', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '手术知情同意书', '16', '1', '240', '所属模块');
  331. INSERT INTO `sys_dictionary_info` VALUES ('241', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '抢救记录', '22', '1', '241', '所属模块');
  332. INSERT INTO `sys_dictionary_info` VALUES ('242', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '危急值记录', '23', '1', '242', '所属模块');
  333. INSERT INTO `sys_dictionary_info` VALUES ('243', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '阶段小结', '28', '1', '243', '所属模块');
  334. INSERT INTO `sys_dictionary_info` VALUES ('244', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '病危通知书', '25', '1', '244', '所属模块');
  335. INSERT INTO `sys_dictionary_info` VALUES ('245', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '输血/血制品病程记录', '10', '1', '245', '所属模块');
  336. INSERT INTO `sys_dictionary_info` VALUES ('246', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '输血后效果评价', '32', '1', '246', '所属模块');
  337. INSERT INTO `sys_dictionary_info` VALUES ('247', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '会诊申请单', '30', '1', '247', '所属模块');
  338. INSERT INTO `sys_dictionary_info` VALUES ('248', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '会诊结果单', '31', '1', '248', '所属模块');
  339. INSERT INTO `sys_dictionary_info` VALUES ('249', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '会诊记录', '7', '1', '249', '所属模块');
  340. INSERT INTO `sys_dictionary_info` VALUES ('250', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '病理检验送检单', '35', '1', '250', '所属模块');
  341. INSERT INTO `sys_dictionary_info` VALUES ('251', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '死亡记录', '24', '1', '251', '所属模块');
  342. INSERT INTO `sys_dictionary_info` VALUES ('252', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '转科记录', '34', '1', '252', '所属模块');
  343. INSERT INTO `sys_dictionary_info` VALUES ('253', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '专科交接单', '33', '1', '253', '所属模块');
  344. INSERT INTO `sys_dictionary_info` VALUES ('254', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '自定义病程记录', '36', '1', '254', '所属模块');
  345. INSERT INTO `sys_dictionary_info` VALUES ('255', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '授权知情同意书', '52', '1', '255', '所属模块');
  346. INSERT INTO `sys_dictionary_info` VALUES ('256', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '知情同意书', '53', '1', '256', '所属模块');
  347. INSERT INTO `sys_dictionary_info` VALUES ('257', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '病重通知书', '29', '1', '257', '所属模块');
  348. INSERT INTO `sys_dictionary_info` VALUES ('258', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '谈话告知书', '54', '1', '258', '所属模块');
  349. INSERT INTO `sys_dictionary_info` VALUES ('259', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '转出记录', '27', '1', '259', '所属模块');
  350. INSERT INTO `sys_dictionary_info` VALUES ('260', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '转入记录', '26', '1', '260', '所属模块');
  351. INSERT INTO `sys_dictionary_info` VALUES ('261', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '手术安全核查表', '21', '1', '261', '所属模块');
  352. INSERT INTO `sys_dictionary_info` VALUES ('262', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '手术风险评估表', '20', '1', '262', '所属模块');
  353. INSERT INTO `sys_dictionary_info` VALUES ('263', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '麻醉术后访视记录', '15', '1', '263', '所属模块');
  354. INSERT INTO `sys_dictionary_info` VALUES ('264', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '麻醉术前访视记录', '14', '1', '264', '所属模块');
  355. INSERT INTO `sys_dictionary_info` VALUES ('265', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '麻醉知情同意书', '13', '1', '265', '所属模块');
  356. INSERT INTO `sys_dictionary_info` VALUES ('266', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '麻醉记录', '12', '1', '266', '所属模块');
  357. INSERT INTO `sys_dictionary_info` VALUES ('267', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '交接班记录', '9', '1', '267', '所属模块');
  358. INSERT INTO `sys_dictionary_info` VALUES ('268', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '医嘱信息', '8', '1', '268', '所属模块');
  359. INSERT INTO `sys_dictionary_info` VALUES ('269', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '出院小结', '5', '1', '269', '所属模块');
  360. INSERT INTO `sys_dictionary_info` VALUES ('270', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '其他', '0', '1', '270', '所属模块');
  361. INSERT INTO `sys_dictionary_info` VALUES ('271', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '13', '台州', '3', '1', '1', '所属医院');
  362. INSERT INTO `sys_dictionary_info` VALUES ('272', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '13', '长兴', '1', '1', '2', '所属医院');
  363. INSERT INTO `sys_dictionary_info` VALUES ('273', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '13', '邵逸夫', '2', '1', '3', '所属医院');
  364. INSERT INTO `sys_dictionary_info` VALUES ('274', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  365. INSERT INTO `sys_dictionary_info` VALUES ('275', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  366. INSERT INTO `sys_dictionary_info` VALUES ('276', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  367. INSERT INTO `sys_dictionary_info` VALUES ('277', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  368. INSERT INTO `sys_dictionary_info` VALUES ('278', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  369. INSERT INTO `sys_dictionary_info` VALUES ('279', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  370. INSERT INTO `sys_dictionary_info` VALUES ('280', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  371. INSERT INTO `sys_dictionary_info` VALUES ('281', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  372. INSERT INTO `sys_dictionary_info` VALUES ('282', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  373. INSERT INTO `sys_dictionary_info` VALUES ('283', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  374. INSERT INTO `sys_dictionary_info` VALUES ('284', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  375. INSERT INTO `sys_dictionary_info` VALUES ('285', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '', '', '1', '0', null);
  376. -- ----------------------------
  377. -- Table structure for sys_menu
  378. -- ----------------------------
  379. DROP TABLE IF EXISTS `sys_menu`;
  380. CREATE TABLE `sys_menu` (
  381. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  382. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  383. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  384. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  385. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  386. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  387. `name` varchar(255) NOT NULL DEFAULT '' COMMENT '菜单名称',
  388. `parent_id` bigint(20) NOT NULL DEFAULT '-1' COMMENT '-1:表示顶级,其他值表示上级菜单的id',
  389. `code` varchar(255) NOT NULL DEFAULT '' COMMENT '编码,与前端对应',
  390. `show_status` int(11) NOT NULL DEFAULT '0' COMMENT '是否在右侧菜单显示(0:不显示,1:显示)',
  391. `maintain_status` int(11) NOT NULL DEFAULT '0' COMMENT '是否可以维护(0:不可维护,1:可以维护)',
  392. `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序,从小到大',
  393. `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  394. PRIMARY KEY (`id`)
  395. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='系统菜单';
  396. -- ----------------------------
  397. -- Records of sys_menu
  398. -- ----------------------------
  399. 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', '1', '用户-控制台');
  400. 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', '用户-基础数据维护');
  401. 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', '用户-病历质控');
  402. 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', '用户-统计分析');
  403. 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', '用户-基础数据维护-模块数据维护');
  404. 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', '用户-基础数据维护-条目数据维护');
  405. 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', '用户-病历质控-质控评分');
  406. 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', '用户-基础功能');
  407. 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', '用户-病历质控-质控评分(科室)');
  408. 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', '用户-病历质控-质控评分(个人)');
  409. 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', '用户-权限管理');
  410. 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', '用户-权限管理-用户管理');
  411. 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', '用户-权限管理-角色管理');
  412. INSERT INTO `sys_menu` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '控制台-科室', '-1', 'YH-KZT(KS)', '0', '1', '6', '用户-控制台(科室)');
  413. -- ----------------------------
  414. -- Table structure for sys_menu_permission
  415. -- ----------------------------
  416. DROP TABLE IF EXISTS `sys_menu_permission`;
  417. CREATE TABLE `sys_menu_permission` (
  418. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  419. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  420. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  421. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  422. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  423. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  424. `menu_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '菜单id',
  425. `permission_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '系统资源id',
  426. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  427. PRIMARY KEY (`id`)
  428. ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COMMENT='菜单和系统资源的映射表';
  429. -- ----------------------------
  430. -- Records of sys_menu_permission
  431. -- ----------------------------
  432. INSERT INTO `sys_menu_permission` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '1', '基础功能-获取用户、机构、菜单信息');
  433. INSERT INTO `sys_menu_permission` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '2', '基础功能-修改密码');
  434. INSERT INTO `sys_menu_permission` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '9', '控制台-病历相关统计');
  435. INSERT INTO `sys_menu_permission` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '15', '控制台-缺陷相关统计');
  436. INSERT INTO `sys_menu_permission` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '16', '控制台-医院运营相关统计');
  437. INSERT INTO `sys_menu_permission` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '3', '用户-基础数据维护-获取医院模块数据信息');
  438. INSERT INTO `sys_menu_permission` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '4', '用户-基础数据维护-批量更新模块数据');
  439. INSERT INTO `sys_menu_permission` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '6', '用户-条目数据维护-分页获取医院条目数据信息');
  440. INSERT INTO `sys_menu_permission` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '7', '用户-条目数据维护-修改医院条目数据信息');
  441. INSERT INTO `sys_menu_permission` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '8', '用户-条目数据维护-获取医院模块数据下拉列表');
  442. INSERT INTO `sys_menu_permission` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '30', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息');
  443. INSERT INTO `sys_menu_permission` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '17', '用户-质控评分-评分');
  444. INSERT INTO `sys_menu_permission` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '5', '用户-质控评分-分页');
  445. INSERT INTO `sys_menu_permission` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '11', '用户-质控评分-新增质控条目');
  446. INSERT INTO `sys_menu_permission` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '12', '用户-质控评分-删除质控条目');
  447. INSERT INTO `sys_menu_permission` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '13', '用户-质控评分-修改质控条目');
  448. INSERT INTO `sys_menu_permission` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '14', '用户-质控评分-获取详情');
  449. INSERT INTO `sys_menu_permission` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '31', '用户-质控评分(科室)-获取病历质控一览下用户科室下拉列表信息');
  450. INSERT INTO `sys_menu_permission` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '34', '用户-质控评分(科室)-评分');
  451. INSERT INTO `sys_menu_permission` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '32', '用户-质控评分(科室)-分页');
  452. INSERT INTO `sys_menu_permission` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '35', '用户-质控评分(科室)-新增质控条目');
  453. INSERT INTO `sys_menu_permission` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '36', '用户-质控评分(科室)-删除质控条目');
  454. INSERT INTO `sys_menu_permission` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '37', '用户-质控评分(科室)-修改质控条目');
  455. INSERT INTO `sys_menu_permission` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '38', '用户-质控评分(科室)-获取详情');
  456. INSERT INTO `sys_menu_permission` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '39', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息');
  457. INSERT INTO `sys_menu_permission` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '40', '用户-质控评分(个人)-评分');
  458. INSERT INTO `sys_menu_permission` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '33', '用户-质控评分(个人)-分页');
  459. INSERT INTO `sys_menu_permission` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '41', '用户-质控评分(个人)-新增质控条目');
  460. INSERT INTO `sys_menu_permission` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '42', '用户-质控评分(个人)-删除质控条目');
  461. INSERT INTO `sys_menu_permission` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '43', '用户-质控评分(个人)-修改质控条目');
  462. INSERT INTO `sys_menu_permission` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '44', '用户-质控评分(个人)-获取详情');
  463. INSERT INTO `sys_menu_permission` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '45', '控制台-平均住院天数');
  464. INSERT INTO `sys_menu_permission` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '46', '控制台-平均住院费用');
  465. INSERT INTO `sys_menu_permission` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '47', '控制台-质控平均分按科室统计');
  466. INSERT INTO `sys_menu_permission` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '48', '控制台-各科室甲级病历占比');
  467. INSERT INTO `sys_menu_permission` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '49', '控制台-出院人数统计');
  468. INSERT INTO `sys_menu_permission` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '50', '控制台-质控病历统计');
  469. INSERT INTO `sys_menu_permission` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '51', '控制台-各模块缺陷占比排行');
  470. INSERT INTO `sys_menu_permission` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '52', '控制台-条目缺陷占比');
  471. INSERT INTO `sys_menu_permission` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '53', '控制台-各科室缺陷占比');
  472. INSERT INTO `sys_menu_permission` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '54', '控制台(科室)-出院人数统计(科室)');
  473. INSERT INTO `sys_menu_permission` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '55', '控制台(科室)-质控病历数统计(科室)');
  474. INSERT INTO `sys_menu_permission` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '56', '控制台(科室)-各模块缺陷占比排行(科室)');
  475. INSERT INTO `sys_menu_permission` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '57', '控制台(科室)-条目缺陷占比(科室)');
  476. -- ----------------------------
  477. -- Table structure for sys_permission
  478. -- ----------------------------
  479. DROP TABLE IF EXISTS `sys_permission`;
  480. CREATE TABLE `sys_permission` (
  481. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '资源ID',
  482. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  483. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  484. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  485. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  486. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  487. `name` varchar(255) NOT NULL DEFAULT '' COMMENT '资源名称',
  488. `code` varchar(20) NOT NULL DEFAULT '' COMMENT '资源编码',
  489. `permissionUrl` varchar(255) NOT NULL DEFAULT '' COMMENT '资源Url',
  490. `method` varchar(255) NOT NULL DEFAULT 'ALL' COMMENT '资源允许的请求方式',
  491. `descritpion` varchar(255) NOT NULL DEFAULT '' COMMENT '资源描述',
  492. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  493. PRIMARY KEY (`id`)
  494. ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 COMMENT='系统资源表';
  495. -- ----------------------------
  496. -- Records of sys_permission
  497. -- ----------------------------
  498. 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);
  499. 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);
  500. 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', '用户-基础数据维护-获取医院模块数据信息', '无需加密');
  501. 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);
  502. 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', '用户-质控评分-分页', '无需加密');
  503. 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', '用户-条目数据维护-分页获取医院条目数据信息', '无需加密');
  504. 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);
  505. 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', '获取医院模块数据列表', '无需加密');
  506. INSERT INTO `sys_permission` VALUES ('9', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病历相关统计', 'FUNC000009', '/console/mrStatistics', 'ALL', '控制台-病历相关统计', null);
  507. INSERT INTO `sys_permission` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '模糊查询医院模块条目列表', 'FUNC000010', '/qc/casesEntryHospital/findQcCasesEntry', 'ALL', '用户-条目数据维护-模糊查询医院模块条目列表', null);
  508. 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);
  509. 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);
  510. 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);
  511. 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', '用户-质控评分-获取详情', '无需加密');
  512. INSERT INTO `sys_permission` VALUES ('15', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '缺陷相关统计', 'FUNC000015', '/console/resultStatistics', 'ALL', '控制台-缺陷相关统计', null);
  513. INSERT INTO `sys_permission` VALUES ('16', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '平均值相关统计', 'FUNC000016', '/console/averageStatistics', 'ALL', '控制台-平均值相关统计', null);
  514. 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);
  515. 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);
  516. 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);
  517. 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);
  518. 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);
  519. 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);
  520. 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);
  521. 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);
  522. 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);
  523. 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);
  524. 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);
  525. 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);
  526. 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);
  527. 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', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息', '无需加密');
  528. 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', '用户-质控评分(科室)-获取病历质控一览下用户科室下拉列表信息', '无需加密');
  529. 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', '用户-质控评分(科室)-分页', '无需加密');
  530. 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', '用户-质控评分(个人)-分页', '无需加密');
  531. 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);
  532. 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);
  533. 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);
  534. 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);
  535. 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', '用户-质控评分(科室)-获取详情', '无需加密');
  536. 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', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息', '无需加密');
  537. 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);
  538. 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);
  539. 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);
  540. 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);
  541. 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', '用户-质控评分(个人)-获取详情', '无需加密');
  542. 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);
  543. 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);
  544. 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);
  545. 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);
  546. 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);
  547. 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);
  548. 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);
  549. 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);
  550. 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);
  551. 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);
  552. 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);
  553. 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);
  554. 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);
  555. -- ----------------------------
  556. -- Table structure for sys_role
  557. -- ----------------------------
  558. DROP TABLE IF EXISTS `sys_role`;
  559. CREATE TABLE `sys_role` (
  560. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  561. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  562. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  563. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  564. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  565. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  566. `name` varchar(255) NOT NULL DEFAULT '' COMMENT '角色名称',
  567. `roleLevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级',
  568. `descritpion` varchar(255) NOT NULL DEFAULT '' COMMENT '角色描述',
  569. `menuItems` varchar(255) NOT NULL DEFAULT '' COMMENT '菜单ID:对应角色ID(暂无用处)',
  570. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  571. PRIMARY KEY (`id`)
  572. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='系统角色表';
  573. -- ----------------------------
  574. -- Records of sys_role
  575. -- ----------------------------
  576. INSERT INTO `sys_role` VALUES ('-1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '超级管理员', '0', '', '', '');
  577. INSERT INTO `sys_role` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(全局)', '0', '', '', '');
  578. INSERT INTO `sys_role` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(科室)', '0', '', '', null);
  579. INSERT INTO `sys_role` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院人员(个人)', '0', '', '', null);
  580. -- ----------------------------
  581. -- Table structure for sys_role_menu
  582. -- ----------------------------
  583. DROP TABLE IF EXISTS `sys_role_menu`;
  584. CREATE TABLE `sys_role_menu` (
  585. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  586. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  587. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  588. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  589. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  590. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  591. `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id',
  592. `menu_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '菜单id',
  593. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  594. PRIMARY KEY (`id`)
  595. ) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8 COMMENT='角色和菜单的映射表';
  596. -- ----------------------------
  597. -- Records of sys_role_menu
  598. -- ----------------------------
  599. INSERT INTO `sys_role_menu` VALUES ('1', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '1', null);
  600. INSERT INTO `sys_role_menu` VALUES ('2', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '2', null);
  601. INSERT INTO `sys_role_menu` VALUES ('3', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '3', null);
  602. INSERT INTO `sys_role_menu` VALUES ('4', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '4', null);
  603. INSERT INTO `sys_role_menu` VALUES ('5', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '5', null);
  604. INSERT INTO `sys_role_menu` VALUES ('6', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '6', null);
  605. INSERT INTO `sys_role_menu` VALUES ('7', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '7', null);
  606. INSERT INTO `sys_role_menu` VALUES ('8', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '8', null);
  607. 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);
  608. 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);
  609. 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);
  610. 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);
  611. 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);
  612. 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);
  613. 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);
  614. 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);
  615. 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);
  616. 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);
  617. 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);
  618. 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);
  619. 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);
  620. INSERT INTO `sys_role_menu` VALUES ('23', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '8', null);
  621. INSERT INTO `sys_role_menu` VALUES ('24', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '1', null);
  622. INSERT INTO `sys_role_menu` VALUES ('25', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '2', null);
  623. INSERT INTO `sys_role_menu` VALUES ('26', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '5', null);
  624. INSERT INTO `sys_role_menu` VALUES ('27', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '6', null);
  625. INSERT INTO `sys_role_menu` VALUES ('28', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '3', null);
  626. INSERT INTO `sys_role_menu` VALUES ('29', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '7', null);
  627. INSERT INTO `sys_role_menu` VALUES ('30', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '8', null);
  628. INSERT INTO `sys_role_menu` VALUES ('31', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '1', null);
  629. INSERT INTO `sys_role_menu` VALUES ('32', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '2', null);
  630. INSERT INTO `sys_role_menu` VALUES ('33', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '5', null);
  631. INSERT INTO `sys_role_menu` VALUES ('34', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '6', null);
  632. INSERT INTO `sys_role_menu` VALUES ('35', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '3', null);
  633. INSERT INTO `sys_role_menu` VALUES ('36', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '7', null);
  634. INSERT INTO `sys_role_menu` VALUES ('37', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '8', null);
  635. INSERT INTO `sys_role_menu` VALUES ('38', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '1', null);
  636. INSERT INTO `sys_role_menu` VALUES ('39', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '2', null);
  637. INSERT INTO `sys_role_menu` VALUES ('40', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '5', null);
  638. INSERT INTO `sys_role_menu` VALUES ('41', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '6', null);
  639. INSERT INTO `sys_role_menu` VALUES ('42', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '3', null);
  640. INSERT INTO `sys_role_menu` VALUES ('43', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '7', null);
  641. INSERT INTO `sys_role_menu` VALUES ('44', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '8', null);
  642. INSERT INTO `sys_role_menu` VALUES ('45', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '1', null);
  643. INSERT INTO `sys_role_menu` VALUES ('46', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '2', null);
  644. INSERT INTO `sys_role_menu` VALUES ('47', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '5', null);
  645. INSERT INTO `sys_role_menu` VALUES ('48', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '6', null);
  646. INSERT INTO `sys_role_menu` VALUES ('49', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '3', null);
  647. INSERT INTO `sys_role_menu` VALUES ('50', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '7', null);
  648. INSERT INTO `sys_role_menu` VALUES ('51', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '8', null);
  649. INSERT INTO `sys_role_menu` VALUES ('52', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '1', null);
  650. INSERT INTO `sys_role_menu` VALUES ('53', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '2', null);
  651. INSERT INTO `sys_role_menu` VALUES ('54', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '5', null);
  652. INSERT INTO `sys_role_menu` VALUES ('55', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '6', null);
  653. INSERT INTO `sys_role_menu` VALUES ('56', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '3', null);
  654. INSERT INTO `sys_role_menu` VALUES ('57', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '7', null);
  655. INSERT INTO `sys_role_menu` VALUES ('58', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '9', null);
  656. INSERT INTO `sys_role_menu` VALUES ('59', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '10', null);
  657. INSERT INTO `sys_role_menu` VALUES ('60', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '8', null);
  658. INSERT INTO `sys_role_menu` VALUES ('61', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '1', null);
  659. INSERT INTO `sys_role_menu` VALUES ('62', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '2', null);
  660. INSERT INTO `sys_role_menu` VALUES ('63', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '5', null);
  661. INSERT INTO `sys_role_menu` VALUES ('64', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '6', null);
  662. INSERT INTO `sys_role_menu` VALUES ('65', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '3', null);
  663. INSERT INTO `sys_role_menu` VALUES ('66', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '7', null);
  664. INSERT INTO `sys_role_menu` VALUES ('67', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '9', null);
  665. INSERT INTO `sys_role_menu` VALUES ('68', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '10', null);
  666. INSERT INTO `sys_role_menu` VALUES ('69', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '8', null);
  667. INSERT INTO `sys_role_menu` VALUES ('70', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '1', null);
  668. INSERT INTO `sys_role_menu` VALUES ('71', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '2', null);
  669. INSERT INTO `sys_role_menu` VALUES ('72', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '5', null);
  670. INSERT INTO `sys_role_menu` VALUES ('73', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '6', null);
  671. INSERT INTO `sys_role_menu` VALUES ('74', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '3', null);
  672. INSERT INTO `sys_role_menu` VALUES ('75', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '7', null);
  673. INSERT INTO `sys_role_menu` VALUES ('76', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '9', null);
  674. INSERT INTO `sys_role_menu` VALUES ('77', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '10', null);
  675. INSERT INTO `sys_role_menu` VALUES ('78', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '8', null);
  676. INSERT INTO `sys_role_menu` VALUES ('79', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '1', null);
  677. INSERT INTO `sys_role_menu` VALUES ('80', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '2', null);
  678. INSERT INTO `sys_role_menu` VALUES ('81', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '5', null);
  679. INSERT INTO `sys_role_menu` VALUES ('82', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '6', null);
  680. INSERT INTO `sys_role_menu` VALUES ('83', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '3', null);
  681. INSERT INTO `sys_role_menu` VALUES ('84', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '7', null);
  682. INSERT INTO `sys_role_menu` VALUES ('85', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '9', null);
  683. INSERT INTO `sys_role_menu` VALUES ('86', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '10', null);
  684. INSERT INTO `sys_role_menu` VALUES ('87', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '8', null);
  685. INSERT INTO `sys_role_menu` VALUES ('88', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '1', null);
  686. INSERT INTO `sys_role_menu` VALUES ('89', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '2', null);
  687. INSERT INTO `sys_role_menu` VALUES ('90', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '5', null);
  688. INSERT INTO `sys_role_menu` VALUES ('91', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '6', null);
  689. INSERT INTO `sys_role_menu` VALUES ('92', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '3', null);
  690. INSERT INTO `sys_role_menu` VALUES ('93', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '7', null);
  691. INSERT INTO `sys_role_menu` VALUES ('94', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '9', null);
  692. INSERT INTO `sys_role_menu` VALUES ('95', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '10', null);
  693. INSERT INTO `sys_role_menu` VALUES ('96', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '8', null);
  694. INSERT INTO `sys_role_menu` VALUES ('97', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '1', null);
  695. INSERT INTO `sys_role_menu` VALUES ('98', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '2', null);
  696. INSERT INTO `sys_role_menu` VALUES ('99', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '5', null);
  697. INSERT INTO `sys_role_menu` VALUES ('100', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '6', null);
  698. INSERT INTO `sys_role_menu` VALUES ('101', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '3', null);
  699. INSERT INTO `sys_role_menu` VALUES ('102', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '7', null);
  700. INSERT INTO `sys_role_menu` VALUES ('103', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '9', null);
  701. INSERT INTO `sys_role_menu` VALUES ('104', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '10', null);
  702. INSERT INTO `sys_role_menu` VALUES ('105', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '8', null);
  703. INSERT INTO `sys_role_menu` VALUES ('106', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '1', null);
  704. INSERT INTO `sys_role_menu` VALUES ('107', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '2', null);
  705. INSERT INTO `sys_role_menu` VALUES ('108', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '5', null);
  706. INSERT INTO `sys_role_menu` VALUES ('109', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '6', null);
  707. INSERT INTO `sys_role_menu` VALUES ('110', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '3', null);
  708. INSERT INTO `sys_role_menu` VALUES ('111', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '7', null);
  709. INSERT INTO `sys_role_menu` VALUES ('112', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '9', null);
  710. INSERT INTO `sys_role_menu` VALUES ('113', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '10', null);
  711. INSERT INTO `sys_role_menu` VALUES ('114', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '8', null);
  712. INSERT INTO `sys_role_menu` VALUES ('115', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '1', null);
  713. INSERT INTO `sys_role_menu` VALUES ('116', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '2', null);
  714. INSERT INTO `sys_role_menu` VALUES ('117', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '5', null);
  715. INSERT INTO `sys_role_menu` VALUES ('118', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '6', null);
  716. INSERT INTO `sys_role_menu` VALUES ('119', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '3', null);
  717. INSERT INTO `sys_role_menu` VALUES ('120', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '7', null);
  718. INSERT INTO `sys_role_menu` VALUES ('121', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '9', null);
  719. INSERT INTO `sys_role_menu` VALUES ('122', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '10', null);
  720. INSERT INTO `sys_role_menu` VALUES ('123', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '8', null);
  721. INSERT INTO `sys_role_menu` VALUES ('124', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '1', null);
  722. INSERT INTO `sys_role_menu` VALUES ('125', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '2', null);
  723. INSERT INTO `sys_role_menu` VALUES ('126', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '5', null);
  724. INSERT INTO `sys_role_menu` VALUES ('127', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '6', null);
  725. INSERT INTO `sys_role_menu` VALUES ('128', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '3', null);
  726. INSERT INTO `sys_role_menu` VALUES ('129', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '7', null);
  727. INSERT INTO `sys_role_menu` VALUES ('130', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '9', null);
  728. INSERT INTO `sys_role_menu` VALUES ('131', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '10', null);
  729. INSERT INTO `sys_role_menu` VALUES ('132', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '8', null);
  730. INSERT INTO `sys_role_menu` VALUES ('133', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '1', null);
  731. INSERT INTO `sys_role_menu` VALUES ('134', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '2', null);
  732. INSERT INTO `sys_role_menu` VALUES ('135', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '5', null);
  733. INSERT INTO `sys_role_menu` VALUES ('136', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '6', null);
  734. INSERT INTO `sys_role_menu` VALUES ('137', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '3', null);
  735. INSERT INTO `sys_role_menu` VALUES ('138', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '7', null);
  736. INSERT INTO `sys_role_menu` VALUES ('139', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '8', null);
  737. INSERT INTO `sys_role_menu` VALUES ('140', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '1', null);
  738. INSERT INTO `sys_role_menu` VALUES ('141', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '2', null);
  739. INSERT INTO `sys_role_menu` VALUES ('142', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '5', null);
  740. INSERT INTO `sys_role_menu` VALUES ('143', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '6', null);
  741. INSERT INTO `sys_role_menu` VALUES ('144', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '3', null);
  742. INSERT INTO `sys_role_menu` VALUES ('145', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '9', null);
  743. INSERT INTO `sys_role_menu` VALUES ('146', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '8', null);
  744. INSERT INTO `sys_role_menu` VALUES ('147', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '1', null);
  745. INSERT INTO `sys_role_menu` VALUES ('148', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '2', null);
  746. INSERT INTO `sys_role_menu` VALUES ('149', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '5', null);
  747. INSERT INTO `sys_role_menu` VALUES ('150', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '6', null);
  748. INSERT INTO `sys_role_menu` VALUES ('151', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '3', null);
  749. INSERT INTO `sys_role_menu` VALUES ('152', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '10', null);
  750. INSERT INTO `sys_role_menu` VALUES ('153', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '8', null);
  751. INSERT INTO `sys_role_menu` VALUES ('154', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '1', null);
  752. INSERT INTO `sys_role_menu` VALUES ('155', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '2', null);
  753. INSERT INTO `sys_role_menu` VALUES ('156', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '5', null);
  754. INSERT INTO `sys_role_menu` VALUES ('157', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '6', null);
  755. INSERT INTO `sys_role_menu` VALUES ('158', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '3', null);
  756. INSERT INTO `sys_role_menu` VALUES ('159', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '7', null);
  757. INSERT INTO `sys_role_menu` VALUES ('160', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '9', null);
  758. INSERT INTO `sys_role_menu` VALUES ('161', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '10', null);
  759. INSERT INTO `sys_role_menu` VALUES ('162', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '8', null);
  760. INSERT INTO `sys_role_menu` VALUES ('163', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '1', null);
  761. INSERT INTO `sys_role_menu` VALUES ('164', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '2', null);
  762. INSERT INTO `sys_role_menu` VALUES ('165', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '5', null);
  763. INSERT INTO `sys_role_menu` VALUES ('166', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '6', null);
  764. INSERT INTO `sys_role_menu` VALUES ('167', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '3', null);
  765. INSERT INTO `sys_role_menu` VALUES ('168', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '7', null);
  766. INSERT INTO `sys_role_menu` VALUES ('169', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '9', null);
  767. INSERT INTO `sys_role_menu` VALUES ('170', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '10', null);
  768. INSERT INTO `sys_role_menu` VALUES ('171', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '8', null);
  769. INSERT INTO `sys_role_menu` VALUES ('172', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '1', null);
  770. INSERT INTO `sys_role_menu` VALUES ('173', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '2', null);
  771. INSERT INTO `sys_role_menu` VALUES ('174', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '5', null);
  772. INSERT INTO `sys_role_menu` VALUES ('175', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '6', null);
  773. INSERT INTO `sys_role_menu` VALUES ('176', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '3', null);
  774. INSERT INTO `sys_role_menu` VALUES ('177', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '7', null);
  775. INSERT INTO `sys_role_menu` VALUES ('178', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '9', null);
  776. INSERT INTO `sys_role_menu` VALUES ('179', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '10', null);
  777. INSERT INTO `sys_role_menu` VALUES ('180', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '8', null);
  778. INSERT INTO `sys_role_menu` VALUES ('181', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '1', null);
  779. INSERT INTO `sys_role_menu` VALUES ('182', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '2', null);
  780. INSERT INTO `sys_role_menu` VALUES ('183', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '5', null);
  781. INSERT INTO `sys_role_menu` VALUES ('184', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '6', null);
  782. INSERT INTO `sys_role_menu` VALUES ('185', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '3', null);
  783. INSERT INTO `sys_role_menu` VALUES ('186', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '7', null);
  784. INSERT INTO `sys_role_menu` VALUES ('187', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '9', null);
  785. INSERT INTO `sys_role_menu` VALUES ('188', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '10', null);
  786. INSERT INTO `sys_role_menu` VALUES ('189', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '8', null);
  787. INSERT INTO `sys_role_menu` VALUES ('190', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '1', null);
  788. INSERT INTO `sys_role_menu` VALUES ('191', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '2', null);
  789. INSERT INTO `sys_role_menu` VALUES ('192', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '5', null);
  790. INSERT INTO `sys_role_menu` VALUES ('193', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '6', null);
  791. INSERT INTO `sys_role_menu` VALUES ('194', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '3', null);
  792. INSERT INTO `sys_role_menu` VALUES ('195', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '7', null);
  793. INSERT INTO `sys_role_menu` VALUES ('196', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '9', null);
  794. INSERT INTO `sys_role_menu` VALUES ('197', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '10', null);
  795. INSERT INTO `sys_role_menu` VALUES ('198', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '8', null);
  796. INSERT INTO `sys_role_menu` VALUES ('199', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '1', null);
  797. INSERT INTO `sys_role_menu` VALUES ('200', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '2', null);
  798. INSERT INTO `sys_role_menu` VALUES ('201', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '5', null);
  799. INSERT INTO `sys_role_menu` VALUES ('202', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '6', null);
  800. INSERT INTO `sys_role_menu` VALUES ('203', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '3', null);
  801. INSERT INTO `sys_role_menu` VALUES ('204', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '7', null);
  802. INSERT INTO `sys_role_menu` VALUES ('205', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '9', null);
  803. INSERT INTO `sys_role_menu` VALUES ('206', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '10', null);
  804. INSERT INTO `sys_role_menu` VALUES ('207', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '15', null);
  805. INSERT INTO `sys_role_menu` VALUES ('208', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '8', null);
  806. INSERT INTO `sys_role_menu` VALUES ('209', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '1', null);
  807. INSERT INTO `sys_role_menu` VALUES ('210', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '2', null);
  808. INSERT INTO `sys_role_menu` VALUES ('211', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '5', null);
  809. INSERT INTO `sys_role_menu` VALUES ('212', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '6', null);
  810. INSERT INTO `sys_role_menu` VALUES ('213', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '3', null);
  811. INSERT INTO `sys_role_menu` VALUES ('214', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '7', null);
  812. INSERT INTO `sys_role_menu` VALUES ('215', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '9', null);
  813. INSERT INTO `sys_role_menu` VALUES ('216', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '10', null);
  814. -- ----------------------------
  815. -- Table structure for sys_role_permission
  816. -- ----------------------------
  817. DROP TABLE IF EXISTS `sys_role_permission`;
  818. CREATE TABLE `sys_role_permission` (
  819. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  820. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  821. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  822. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  823. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  824. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  825. `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id',
  826. `permission_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '资源id',
  827. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  828. PRIMARY KEY (`id`)
  829. ) ENGINE=InnoDB AUTO_INCREMENT=540 DEFAULT CHARSET=utf8 COMMENT='角色和资源的映射表';
  830. -- ----------------------------
  831. -- Records of sys_role_permission
  832. -- ----------------------------
  833. INSERT INTO `sys_role_permission` VALUES ('1', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '1', '基础功能-获取用户、机构、菜单信息');
  834. INSERT INTO `sys_role_permission` VALUES ('2', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '2', '基础功能-修改密码');
  835. INSERT INTO `sys_role_permission` VALUES ('3', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '3', '用户-基础数据维护-获取医院模块数据信息');
  836. INSERT INTO `sys_role_permission` VALUES ('4', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '4', '用户-基础数据维护-批量更新模块数据');
  837. INSERT INTO `sys_role_permission` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '1', '基础功能-获取用户、机构、菜单信息');
  838. INSERT INTO `sys_role_permission` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '2', '基础功能-修改密码');
  839. INSERT INTO `sys_role_permission` VALUES ('7', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '5', '用户-质控评分-分页');
  840. INSERT INTO `sys_role_permission` VALUES ('8', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '6', '用户-条目数据维护-分页获取医院条目数据信息');
  841. INSERT INTO `sys_role_permission` VALUES ('9', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '7', '用户-条目数据维护-修改医院条目数据信息');
  842. INSERT INTO `sys_role_permission` VALUES ('10', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '8', '用户-条目数据维护-获取医院模块数据列表');
  843. INSERT INTO `sys_role_permission` VALUES ('11', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '9', '控制台-病历相关统计');
  844. INSERT INTO `sys_role_permission` VALUES ('12', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '10', '用户-条目数据维护-模糊查询医院模块条目列表');
  845. INSERT INTO `sys_role_permission` VALUES ('13', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '11', '用户-质控评分-新增质控条目');
  846. INSERT INTO `sys_role_permission` VALUES ('14', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '12', '用户-质控评分-删除质控条目');
  847. INSERT INTO `sys_role_permission` VALUES ('15', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '13', '用户-质控评分-修改质控条目');
  848. INSERT INTO `sys_role_permission` VALUES ('16', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '14', '用户-质控评分-获取详情');
  849. INSERT INTO `sys_role_permission` VALUES ('17', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '15', '控制台-缺陷相关统计');
  850. INSERT INTO `sys_role_permission` VALUES ('18', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '16', '控制台-医院运营相关统计');
  851. INSERT INTO `sys_role_permission` VALUES ('19', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '17', '用户-质控评分-评分');
  852. INSERT INTO `sys_role_permission` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '3', '用户-基础数据维护-获取医院模块数据信息');
  853. INSERT INTO `sys_role_permission` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '4', '用户-基础数据维护-批量更新模块数据');
  854. INSERT INTO `sys_role_permission` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '5', '用户-质控评分-分页');
  855. INSERT INTO `sys_role_permission` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '6', '用户-条目数据维护-分页获取医院条目数据信息');
  856. INSERT INTO `sys_role_permission` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '7', '用户-条目数据维护-修改医院条目数据信息');
  857. INSERT INTO `sys_role_permission` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '8', '用户-条目数据维护-获取医院模块数据列表');
  858. INSERT INTO `sys_role_permission` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '9', '控制台-病历相关统计');
  859. INSERT INTO `sys_role_permission` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '10', '用户-条目数据维护-模糊查询医院模块条目列表');
  860. INSERT INTO `sys_role_permission` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '11', '用户-质控评分-新增质控条目');
  861. INSERT INTO `sys_role_permission` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '12', '用户-质控评分-删除质控条目');
  862. INSERT INTO `sys_role_permission` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '13', '用户-质控评分-修改质控条目');
  863. INSERT INTO `sys_role_permission` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '14', '用户-质控评分-获取详情');
  864. INSERT INTO `sys_role_permission` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '15', '控制台-缺陷相关统计');
  865. INSERT INTO `sys_role_permission` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '16', '控制台-医院运营相关统计');
  866. INSERT INTO `sys_role_permission` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '17', '用户-质控评分-评分');
  867. INSERT INTO `sys_role_permission` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '18', '用户-权限管理-角色管理-获取角色列表信息');
  868. INSERT INTO `sys_role_permission` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '19', '用户-权限管理-角色管理-获取角色菜权限单等数据');
  869. INSERT INTO `sys_role_permission` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '20', '用户-权限管理-角色管理-修改角色菜单权限数据');
  870. INSERT INTO `sys_role_permission` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '21', '用户-权限管理-用户管理-获取医院科室下拉列表信息');
  871. INSERT INTO `sys_role_permission` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '22', '用户-权限管理-用户管理-获取角色下拉列表信息');
  872. INSERT INTO `sys_role_permission` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '23', '用户-权限管理-用户管理-用户列表翻页信息查询');
  873. INSERT INTO `sys_role_permission` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '24', '用户-权限管理-用户管理-获取用户科室');
  874. INSERT INTO `sys_role_permission` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '25', '用户-权限管理-用户管理-获取用户角色');
  875. INSERT INTO `sys_role_permission` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '26', '用户-权限管理-用户管理-用户启用');
  876. INSERT INTO `sys_role_permission` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '27', '用户-权限管理-用户管理-用户停用');
  877. INSERT INTO `sys_role_permission` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '28', '用户-权限管理-用户管理-编辑用户科室');
  878. INSERT INTO `sys_role_permission` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '29', '用户-权限管理-用户管理-编辑用户角色');
  879. INSERT INTO `sys_role_permission` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '30', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息');
  880. INSERT INTO `sys_role_permission` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '31', '用户-质控评分-获取病历质控一览下用户科室下拉列表信息');
  881. INSERT INTO `sys_role_permission` VALUES ('49', 'Y', '1970-01-01 12:00:00', '2020-05-06 18:34:26', '0', '1', '1', '30', '用户-质控评分-获取病历质控一览下医院科室下拉列表信息');
  882. INSERT INTO `sys_role_permission` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '32', '用户-质控评分(科室)-分页');
  883. INSERT INTO `sys_role_permission` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '33', '用户-质控评分(个人)-分页');
  884. INSERT INTO `sys_role_permission` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '34', '用户-质控评分(科室)-评分');
  885. INSERT INTO `sys_role_permission` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '35', '用户-质控评分(科室)-新增质控条目');
  886. INSERT INTO `sys_role_permission` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '36', '用户-质控评分(科室)-删除质控条目');
  887. INSERT INTO `sys_role_permission` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '37', '用户-质控评分(科室)-修改质控条目');
  888. INSERT INTO `sys_role_permission` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '38', '用户-质控评分(科室)-获取详情');
  889. INSERT INTO `sys_role_permission` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '39', '用户-质控评分(个人)-获取病历质控一览下用户科室下拉列表信息');
  890. INSERT INTO `sys_role_permission` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '40', '用户-质控评分(科室)-评分');
  891. INSERT INTO `sys_role_permission` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '41', '用户-质控评分(科室)-新增质控条目');
  892. INSERT INTO `sys_role_permission` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '42', '用户-质控评分(科室)-删除质控条目');
  893. INSERT INTO `sys_role_permission` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '43', '用户-质控评分(科室)-修改质控条目');
  894. INSERT INTO `sys_role_permission` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '44', '用户-质控评分(科室)-获取详情');
  895. INSERT INTO `sys_role_permission` VALUES ('63', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '1', null);
  896. INSERT INTO `sys_role_permission` VALUES ('64', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '2', null);
  897. INSERT INTO `sys_role_permission` VALUES ('65', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '9', null);
  898. INSERT INTO `sys_role_permission` VALUES ('66', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '15', null);
  899. INSERT INTO `sys_role_permission` VALUES ('67', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '16', null);
  900. INSERT INTO `sys_role_permission` VALUES ('68', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '3', null);
  901. INSERT INTO `sys_role_permission` VALUES ('69', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '4', null);
  902. INSERT INTO `sys_role_permission` VALUES ('70', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '6', null);
  903. INSERT INTO `sys_role_permission` VALUES ('71', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '7', null);
  904. INSERT INTO `sys_role_permission` VALUES ('72', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '8', null);
  905. INSERT INTO `sys_role_permission` VALUES ('73', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '30', null);
  906. INSERT INTO `sys_role_permission` VALUES ('74', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '5', null);
  907. INSERT INTO `sys_role_permission` VALUES ('75', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '11', null);
  908. INSERT INTO `sys_role_permission` VALUES ('76', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '12', null);
  909. INSERT INTO `sys_role_permission` VALUES ('77', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '13', null);
  910. INSERT INTO `sys_role_permission` VALUES ('78', 'Y', '2020-05-06 18:34:26', '2020-05-06 18:34:54', '1', '1', '1', '14', null);
  911. INSERT INTO `sys_role_permission` VALUES ('79', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '1', null);
  912. INSERT INTO `sys_role_permission` VALUES ('80', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '2', null);
  913. INSERT INTO `sys_role_permission` VALUES ('81', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '9', null);
  914. INSERT INTO `sys_role_permission` VALUES ('82', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '15', null);
  915. INSERT INTO `sys_role_permission` VALUES ('83', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '16', null);
  916. INSERT INTO `sys_role_permission` VALUES ('84', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '3', null);
  917. INSERT INTO `sys_role_permission` VALUES ('85', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '4', null);
  918. INSERT INTO `sys_role_permission` VALUES ('86', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '6', null);
  919. INSERT INTO `sys_role_permission` VALUES ('87', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '7', null);
  920. INSERT INTO `sys_role_permission` VALUES ('88', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '8', null);
  921. INSERT INTO `sys_role_permission` VALUES ('89', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '30', null);
  922. INSERT INTO `sys_role_permission` VALUES ('90', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '17', null);
  923. INSERT INTO `sys_role_permission` VALUES ('91', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '5', null);
  924. INSERT INTO `sys_role_permission` VALUES ('92', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '11', null);
  925. INSERT INTO `sys_role_permission` VALUES ('93', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '12', null);
  926. INSERT INTO `sys_role_permission` VALUES ('94', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '13', null);
  927. INSERT INTO `sys_role_permission` VALUES ('95', 'Y', '2020-05-06 18:34:54', '2020-05-06 18:37:39', '1', '1', '1', '14', null);
  928. INSERT INTO `sys_role_permission` VALUES ('96', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '1', null);
  929. INSERT INTO `sys_role_permission` VALUES ('97', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '2', null);
  930. INSERT INTO `sys_role_permission` VALUES ('98', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '9', null);
  931. INSERT INTO `sys_role_permission` VALUES ('99', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '15', null);
  932. INSERT INTO `sys_role_permission` VALUES ('100', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '16', null);
  933. INSERT INTO `sys_role_permission` VALUES ('101', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '3', null);
  934. INSERT INTO `sys_role_permission` VALUES ('102', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '4', null);
  935. INSERT INTO `sys_role_permission` VALUES ('103', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '6', null);
  936. INSERT INTO `sys_role_permission` VALUES ('104', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '7', null);
  937. INSERT INTO `sys_role_permission` VALUES ('105', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '8', null);
  938. INSERT INTO `sys_role_permission` VALUES ('106', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '30', null);
  939. INSERT INTO `sys_role_permission` VALUES ('107', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '5', null);
  940. INSERT INTO `sys_role_permission` VALUES ('108', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '11', null);
  941. INSERT INTO `sys_role_permission` VALUES ('109', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '12', null);
  942. INSERT INTO `sys_role_permission` VALUES ('110', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '13', null);
  943. INSERT INTO `sys_role_permission` VALUES ('111', 'Y', '2020-05-06 18:37:39', '2020-05-06 18:41:51', '1', '1', '1', '14', null);
  944. INSERT INTO `sys_role_permission` VALUES ('112', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '1', null);
  945. INSERT INTO `sys_role_permission` VALUES ('113', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '2', null);
  946. INSERT INTO `sys_role_permission` VALUES ('114', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '9', null);
  947. INSERT INTO `sys_role_permission` VALUES ('115', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '15', null);
  948. INSERT INTO `sys_role_permission` VALUES ('116', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '16', null);
  949. INSERT INTO `sys_role_permission` VALUES ('117', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '3', null);
  950. INSERT INTO `sys_role_permission` VALUES ('118', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '4', null);
  951. INSERT INTO `sys_role_permission` VALUES ('119', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '6', null);
  952. INSERT INTO `sys_role_permission` VALUES ('120', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '7', null);
  953. INSERT INTO `sys_role_permission` VALUES ('121', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '8', null);
  954. INSERT INTO `sys_role_permission` VALUES ('122', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '5', null);
  955. INSERT INTO `sys_role_permission` VALUES ('123', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '11', null);
  956. INSERT INTO `sys_role_permission` VALUES ('124', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '12', null);
  957. INSERT INTO `sys_role_permission` VALUES ('125', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '13', null);
  958. INSERT INTO `sys_role_permission` VALUES ('126', 'Y', '2020-05-06 18:41:51', '2020-05-08 10:45:09', '1', '79', '1', '14', null);
  959. INSERT INTO `sys_role_permission` VALUES ('127', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '1', null);
  960. INSERT INTO `sys_role_permission` VALUES ('128', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '2', null);
  961. INSERT INTO `sys_role_permission` VALUES ('129', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '9', null);
  962. INSERT INTO `sys_role_permission` VALUES ('130', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '15', null);
  963. INSERT INTO `sys_role_permission` VALUES ('131', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '16', null);
  964. INSERT INTO `sys_role_permission` VALUES ('132', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '3', null);
  965. INSERT INTO `sys_role_permission` VALUES ('133', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '4', null);
  966. INSERT INTO `sys_role_permission` VALUES ('134', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '6', null);
  967. INSERT INTO `sys_role_permission` VALUES ('135', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '7', null);
  968. INSERT INTO `sys_role_permission` VALUES ('136', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '8', null);
  969. INSERT INTO `sys_role_permission` VALUES ('137', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '30', null);
  970. INSERT INTO `sys_role_permission` VALUES ('138', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '17', null);
  971. INSERT INTO `sys_role_permission` VALUES ('139', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '5', null);
  972. INSERT INTO `sys_role_permission` VALUES ('140', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '11', null);
  973. INSERT INTO `sys_role_permission` VALUES ('141', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '12', null);
  974. INSERT INTO `sys_role_permission` VALUES ('142', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '13', null);
  975. INSERT INTO `sys_role_permission` VALUES ('143', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '14', null);
  976. INSERT INTO `sys_role_permission` VALUES ('144', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '31', null);
  977. INSERT INTO `sys_role_permission` VALUES ('145', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '34', null);
  978. INSERT INTO `sys_role_permission` VALUES ('146', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '32', null);
  979. INSERT INTO `sys_role_permission` VALUES ('147', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '35', null);
  980. INSERT INTO `sys_role_permission` VALUES ('148', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '36', null);
  981. INSERT INTO `sys_role_permission` VALUES ('149', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '37', null);
  982. INSERT INTO `sys_role_permission` VALUES ('150', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '38', null);
  983. INSERT INTO `sys_role_permission` VALUES ('151', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '39', null);
  984. INSERT INTO `sys_role_permission` VALUES ('152', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '40', null);
  985. INSERT INTO `sys_role_permission` VALUES ('153', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '33', null);
  986. INSERT INTO `sys_role_permission` VALUES ('154', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '41', null);
  987. INSERT INTO `sys_role_permission` VALUES ('155', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '42', null);
  988. INSERT INTO `sys_role_permission` VALUES ('156', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '43', null);
  989. INSERT INTO `sys_role_permission` VALUES ('157', 'Y', '2020-05-08 10:45:09', '2020-05-08 10:45:21', '79', '79', '1', '44', null);
  990. INSERT INTO `sys_role_permission` VALUES ('158', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '1', null);
  991. INSERT INTO `sys_role_permission` VALUES ('159', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '2', null);
  992. INSERT INTO `sys_role_permission` VALUES ('160', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '9', null);
  993. INSERT INTO `sys_role_permission` VALUES ('161', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '15', null);
  994. INSERT INTO `sys_role_permission` VALUES ('162', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '16', null);
  995. INSERT INTO `sys_role_permission` VALUES ('163', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '3', null);
  996. INSERT INTO `sys_role_permission` VALUES ('164', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '4', null);
  997. INSERT INTO `sys_role_permission` VALUES ('165', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '6', null);
  998. INSERT INTO `sys_role_permission` VALUES ('166', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '7', null);
  999. INSERT INTO `sys_role_permission` VALUES ('167', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '8', null);
  1000. INSERT INTO `sys_role_permission` VALUES ('168', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '30', null);
  1001. INSERT INTO `sys_role_permission` VALUES ('169', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '17', null);
  1002. INSERT INTO `sys_role_permission` VALUES ('170', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '5', null);
  1003. INSERT INTO `sys_role_permission` VALUES ('171', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '11', null);
  1004. INSERT INTO `sys_role_permission` VALUES ('172', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '12', null);
  1005. INSERT INTO `sys_role_permission` VALUES ('173', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '13', null);
  1006. INSERT INTO `sys_role_permission` VALUES ('174', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '14', null);
  1007. INSERT INTO `sys_role_permission` VALUES ('175', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '31', null);
  1008. INSERT INTO `sys_role_permission` VALUES ('176', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '34', null);
  1009. INSERT INTO `sys_role_permission` VALUES ('177', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '32', null);
  1010. INSERT INTO `sys_role_permission` VALUES ('178', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '35', null);
  1011. INSERT INTO `sys_role_permission` VALUES ('179', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '36', null);
  1012. INSERT INTO `sys_role_permission` VALUES ('180', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '37', null);
  1013. INSERT INTO `sys_role_permission` VALUES ('181', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '38', null);
  1014. INSERT INTO `sys_role_permission` VALUES ('182', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '39', null);
  1015. INSERT INTO `sys_role_permission` VALUES ('183', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '40', null);
  1016. INSERT INTO `sys_role_permission` VALUES ('184', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '33', null);
  1017. INSERT INTO `sys_role_permission` VALUES ('185', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '41', null);
  1018. INSERT INTO `sys_role_permission` VALUES ('186', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '42', null);
  1019. INSERT INTO `sys_role_permission` VALUES ('187', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '43', null);
  1020. INSERT INTO `sys_role_permission` VALUES ('188', 'Y', '2020-05-08 10:46:25', '2020-05-08 10:48:34', '79', '79', '1', '44', null);
  1021. INSERT INTO `sys_role_permission` VALUES ('189', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '1', null);
  1022. INSERT INTO `sys_role_permission` VALUES ('190', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '2', null);
  1023. INSERT INTO `sys_role_permission` VALUES ('191', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '9', null);
  1024. INSERT INTO `sys_role_permission` VALUES ('192', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '15', null);
  1025. INSERT INTO `sys_role_permission` VALUES ('193', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '16', null);
  1026. INSERT INTO `sys_role_permission` VALUES ('194', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '3', null);
  1027. INSERT INTO `sys_role_permission` VALUES ('195', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '4', null);
  1028. INSERT INTO `sys_role_permission` VALUES ('196', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '6', null);
  1029. INSERT INTO `sys_role_permission` VALUES ('197', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '7', null);
  1030. INSERT INTO `sys_role_permission` VALUES ('198', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '8', null);
  1031. INSERT INTO `sys_role_permission` VALUES ('199', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '30', null);
  1032. INSERT INTO `sys_role_permission` VALUES ('200', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '17', null);
  1033. INSERT INTO `sys_role_permission` VALUES ('201', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '5', null);
  1034. INSERT INTO `sys_role_permission` VALUES ('202', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '11', null);
  1035. INSERT INTO `sys_role_permission` VALUES ('203', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '12', null);
  1036. INSERT INTO `sys_role_permission` VALUES ('204', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '13', null);
  1037. INSERT INTO `sys_role_permission` VALUES ('205', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '14', null);
  1038. INSERT INTO `sys_role_permission` VALUES ('206', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '31', null);
  1039. INSERT INTO `sys_role_permission` VALUES ('207', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '34', null);
  1040. INSERT INTO `sys_role_permission` VALUES ('208', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '32', null);
  1041. INSERT INTO `sys_role_permission` VALUES ('209', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '35', null);
  1042. INSERT INTO `sys_role_permission` VALUES ('210', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '36', null);
  1043. INSERT INTO `sys_role_permission` VALUES ('211', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '37', null);
  1044. INSERT INTO `sys_role_permission` VALUES ('212', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '38', null);
  1045. INSERT INTO `sys_role_permission` VALUES ('213', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '39', null);
  1046. INSERT INTO `sys_role_permission` VALUES ('214', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '40', null);
  1047. INSERT INTO `sys_role_permission` VALUES ('215', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '33', null);
  1048. INSERT INTO `sys_role_permission` VALUES ('216', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '41', null);
  1049. INSERT INTO `sys_role_permission` VALUES ('217', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '42', null);
  1050. INSERT INTO `sys_role_permission` VALUES ('218', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '43', null);
  1051. INSERT INTO `sys_role_permission` VALUES ('219', 'Y', '2020-05-08 11:22:08', '2020-05-08 14:32:46', '80', '80', '1', '44', null);
  1052. INSERT INTO `sys_role_permission` VALUES ('220', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '1', null);
  1053. INSERT INTO `sys_role_permission` VALUES ('221', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '9', null);
  1054. INSERT INTO `sys_role_permission` VALUES ('222', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '15', null);
  1055. INSERT INTO `sys_role_permission` VALUES ('223', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '16', null);
  1056. INSERT INTO `sys_role_permission` VALUES ('224', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '3', null);
  1057. INSERT INTO `sys_role_permission` VALUES ('225', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '4', null);
  1058. INSERT INTO `sys_role_permission` VALUES ('226', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '6', null);
  1059. INSERT INTO `sys_role_permission` VALUES ('227', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '7', null);
  1060. INSERT INTO `sys_role_permission` VALUES ('228', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '8', null);
  1061. INSERT INTO `sys_role_permission` VALUES ('229', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '30', null);
  1062. INSERT INTO `sys_role_permission` VALUES ('230', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '17', null);
  1063. INSERT INTO `sys_role_permission` VALUES ('231', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '5', null);
  1064. INSERT INTO `sys_role_permission` VALUES ('232', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '11', null);
  1065. INSERT INTO `sys_role_permission` VALUES ('233', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '12', null);
  1066. INSERT INTO `sys_role_permission` VALUES ('234', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '13', null);
  1067. INSERT INTO `sys_role_permission` VALUES ('235', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '14', null);
  1068. INSERT INTO `sys_role_permission` VALUES ('236', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '31', null);
  1069. INSERT INTO `sys_role_permission` VALUES ('237', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '34', null);
  1070. INSERT INTO `sys_role_permission` VALUES ('238', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '32', null);
  1071. INSERT INTO `sys_role_permission` VALUES ('239', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '35', null);
  1072. INSERT INTO `sys_role_permission` VALUES ('240', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '36', null);
  1073. INSERT INTO `sys_role_permission` VALUES ('241', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '37', null);
  1074. INSERT INTO `sys_role_permission` VALUES ('242', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '38', null);
  1075. INSERT INTO `sys_role_permission` VALUES ('243', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '39', null);
  1076. INSERT INTO `sys_role_permission` VALUES ('244', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '40', null);
  1077. INSERT INTO `sys_role_permission` VALUES ('245', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '33', null);
  1078. INSERT INTO `sys_role_permission` VALUES ('246', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '41', null);
  1079. INSERT INTO `sys_role_permission` VALUES ('247', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '42', null);
  1080. INSERT INTO `sys_role_permission` VALUES ('248', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '43', null);
  1081. INSERT INTO `sys_role_permission` VALUES ('249', 'Y', '2020-05-08 14:32:46', '2020-05-08 14:35:50', '80', '80', '1', '44', null);
  1082. INSERT INTO `sys_role_permission` VALUES ('250', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '1', null);
  1083. INSERT INTO `sys_role_permission` VALUES ('251', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '2', null);
  1084. INSERT INTO `sys_role_permission` VALUES ('252', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '9', null);
  1085. INSERT INTO `sys_role_permission` VALUES ('253', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '15', null);
  1086. INSERT INTO `sys_role_permission` VALUES ('254', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '16', null);
  1087. INSERT INTO `sys_role_permission` VALUES ('255', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '3', null);
  1088. INSERT INTO `sys_role_permission` VALUES ('256', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '4', null);
  1089. INSERT INTO `sys_role_permission` VALUES ('257', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '6', null);
  1090. INSERT INTO `sys_role_permission` VALUES ('258', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '7', null);
  1091. INSERT INTO `sys_role_permission` VALUES ('259', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '8', null);
  1092. INSERT INTO `sys_role_permission` VALUES ('260', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '30', null);
  1093. INSERT INTO `sys_role_permission` VALUES ('261', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '17', null);
  1094. INSERT INTO `sys_role_permission` VALUES ('262', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '5', null);
  1095. INSERT INTO `sys_role_permission` VALUES ('263', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '11', null);
  1096. INSERT INTO `sys_role_permission` VALUES ('264', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '12', null);
  1097. INSERT INTO `sys_role_permission` VALUES ('265', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '13', null);
  1098. INSERT INTO `sys_role_permission` VALUES ('266', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '14', null);
  1099. INSERT INTO `sys_role_permission` VALUES ('267', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '31', null);
  1100. INSERT INTO `sys_role_permission` VALUES ('268', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '34', null);
  1101. INSERT INTO `sys_role_permission` VALUES ('269', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '32', null);
  1102. INSERT INTO `sys_role_permission` VALUES ('270', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '35', null);
  1103. INSERT INTO `sys_role_permission` VALUES ('271', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '36', null);
  1104. INSERT INTO `sys_role_permission` VALUES ('272', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '37', null);
  1105. INSERT INTO `sys_role_permission` VALUES ('273', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '38', null);
  1106. INSERT INTO `sys_role_permission` VALUES ('274', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '39', null);
  1107. INSERT INTO `sys_role_permission` VALUES ('275', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '40', null);
  1108. INSERT INTO `sys_role_permission` VALUES ('276', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '33', null);
  1109. INSERT INTO `sys_role_permission` VALUES ('277', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '41', null);
  1110. INSERT INTO `sys_role_permission` VALUES ('278', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '42', null);
  1111. INSERT INTO `sys_role_permission` VALUES ('279', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '43', null);
  1112. INSERT INTO `sys_role_permission` VALUES ('280', 'Y', '2020-05-08 14:35:50', '2020-05-08 14:45:39', '80', '80', '1', '44', null);
  1113. INSERT INTO `sys_role_permission` VALUES ('281', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '1', null);
  1114. INSERT INTO `sys_role_permission` VALUES ('282', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '9', null);
  1115. INSERT INTO `sys_role_permission` VALUES ('283', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '15', null);
  1116. INSERT INTO `sys_role_permission` VALUES ('284', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '16', null);
  1117. INSERT INTO `sys_role_permission` VALUES ('285', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '3', null);
  1118. INSERT INTO `sys_role_permission` VALUES ('286', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '4', null);
  1119. INSERT INTO `sys_role_permission` VALUES ('287', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '6', null);
  1120. INSERT INTO `sys_role_permission` VALUES ('288', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '7', null);
  1121. INSERT INTO `sys_role_permission` VALUES ('289', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '8', null);
  1122. INSERT INTO `sys_role_permission` VALUES ('290', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '30', null);
  1123. INSERT INTO `sys_role_permission` VALUES ('291', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '17', null);
  1124. INSERT INTO `sys_role_permission` VALUES ('292', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '5', null);
  1125. INSERT INTO `sys_role_permission` VALUES ('293', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '11', null);
  1126. INSERT INTO `sys_role_permission` VALUES ('294', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '12', null);
  1127. INSERT INTO `sys_role_permission` VALUES ('295', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '13', null);
  1128. INSERT INTO `sys_role_permission` VALUES ('296', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '14', null);
  1129. INSERT INTO `sys_role_permission` VALUES ('297', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '31', null);
  1130. INSERT INTO `sys_role_permission` VALUES ('298', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '34', null);
  1131. INSERT INTO `sys_role_permission` VALUES ('299', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '32', null);
  1132. INSERT INTO `sys_role_permission` VALUES ('300', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '35', null);
  1133. INSERT INTO `sys_role_permission` VALUES ('301', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '36', null);
  1134. INSERT INTO `sys_role_permission` VALUES ('302', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '37', null);
  1135. INSERT INTO `sys_role_permission` VALUES ('303', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '38', null);
  1136. INSERT INTO `sys_role_permission` VALUES ('304', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '39', null);
  1137. INSERT INTO `sys_role_permission` VALUES ('305', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '40', null);
  1138. INSERT INTO `sys_role_permission` VALUES ('306', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '33', null);
  1139. INSERT INTO `sys_role_permission` VALUES ('307', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '41', null);
  1140. INSERT INTO `sys_role_permission` VALUES ('308', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '42', null);
  1141. INSERT INTO `sys_role_permission` VALUES ('309', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '43', null);
  1142. INSERT INTO `sys_role_permission` VALUES ('310', 'Y', '2020-05-08 14:45:39', '2020-05-08 15:59:11', '80', '80', '1', '44', null);
  1143. INSERT INTO `sys_role_permission` VALUES ('311', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '1', null);
  1144. INSERT INTO `sys_role_permission` VALUES ('312', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '9', null);
  1145. INSERT INTO `sys_role_permission` VALUES ('313', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '15', null);
  1146. INSERT INTO `sys_role_permission` VALUES ('314', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '16', null);
  1147. INSERT INTO `sys_role_permission` VALUES ('315', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '3', null);
  1148. INSERT INTO `sys_role_permission` VALUES ('316', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '6', null);
  1149. INSERT INTO `sys_role_permission` VALUES ('317', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '8', null);
  1150. INSERT INTO `sys_role_permission` VALUES ('318', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '30', null);
  1151. INSERT INTO `sys_role_permission` VALUES ('319', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '17', null);
  1152. INSERT INTO `sys_role_permission` VALUES ('320', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '5', null);
  1153. INSERT INTO `sys_role_permission` VALUES ('321', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '11', null);
  1154. INSERT INTO `sys_role_permission` VALUES ('322', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '12', null);
  1155. INSERT INTO `sys_role_permission` VALUES ('323', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '13', null);
  1156. INSERT INTO `sys_role_permission` VALUES ('324', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '14', null);
  1157. INSERT INTO `sys_role_permission` VALUES ('325', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '31', null);
  1158. INSERT INTO `sys_role_permission` VALUES ('326', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '34', null);
  1159. INSERT INTO `sys_role_permission` VALUES ('327', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '32', null);
  1160. INSERT INTO `sys_role_permission` VALUES ('328', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '35', null);
  1161. INSERT INTO `sys_role_permission` VALUES ('329', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '36', null);
  1162. INSERT INTO `sys_role_permission` VALUES ('330', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '37', null);
  1163. INSERT INTO `sys_role_permission` VALUES ('331', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '38', null);
  1164. INSERT INTO `sys_role_permission` VALUES ('332', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '39', null);
  1165. INSERT INTO `sys_role_permission` VALUES ('333', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '40', null);
  1166. INSERT INTO `sys_role_permission` VALUES ('334', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '33', null);
  1167. INSERT INTO `sys_role_permission` VALUES ('335', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '41', null);
  1168. INSERT INTO `sys_role_permission` VALUES ('336', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '42', null);
  1169. INSERT INTO `sys_role_permission` VALUES ('337', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '43', null);
  1170. INSERT INTO `sys_role_permission` VALUES ('338', 'Y', '2020-05-08 15:59:11', '2020-05-08 16:15:56', '80', '80', '1', '44', null);
  1171. INSERT INTO `sys_role_permission` VALUES ('339', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '1', null);
  1172. INSERT INTO `sys_role_permission` VALUES ('340', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '9', null);
  1173. INSERT INTO `sys_role_permission` VALUES ('341', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '15', null);
  1174. INSERT INTO `sys_role_permission` VALUES ('342', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '16', null);
  1175. INSERT INTO `sys_role_permission` VALUES ('343', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '3', null);
  1176. INSERT INTO `sys_role_permission` VALUES ('344', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '4', null);
  1177. INSERT INTO `sys_role_permission` VALUES ('345', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '6', null);
  1178. INSERT INTO `sys_role_permission` VALUES ('346', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '7', null);
  1179. INSERT INTO `sys_role_permission` VALUES ('347', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '8', null);
  1180. INSERT INTO `sys_role_permission` VALUES ('348', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '30', null);
  1181. INSERT INTO `sys_role_permission` VALUES ('349', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '17', null);
  1182. INSERT INTO `sys_role_permission` VALUES ('350', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '5', null);
  1183. INSERT INTO `sys_role_permission` VALUES ('351', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '11', null);
  1184. INSERT INTO `sys_role_permission` VALUES ('352', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '12', null);
  1185. INSERT INTO `sys_role_permission` VALUES ('353', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '13', null);
  1186. INSERT INTO `sys_role_permission` VALUES ('354', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '14', null);
  1187. INSERT INTO `sys_role_permission` VALUES ('355', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '31', null);
  1188. INSERT INTO `sys_role_permission` VALUES ('356', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '34', null);
  1189. INSERT INTO `sys_role_permission` VALUES ('357', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '32', null);
  1190. INSERT INTO `sys_role_permission` VALUES ('358', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '35', null);
  1191. INSERT INTO `sys_role_permission` VALUES ('359', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '36', null);
  1192. INSERT INTO `sys_role_permission` VALUES ('360', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '37', null);
  1193. INSERT INTO `sys_role_permission` VALUES ('361', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '38', null);
  1194. INSERT INTO `sys_role_permission` VALUES ('362', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '39', null);
  1195. INSERT INTO `sys_role_permission` VALUES ('363', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '40', null);
  1196. INSERT INTO `sys_role_permission` VALUES ('364', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '33', null);
  1197. INSERT INTO `sys_role_permission` VALUES ('365', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '41', null);
  1198. INSERT INTO `sys_role_permission` VALUES ('366', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '42', null);
  1199. INSERT INTO `sys_role_permission` VALUES ('367', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '43', null);
  1200. INSERT INTO `sys_role_permission` VALUES ('368', 'Y', '2020-05-08 16:15:56', '2020-05-08 17:10:21', '80', '80', '1', '44', null);
  1201. INSERT INTO `sys_role_permission` VALUES ('369', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '1', null);
  1202. INSERT INTO `sys_role_permission` VALUES ('370', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '9', null);
  1203. INSERT INTO `sys_role_permission` VALUES ('371', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '15', null);
  1204. INSERT INTO `sys_role_permission` VALUES ('372', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '16', null);
  1205. INSERT INTO `sys_role_permission` VALUES ('373', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '4', null);
  1206. INSERT INTO `sys_role_permission` VALUES ('374', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '7', null);
  1207. INSERT INTO `sys_role_permission` VALUES ('375', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '17', null);
  1208. INSERT INTO `sys_role_permission` VALUES ('376', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '11', null);
  1209. INSERT INTO `sys_role_permission` VALUES ('377', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '34', null);
  1210. INSERT INTO `sys_role_permission` VALUES ('378', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '35', null);
  1211. INSERT INTO `sys_role_permission` VALUES ('379', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '36', null);
  1212. INSERT INTO `sys_role_permission` VALUES ('380', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '37', null);
  1213. INSERT INTO `sys_role_permission` VALUES ('381', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '40', null);
  1214. INSERT INTO `sys_role_permission` VALUES ('382', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '41', null);
  1215. INSERT INTO `sys_role_permission` VALUES ('383', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '42', null);
  1216. INSERT INTO `sys_role_permission` VALUES ('384', 'Y', '2020-05-08 17:10:21', '2020-05-08 19:01:31', '80', '13', '1', '43', null);
  1217. INSERT INTO `sys_role_permission` VALUES ('385', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '1', null);
  1218. INSERT INTO `sys_role_permission` VALUES ('386', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '2', null);
  1219. INSERT INTO `sys_role_permission` VALUES ('387', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '9', null);
  1220. INSERT INTO `sys_role_permission` VALUES ('388', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '15', null);
  1221. INSERT INTO `sys_role_permission` VALUES ('389', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '16', null);
  1222. INSERT INTO `sys_role_permission` VALUES ('390', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '4', null);
  1223. INSERT INTO `sys_role_permission` VALUES ('391', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '7', null);
  1224. INSERT INTO `sys_role_permission` VALUES ('392', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '17', null);
  1225. INSERT INTO `sys_role_permission` VALUES ('393', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '11', null);
  1226. INSERT INTO `sys_role_permission` VALUES ('394', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '12', null);
  1227. INSERT INTO `sys_role_permission` VALUES ('395', 'Y', '2020-05-08 19:01:31', '2020-05-08 19:11:49', '13', '81', '1', '13', null);
  1228. INSERT INTO `sys_role_permission` VALUES ('396', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '1', null);
  1229. INSERT INTO `sys_role_permission` VALUES ('397', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '2', null);
  1230. INSERT INTO `sys_role_permission` VALUES ('398', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '9', null);
  1231. INSERT INTO `sys_role_permission` VALUES ('399', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '15', null);
  1232. INSERT INTO `sys_role_permission` VALUES ('400', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '16', null);
  1233. INSERT INTO `sys_role_permission` VALUES ('401', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '4', null);
  1234. INSERT INTO `sys_role_permission` VALUES ('402', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '7', null);
  1235. INSERT INTO `sys_role_permission` VALUES ('403', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '34', null);
  1236. INSERT INTO `sys_role_permission` VALUES ('404', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '35', null);
  1237. INSERT INTO `sys_role_permission` VALUES ('405', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '36', null);
  1238. INSERT INTO `sys_role_permission` VALUES ('406', 'N', '2020-05-08 19:01:43', '2020-05-08 19:01:43', '13', '13', '2', '37', null);
  1239. INSERT INTO `sys_role_permission` VALUES ('407', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '1', null);
  1240. INSERT INTO `sys_role_permission` VALUES ('408', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '2', null);
  1241. INSERT INTO `sys_role_permission` VALUES ('409', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '9', null);
  1242. INSERT INTO `sys_role_permission` VALUES ('410', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '15', null);
  1243. INSERT INTO `sys_role_permission` VALUES ('411', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '16', null);
  1244. INSERT INTO `sys_role_permission` VALUES ('412', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '4', null);
  1245. INSERT INTO `sys_role_permission` VALUES ('413', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '7', null);
  1246. INSERT INTO `sys_role_permission` VALUES ('414', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '40', null);
  1247. INSERT INTO `sys_role_permission` VALUES ('415', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '41', null);
  1248. INSERT INTO `sys_role_permission` VALUES ('416', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '42', null);
  1249. INSERT INTO `sys_role_permission` VALUES ('417', 'N', '2020-05-08 19:01:54', '2020-05-08 19:01:54', '13', '13', '3', '43', null);
  1250. INSERT INTO `sys_role_permission` VALUES ('418', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '1', null);
  1251. INSERT INTO `sys_role_permission` VALUES ('419', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '2', null);
  1252. INSERT INTO `sys_role_permission` VALUES ('420', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '9', null);
  1253. INSERT INTO `sys_role_permission` VALUES ('421', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '15', null);
  1254. INSERT INTO `sys_role_permission` VALUES ('422', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '16', null);
  1255. INSERT INTO `sys_role_permission` VALUES ('423', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '4', null);
  1256. INSERT INTO `sys_role_permission` VALUES ('424', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '7', null);
  1257. INSERT INTO `sys_role_permission` VALUES ('425', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '17', null);
  1258. INSERT INTO `sys_role_permission` VALUES ('426', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '11', null);
  1259. INSERT INTO `sys_role_permission` VALUES ('427', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '12', null);
  1260. INSERT INTO `sys_role_permission` VALUES ('428', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '13', null);
  1261. INSERT INTO `sys_role_permission` VALUES ('429', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '34', null);
  1262. INSERT INTO `sys_role_permission` VALUES ('430', 'Y', '2020-05-08 19:11:49', '2020-05-08 19:26:27', '81', '20', '1', '40', null);
  1263. INSERT INTO `sys_role_permission` VALUES ('431', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '1', null);
  1264. INSERT INTO `sys_role_permission` VALUES ('432', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '2', null);
  1265. INSERT INTO `sys_role_permission` VALUES ('433', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '9', null);
  1266. INSERT INTO `sys_role_permission` VALUES ('434', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '15', null);
  1267. INSERT INTO `sys_role_permission` VALUES ('435', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '16', null);
  1268. INSERT INTO `sys_role_permission` VALUES ('436', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '4', null);
  1269. INSERT INTO `sys_role_permission` VALUES ('437', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '7', null);
  1270. INSERT INTO `sys_role_permission` VALUES ('438', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '17', null);
  1271. INSERT INTO `sys_role_permission` VALUES ('439', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '11', null);
  1272. INSERT INTO `sys_role_permission` VALUES ('440', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '12', null);
  1273. INSERT INTO `sys_role_permission` VALUES ('441', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '13', null);
  1274. INSERT INTO `sys_role_permission` VALUES ('442', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '34', null);
  1275. INSERT INTO `sys_role_permission` VALUES ('443', 'Y', '2020-05-08 19:26:27', '2020-05-08 19:26:34', '20', '20', '1', '40', null);
  1276. INSERT INTO `sys_role_permission` VALUES ('444', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '1', null);
  1277. INSERT INTO `sys_role_permission` VALUES ('445', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '2', null);
  1278. INSERT INTO `sys_role_permission` VALUES ('446', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '9', null);
  1279. INSERT INTO `sys_role_permission` VALUES ('447', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '15', null);
  1280. INSERT INTO `sys_role_permission` VALUES ('448', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '16', null);
  1281. INSERT INTO `sys_role_permission` VALUES ('449', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '4', null);
  1282. INSERT INTO `sys_role_permission` VALUES ('450', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '7', null);
  1283. INSERT INTO `sys_role_permission` VALUES ('451', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '17', null);
  1284. INSERT INTO `sys_role_permission` VALUES ('452', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '11', null);
  1285. INSERT INTO `sys_role_permission` VALUES ('453', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '12', null);
  1286. INSERT INTO `sys_role_permission` VALUES ('454', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '13', null);
  1287. INSERT INTO `sys_role_permission` VALUES ('455', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '34', null);
  1288. INSERT INTO `sys_role_permission` VALUES ('456', 'Y', '2020-05-08 19:26:34', '2020-05-08 19:26:39', '20', '20', '1', '40', null);
  1289. INSERT INTO `sys_role_permission` VALUES ('457', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '1', null);
  1290. INSERT INTO `sys_role_permission` VALUES ('458', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '2', null);
  1291. INSERT INTO `sys_role_permission` VALUES ('459', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '9', null);
  1292. INSERT INTO `sys_role_permission` VALUES ('460', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '15', null);
  1293. INSERT INTO `sys_role_permission` VALUES ('461', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '16', null);
  1294. INSERT INTO `sys_role_permission` VALUES ('462', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '4', null);
  1295. INSERT INTO `sys_role_permission` VALUES ('463', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '7', null);
  1296. INSERT INTO `sys_role_permission` VALUES ('464', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '17', null);
  1297. INSERT INTO `sys_role_permission` VALUES ('465', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '11', null);
  1298. INSERT INTO `sys_role_permission` VALUES ('466', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '12', null);
  1299. INSERT INTO `sys_role_permission` VALUES ('467', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '13', null);
  1300. INSERT INTO `sys_role_permission` VALUES ('468', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '34', null);
  1301. INSERT INTO `sys_role_permission` VALUES ('469', 'Y', '2020-05-08 19:26:39', '2020-05-08 19:26:42', '20', '20', '1', '40', null);
  1302. INSERT INTO `sys_role_permission` VALUES ('470', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '1', null);
  1303. INSERT INTO `sys_role_permission` VALUES ('471', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '2', null);
  1304. INSERT INTO `sys_role_permission` VALUES ('472', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '9', null);
  1305. INSERT INTO `sys_role_permission` VALUES ('473', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '15', null);
  1306. INSERT INTO `sys_role_permission` VALUES ('474', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '16', null);
  1307. INSERT INTO `sys_role_permission` VALUES ('475', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '4', null);
  1308. INSERT INTO `sys_role_permission` VALUES ('476', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '7', null);
  1309. INSERT INTO `sys_role_permission` VALUES ('477', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '17', null);
  1310. INSERT INTO `sys_role_permission` VALUES ('478', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '11', null);
  1311. INSERT INTO `sys_role_permission` VALUES ('479', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '12', null);
  1312. INSERT INTO `sys_role_permission` VALUES ('480', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '13', null);
  1313. INSERT INTO `sys_role_permission` VALUES ('481', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '34', null);
  1314. INSERT INTO `sys_role_permission` VALUES ('482', 'Y', '2020-05-08 19:26:42', '2020-05-08 19:27:08', '20', '20', '1', '40', null);
  1315. INSERT INTO `sys_role_permission` VALUES ('483', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '1', null);
  1316. INSERT INTO `sys_role_permission` VALUES ('484', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '2', null);
  1317. INSERT INTO `sys_role_permission` VALUES ('485', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '9', null);
  1318. INSERT INTO `sys_role_permission` VALUES ('486', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '15', null);
  1319. INSERT INTO `sys_role_permission` VALUES ('487', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '16', null);
  1320. INSERT INTO `sys_role_permission` VALUES ('488', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '4', null);
  1321. INSERT INTO `sys_role_permission` VALUES ('489', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '7', null);
  1322. INSERT INTO `sys_role_permission` VALUES ('490', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '17', null);
  1323. INSERT INTO `sys_role_permission` VALUES ('491', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '11', null);
  1324. INSERT INTO `sys_role_permission` VALUES ('492', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '12', null);
  1325. INSERT INTO `sys_role_permission` VALUES ('493', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '13', null);
  1326. INSERT INTO `sys_role_permission` VALUES ('494', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '34', null);
  1327. INSERT INTO `sys_role_permission` VALUES ('495', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '35', null);
  1328. INSERT INTO `sys_role_permission` VALUES ('496', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '36', null);
  1329. INSERT INTO `sys_role_permission` VALUES ('497', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '37', null);
  1330. INSERT INTO `sys_role_permission` VALUES ('498', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '40', null);
  1331. INSERT INTO `sys_role_permission` VALUES ('499', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '41', null);
  1332. INSERT INTO `sys_role_permission` VALUES ('500', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '42', null);
  1333. INSERT INTO `sys_role_permission` VALUES ('501', 'Y', '2020-05-08 19:27:32', '2020-05-09 14:10:39', '20', '80', '1', '43', null);
  1334. INSERT INTO `sys_role_permission` VALUES ('502', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '45', '控制台-平均住院天数');
  1335. INSERT INTO `sys_role_permission` VALUES ('503', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '46', '控制台-平均住院费用');
  1336. INSERT INTO `sys_role_permission` VALUES ('504', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '47', '控制台-质控平均分按科室统计');
  1337. INSERT INTO `sys_role_permission` VALUES ('505', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '48', '控制台-各科室甲级病历占比');
  1338. INSERT INTO `sys_role_permission` VALUES ('506', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '49', '控制台-出院人数统计');
  1339. INSERT INTO `sys_role_permission` VALUES ('507', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '50', '控制台-质控病历统计');
  1340. INSERT INTO `sys_role_permission` VALUES ('508', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '51', '控制台-各模块缺陷占比排行');
  1341. INSERT INTO `sys_role_permission` VALUES ('509', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '52', '控制台-条目缺陷占比');
  1342. INSERT INTO `sys_role_permission` VALUES ('510', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '-1', '53', '控制台-各科室缺陷占比');
  1343. INSERT INTO `sys_role_permission` VALUES ('511', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '54', '控制台(科室)-出院人数统计(科室)');
  1344. INSERT INTO `sys_role_permission` VALUES ('512', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '55', '控制台(科室)-质控病历数统计(科室)');
  1345. INSERT INTO `sys_role_permission` VALUES ('513', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '56', '控制台(科室)-各模块缺陷占比排行(科室)');
  1346. INSERT INTO `sys_role_permission` VALUES ('514', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '57', '控制台(科室)-条目缺陷占比(科室)');
  1347. INSERT INTO `sys_role_permission` VALUES ('515', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '1', null);
  1348. INSERT INTO `sys_role_permission` VALUES ('516', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '2', null);
  1349. INSERT INTO `sys_role_permission` VALUES ('517', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '45', null);
  1350. INSERT INTO `sys_role_permission` VALUES ('518', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '46', null);
  1351. INSERT INTO `sys_role_permission` VALUES ('519', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '47', null);
  1352. INSERT INTO `sys_role_permission` VALUES ('520', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '48', null);
  1353. INSERT INTO `sys_role_permission` VALUES ('521', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '49', null);
  1354. INSERT INTO `sys_role_permission` VALUES ('522', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '50', null);
  1355. INSERT INTO `sys_role_permission` VALUES ('523', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '51', null);
  1356. INSERT INTO `sys_role_permission` VALUES ('524', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '52', null);
  1357. INSERT INTO `sys_role_permission` VALUES ('525', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '53', null);
  1358. INSERT INTO `sys_role_permission` VALUES ('526', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '4', null);
  1359. INSERT INTO `sys_role_permission` VALUES ('527', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '7', null);
  1360. INSERT INTO `sys_role_permission` VALUES ('528', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '17', null);
  1361. INSERT INTO `sys_role_permission` VALUES ('529', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '11', null);
  1362. INSERT INTO `sys_role_permission` VALUES ('530', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '12', null);
  1363. INSERT INTO `sys_role_permission` VALUES ('531', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '13', null);
  1364. INSERT INTO `sys_role_permission` VALUES ('532', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '34', null);
  1365. INSERT INTO `sys_role_permission` VALUES ('533', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '35', null);
  1366. INSERT INTO `sys_role_permission` VALUES ('534', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '36', null);
  1367. INSERT INTO `sys_role_permission` VALUES ('535', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '37', null);
  1368. INSERT INTO `sys_role_permission` VALUES ('536', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '40', null);
  1369. INSERT INTO `sys_role_permission` VALUES ('537', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '41', null);
  1370. INSERT INTO `sys_role_permission` VALUES ('538', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '42', null);
  1371. INSERT INTO `sys_role_permission` VALUES ('539', 'N', '2020-05-09 14:10:39', '2020-05-09 14:10:39', '80', '80', '1', '43', null);