02-menuInit.sql 1.3 KB

12345678910
  1. -- 以下为菜单初始化文件,再次生成将覆盖
  2. DELETE FROM SYS_MENU;
  3. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('system','系统管理','','','系统管理','null',100001,'1');
  4. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('department','机构管理','department','system','机构管理','null',100002,'1');
  5. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('role','角色管理','role','system','角色管理','null',100003,'1');
  6. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('personal','人员管理','personal','system','人员管理','null',100004,'1');
  7. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('batch','批量管理','batch','system','批量管理','null',100005,'1');
  8. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('loginlist','登录日志','loginlist','system','登录日志','null',100006,'1');
  9. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('application','业务功能','','','业务功能','null',100007,'1');