Repository: cloudstack Updated Branches: refs/heads/4.5 84e44a4db -> ddfd74dba
CLOUDSTACK-3608 removing duplicate entries, IDs not saved anywhere else hence safe to remove Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/ddfd74db Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/ddfd74db Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/ddfd74db Branch: refs/heads/4.5 Commit: ddfd74dba1d3f458c98c5074c79b2ab0199da682 Parents: 84e44a4 Author: amoghvk <amogh.vase...@citrix.com> Authored: Mon Nov 3 15:28:11 2014 -0800 Committer: amoghvk <amogh.vase...@citrix.com> Committed: Mon Nov 3 15:28:11 2014 -0800 ---------------------------------------------------------------------- setup/db/db/schema-441to450.sql | 2 ++ 1 file changed, 2 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/ddfd74db/setup/db/db/schema-441to450.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-441to450.sql b/setup/db/db/schema-441to450.sql index c899289..5caaa9f 100644 --- a/setup/db/db/schema-441to450.sql +++ b/setup/db/db/schema-441to450.sql @@ -749,3 +749,5 @@ INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervis INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_data_volumes_limit, storage_motion_supported) VALUES (UUID(), 'XenServer', '6.5.0', 500, 1, 13, 1); +--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);
