diff options
author | Simon | 2011-03-18 09:59:02 +0100 |
---|---|---|
committer | Simon | 2011-03-18 09:59:02 +0100 |
commit | 56d0655309fb13e8a2b8bb86a54206b419c32d18 (patch) | |
tree | 8ffdf1cfc00eef35ec08d2310e62566df55508ce /pbs.sql | |
parent | Person und Gruppen, Fehler korrigiert + Layout (diff) | |
download | pbs2-56d0655309fb13e8a2b8bb86a54206b419c32d18.tar.gz pbs2-56d0655309fb13e8a2b8bb86a54206b419c32d18.tar.xz pbs2-56d0655309fb13e8a2b8bb86a54206b419c32d18.zip |
Datenbank update, PoolController
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 3 |
1 files changed, 3 insertions, 0 deletions
@@ -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, |