diff options
| author |   Vikas Varma <vv8305@att.com> | 2019-04-05 17:04:02 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2019-04-05 17:04:02 +0000 |
| commit | c98cf7f69ff8a7765766a6ca569c874ae075fdea (patch) | |
| tree | f077f33c03aa489e04707b54b7e4ac6154eb979a /cmso-database/src/main/resources | |
| parent | e8f3843950f26bfdf74fa2d0ca0f2019a1586eb2 (diff) | |
| parent | 26b84388ba3eb179f9d4a9d4e2d478eba3df8201 (diff) | |
Merge "Integrate new mS into IT"
Diffstat (limited to 'cmso-database/src/main/resources')
| -rw-r--r-- | cmso-database/src/main/resources/cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql | 5 |
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; |