cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kis...@apache.org
Subject git commit: refs/heads/master - 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
Date Tue, 05 Mar 2013 08:40:49 GMT
Updated Branches:
  refs/heads/master b683c34d3 -> 5b8f0791e


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: Kishan Kavala <kishan@cloud.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/5b8f0791
Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/5b8f0791
Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/5b8f0791

Branch: refs/heads/master
Commit: 5b8f0791ec15efd6a77f581a62dde9960d06102c
Parents: b683c34
Author: Venkata Swamybabu Budumuru <venkataswamybabu.budumuru@citrix.com>
Authored: Wed Feb 27 13:37:41 2013 -0500
Committer: Kishan Kavala <kishan@cloud.com>
Committed: Tue Mar 5 13:59:02 2013 +0530

----------------------------------------------------------------------
 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/5b8f0791/setup/db/db/schema-40to410.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-40to410.sql b/setup/db/db/schema-40to410.sql
index 809e264..4fa83a0 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,


Mime
View raw message