FilterController Evaluate funktioniert

1 files changed, 11 insertions, 2 deletions

diff --git a/pbs.sql b/pbs.sql
index a4149c2..f404b0a 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -204,8 +204,8 @@ CREATE TABLE IF NOT EXISTS `pbs_client` (
 
 CREATE TABLE IF NOT EXISTS `pbs_session` (
   `sessionID` int(11) NOT NULL AUTO_INCREMENT,
-  `clientID` int(11) NOT NULL,
-  `bootosID` int(11) NOT NULL,
+  `clientID` int(11),
+  `bootosID` int(11),
   `time` varchar(14) NOT NULL,
   `ip` varchar(15) NOT NULL,
   `ip6` varchar(45),
@@ -303,5 +303,14 @@ ALTER TABLE `pbs_filterentries`
   ADD CONSTRAINT `pbs_filterentries_ibfk_2` FOREIGN KEY (`filtertypeID`) REFERENCES `pbs_filtertype` (`filtertypeID`) ON DELETE CASCADE;
 
 
+-- Insert Filtertypes
+INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'IP');
+INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'MAC');
+INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'PoolID');
+INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'BootIso');
+INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'Membership');
+INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'Group');
+INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'Time');
+INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'Client');