summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql
diff options
context:
space:
mode:
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.sql58
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