diff options
| author |   Steve Smokowski <ss835w@att.com> | 2019-09-10 11:57:37 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2019-09-10 11:57:37 +0000 |
| commit | a50be1862d4dbe9ea338faecb078237f05824658 (patch) | |
| tree | 004de37a65b87993535ce576034731833c98fcfd /adapters/mso-requests-db-adapter/src/main | |
| parent | c11b263267264cec234e734c72576be31a98b86a (diff) | |
| parent | db073432c2de9c8d248a0ff63d65b63a8fb920ca (diff) | |
Merge "updated all sql files including in tests to use"
Diffstat (limited to 'adapters/mso-requests-db-adapter/src/main')
| -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); |