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 |