Added database table for storing VNMC devices
Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/db42da17 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/db42da17 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/db42da17 Branch: refs/heads/cisco-vnmc-api-integration Commit: db42da17e9d3cf7466e0f755d5046d710a5f5356 Parents: f991436 Author: Koushik Das <[email protected]> Authored: Mon Feb 11 22:44:01 2013 +0530 Committer: Koushik Das <[email protected]> Committed: Mon Feb 11 22:44:01 2013 +0530 ---------------------------------------------------------------------- setup/db/create-schema.sql | 12 ++++++++++++ 1 files changed, 12 insertions(+), 0 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/db42da17/setup/db/create-schema.sql ---------------------------------------------------------------------- diff --git a/setup/db/create-schema.sql b/setup/db/create-schema.sql index 174f53c..70fb0b8 100755 --- a/setup/db/create-schema.sql +++ b/setup/db/create-schema.sql @@ -2421,6 +2421,18 @@ CREATE TABLE `cloud`.`nicira_nvp_router_map` ( CONSTRAINT `fk_nicira_nvp_router_map__network_id` FOREIGN KEY (`network_id`) REFERENCES `networks`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +CREATE TABLE `cloud`.`external_cisco_vnmc_devices` ( + `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', + `uuid` varchar(255) UNIQUE, + `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical network in to which cisco vnmc device is added', + `provider_name` varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this cisco vnmc device', + `device_name` varchar(255) NOT NULL COMMENT 'name of the cisco vnmc device', + `host_id` bigint unsigned NOT NULL COMMENT 'host id coresponding to the external cisco vnmc device', + PRIMARY KEY (`id`), + CONSTRAINT `fk_external_cisco_vnmc_devices__host_id` FOREIGN KEY (`host_id`) REFERENCES `host`(`id`) ON DELETE CASCADE, + CONSTRAINT `fk_external_cisco_vnmc_devices__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + CREATE TABLE `cloud`.`counter` ( `id` bigint unsigned NOT NULL UNIQUE AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40),
