Membership in Session eingefügt, Filtertypes nur einmal per Script einfügen, auskommentierten Code entfernt

1 files changed, 4 insertions, 3 deletions

diff --git a/pbs.sql b/pbs.sql
index 7a7be81..81c7a3d 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -216,14 +216,15 @@ CREATE TABLE IF NOT EXISTS `pbs_session` (
   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 `alphasessionID` VARCHAR( 16 ) NOT NULL AFTER `sessionID` ,
-ADD UNIQUE (`alphasessionID`) ;
+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`),
   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`);
+  ADD CONSTRAINT `pbs_session_ibfk_3` FOREIGN KEY (`bootisoID`) REFERENCES `pbs_bootiso` (`bootisoID`),
+  ADD CONSTRAINT `pbs_session_ibfk_4` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`);
 
 CREATE TABLE IF NOT EXISTS `pbs_pool` (
   `poolID` int(11) NOT NULL AUTO_INCREMENT,