diff options
author | st782s <statta@research.att.com> | 2017-08-14 11:41:04 -0400 |
---|---|---|
committer | st782s <statta@research.att.com> | 2017-08-15 14:07:15 -0400 |
commit | a2f5a35c06a526b05e4efd9fe275d6639bf22cd3 (patch) | |
tree | 75e423e367598929f54345359b3851e48ae9cd68 /ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql | |
parent | 3159458ff8563771a5460839fd75bdc25159ea87 (diff) |
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>
Diffstat (limited to 'ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql')
-rw-r--r-- | ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql | 18 |
1 files changed, 18 insertions, 0 deletions
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 |