diff options
Diffstat (limited to 'ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql')
-rw-r--r-- | ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql new file mode 100644 index 00000000..1db43db8 --- /dev/null +++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql @@ -0,0 +1,58 @@ +use ecomp_sdk; + +SET FOREIGN_KEY_CHECKS=0; + +UPDATE fn_menu +SET ACTION='welcome' +WHERE LABEL='Home'; + +UPDATE fn_menu +SET ACTION='userProfile#/self_profile' +WHERE LABEL='Self'; + +UPDATE fn_menu +SET ACTION='admin#/role_function_list' +WHERE LABEL='Role Functions'; + + +UPDATE fn_menu +SET ACTION='admin#/usage_list' +WHERE LABEL='Usage'; + + +UPDATE fn_menu +SET ACTION='admin#/admin' +WHERE LABEL='Roles'; + +UPDATE fn_menu +SET ACTION='admin#/jcs_admin' +WHERE LABEL='Cache Admin'; + +UPDATE fn_menu +SET ACTION='userProfile' +WHERE LABEL='Search'; + +UPDATE fn_menu +SET ACTION='admin#/admin_menu_edit' +WHERE LABEL='Menus'; + +-- fn_menu - update menu icon +UPDATE fn_menu +SET `IMAGE_SRC`='icon-building-home' +WHERE `LABEL`='Home'; + +UPDATE fn_menu +SET `IMAGE_SRC`='icon-misc-piechart' +WHERE `LABEL`='Reports'; + +UPDATE fn_menu +SET `IMAGE_SRC`='icon-people-oneperson' +WHERE `LABEL`='Profile'; + +UPDATE fn_menu +SET `IMAGE_SRC`='icon-content-star' +WHERE `LABEL`='Admin'; + +delete FROM fn_restricted_url WHERE RESTRICTED_URL='V2'; + +commit;
\ No newline at end of file |