diff options
author | michael pereira | 2011-03-08 14:54:34 +0100 |
---|---|---|
committer | michael pereira | 2011-03-08 14:54:34 +0100 |
commit | 2d7595cc8b8078acce88888c6800f85f927c7c2d (patch) | |
tree | 97b74c4134c0e480a4d4ca34dbdbc0083f54d5a3 /pbs.sql | |
parent | pbs.sql aktualisiert (diff) | |
parent | application.ini entfernt (diff) | |
download | pbs2-2d7595cc8b8078acce88888c6800f85f927c7c2d.tar.gz pbs2-2d7595cc8b8078acce88888c6800f85f927c7c2d.tar.xz pbs2-2d7595cc8b8078acce88888c6800f85f927c7c2d.zip |
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 2 |
1 files changed, 2 insertions, 0 deletions
@@ -213,10 +213,12 @@ 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 CONSTRAINT `pbs_session_ibfk_1` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`), ADD CONSTRAINT `pbs_session_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`); + ADD CONSTRAINT `pbs_session_ibfk_3` FOREIGN KEY (`bootisoID`) REFERENCES `pbs_bootiso` (`bootisoID`); CREATE TABLE IF NOT EXISTS `pbs_pool` ( `poolID` int(11) NOT NULL AUTO_INCREMENT, |