menu_setup.sql

Java的框架

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @MENUID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@MENUID, 'MenuConfigMenu.Add', 'menu.menuConfigMenu.addMenu', 'Add menu', '_self', '/editMenu.action?method=Add&parentId=-1', 1);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @MENUID);


## ----------------- Audit log ------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@ADMINID, 'AuditMenu', 'menu.auditMenu', 'Audit  Menu', '_self', '', 4);

SET @AUDITID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@AUDITID, 'admin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@AUDITID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@AUDITID, 'AuditMenu.List.Active.User', 'menu.auditMenu.activeUsers', 'List all active user', '_self', '/activeUsers.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @AUDITID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@AUDITID, 'AuditMenu.List.Session.Log', 'menu.auditMenu.listSessionLog', 'List all user session log', '_self', '/listSessionLog.action', 1);
     
SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @AUDITID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@AUDITID, 'AuditMenu.Purge.Session.Log', 'menu.auditMenu.purgeSessionLog', 'Purge user session log', '_self', '/purgeSessionLog.action', 2);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @AUDITID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@AUDITID, 'AuditMenu.Clickstream', 'menu.clickstream', 'List clickstream log', '_self', '/clickstreams.jsp', 3);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @AUDITID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@AUDITID, 'AuditMenu.List.Action.Log', 'menu.clickstream.listActionLog', 'List action log', '_self', '/listActionLog.action', 4);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @AUDITID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@AUDITID, 'AuditMenu.Purge.Action.Log', 'menu.clickstream.purgeActionLog', 'List action log', '_self', '/purgeActionLog.action', 5);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @AUDITID);


## ----------------- Alert ------------------------------------------------


INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ADMINID, 'AlertMenu', 'menu.alertMenu', 'Alert  Menu', '_self', '', 5);

SET @ALERTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ALERTID, 'alertAdmin');

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@ALERTID, 'alertSender');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@ALERTID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ALERTID, 'AlertMenu.List', 'menu.alertMenu.listAlertByUser', 'List Alert created by user', '_self', '/listAlert.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@LASTID, 'alertAdmin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @ALERTID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@ALERTID, 'AlertMenu.Add', 'menu.alertMenu.addAlert', 'Add new alert', '_self', '/addAlert.action', 1);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@LASTID, 'alertSender');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @ALERTID);


## ----------------- Report -------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ADMINID, 'ReportMenu', 'menu.reportMenu', 'Report', '_self', '', 6);

SET @RPTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@RPTID, 'reportAdmin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@RPTID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@RPTID, 'ReportMenu.List', 'menu.reportMenu.listReports', 'List Reports', '_self', '/reports.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @RPTID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@RPTID, 'ReportMenu.Add', 'menu.reportMenu.addReport', 'Add Report', '_self', '/reportForm.action?method=add&from=list', 1);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @RPTID);


## ----------------- Scheduling -------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@ADMINID, 'SchedulingMenu', 'menu.schedulingMenu', 'Schedule', '_self', '', 7);

SET @SCHDID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@SCHDID, 'schedulerAdmin');

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@SCHDID, 'admin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@SCHDID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@SCHDID, 'SchedulingMenu.List.Jobs', 'menu.schedulingMenu.listJobs', 'List All Jobs', '_self', '/jobs.action', 0);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @SCHDID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@SCHDID, 'SchedulingMenu.Add.Job', 'menu.schedulingMenu.addJob', 'Add Job', '_self', '/jobForm.action?method=add&from=list', 1);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @SCHDID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@SCHDID, 'SchedulingMenu.List.Schedules', 'menu.schedulingMenu.listSchedules', 'List All Job Schedules', '_self', '/schedules.action', 2);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @SCHDID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@SCHDID, 'SchedulingMenu.Add.SimpleSchedule', 'menu.schedulingMenu.addSimpleSchedule', 'Add Simple Schedule', '_self', '/simpleScheduleForm.action?method=add&from=list', 3);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @SCHDID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
VALUES (@SCHDID, 'SchedulingMenu.Add.Advanced.Schedule', 'menu.schedulingMenu.addAdvancedSchedule', 'Add Advanced Schedule', '_self', '/advancedScheduleForm.action?method=add&from=list', 4);

SET @LASTID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @SCHDID);


## DEPRECATED ----------------- Map -------------------------------------------


#INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
#VALUES (@ADMINID, 'MapMenu', 'menu.mapMenu', 'Map', '_self', '', 8);

#SET @MAPID = LAST_INSERT_ID();

#INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
#VALUES (@MAPID, 'mapAdmin');

#INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
#VALUES (@MAPID, 'admin');

#INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@MAPID, @ADMINID);

## ------------------------------------------------------------------------------------

#INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
#VALUES (@MAPID , 'MapMenu.List', 'menu.mapMenu.listMapDetails', 'List Map Details', '_self', '/mapDetails.action', 0);

#SET @LASTID = LAST_INSERT_ID();

#INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID , @MAPID);

## ------------------------------------------------------------------------------------

#INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING)
#VALUES (@MAPID, 'MapMenu.Add', 'menu.mapMenu.addMapDetail', 'Add Map Detail', '_self', '/mapDetailForm.action?method=add&from=list', 1);

#SET @LASTID = LAST_INSERT_ID();

#INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID , @MAPID);


## ----------------- Document  -------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@ADMINID, 'DocumentMenu', 'menu.docManMenu', 'Document', '_self', '', 8);

SET @DOCID = LAST_INSERT_ID();

INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@DOCID, 'admin');
  
INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@DOCID, @ADMINID);

## ------------------------------------------------------------------------------------

INSERT INTO MENU_ITEM (PARENT_ID, NAME, TITLE, DESCRIPTION, TARGET, PAGE, ORDERING) 
VALUES (@DOCID, 'DocumentMenu.Admin', 'menu.docManMenu.docManAdmin', 'Document  Admin', '_self', '/docMan.action', 0);

SET @LASTID = LAST_INSERT_ID();
	
INSERT INTO MENU_ITEM_ROLE (ID, ROLE_NAME)
VALUES (@LASTID, 'admin');

INSERT INTO MENU_ITEM_MAPPING (ID, PARENT_ID) VALUES (@LASTID, @DOCID);