From a2f5a35c06a526b05e4efd9fe275d6639bf22cd3 Mon Sep 17 00:00:00 2001
From: st782s <statta@research.att.com>
Date: Mon, 14 Aug 2017 11:41:04 -0400
Subject: DDL updates and cleanup

- remove unused javascript libraries
- remove contentious icons and images
- Remove constraints to support Role Centralization

Issue: PORTAL-21, Portal-17


Change-Id: I347accb04343d1c866c075ee716c46fea9e0d036
Signed-off-by: st782s <statta@research.att.com>
---
 .../EcompSdkMySql_Upgrade_1707_to_1710_Common.sql      | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql

(limited to 'ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql')

diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql
new file mode 100644
index 00000000..36c19658
--- /dev/null
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql
@@ -0,0 +1,18 @@
+use ecomp_sdk;
+
+SET FOREIGN_KEY_CHECKS=0;
+
+alter table fn_menu 
+drop foreign key fk_fn_menu_ref_223_fn_funct;
+alter table fn_menu 
+drop index fn_menu_function_cd;
+
+alter table fn_restricted_url 
+drop foreign key fk_restricted_url_function_cd;
+alter table fn_restricted_url 
+drop index fk_restricted_url_function_cd;
+
+alter table fn_role
+modify role_name varchar(300) NOT NULL;
+
+commit;
\ No newline at end of file
-- 
cgit 1.2.3-korg

