Repository: cloudstack Updated Branches: refs/heads/4.4 beaa65f77 -> 3a578fff1
CLOUDSTACK-6585: added missing db upgrade statements (cherry picked from commit 9e2db2f2210904752eea2f3abf87b16bb3080384) Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/3a578fff Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/3a578fff Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/3a578fff Branch: refs/heads/4.4 Commit: 3a578fff1f2c9c3fecb02732d1ee371039123e34 Parents: beaa65f Author: Alena Prokharchyk <alena.prokharc...@citrix.com> Authored: Fri Jun 6 10:39:24 2014 -0700 Committer: Daan Hoogland <d...@onecht.net> Committed: Fri Jun 6 22:09:34 2014 +0200 ---------------------------------------------------------------------- setup/db/db/schema-430to440.sql | 23 ++++++++++++++++++++++- 1 file changed, 22 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/3a578fff/setup/db/db/schema-430to440.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-430to440.sql b/setup/db/db/schema-430to440.sql index 7e518e3..d149a65 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 @@ -1705,3 +1705,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;
