cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From muralire...@apache.org
Subject git commit: updated refs/heads/4.2 to a851ad2
Date Sat, 27 Jul 2013 11:48:56 GMT
Updated Branches:
  refs/heads/4.2 3efae4b47 -> a851ad243


CLOUDSTACK-3834: 3.0.6 to ASF 4.2 Upgrade: "cloud" Database Schema
Inconsistencies on the Upgraded Setup - Table "netscaler_pod_ref"

adding netscaler_pod_ref table 3.0.7 to 4.1 upgrade path


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

Branch: refs/heads/4.2
Commit: a851ad24306581031f550f316eba0a6cc2f797bf
Parents: 3efae4b
Author: Murali Reddy <muralimmreddy@gmail.com>
Authored: Sat Jul 27 17:15:14 2013 +0530
Committer: Murali Reddy <muralimmreddy@gmail.com>
Committed: Sat Jul 27 17:18:04 2013 +0530

----------------------------------------------------------------------
 setup/db/db/schema-307to410.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/a851ad24/setup/db/db/schema-307to410.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-307to410.sql b/setup/db/db/schema-307to410.sql
index cbd564d..414d3bc 100644
--- a/setup/db/db/schema-307to410.sql
+++ b/setup/db/db/schema-307to410.sql
@@ -1554,3 +1554,13 @@ CREATE TABLE IF NOT EXISTS `cloud`.`baremetal_pxe_devices` (
 #drop tables as the feature is not a part of 4.2
 DROP TABLE IF EXISTS `cloud`.`host_updates`;
 DROP TABLE IF EXISTS `cloud`.`host_updates_ref`;
+
+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;
\ No newline at end of file


Mime
View raw message