cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From raj...@apache.org
Subject [37/50] [abbrv] git commit: updated refs/heads/master to 4c5f792
Date Wed, 05 Nov 2014 10:45:31 GMT
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/master
Commit: ddfd74dba1d3f458c98c5074c79b2ab0199da682
Parents: 84e44a4
Author: amoghvk <amogh.vasekar@citrix.com>
Authored: Mon Nov 3 15:28:11 2014 -0800
Committer: amoghvk <amogh.vasekar@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);


Mime
View raw message