diff options
author | michael pereira | 2011-03-16 16:35:15 +0100 |
---|---|---|
committer | michael pereira | 2011-03-16 16:35:15 +0100 |
commit | 26deb7a640aea0653dae33f9b9d36f552b58c07d (patch) | |
tree | 3d8c62cdd4906322cf518e618479b061ccf41e8d /pbs.sql | |
parent | Default KCL wird jetzt automatisch geupdated (diff) | |
download | pbs2-26deb7a640aea0653dae33f9b9d36f552b58c07d.tar.gz pbs2-26deb7a640aea0653dae33f9b9d36f552b58c07d.tar.xz pbs2-26deb7a640aea0653dae33f9b9d36f552b58c07d.zip |
KCLAppend hinzugefuegt, KCL fertig :-)
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -220,15 +220,15 @@ CREATE TABLE IF NOT EXISTS `pbs_session` ( KEY `clientID` (`clientID`), KEY `bootosID` (`bootosID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -ALTER TABLE `pbs_session` ADD `bootisoID` INT NOT NULL AFTER `bootosID`; +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 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 CASCADE, - ADD CONSTRAINT `pbs_session_ibfk_3` FOREIGN KEY (`bootisoID`) REFERENCES `pbs_bootiso` (`bootisoID`) 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; CREATE TABLE IF NOT EXISTS `pbs_pool` ( |