aboutsummaryrefslogtreecommitdiffstats
path: root/adapters/mso-requests-db-adapter/src/main/resources/db
diff options
context:
space:
mode:
authorPlummer, Brittany <brittany.plummer@att.com>2019-06-09 10:38:55 -0400
committerBenjamin, Max (mb388a) <mb388a@us.att.com>2019-06-09 10:39:01 -0400
commitb7cde4474b9688a1527254dcae6114123ea00c9c (patch)
tree3a60ab40b6b994a1162f5aa244a70243f34cc70a /adapters/mso-requests-db-adapter/src/main/resources/db
parent242e71883f59b8ad971f77c9bbdf032527fd77c0 (diff)
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) <mb388a@us.att.com>
Diffstat (limited to 'adapters/mso-requests-db-adapter/src/main/resources/db')
-rw-r--r--adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.9__Add_Column_Ext_System_Error_Source.sql4
1 files changed, 4 insertions, 0 deletions
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