You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ch...@apache.org on 2013/03/05 16:57:52 UTC
git commit: refs/heads/4.1 - Accounts can hold multiple vnets. Same
vnets can exist across multiple pnets. It is sufficient to constrain a single
vnet in a given pnet within a datacenter.
`i_op_dc_vnet_alloc__vnet__data_center_id` covers all use cases fo
Updated Branches:
refs/heads/4.1 c60643d53 -> 17e3313e6
Accounts can hold multiple vnets. Same vnets can exist across multiple pnets. It is sufficient to constrain a single vnet in a given pnet within a datacenter. `i_op_dc_vnet_alloc__vnet__data_center_id` covers all use cases for the table.
Having `i_op_dc_vnet_alloc__vnet__data_center_id__account_id` will restrict
same account holding the same vnet across different physical networks.
Signed-off-by: Venkata Swamybabu Budumuru <ve...@citrix.com>
Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/17e3313e
Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/17e3313e
Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/17e3313e
Branch: refs/heads/4.1
Commit: 17e3313e694940efb97eb4aadec336869c24022d
Parents: c60643d
Author: Venkata Swamybabu Budumuru <ve...@citrix.com>
Authored: Wed Feb 27 13:37:41 2013 -0500
Committer: Chip Childers <ch...@gmail.com>
Committed: Tue Mar 5 10:57:37 2013 -0500
----------------------------------------------------------------------
setup/db/db/schema-40to410.sql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/17e3313e/setup/db/db/schema-40to410.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-40to410.sql b/setup/db/db/schema-40to410.sql
index bc23a09..b45482f 100644
--- a/setup/db/db/schema-40to410.sql
+++ b/setup/db/db/schema-40to410.sql
@@ -251,6 +251,8 @@ ALTER TABLE `cloud`.`op_dc_vnet_alloc` DROP INDEX i_op_dc_vnet_alloc__vnet__data
ALTER TABLE `cloud`.`op_dc_vnet_alloc` ADD CONSTRAINT UNIQUE `i_op_dc_vnet_alloc__vnet__data_center_id`(`vnet`, `physical_network_id`, `data_center_id`);
+ALTER TABLE `cloud`.`op_dc_vnet_alloc` DROP INDEX i_op_dc_vnet_alloc__vnet__data_center_id__account_id;
+
CREATE TABLE `cloud`.`region` (
`id` int unsigned NOT NULL UNIQUE,
`name` varchar(255) NOT NULL UNIQUE,