diff options
author | Plummer, Brittany <brittany.plummer@att.com> | 2019-06-09 10:38:55 -0400 |
---|---|---|
committer | Benjamin, Max (mb388a) <mb388a@us.att.com> | 2019-06-09 10:39:01 -0400 |
commit | b7cde4474b9688a1527254dcae6114123ea00c9c (patch) | |
tree | 3a60ab40b6b994a1162f5aa244a70243f34cc70a /adapters/mso-requests-db-adapter/src/main/resources/db/migration | |
parent | 242e71883f59b8ad971f77c9bbdf032527fd77c0 (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/migration')
-rw-r--r-- | adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.9__Add_Column_Ext_System_Error_Source.sql | 4 |
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 |