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>

1 files changed, 21 insertions, 0 deletions

diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql
new file mode 100644
index 00000000..a378d506
--- /dev/null
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql
@@ -0,0 +1,21 @@
+use ecomp_sdk;
+
+alter table fn_menu  
+add index fn_menu_function_cd (function_cd ASC);
+alter table fn_menu
+add constraint fk_fn_menu_ref_223_fn_funct
+foreign key (function_cd)
+references fn_function (function_cd);
+
+alter table fn_restricted_url  
+add index fk_restricted_url_function_cd (function_cd ASC);
+alter table fn_restricted_url
+add constraint fk_restricted_url_function_cd
+foreign key (function_cd)
+references fn_function (function_cd);
+
+
+alter table fn_role
+modify role_name varchar(50) NOT NULL;
+
+commit;
\ No newline at end of file