summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-09-07 14:02:46 +0200
committerBjörn Geiger2011-09-07 14:02:46 +0200
commitafc41a26404d9dfffeae3f9ac16f0c7be7e945ba (patch)
tree27b7518a1d3f49321d33e4e029c591220fe3966a /setup
parentMerge branch 'master' of git.openslx.org:lsfks/projekte/poolctrl (diff)
downloadpoolctrl-afc41a26404d9dfffeae3f9ac16f0c7be7e945ba.tar.gz
poolctrl-afc41a26404d9dfffeae3f9ac16f0c7be7e945ba.tar.xz
poolctrl-afc41a26404d9dfffeae3f9ac16f0c7be7e945ba.zip
kleine korrektur in DB
Diffstat (limited to 'setup')
-rw-r--r--setup/poolctrl.sql6
1 files changed, 1 insertions, 5 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index 4cd4c2a..5762a29 100644
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -124,12 +124,8 @@ CREATE TABLE IF NOT EXISTS `pbs_poolentries` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
-- Constraints
-ALTER TABLE `pbs_bootos`
- ADD CONSTRAINT `pbs_bootos_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL;
-
ALTER TABLE `pbs_config`
- ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
- ADD CONSTRAINT `pbs_config_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE;
+ ADD CONSTRAINT `pbs_config_ibfk` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE;
ALTER TABLE `pbs_poolentries`
ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,