1 files changed, 2 insertions, 0 deletions
diff --git a/pbs.sql b/pbs.sql
index ef72c39..099ea65 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -214,10 +214,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,