You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by da...@apache.org on 2014/06/06 22:09:47 UTC
git commit: updated refs/heads/4.4 to 3a578ff
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 <al...@citrix.com>
Authored: Fri Jun 6 10:39:24 2014 -0700
Committer: Daan Hoogland <da...@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;