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
preferences - true if the e-mail account has account-level preferences, otherwise false
reject_spam - true 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

• psa.spamfilter_preferences