aboutsummaryrefslogtreecommitdiffstats
path: root/adapters/mso-requests-db-adapter/src/main
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
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')
-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
65' href='#n165'>165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201