You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ed...@apache.org on 2012/09/24 19:29:54 UTC
[19/20] git commit: Add a proper contraint to the nicira nic map
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 <ht...@schubergphilis.com>
Authored: Sat Sep 22 11:29:39 2012 +0200
Committer: Edison Su <su...@gmail.com>
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;