USE `sys-user`;

INSERT INTO `sys_menu` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','诊断依据维护','97','LT-ZSKKZWH-ZUYJ','5','朗通-知识库扩展维护-诊断依据维护');


INSERT INTO sys_role_menu (role_id, menu_id,remark) SELECT c.id, a.id,a.remark  FROM sys_menu a INNER JOIN sys_role c
  WHERE a.name IN ("诊断依据维护") AND a.is_deleted = "N"  AND a.creator = - 1  AND c.name = "CDSS知识库";

