cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alena1...@apache.org
Subject git commit: updated refs/heads/4.4-forward to 9e2db2f
Date Fri, 06 Jun 2014 18:09:45 GMT
Repository: cloudstack
Updated Branches:
  refs/heads/4.4-forward fc52e641d -> 9e2db2f22


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/9e2db2f2
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/9e2db2f2
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/9e2db2f2

Branch: refs/heads/4.4-forward
Commit: 9e2db2f2210904752eea2f3abf87b16bb3080384
Parents: fc52e64
Author: Alena Prokharchyk <alena.prokharchyk@citrix.com>
Authored: Fri Jun 6 10:39:24 2014 -0700
Committer: Alena Prokharchyk <alena.prokharchyk@citrix.com>
Committed: Fri Jun 6 11:09:38 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/9e2db2f2/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;


Mime
View raw message