psa.mail_resp
Overview
The mail_resp table contains information about e-mail auto responders.
Column Descriptions
id - primary key that is automatically incremented
mn_id - links to id in mail table
resp_name - friendly name of the auto responder, shown in Plesk
keystr - what keyword string to match in the e-mail sent to the auto responder
key_where - where to match the keywords, can be subj, body or no
subject - subject line to use for the auto response
reply_to - e-mail address used in the auto response’s Reply To: line
content_type - either text/plain or text/html
charset - character set for the auto-response, usually UTF-8
text - body of the auto-response
resp_on - true if the auto responder is enabled, otherwise false
ans_freq - maximum responses per e-mail address per day
mem_limit - how many unique e-mail addresses to store for ans_freq limitations
Table Structure
CREATE TABLE `mail_resp` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `mn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', `resp_name` VARCHAR(245) character SET utf8 NOT NULL DEFAULT '', `keystr` VARCHAR(255) character SET utf8 DEFAULT NULL, `key_where` ENUM('subj','body','no') NOT NULL DEFAULT 'no', `subject` VARCHAR(255) character SET utf8 DEFAULT NULL, `reply_to` VARCHAR(255) character SET utf8 DEFAULT NULL, `content_type` VARCHAR(245) character SET utf8 NOT NULL DEFAULT 'text/plain', `CHARSET` VARCHAR(245) character SET ASCII COLLATE ascii_bin NOT NULL DEFAULT 'UTF-8', `TEXT` MEDIUMTEXT character SET utf8, `resp_on` ENUM('false','true') NOT NULL DEFAULT 'false', `ans_freq` INT(11) DEFAULT '10', `mem_limit` INT(11) DEFAULT '1000', PRIMARY KEY (`id`), KEY `mn_id_resp_name` (`mn_id`,`resp_name`) ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1