Add a proper contraint to the nicira nic map
Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/d10a7cdc Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/d10a7cdc Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/d10a7cdc Branch: refs/heads/4.0 Commit: d10a7cdc9554082401bed574e5cdfc5ea8a77265 Parents: 56af599 Author: Hugo Trippaers <[email protected]> Authored: Sat Sep 22 11:29:39 2012 +0200 Committer: Edison Su <[email protected]> Committed: Mon Sep 24 10:05:30 2012 -0700 ---------------------------------------------------------------------- setup/db/create-index-fk.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/d10a7cdc/setup/db/create-index-fk.sql ---------------------------------------------------------------------- diff --git a/setup/db/create-index-fk.sql b/setup/db/create-index-fk.sql index 82284d4..62674c6 100755 --- a/setup/db/create-index-fk.sql +++ b/setup/db/create-index-fk.sql @@ -93,3 +93,5 @@ ALTER TABLE `cloud`.`ssh_keypairs` ADD CONSTRAINT `fk_ssh_keypairs__account_id` ALTER TABLE `cloud`.`ssh_keypairs` ADD CONSTRAINT `fk_ssh_keypairs__domain_id` FOREIGN KEY `fk_ssh_keypair__domain_id` (`domain_id`) REFERENCES `domain` (`id`) ON DELETE CASCADE; ALTER TABLE `cloud`.`usage_event` ADD INDEX `i_usage_event__created`(`created`); + +ALTER TABLE `cloud`.`nicira_nvp_nic_map` ADD CONSTRAINT `fk_nicira_nvp_nic_map__nic` FOREIGN KEY `fk_nicira_nvp_nic_map__nic` (`nic`) REFERENCES `nics` (`uuid`) ON DELETE CASCADE;
