02-menuInit.sql 2.0 KB

12345678910111213
  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 ('role','角色管理','pages/system/role.html','system','系统管理','null',100002,'1');
  5. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('personal','人员管理','pages/system/user.html','system','系统管理','null',100003,'1');
  6. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('loginlist','登录日志','pages/system/loginlist.html','system','系统管理','null',100004,'1');
  7. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('department','机构管理','pages/system/sysdepartment.html','system','系统管理','null',100005,'1');
  8. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('user_manager','用户管理','','','','null',100006,'1');
  9. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('user_list','用户列表','pages/business/userlist.html','user_manager','用户管理','null',100007,'1');
  10. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('trademark_management','商标公证管理','','','','null',100008,'1');
  11. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('trademark_auditing','商标公证审核','pages/trademark/auditing.html','trademark_management','商标公证管理','null',100009,'1');
  12. INSERT INTO SYS_MENU(MENUID, MENUNAME, MENUURL, MENUPID, MENUDESC,MENUIMAGE,MENUINDEX,FLAG)VALUES ('reissue_cert','补发纸证','pages/trademark/reissueCert.html','trademark_management','补发纸证管理','null',100010,'1');