diff options
Diffstat (limited to 'pbs.sql')
| -rw-r--r-- | pbs.sql | 20 |
1 files changed, 12 insertions, 8 deletions
@@ -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'); |
