From 26b84388ba3eb179f9d4a9d4e2d478eba3df8201 Mon Sep 17 00:00:00 2001 From: Jerry Flood Date: Fri, 5 Apr 2019 12:23:07 -0400 Subject: Integrate new mS into IT Issue-ID: OPTFRA-458 Change-Id: I42966034101baa54c1b60e07b74c17d97680da81 Signed-off-by: Jerry Flood --- .../src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql | 5 ----- 1 file changed, 5 deletions(-) (limited to 'cmso-database') diff --git a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql index 2f6aafb..639a030 100644 --- a/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql +++ b/cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql @@ -84,11 +84,6 @@ update CHANGE_MANAGEMENT_CHANGE_WINDOWS set change_management_group_uuid = update SCHEDULE_APPROVALS set approval_types_uuid = (select distinct s.uuid from APPROVAL_TYPES s where approval_type_id = s.id); --- ---------------------------------------------------- --- APPROVAL_TYPES Update all of the foreign key columns --- ---------------------------------------------------- -update SCHEDULE_APPROVALS set approval_types_uuid = - (select distinct s.uuid from SCHEDULE_APPROVALS t, APPROVAL_TYPES s where t.approval_type_id = s.id); SET SQL_SAFE_UPDATES = 1; -- cgit 1.2.3-korg