diff options
Diffstat (limited to 'ecomp-sdk/epsdk-app-common/db-scripts')
| -rw-r--r-- | ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql | 1 | ||||
| -rw-r--r-- | ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql | 42 |
2 files changed, 35 insertions, 8 deletions
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql index 4afb501e..f0a228df 100644 --- a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql +++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql @@ -24,5 +24,6 @@ UPDATE fn_menu SET ACTION='admin#/admin_menu_edit' WHERE LABEL='Menus'; +delete FROM fn_restricted_url WHERE RESTRICTED_URL='V2'; commit;
\ No newline at end of file diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql index 5982363b..4139a7a5 100644 --- a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql +++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql @@ -3,20 +3,34 @@ use ecomp_sdk; SET FOREIGN_KEY_CHECKS=0; UPDATE fn_menu -SET ACTION='v2/admin/role_function_list' -WHERE LABEL='Role Functions'; +SET ACTION='welcome' +WHERE LABEL='Home'; +UPDATE fn_menu +SET ACTION='v2/userProfile' +WHERE LABEL='Search'; UPDATE fn_menu -SET ACTION='v2/admin/usage_list' -WHERE LABEL='Usage'; +SET ACTION='v2/userProfile/post_search' +WHERE LABEL='Import from WEBPHONE'; +UPDATE fn_menu +SET ACTION='v2/userProfile/self_profile' +WHERE LABEL='Self'; UPDATE fn_menu SET ACTION='v2/admin/admin' WHERE LABEL='Roles'; UPDATE fn_menu +SET ACTION='v2/admin/role_function_list' +WHERE LABEL='Role Functions'; + +UPDATE fn_menu +SET ACTION='v2/admin/usage_list' +WHERE LABEL='Usage'; + +UPDATE fn_menu SET ACTION='v2/admin/cache_admin' WHERE LABEL='Cache Admin'; @@ -24,13 +38,25 @@ UPDATE fn_menu SET ACTION='v2/admin/admin_menu_edit' WHERE LABEL='Menus'; + +-- fn_menu - update menu icon +UPDATE fn_menu +SET `IMAGE_SRC`='icon ion-ios-home' +WHERE `LABEL`='Home'; + +UPDATE fn_menu +SET `IMAGE_SRC`='icon ion-md-pie' +WHERE `LABEL`='Reports'; + UPDATE fn_menu -SET ACTION='v2/report-list' -WHERE LABEL='All Reports'; +SET `IMAGE_SRC`='ion-md-person' +WHERE `LABEL`='Profile'; UPDATE fn_menu -SET ACTION='v2/create' -WHERE LABEL='Create Reports'; +SET `IMAGE_SRC`='icon ion-md-star' +WHERE `LABEL`='Admin'; +-- Added new update for fn_restricted_url - +insert into fn_restricted_url values ('v2','menu_home'); commit;
\ No newline at end of file |