1 files changed, 3 insertions, 0 deletions
diff --git a/pbs.sql b/pbs.sql
index 2b3a198..58c21b2 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -242,6 +242,9 @@ CREATE TABLE IF NOT EXISTS `pbs_pool` (
   `location` varchar(30),
   PRIMARY KEY (`poolID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+ALTER TABLE `pbs_pool` ADD `groupID` INT NOT NULL AFTER `poolID`;
+ALTER TABLE `pbs_pool`
+  ADD CONSTRAINT `pbs_pool_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
 
 CREATE TABLE IF NOT EXISTS `pbs_poolentries` (
   `poolID` int(11) NOT NULL,