Repository: cloudstack Updated Branches: refs/heads/master 88acc9bd5 -> 37cb63f6b
CLOUDSTACK-3608 remove duplicate entries Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/37cb63f6 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/37cb63f6 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/37cb63f6 Branch: refs/heads/master Commit: 37cb63f6b782c57135fd232e5ec766c87278cfc4 Parents: 88acc9b Author: amoghvk <amogh.vase...@citrix.com> Authored: Mon Nov 3 15:28:11 2014 -0800 Committer: amogh.vasekar <amogh.vase...@citrix.com> Committed: Mon Nov 3 15:32:09 2014 -0800 ---------------------------------------------------------------------- setup/db/db/schema-441to450.sql | 3 +++ 1 file changed, 3 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/37cb63f6/setup/db/db/schema-441to450.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-441to450.sql b/setup/db/db/schema-441to450.sql index 3deb8ad..4946771 100644 --- a/setup/db/db/schema-441to450.sql +++ b/setup/db/db/schema-441to450.sql @@ -758,3 +758,6 @@ CREATE TABLE `cloud`.`baremetal_rct` ( `rct` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET=utf8; + +--Remove duplicates from guest_os_hypervisor table +DELETE t1 FROM guest_os_hypervisor t1, guest_os_hypervisor t2 WHERE (t1.hypervisor_type = t2.hypervisor_type AND t1.hypervisor_version = t2.hypervisor_version AND t1.guest_os_id = t2.guest_os_id AND t1.id > t2.id AND t1.is_user_defined=0);
