diff options
| author |   Smokowski, Steven <steve.smokowski@att.com> | 2020-03-24 10:26:59 -0400 |
|---|---|---|
| committer |   Benjamin, Max (mb388a) <mb388a@att.com> | 2020-03-24 10:27:00 -0400 |
| commit | d82646cefc266063382d09f1bd3ed256eca0887b (patch) | |
| tree | db7da4f7ff8fcc7ec9715c94ae3cac346dcec45f /adapters/mso-requests-db-adapter/src/main/resources/db/migration | |
| parent | 3b6caf9cc8e1341ea000cb55ae277f622c816dda (diff) | |
Update Subprocess to use COMPLETE status
Update Subprocess to use COMPLETE status
Update Subprocess to use COMPLETE status
Fix column name to be request_status
Issue-ID: SO-2762
Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com>
Change-Id: I8307524b3c226a25795247a47c95753b150076fe
Diffstat (limited to 'adapters/mso-requests-db-adapter/src/main/resources/db/migration')
| -rw-r--r-- | adapters/mso-requests-db-adapter/src/main/resources/db/migration/V8.2__Fix_Invalid_Request_Status.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V8.2__Fix_Invalid_Request_Status.sql b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V8.2__Fix_Invalid_Request_Status.sql new file mode 100644 index 0000000000..9fee716326 --- /dev/null +++ b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V8.2__Fix_Invalid_Request_Status.sql @@ -0,0 +1,4 @@ +USE `requestdb`; + +UPDATE infra_active_requests SET request_status='COMPLETE' where request_status = 'COMPLETED'; +UPDATE archived_infra_requests SET request_status='COMPLETE' where request_status = 'COMPLETED';
\ No newline at end of file |