The LogDB.SpamRules table contains a record of the spamfilter rules which matched for messages logged by VPOP3. A message may have zero or more spamrules entries
Columns
spamruleid - this is a bigint sequential value which identifies the spam rule entry uniquely in the database
msgid - this is a bigint value linking this message to a message
name - the spam rule name
testpattern - the spam rule test pattern which matched (if any)
testmatch - the message content which matched the pattern (if any)
score - the spam filter score assigned by the spam rule match