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/6dcff824 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/6dcff824 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/6dcff824 Branch: refs/heads/vmware-datamodel Commit: 6dcff8246bb50398bba92ac9a7aad780c033f231 Parents: 8aa4134 Author: Sateesh Chodapuneedi <sate...@apache.org> Authored: Sat May 4 23:20:59 2013 +0530 Committer: Sateesh Chodapuneedi <sate...@apache.org> Committed: Sun May 19 08:37:16 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/6dcff824/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index 42815a1..12d50af 100644 --- a/setup/db/db/schema-410to420.sql +++ b/setup/db/db/schema-410to420.sql @@ -998,6 +998,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`; @@ -1110,6 +1117,7 @@ CREATE VIEW `cloud`.`account_view` AS select account.id, account.uuid, + account.uuid, account.account_name, account.type, account.state,
