summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts
diff options
context:
space:
mode:
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.sql1
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql42
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