You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by al...@apache.org on 2014/06/06 20:07:32 UTC
git commit: updated refs/heads/master to 2459f55
Repository: cloudstack
Updated Branches:
refs/heads/master b43517c49 -> 2459f55c2
CLOUDSTACK-6585: added missing db upgrade statements
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/2459f55c
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/2459f55c
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/2459f55c
Branch: refs/heads/master
Commit: 2459f55c2307039534c80238656e0e8dd751529e
Parents: b43517c
Author: Alena Prokharchyk <al...@citrix.com>
Authored: Fri Jun 6 10:39:24 2014 -0700
Committer: Alena Prokharchyk <al...@citrix.com>
Committed: Fri Jun 6 11:00:28 2014 -0700
----------------------------------------------------------------------
setup/db/db/schema-430to440.sql | 23 ++++++++++++++++++++++-
1 file changed, 22 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/2459f55c/setup/db/db/schema-430to440.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-430to440.sql b/setup/db/db/schema-430to440.sql
index 735bbbe..d60997b 100644
--- a/setup/db/db/schema-430to440.sql
+++ b/setup/db/db/schema-430to440.sql
@@ -220,7 +220,7 @@ CREATE VIEW `cloud`.`volume_view` AS
left join
`cloud`.`cluster` ON storage_pool.cluster_id = cluster.id
left join
- `cloud`.`vm_template` ON volumes.template_id = vm_template.id
+ `cloud`.`vm_template` ON volumes.template_id = vm_template.id
left join
`cloud`.`vm_template` iso ON iso.id = volumes.iso_id
left join
@@ -1686,3 +1686,24 @@ alter table `cloud`.`vlan` add column created datetime NULL COMMENT 'date create
alter table `cloud`.`user_ip_address` drop key public_ip_address;
alter table `cloud`.`user_ip_address` add UNIQUE KEY public_ip_address (public_ip_address,source_network_id, removed);
+
+CREATE TABLE `cloud`.`load_balancer_stickiness_policy_details` (
+ `id` bigint unsigned NOT NULL auto_increment,
+ `lb_policy_id` bigint unsigned NOT NULL COMMENT 'resource id',
+ `name` varchar(255) NOT NULL,
+ `value` varchar(1024) NOT NULL,
+ `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the detail can be displayed to the end user',
+ PRIMARY KEY (`id`),
+ CONSTRAINT `fk_lb_stickiness_policy_details__lb_stickiness_policy_id` FOREIGN KEY `fk_lb_stickiness_policy_details__lb_stickiness_policy_id`(`lb_policy_id`) REFERENCES `load_balancer_stickiness_policies`(`id`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE `cloud`.`load_balancer_healthcheck_policy_details` (
+ `id` bigint unsigned NOT NULL auto_increment,
+ `lb_policy_id` bigint NOT NULL COMMENT 'resource id',
+ `name` varchar(255) NOT NULL,
+ `value` varchar(1024) NOT NULL,
+ `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the detail can be displayed to the end user',
+ PRIMARY KEY (`id`),
+ CONSTRAINT `fk_lb_healthcheck_policy_details__lb_healthcheck_policy_id` FOREIGN KEY `fk_lb_healthcheck_policy_details__lb_healthcheck_policy_id`(`lb_policy_id`) REFERENCES `load_balancer_healthcheck_policies`(`id`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;