1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

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

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