cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sate...@apache.org
Subject [46/50] [abbrv] git commit: updated refs/heads/vmware-datamodel to 57444fc
Date Thu, 09 May 2013 18:02:01 GMT
Legacy zone support.


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

Branch: refs/heads/vmware-datamodel
Commit: f01189ac5f3b3f82206fc0f41f1251752db86925
Parents: cada301
Author: Sateesh Chodapuneedi <sateesh@apache.org>
Authored: Sat May 4 23:20:59 2013 +0530
Committer: Sateesh Chodapuneedi <sateesh@apache.org>
Committed: Thu May 9 23:22:58 2013 +0530

----------------------------------------------------------------------
 setup/db/db/schema-410to420.sql |    8 ++++++++
 1 files changed, 8 insertions(+), 0 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/f01189ac/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index 9183754..d19ed4d 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -934,6 +934,13 @@ CREATE TABLE `cloud`.`vmware_data_center_zone_map` (
   CONSTRAINT `fk_vmware_data_center_zone_map__vmware_data_center_id` FOREIGN KEY (`vmware_data_center_id`)
REFERENCES `vmware_data_center`(`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
+CREATE TABLE `cloud`.`legacy_zones` (
+  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
+  `zone_id` bigint unsigned NOT NULL UNIQUE COMMENT 'id of CloudStack zone',
+  PRIMARY KEY (`id`),
+  CONSTRAINT `fk_legacy_zones__zone_id` FOREIGN KEY (`zone_id`) REFERENCES `data_center`(`id`)
ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
 ALTER TABLE `cloud`.`network_offerings` ADD COLUMN `eip_associate_public_ip` int(1) unsigned
NOT NULL DEFAULT 0 COMMENT 'true if public IP is associated with user VM creation by default
when EIP service is enabled.' AFTER `elastic_ip_service`;
 
 -- Re-enable foreign key checking, at the end of the upgrade path
@@ -994,6 +1001,7 @@ CREATE VIEW `cloud`.`account_view` AS
     select
         account.id,
         account.uuid,
+        account.uuid,
         account.account_name,
         account.type,
         account.state,


Mime
View raw message