From b7cde4474b9688a1527254dcae6114123ea00c9c Mon Sep 17 00:00:00 2001 From: "Plummer, Brittany" Date: Sun, 9 Jun 2019 10:38:55 -0400 Subject: Added ext_system_error_source column to requestdb Added ext_system_error_source column to requestdb Change-Id: Iad9ad0178546aad2b64014987ff3da60f01f8bd4 Issue-ID: SO-2001 Signed-off-by: Benjamin, Max (mb388a) --- .../db/migration/V5.9__Add_Column_Ext_System_Error_Source.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.9__Add_Column_Ext_System_Error_Source.sql (limited to 'adapters/mso-requests-db-adapter/src/main/resources/db') diff --git a/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.9__Add_Column_Ext_System_Error_Source.sql b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.9__Add_Column_Ext_System_Error_Source.sql new file mode 100644 index 0000000000..e76dbbe883 --- /dev/null +++ b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.9__Add_Column_Ext_System_Error_Source.sql @@ -0,0 +1,4 @@ +use requestdb; + +ALTER TABLE infra_active_requests ADD COLUMN IF NOT EXISTS EXT_SYSTEM_ERROR_SOURCE varchar(80); +ALTER TABLE archived_infra_requests ADD COLUMN IF NOT EXISTS EXT_SYSTEM_ERROR_SOURCE varchar(80); \ No newline at end of file -- cgit 1.2.3-korg