psa.mail_resp

Overview

Column Descriptions

id –

CREATE TABLE `mail_resp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mn_id` int(10) unsigned NOT NULL,
  `resp_name` varchar(245) CHARACTER SET utf8 NOT NULL,
  `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 DEFAULT CHARSET=latin1

Related documentation