From f2178d2d330f3416a6f56ca6185c4a4a4c47475d Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Tue, 28 Jun 2011 11:45:38 +0200 Subject: Fehler in Datenbank korrgiert --- setup/poolctrl.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'setup/poolctrl.sql') diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql index eaecfa0..2a4432a 100644 --- a/setup/poolctrl.sql +++ b/setup/poolctrl.sql @@ -115,6 +115,7 @@ CREATE TABLE IF NOT EXISTS `pbs_membership` ( CREATE TABLE IF NOT EXISTS `pbs_pool` ( `poolID` int(11) NOT NULL AUTO_INCREMENT, + `groupID` int(11) NOT NULL, `title` varchar(30) NOT NULL, `description` varchar(140), `location` varchar(30), @@ -159,6 +160,9 @@ ALTER TABLE `pbs_bootos` ALTER TABLE `pbs_client` ADD CONSTRAINT `pbs_client_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; +ALTER TABLE `pbs_pool` + ADD CONSTRAINT `pbs_pool_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; + ALTER TABLE `pbs_poolentries` ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE; -- cgit v1.2.3-55-g7522