# spfilter magic sources: TEST_LIST (0.59_050208)
# created by spfilter/0.59 (spfilter.sourceforge.net, linux) on 20050208
DROP TABLE IF EXISTS spfilter;
CREATE TABLE spfilter (
addr varchar(16) NOT NULL default '',
text varchar(127) NOT NULL default '',
KEY addr (addr)
);
# query: SELECT * from spfilter WHERE addr='$a.$b.$c.$d' OR addr='$a.$b.$c';
# tip: insert into non-indexed db and create the index later will be faster
# note: sould really use LOAD DATA INFILE and read from csv above
INSERT INTO spfilter VALUES ('0.0.0.0','TEST_LIST test illegal addr-to-be-treated-as-hostname [0.0.0.0]');
INSERT INTO spfilter VALUES ('0.1.2.3','TEST_LIST test illegal addr-to-be-treated-as-hostname [0.1.2.3]');
INSERT INTO spfilter VALUES ('1','TEST_LIST test class A [1]');
INSERT INTO spfilter VALUES ('10.0.0.0','TEST_LIST EXCEPTION local net [10.0.0.0/8]');
INSERT INTO spfilter VALUES ('10.10.10.1','TEST_LIST test hyperlink http://openrbl.org/lookup.php?i=10.10.10.1');
INSERT INTO spfilter VALUES ('10.10.10.2','TEST_LIST test mailto mailto:me@privacy.net');
INSERT INTO spfilter VALUES ('12.1.1.1','TEST_LIST test hash identical-text-12.x.x.x');
INSERT INTO spfilter VALUES ('12.2.2.2','TEST_LIST test hash identical-text-12.x.x.x');
INSERT INTO spfilter VALUES ('12.3.3.3','TEST_LIST test hash identical-text-12.x.x.x');
INSERT INTO spfilter VALUES ('12.4.4.4','TEST_LIST test hash identical-text-12.x.x.x');
INSERT INTO spfilter VALUES ('127.0.0.0','TEST_LIST EXCEPTION local host [127.0.0.0/8]');
INSERT INTO spfilter VALUES ('127.0.0.2','TEST_LIST test generic [127.0.0.2]');
INSERT INTO spfilter VALUES ('127.0.0.3','TEST_LIST test dialups [127.0.0.3]');
INSERT INTO spfilter VALUES ('127.0.0.4','TEST_LIST test manual [127.0.0.4]');
INSERT INTO spfilter VALUES ('15.15.0.0','TEST_LIST test cidr-to-be-expanded [15.15.0.0/15]');
INSERT INTO spfilter VALUES ('172.16.0.0','TEST_LIST EXCEPTION local net [172.16.0.0/12]');
INSERT INTO spfilter VALUES ('192.168','TEST_LIST EXCEPTION local net [192.168.0.0/16]');
INSERT INTO spfilter VALUES ('192.203.178.107','TEST_LIST SBL sbl.crynwr.com nelson-sbl-test@crynwr.com');
INSERT INTO spfilter VALUES ('192.203.178.39','TEST_LIST RBL linux.crynwr.com nelson-rbl-test@crynwr.com');
INSERT INTO spfilter VALUES ('192.203.178.4','TEST_LIST DUL dul.crynwr.com nelson-dul-test@crynwr.com');
INSERT INTO spfilter VALUES ('192.203.178.70','TEST_LIST RSS rrss.crynwr.com nelson-rss-test@crynwr.com');
INSERT INTO spfilter VALUES ('2.2','TEST_LIST test class B [2.2]');
INSERT INTO spfilter VALUES ('200.200.200.200','TEST_LIST test tabs and trailing whitespaces');
INSERT INTO spfilter VALUES ('23.23.22','TEST_LIST test cidr-to-be-expanded [23.23.23.0/23]');
INSERT INTO spfilter VALUES ('23.23.23','TEST_LIST test cidr-to-be-expanded [23.23.23.0/23]');
INSERT INTO spfilter VALUES ('255.255.255.255','TEST_LIST test illegal addr-to-be-treated-as-hostname [255.255.255.255]');
INSERT INTO spfilter VALUES ('3.3.3','TEST_LIST test class C [3.3.3]');
INSERT INTO spfilter VALUES ('32.32.32.32','TEST_LIST test cidr-to-be-stripped [32.32.32.32/32]');
INSERT INTO spfilter VALUES ('33.33.33.33','TEST_LIST test illegal cidr-to-be-ignored [33.33.33.33/33]');
INSERT INTO spfilter VALUES ('333.444.555.666','TEST_LIST test illegal addr-to-be-treated-as-hostname [666.777.888.999]');
INSERT INTO spfilter VALUES ('4.4.4.4','TEST_LIST test class D [4.4.4.4]');
INSERT INTO spfilter VALUES ('444.555.666','TEST_LIST test illegal cidr-to-be-treated-as-hostname [444.555.666.0/24]');
INSERT INTO spfilter VALUES ('5.5.5.5','TEST_LIST test multiline 1 of 3 [5.5.5.5]; TEST_LIST test multiline 2 of 3 [5.5.5.5]; TEST_LIST test multiline 3 of 3 [5.5.5.5]');
INSERT INTO spfilter VALUES ('6.6.6.6','TEST_LIST test multiple identical records [6.6.6.6]');
INSERT INTO spfilter VALUES ('7.0.0.0','TEST_LIST test cidr-to-be-expanded [7.0.0.0/7]');
INSERT INTO spfilter VALUES ('77.1.1.1','TEST_LIST IGNORE this should not show up at all [77.1.1.1]');
INSERT INTO spfilter VALUES ('77.2.2.2','TEST_LIST IGNORE this should kill also the other one [77.2.2.2]; TEST_LIST test ignore-to-be-ignored [77.2.2.2]');
INSERT INTO spfilter VALUES ('77.3.3','TEST_LIST IGNORE partial [77.3.3]; TEST_LIST test partial ignore-to-be-ignored [77.3.3]');
INSERT INTO spfilter VALUES ('77.4.4','TEST_LIST IGNORE cidr [77.4.4.0/24]; TEST_LIST test cidr ignore-to-be-ignored [77.4.4.0/24]');
INSERT INTO spfilter VALUES ('8.8','TEST_LIST test octet-to-be-aggregated-8.8.x.x');
INSERT INTO spfilter VALUES ('8.8.8','TEST_LIST test octet-to-be-aggregated-8.8.x.x');
INSERT INTO spfilter VALUES ('8.8.8.8','TEST_LIST test octet-to-be-aggregated-8.8.x.x');
INSERT INTO spfilter VALUES ('88.1.1','TEST_LIST test exception-to-be-expanded [88.1.1.0/24]');
INSERT INTO spfilter VALUES ('88.1.1.1','TEST_LIST EXCEPTION without-parent [88.1.1.1]');
INSERT INTO spfilter VALUES ('88.2.2','TEST_LIST text exception-to-be-expanded [88.2.2]');
INSERT INTO spfilter VALUES ('88.2.2.2','TEST_LIST EXCEPTION [88.2.2]');
INSERT INTO spfilter VALUES ('88.3.2','TEST_LIST test exception-with-cidr [88.3.3.0/23]');
INSERT INTO spfilter VALUES ('88.3.3','TEST_LIST test exception-with-cidr [88.3.3.0/23]; TEST_LIST EXCEPTION [88.3.3.0/24]');
INSERT INTO spfilter VALUES ('9.9','TEST_LIST test cidr-to-be-aggregated-9.9.x.x/16');
INSERT INTO spfilter VALUES ('9.9.8','TEST_LIST test cidr-to-be-aggregated-9.9.x.x/16');
INSERT INTO spfilter VALUES ('9.9.9','TEST_LIST test cidr-to-be-aggregated-9.9.x.x/16');
INSERT INTO spfilter VALUES ('99.1.1.1','OK to-be-at-start-of-line; TEST_LIST WHITELIST to-be-at-start-of-line [99.1.1.1]; TEST_LIST test another-to-be-appended-behind-whitelist [99.1.1.1]; TEST_LIST test one-to-be-appended-behind-whitelist [99.1.1.1]');
INSERT INTO spfilter VALUES ('about','TEST_LIST test entry [about], see http://spfilter.sourceforge.net');
INSERT INTO spfilter VALUES ('example.com','TEST_LIST test hostname [example.com]');
INSERT INTO spfilter VALUES ('freemail.dom','FREEMAIL mx.freemail.dom');
INSERT INTO spfilter VALUES ('friend@public.com','TEST_LIST test email-address [friend@public.com]');
INSERT INTO spfilter VALUES ('relaytest@','TEST_LIST test localpart [relaytest@]');
INSERT INTO spfilter VALUES ('timestamp','TEST_LIST filled in by spfilter, not implemented [timestamp]');
# spfilter magic end: 050208 - added 58 records - do not edit above