1 files changed, 34 insertions, 8 deletions
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