summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-08-24 14:50:37 +0200
committerBjörn Geiger2011-08-24 14:50:37 +0200
commitd4296b3d508ae80be78606a1fa801da7bb5a383a (patch)
tree38d5419810aaff92e7029e2a12ef890e11a95e31 /setup
parentMerge branch 'master' of git.openslx.org:lsfks/projekte/poolctrl (diff)
downloadpoolctrl-d4296b3d508ae80be78606a1fa801da7bb5a383a.tar.gz
poolctrl-d4296b3d508ae80be78606a1fa801da7bb5a383a.tar.xz
poolctrl-d4296b3d508ae80be78606a1fa801da7bb5a383a.zip
minor
Diffstat (limited to 'setup')
-rw-r--r--setup/poolctrl.sql3
1 files changed, 0 insertions, 3 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index 3580485..897229a 100644
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -192,9 +192,6 @@ ALTER TABLE `poolctrl_eventreport`
ADD CONSTRAINT `pbs_eventreport_typeidC` FOREIGN KEY (`type`) REFERENCES `poolctrl_eventtype` (`eventtypeID`) ON DELETE CASCADE;
ALTER TABLE `poolctrl_event`
- ADD CONSTRAINT `poolctrl_event_poolidC` FOREIGN KEY (`pbs_poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,
- ADD CONSTRAINT `poolctrl_event_bootosidC` FOREIGN KEY (`pbs_bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE,
- ADD CONSTRAINT `poolctrl_event_membershipidC` FOREIGN KEY (`pbs_membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
ADD CONSTRAINT `poolctrl_event_categoryC` FOREIGN KEY (`category`) REFERENCES `poolctrl_eventcategory` (`eventcategoryID`) ON DELETE CASCADE,
ADD CONSTRAINT `poolctrl_event_runningtypeC` FOREIGN KEY (`runningtype`) REFERENCES `poolctrl_eventtype` (`eventtypeID`) ON DELETE SET NULL,
ADD CONSTRAINT `poolctrl_event_startC` CHECK (start > CURRENT_TIMESTAMP()),