Added functions, role functions for left menu

Issue-ID: PORTAL-874

Signed-off-by: Lorraine Welch <lb2391@att.com>
Change-Id: I599d2422b62859867b4161a5d8e2735b25509905

diff --git a/ecomp-portal-DB-common/PortalDMLMySql_3_2_Common.sql b/ecomp-portal-DB-common/PortalDMLMySql_3_2_Common.sql
index 7119726..83d6e3a 100644 (file)
--- a/ecomp-portal-DB-common/PortalDMLMySql_3_2_Common.sql
+++ b/ecomp-portal-DB-common/PortalDMLMySql_3_2_Common.sql
@@ -72,6 +72,11 @@ Insert INTO fn_function (function_cd,function_name) values ('saveNotification',
 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');
@@ -291,6 +296,11 @@ INSERT INTO fn_role_function (role_id, function_cd) VALUES ('1010', 'menu_web_an
 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');