Statistics
| Branch: | Revision:

m2u-upass-admin / DBScript / insert_admin_navigation.sql @ 104:e82bae1007b4

History | View | Annotate | Download (4.25 KB)

1 0:ea666cc7880e hadi 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (1,0,'RIB User Enquiry','RIB User Enquiry','1','0','UENQ',7,'/ss112/searchUser.do',1,1,GETDATE(),GETDATE(),1);
2 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (3,0,'Admin Enquiry','MSS User Enquiry','1','0','AENQ',2,'/ss102/userEnquiryScreen.do',1,1,GETDATE(),GETDATE(),1);
3 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (5,0,'RIB Navigation','Navigation','1','0','RIBNAV',4,'/ss110/navigationEnquiryMain.do',1,1,GETDATE(),GETDATE(),1);
4 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (6,0,'Admin Navigation','Navigation','1','0','ANAV',3,'/ss100/navigationEnquiryMain.do',1,1,GETDATE(),GETDATE(),1);
5 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (7,0,'Admin Group','Group Access 1','1','0','AGRP',1,'/ss103/groupEnquiryMain.do',1,1,GETDATE(),GETDATE(),1);
6 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (8,0,'Audit Log','Audit Log','1','0','ALOG',9,'/ss104/auditTrailMain.do',1,1,GETDATE(),GETDATE(),1);
7 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (9,0,'Change Own Password','Change Password','1','0','SSSSCPWD',10,'/ss102/changePassword.do',1,1,GETDATE(),GETDATE(),1);
8 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (12,0,'Content','Content','1','0','CONT',5,'/ss105/content.do',1,1,GETDATE(),GETDATE(),1);
9 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (13,0,'RIB Transaction Enquiry','RIB Transaction Enquiry','1','0','RTENQ',8,'/ss115/trnxEnquiryMain.do',1,1,GETDATE(),GETDATE(),1);
10 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (14,0,'IB User Group','IB Group','1','0','IBGRP',6,'/ss113/groupEnquiryMain.do',1,1,GETDATE(),GETDATE(),1);
11 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (15,0,'Report','Report','1','0','SSSRPT',1,'/ss219/reportSearch.do',1,1,GETDATE(),GETDATE(),1);
12 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (16,0,'Secure Mailbox','Secure Mailbox','1','0','SSSM',11,'/ss119/secureMailboxMain.do',1,1,GETDATE(),GETDATE(),1);
13 
INSERT INTO ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY) VALUES (17,0,'Subject Maintenance','Subject Maintenance','1','0','SSSBJT',12,'/ss119/secureMailboxCategory.do',1,1,GETDATE(),GETDATE(),1);