psa.spamfilter

Overview
The spamfilter table contains the basic configuration for spam filtering per e-mail account.

Column Descriptions
id – primary key that is automatically incremented
username – e-mail account that has spam filtering enabled
preferencestrue if the e-mail account has account-level preferences, otherwise false
reject_spamtrue if spam should be thrown away, otherwise false

Table Structure

CREATE TABLE `spamfilter` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `username` varchar(128) character set ascii NOT NULL default '',
 `preferences` enum('false','true') NOT NULL default 'false',
 `reject_spam` enum('false','true') NOT NULL default 'false',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=636 DEFAULT CHARSET=latin1

Related documentation