aboutsummaryrefslogtreecommitdiffstats
path: root/adapters/mso-requests-db-adapter/src/main/resources/db
diff options
context:
space:
mode:
authorGamboa, Gilbert <gilbert.g.gamboa@att.com>2019-07-17 17:36:28 -0400
committerBenjamin, Max (mb388a) <mb388a@us.att.com>2019-07-17 17:36:28 -0400
commit96fad73d3c8b89df2b39e22011f45e7184af09f2 (patch)
tree7ddc6cacd496b2e939c73cdfc138a22ff30c4993 /adapters/mso-requests-db-adapter/src/main/resources/db
parent785c77ae295b287678d4842269222c31b3e4c330 (diff)
We need to expand column request_status
New script to expand column request_status on table archived_infra_requests as well. Issue-ID: SO-2114 Signed-off-by: Benjamin, Max (mb388a) <mb388a@us.att.com> Change-Id: Ife1168e658bbb9e7fa69541de42173947564cac8
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/V6.3__Expand_Column_Size_Archived_Infra_Active_Requests_Request_Status.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.3__Expand_Column_Size_Archived_Infra_Active_Requests_Request_Status.sql b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.3__Expand_Column_Size_Archived_Infra_Active_Requests_Request_Status.sql
new file mode 100644
index 0000000000..0780a611db
--- /dev/null
+++ b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.3__Expand_Column_Size_Archived_Infra_Active_Requests_Request_Status.sql
@@ -0,0 +1,3 @@
+use requestdb;
+
+ALTER TABLE archived_infra_requests MODIFY COLUMN REQUEST_STATUS varchar(25) NULL; \ No newline at end of file