adding sdk changes

adding sdk changes

Issue-ID: PORTAL-830
Signed-off-by: Muni Mohan Kunchi <munmohan@att.com>
Change-Id: I0c99d3ab15fcf4c3b34d84658b64114dadbe2577

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