You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ko...@apache.org on 2013/02/18 10:57:10 UTC

git commit: refs/heads/master - As part of the upgrade changes, some db changes got removed from create-schema.sql. Moved the changes to the corresponding upgrade sql.

Updated Branches:
  refs/heads/master a4510efc2 -> ed757f24a


As part of the upgrade changes, some db changes got removed from create-schema.sql.
Moved the changes to the corresponding upgrade sql.


Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/ed757f24
Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/ed757f24
Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/ed757f24

Branch: refs/heads/master
Commit: ed757f24aea31a3befacc0f6ee0646c8e4e02b19
Parents: a4510ef
Author: Koushik Das <ko...@citrix.com>
Authored: Mon Feb 18 15:25:09 2013 +0530
Committer: Koushik Das <ko...@citrix.com>
Committed: Mon Feb 18 15:25:09 2013 +0530

----------------------------------------------------------------------
 setup/db/db/schema-410to420.sql |    4 ++++
 1 files changed, 4 insertions(+), 0 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/ed757f24/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index d1f90be..8bd9bfd 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -19,3 +19,7 @@
 -- Schema upgrade from 4.1.0 to 4.2.0;
 --;
 
+ALTER TABLE `cloud`.`hypervisor_capabilities` ADD COLUMN `max_hosts_per_cluster` int unsigned DEFAULT NULL COMMENT 'Max. hosts in cluster supported by hypervisor';
+UPDATE `cloud`.`hypervisor_capabilities` SET `max_hosts_per_cluster`=32 WHERE `hypervisor_type`='VMware';
+INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_hosts_per_cluster) VALUES ('VMware', '5.1', 128, 0, 32);
+DELETE FROM `cloud`.`configuration` where name='vmware.percluster.host.max';