======LogDB.SpamRules table======
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 [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]] sequential value which identifies the spam rule entry uniquely in the database
  * msgid - this is a bigint value linking this message to a [[logdb messages|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