diff options
author | michael pereira | 2011-09-26 02:25:32 +0200 |
---|---|---|
committer | michael pereira | 2011-09-26 02:25:32 +0200 |
commit | c96879951fec2354af5f1c0183a0f941099f0caa (patch) | |
tree | 8de146fe1efa9e5970df85d2d187f681b9b2e3cb /setup/pbs.sql | |
parent | nomembership (diff) | |
download | pbs2-c96879951fec2354af5f1c0183a0f941099f0caa.tar.gz pbs2-c96879951fec2354af5f1c0183a0f941099f0caa.tar.xz pbs2-c96879951fec2354af5f1c0183a0f941099f0caa.zip |
menues ueberarbeitet
Diffstat (limited to 'setup/pbs.sql')
-rw-r--r-- | setup/pbs.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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, |