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 <alena.prokharc...@citrix.com> Authored: Fri Jun 6 10:39:24 2014 -0700 Committer: Alena Prokharchyk <alena.prokharc...@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;
