cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From amog...@apache.org
Subject git commit: updated refs/heads/master to 37cb63f
Date Mon, 03 Nov 2014 23:33:05 GMT
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.vasekar@citrix.com>
Authored: Mon Nov 3 15:28:11 2014 -0800
Committer: amogh.vasekar <amogh.vasekar@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);


Mime
View raw message