-- --------------------------------------------------------------------------------------------
--- This is the common default data for 2.1.0 Version of Portal database called portal
+-- This is the common default data for 3.3.0 Version of Portal database called portal
USE portal;
INSERT INTO fn_function (function_cd, function_name) VALUES ('menu_web_analytics', 'Web Analytics');
-- end new 1707
+-- new 3_2
+insert into fn_function (function_cd, function_name) values ('menu_acc_admin', 'Account Admin Menu');
+insert into fn_function (function_cd, function_name) values ('menu_app_onboarding', 'App Onboarding menu');
+-- end new 3_2
+
-- FN_LU_ACTIVITY
Insert into fn_lu_activity (ACTIVITY_CD,ACTIVITY) values ('add_role','add_role');
Insert into fn_lu_activity (ACTIVITY_CD,ACTIVITY) values ('remove_role','remove_role');
values(1,'root',NULL,10,NULL,'menu_home','N','APP','N',NULL);
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(2,'Home',1,10,'root.applicationsHome','menu_home','Y','APP','N','icon-building-home');
+ values(2,'Home',1,10,'applicationsHome','menu_home','Y','APP','N','home');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(3,'Application Catalog',1,15,'root.appCatalog','menu_home','Y','APP','N','icon-retail-gallery');
+ values(3,'Application Catalog',1,15,'appCatalog','menu_home','Y','APP','N','apps');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(4,'Widget Catalog',1,20,'root.widgetCatalog','menu_home','Y','APP','N','icon-retail-gallery');
+ values(4,'Widget Catalog',1,20,'widgetCatalog','menu_home','Y','APP','N','apps');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(5,'Admins',1,40,'root.admins','menu_admin','Y','APP','N','icon-content-star');
+ values(5,'Admins',1,40,'admins','menu_admin','Y','APP','N','star');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(6,'Roles',1,45,'root.roles','menu_acc_admin','Y','APP','N','icon-people-groupcollaboration');
+ values(6,'Roles',1,45,'roles','menu_acc_admin','Y','APP','N','person');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(7,'Users',1,50,'root.users','menu_acc_admin','Y','APP','N','icon-people-groupcollaboration');
+ values(7,'Users',1,50,'users','menu_acc_admin','Y','APP','N','person');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(8,'Portal Admins',1,60,'root.portalAdmins','menu_admin','Y','APP','N','icon-controls-settingsconnectedactivity');
+ values(8,'Portal Admins',1,60,'portalAdmins','menu_admin','Y','APP','N','settings');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(9,'Application Onboarding',1,70,'root.applications','menu_app_onboarding','Y','APP','N','icon-content-grid2');
+ values(9,'Application Onboarding',1,70,'applications','menu_app_onboarding','Y','APP','N','filing');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(10,'Widget Onboarding',1,80,'root.widgetOnboarding','menu_admin','Y','APP','N','icon-content-grid2');
+ values(10,'Widget Onboarding',1,80,'widgetOnboarding','menu_admin','Y','APP','N','filing');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(11,'Edit Functional Menu',1,90,'root.functionalMenu','menu_admin','Y','APP','N','icon-misc-pen');
+ values(11,'Edit Functional Menu',1,90,'functionalMenu','menu_admin','Y','APP','N','menu');
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values(12,'User Notifications',1,100,'root.userNotifications','edit_notification','Y','APP','N','icon-controls-settingsconnectedactivity');
+ values(12,'User Notifications',1,100,'userNotifications','edit_notification','Y','APP','N','settings');
-- end new 1702
-- new 1707
Insert into fn_menu(MENU_ID,LABEL,PARENT_ID,SORT_ORDER,ACTION,FUNCTION_CD,ACTIVE_YN,MENU_SET_CD,SEPARATOR_YN,IMAGE_SRC)
- values (13,'Microservice Onboarding', 1, 110, 'root.microserviceOnboarding', 'menu_admin', 'Y', 'APP', 'N', 'icon-content-grid2');
+ values (13,'Microservice Onboarding', 1, 110, 'microserviceOnboarding', 'menu_admin', 'Y', 'APP', 'N', 'filing');
+
Insert into fn_menu (menu_id, label, parent_id, sort_order, action, function_cd, active_yn, menu_set_cd, separator_yn, image_src)
- values(15,'App Account Management', 1, 130, 'root.accountOnboarding', 'menu_admin', 'Y', 'App', 'N', 'icon-content-grid2');
+ values(15,'App Account Management', 1, 130, 'accountOnboarding', 'menu_admin', 'Y', 'App', 'N', 'filing');
-- end new 1707
INSERT INTO fn_role_function (role_id, function_cd) VALUES ('2115', 'menu_web_analytics');
-- end new 1707
+-- new 3_2
+insert into fn_role_function (role_id, function_cd) values (16, 'menu_acc_admin');
+insert into fn_role_function (role_id, function_cd) values (16, 'menu_app_onboarding');
+-- end new 3_2
+
-- FN_TAB
Insert into fn_tab (TAB_CD,TAB_NAME,TAB_DESCR,ACTION,FUNCTION_CD,ACTIVE_YN,SORT_ORDER,PARENT_TAB_CD,TAB_SET_CD) values ('TAB2_SUB1_S1','Left Tab 1','Sub - Sub Tab 1 Information','tab2_sub1.htm','menu_tab','Y',10,'TAB2_SUB1','APP');
Insert into fn_tab (TAB_CD,TAB_NAME,TAB_DESCR,ACTION,FUNCTION_CD,ACTIVE_YN,SORT_ORDER,PARENT_TAB_CD,TAB_SET_CD) values ('TAB1','Tab 1','Tab 1 Information','tab1.htm','menu_tab','Y',10,null,'APP');
Insert into fn_tab_selected (SELECTED_TAB_CD,TAB_URI) values ('TAB3','tab3');
Insert into fn_tab_selected (SELECTED_TAB_CD,TAB_URI) values ('TAB4','tab4');
-commit;
\ No newline at end of file
+UPDATE
+ fn_menu
+SET
+ ACTION = 'webAnalytics',
+ image_src= 'pie'
+WHERE
+ active_yn = 'Y' AND label = 'Web Analytics';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'webAnlayticsSource',
+ image_src= 'pie'
+WHERE
+ active_yn = 'Y' AND label = 'Web Analytics Onboarding';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'applicationsHome',
+ image_src = 'home'
+WHERE
+ active_yn = 'Y' AND label = 'Home';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'appCatalog',
+ image_src= 'apps'
+WHERE
+ active_yn = 'Y' AND label = 'Application Catalog';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'widgetCatalog',
+ image_src= 'apps'
+WHERE
+ active_yn = 'Y' AND label = 'Widget Catalog';
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'admins' ,
+ image_src= 'star'
+WHERE
+ active_yn = 'Y' AND label = 'Admins';
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'roles' ,
+ image_src= 'person'
+WHERE
+ active_yn = 'Y' AND label = 'Roles';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'users',
+ image_src= 'person'
+WHERE
+ active_yn = 'Y' AND label = 'Users';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'portalAdmins',
+ image_src= 'settings'
+WHERE
+ active_yn = 'Y' AND label = 'Portal Admins';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'applications',
+ image_src= 'filing'
+WHERE
+ active_yn = 'Y' AND label = 'Application Onboarding';
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'widgetOnboarding',
+ image_src= 'filing'
+WHERE
+ active_yn = 'Y' AND label = 'Widget Onboarding';
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'functionalMenu',
+ image_src= 'menu'
+WHERE
+ active_yn = 'Y' AND label = 'Edit Functional Menu';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'userNotifications',
+ image_src= 'settings'
+WHERE
+ active_yn = 'Y' AND label = 'User Notifications';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'microserviceOnboarding',
+ image_src= 'filing'
+WHERE
+ active_yn = 'Y' AND label = 'Microservice Onboarding';
+
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'webAnalytics',
+ image_src= 'pie'
+WHERE
+ active_yn = 'Y' AND label = 'Web Analytics';
+
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'webAnlayticsSource',
+ image_src= 'pie'
+WHERE
+ active_yn = 'Y' AND label = 'Web Analytics Onboarding';
+
+UPDATE
+ fn_menu
+SET
+ ACTION = 'accountOnboarding',
+ image_src= 'filing'
+WHERE
+ active_yn = 'Y' AND label = 'App Account Management';
+
+
+
+commit;