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

