[cloudstack] branch remove-duplicate-region-index created (now a03eeb5)

[an...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

andrijapanic pushed a change to branch remove-duplicate-region-index
in repository https://gitbox.apache.org/repos/asf/cloudstack.git.


      at a03eeb5  remove duplicate index region

This branch includes the following new commits:

     new a03eeb5  remove duplicate index region

The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails.  The revisions
listed as "add" were already present in the repository and have only
been added to this reference.

[cloudstack] 01/01: remove duplicate index region

[an...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

andrijapanic pushed a commit to branch remove-duplicate-region-index
in repository https://gitbox.apache.org/repos/asf/cloudstack.git

commit a03eeb5c7a63511828299141e1fce369cb9ede0b
Author: Andrija Panic <45...@users.noreply.github.com>
AuthorDate: Wed Feb 12 13:07:17 2020 +0100

    remove duplicate index region
---
 .../src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql     | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/engine/schema/src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql b/engine/schema/src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql
index fa631ef..7758f11 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql
@@ -23,3 +23,6 @@ DELETE FROM `cloud`.`configuration` WHERE name = 'host.maintenance.retries';
 
 -- Stop asking user (in the upgraded documentation) to remove a trailing slash for local KVM pool
 UPDATE `cloud`.`storage_pool` SET path="/var/lib/libvirt/images" WHERE path="/var/lib/libvirt/images/";
+
+-- remove (one of) duplicate unique indexes from Region table
+ALTER TABLE `region` DROP INDEX `id_3`;