 'NAVMENU',
 1,
 1,
-'system',
-CURRENT_TIMESTAMP,
-'system',
-CURRENT_TIMESTAMP);
-
-
-
-INSERT INTO `calordersdb`.`PRIVILEGE`
-( 
-`GRP_UID_FK`,
-`PRV_PAGE_ID`,
-`PRV_COMPONENT_ID`,
-`PRV_READ_IND`,
-`PRV_WRITE_IND`,
-`CREATE_USER_ID`,
-`CREATE_TS`,
-`UPDATE_USER_ID`,
-`UPDATE_TS`)
-VALUES
-( 
-(SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD'),
-'dashboard',
-'NAVBAR',
-1,
-1,
-'system',
-CURRENT_TIMESTAMP,
-'system',
-CURRENT_TIMESTAMP);
+1,
+'Add Service',
+'system',
+CURRENT_TIMESTAMP,
+'system',
+CURRENT_TIMESTAMP);
+
+
 
 
 

VALUES
( 
(SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD'),
'orders',
'NAVBAR',
1,
1,
'system',
CURRENT_TIMESTAMP,
'system',
CURRENT_TIMESTAMP);


INSERT INTO `calordersdb`.`PRIVILEGE`
( 
`GRP_UID_FK`,
`PRV_PAGE_ID`,
`PRV_COMPONENT_ID`,
`PRV_READ_IND`,
`PRV_WRITE_IND`,
`CREATE_USER_ID`,
`CREATE_TS`,
`UPDATE_USER_ID`,

INSERT INTO `calordersdb`.`GROUP_PRIVILEGE_ASSOC`(`GRP_UID_FK`,`PRV_UID_FK`,`CREATE_USER_ID`,`CREATE_TS`,`UPDATE_USER_ID`,`UPDATE_TS`)
	VALUES ((SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD'),(SELECT PRV_UID FROM calordersdb.PRIVILEGE where PRV_PAGE_ID = 'dashboard' AND PRV_COMPONENT_ID = 'NAVBAR' AND GRP_UID_FK IN (SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD')), 'system', CURRENT_TIMESTAMP, 'system', CURRENT_TIMESTAMP);
INSERT INTO `calordersdb`.`GROUP_PRIVILEGE_ASSOC`(`GRP_UID_FK`,`PRV_UID_FK`,`CREATE_USER_ID`,`CREATE_TS`,`UPDATE_USER_ID`,`UPDATE_TS`)
	VALUES ((SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD'),(SELECT PRV_UID FROM calordersdb.PRIVILEGE where PRV_PAGE_ID = 'productSearch' AND PRV_COMPONENT_ID = 'NAVBAR' AND GRP_UID_FK IN (SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD')), 'system', CURRENT_TIMESTAMP, 'system', CURRENT_TIMESTAMP);
INSERT INTO `calordersdb`.`GROUP_PRIVILEGE_ASSOC`(`GRP_UID_FK`,`PRV_UID_FK`,`CREATE_USER_ID`,`CREATE_TS`,`UPDATE_USER_ID`,`UPDATE_TS`)
	VALUES ((SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD'),(SELECT PRV_UID FROM calordersdb.PRIVILEGE where PRV_PAGE_ID = 'orderHistory' AND PRV_COMPONENT_ID = 'NAVBAR' AND GRP_UID_FK IN (SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD')), 'system', CURRENT_TIMESTAMP, 'system', CURRENT_TIMESTAMP);
INSERT INTO `calordersdb`.`GROUP_PRIVILEGE_ASSOC`(`GRP_UID_FK`,`PRV_UID_FK`,`CREATE_USER_ID`,`CREATE_TS`,`UPDATE_USER_ID`,`UPDATE_TS`)
	VALUES ((SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD'),(SELECT PRV_UID FROM calordersdb.PRIVILEGE where PRV_PAGE_ID = 'services' AND PRV_COMPONENT_ID = 'NAVMENU' AND GRP_UID_FK IN (SELECT GRP_UID FROM calordersdb.GROUPS WHERE GRP_TYPE_CD = 'AAD')), 'system', CURRENT_TIMESTAMP, 'system', CURRENT_TIMESTAMP);
  
