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 <[email protected]> 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/ui-multiple-nics Commit: 5b8f0791ec15efd6a77f581a62dde9960d06102c Parents: b683c34 Author: Venkata Swamybabu Budumuru <[email protected]> Authored: Wed Feb 27 13:37:41 2013 -0500 Committer: Kishan Kavala <[email protected]> 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,
