diff options
| author |   Lorraine Welch <lb2391@att.com> | 2020-04-07 22:45:07 -0400 |
|---|---|---|
| committer |   Sunder Tattavarada <statta@research.att.com> | 2020-04-08 13:38:56 +0000 |
| commit | 5c7d5cc2fd56ae3edc69caf45c0250751300ce79 (patch) | |
| tree | 61327199d2c512619d8443597fc39e8b02176987 /ecomp-portal-DB-common | |
| parent | 035b04ce0dafae3a789ba971873b286f5f02c762 (diff) | |
Added functions, role functions for left menu
Issue-ID: PORTAL-874
Signed-off-by: Lorraine Welch <lb2391@att.com>
Change-Id: I599d2422b62859867b4161a5d8e2735b25509905
(cherry picked from commit 0ef01433b433da7b1b3321ef789dea398720979a)
Diffstat (limited to 'ecomp-portal-DB-common')
| -rw-r--r-- | ecomp-portal-DB-common/PortalDMLMySql_3_2_Common.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/ecomp-portal-DB-common/PortalDMLMySql_3_2_Common.sql b/ecomp-portal-DB-common/PortalDMLMySql_3_2_Common.sql index 71197261..83d6e3ac 100644 --- 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'); |