filtertypen hinzugefügt, Zeit, Datum und Wochentage können in Filtern definiert werden, Formular wird automatisch aktualisiert

1 files changed, 12 insertions, 8 deletions

diff --git a/pbs.sql b/pbs.sql
index 9a14bb2..7a7be81 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -306,12 +306,16 @@ 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');
+INSERT INTO `pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES
+(1, 'IP'),
+(2, 'MAC'),
+(3, 'PoolID'),
+(4, 'BootIso'),
+(5, 'Membership'),
+(6, 'Group'),
+(7, 'Time'),
+(8, 'Client'),
+(9, 'Hardwarehash'),
+(10, 'Weekday'),
+(11, 'Date');