Updated Branches: refs/heads/master 66dc71862 -> 21ee8982a
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/21ee8982 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/21ee8982 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/21ee8982 Branch: refs/heads/master Commit: 21ee8982a1c9fe20f9ab892141b42b15444ec926 Parents: 4c38152 Author: Hugo Trippaers <[email protected]> Authored: Sat Sep 22 11:29:39 2012 +0200 Committer: Hugo Trippaers <[email protected]> Committed: Sat Sep 22 11:29:39 2012 +0200 ---------------------------------------------------------------------- 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/21ee8982/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;
