summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-06-30 09:38:26 +0200
committerBjörn Geiger2011-06-30 09:38:26 +0200
commit0a62c07d8f63cd8281cef874beade8b80ce46c37 (patch)
tree7794d56b258f5e033dff488430a0d091cfc81c85 /setup
parentminor (diff)
downloadpoolctrl-0a62c07d8f63cd8281cef874beade8b80ce46c37.tar.gz
poolctrl-0a62c07d8f63cd8281cef874beade8b80ce46c37.tar.xz
poolctrl-0a62c07d8f63cd8281cef874beade8b80ce46c37.zip
filterID und bootmenuID Constrait zunächst einmal auskommentiert
Diffstat (limited to 'setup')
-rw-r--r--setup/poolctrl.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index c3604d2..66fbf04 100644
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -216,8 +216,8 @@ ALTER TABLE `poolctrl_event`
ADD CONSTRAINT `poolctrl_event_poolidC` FOREIGN KEY (`pbs_poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,
ADD CONSTRAINT `poolctrl_event_membershipC` FOREIGN KEY (`pbs_membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
ADD CONSTRAINT `poolctrl_event_bootosidC` FOREIGN KEY (`pbs_bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE,
- ADD CONSTRAINT `poolctrl_event_bootmenuidC` FOREIGN KEY (`pbs_bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE,
- ADD CONSTRAINT `poolctrl_event_filteridC` FOREIGN KEY (`pbs_filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE,
+-- ADD CONSTRAINT `poolctrl_event_bootmenuidC` FOREIGN KEY (`pbs_bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE,
+-- ADD CONSTRAINT `poolctrl_event_filteridC` FOREIGN KEY (`pbs_filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE,
ADD CONSTRAINT `poolctrl_event_categoryC` FOREIGN KEY (`category`) REFERENCES `poolctrl_eventcategory` (`eventcategoryID`) ON DELETE CASCADE,
ADD CONSTRAINT `poolctrl_event_startC` CHECK (start > CURRENT_TIMESTAMP()),
ADD CONSTRAINT `poolctrl_event_endC` CHECK (end > start);