cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wid...@apache.org
Subject [2/9] git commit: updated refs/heads/rbd-snap-clone to 7619076
Date Thu, 23 May 2013 22:06:34 GMT
CLOUDSTACK-2587: netscaler_pod_ref DB upgrade is missing from 3.0.2 to
4.x

added missing schema as part of 4.0 to 4.1 upgrade


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/623a26e4
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/623a26e4
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/623a26e4

Branch: refs/heads/rbd-snap-clone
Commit: 623a26e469ca7354a7dbe6b8954276985e289687
Parents: cc49230
Author: Murali Reddy <muralimmreddy@gmail.com>
Authored: Thu May 23 21:59:32 2013 +0530
Committer: Murali Reddy <muralimmreddy@gmail.com>
Committed: Thu May 23 22:28:17 2013 +0530

----------------------------------------------------------------------
 setup/db/db/schema-40to410.sql |   12 ++++++++++++
 1 files changed, 12 insertions(+), 0 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/623a26e4/setup/db/db/schema-40to410.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-40to410.sql b/setup/db/db/schema-40to410.sql
index b7b1c7a..381a4ce 100644
--- a/setup/db/db/schema-40to410.sql
+++ b/setup/db/db/schema-40to410.sql
@@ -1639,3 +1639,15 @@ INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Usage', 'DEFAULT',
'manageme
 
 INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (163,
UUID(), 10, 'Ubuntu 12.04 (32-bit)');
 INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES (164,
UUID(), 10, 'Ubuntu 12.04 (64-bit)');
+
+DROP TABLE IF EXISTS `cloud`.`netscaler_pod_ref`;
+CREATE TABLE  `cloud`.`netscaler_pod_ref` (
+  `id` bigint unsigned NOT NULL auto_increment COMMENT 'id',
+  `external_load_balancer_device_id` bigint unsigned NOT NULL COMMENT 'id of external load
balancer device',
+  `pod_id` bigint unsigned NOT NULL COMMENT 'pod id',
+  PRIMARY KEY  (`id`),
+  CONSTRAINT `fk_ns_pod_ref__pod_id` FOREIGN KEY (`pod_id`) REFERENCES `cloud`.`host_pod_ref`(`id`)
ON DELETE CASCADE,
+  CONSTRAINT `fk_ns_pod_ref__device_id` FOREIGN KEY (`external_load_balancer_device_id`)
REFERENCES `external_load_balancer_devices`(`id`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server',
'eip.use.multiple.netscalers' , 'false', 'Should be set to true, if there will be multiple
NetScaler devices providing EIP service in a zone');


Mime
View raw message