Fixed DB scripts for Frankfurt

Issue-ID: PORTAL-854

Signed-off-by: Lorraine Welch <lb2391@att.com>
Change-Id: Ic7d37ecea2546f481f1fa00070746957c8e53091

1 files changed, 61 insertions, 0 deletions

diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_2_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_2_Common.sql
new file mode 100644
index 00000000..16a408e4
--- /dev/null
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_2_Common.sql
@@ -0,0 +1,61 @@
+use ecomp_sdk;
+
+SET FOREIGN_KEY_CHECKS=0;
+
+UPDATE fn_menu 
+SET ACTION='v2/welcome'
+WHERE LABEL='Home';
+
+UPDATE fn_menu 
+SET ACTION='v2/userProfile'
+WHERE LABEL='Search';
+
+UPDATE fn_menu 
+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';
+
+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 `IMAGE_SRC`='ion-md-person' 
+WHERE  `LABEL`='Profile';
+
+UPDATE fn_menu 
+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