diff options
author | 2019-09-09 16:41:56 -0400 | |
---|---|---|
committer | 2019-09-09 16:41:57 -0400 | |
commit | db073432c2de9c8d248a0ff63d65b63a8fb920ca (patch) | |
tree | e3d09f415796d865513a8dc0cdc44adaf8f7175e /adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.4.1__Rename_Infra_active_requests_AIC_CLOUD_REGION_Column.sql | |
parent | 42b399ea943940ef1e37c267a9aea03b5f01f2d0 (diff) |
updated all sql files including in tests to use
updated all sql files including in tests to use the correct column
name. Updated hibernate mapping to use the correct column name as well.
Issue-ID: SO-2297
Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com>
Change-Id: I4a2d3e82a7b182ea1d67d297c0a0d3a35c856255
Diffstat (limited to 'adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.4.1__Rename_Infra_active_requests_AIC_CLOUD_REGION_Column.sql')
-rw-r--r-- | adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.4.1__Rename_Infra_active_requests_AIC_CLOUD_REGION_Column.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.4.1__Rename_Infra_active_requests_AIC_CLOUD_REGION_Column.sql b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.4.1__Rename_Infra_active_requests_AIC_CLOUD_REGION_Column.sql new file mode 100644 index 0000000000..eac9a65f65 --- /dev/null +++ b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.4.1__Rename_Infra_active_requests_AIC_CLOUD_REGION_Column.sql @@ -0,0 +1,12 @@ +use requestdb; + +DROP INDEX `infra_active_requests__aic_cloud_region_idx` on `infra_active_requests`; + +ALTER TABLE + `infra_active_requests` CHANGE AIC_CLOUD_REGION CLOUD_REGION varchar(50) DEFAULT NULL; + +ALTER TABLE + `archived_infra_requests` CHANGE AIC_CLOUD_REGION CLOUD_REGION VARCHAR(50) NULL DEFAULT NULL; + +ALTER TABLE `infra_active_requests` + ADD INDEX IF NOT EXISTS `infra_active_requests__cloud_region_idx` (`CLOUD_REGION` ASC); |