summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql20
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');