You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by an...@apache.org on 2020/02/12 12:07:33 UTC
[cloudstack] 01/01: remove duplicate index region
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`;