From c96879951fec2354af5f1c0183a0f941099f0caa Mon Sep 17 00:00:00 2001
From: michael pereira
Date: Mon, 26 Sep 2011 02:25:32 +0200
Subject: menues ueberarbeitet

---
 setup/pbs.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'setup')

diff --git a/setup/pbs.sql b/setup/pbs.sql
index 0ddf900..227aec7 100644
--- a/setup/pbs.sql
+++ b/setup/pbs.sql
@@ -288,13 +288,14 @@ ALTER TABLE `pbs_session` ADD `bootisoID` INT AFTER `bootosID`;
 ALTER TABLE `pbs_session` ADD `alphasessionID` VARCHAR( 16 ) NOT NULL AFTER `sessionID`, ADD UNIQUE (`alphasessionID`) ;
 ALTER TABLE `pbs_session` ADD `bootmenuentryID` INT AFTER `clientID` ;
 ALTER TABLE `pbs_session` ADD `membershipID` INT NULL AFTER `bootisoID` ;
-
+ALTER TABLE `pbs_session` ADD `personID` INT NULL AFTER `membershipID` ;
 
 ALTER TABLE `pbs_session`
   ADD CONSTRAINT `pbs_session_ibfk_1` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_session_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE SET NULL,
   ADD CONSTRAINT `pbs_session_ibfk_3` FOREIGN KEY (`bootisoID`) REFERENCES `pbs_bootiso` (`bootisoID`) ON DELETE SET NULL,
   ADD CONSTRAINT `pbs_session_ibfk_4` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE;
+  ADD CONSTRAINT `pbs_session_ibfk_5` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE; 
 
 CREATE TABLE IF NOT EXISTS `pbs_pool` (
   `poolID` int(11) NOT NULL AUTO_INCREMENT,
-- 
cgit v1.2.3-55-g7522