From d82646cefc266063382d09f1bd3ed256eca0887b Mon Sep 17 00:00:00 2001 From: "Smokowski, Steven" Date: Tue, 24 Mar 2020 10:26:59 -0400 Subject: 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) Change-Id: I8307524b3c226a25795247a47c95753b150076fe --- .../main/resources/db/migration/V8.2__Fix_Invalid_Request_Status.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 adapters/mso-requests-db-adapter/src/main/resources/db/migration/V8.2__Fix_Invalid_Request_Status.sql (limited to 'adapters') 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 -- cgit 1.2.3-korg