aboutsummaryrefslogtreecommitdiffstats
path: root/cmso-database/src
diff options
context:
space:
mode:
authorJerry Flood <jflood@att.com>2019-04-05 12:23:07 -0400
committerJerry Flood <jflood@att.com>2019-04-05 12:23:16 -0400
commit26b84388ba3eb179f9d4a9d4e2d478eba3df8201 (patch)
treeb121fb1f29c0fa07774784dce68aada4ba55a9dd /cmso-database/src
parentb775e3842710fe1190675d318a0526b8dfb8eead (diff)
Integrate new mS into IT
Issue-ID: OPTFRA-458 Change-Id: I42966034101baa54c1b60e07b74c17d97680da81 Signed-off-by: Jerry Flood <jflood@att.com>
Diffstat (limited to 'cmso-database/src')
-rw-r--r--cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql5
1 files changed, 0 insertions, 5 deletions
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;