psa.spamfilter_preferences

Overview
The spamfilter_preferences table contains detailed preferences for spam filtering per e-mail account.

Column Descriptions
prefid - primary key that is automatically incremented
spamfilter_id - links to id in spamfilter table
preference - keyword parameter
value - value which corresponds to the keyword parameter

Table Structure

CREATE TABLE `spamfilter_preferences` (
 `prefid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `spamfilter_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
 `preference` VARCHAR(30) character SET ASCII NOT NULL DEFAULT '',
 `value` VARCHAR(255) character SET utf8 NOT NULL DEFAULT '',
 PRIMARY KEY  (`prefid`),
 KEY `spamfilter_id` (`spamfilter_id`,`preference`,`value`)
) ENGINE=INNODB AUTO_INCREMENT=1531 DEFAULT CHARSET=latin1

Related documentation

September 25th, 2008 in All Tables, Mail | tags: