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

CREATE TABLE `mail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userId` int(10) unsigned NOT NULL DEFAULT '0',
  `mail_name` varchar(245) CHARACTER SET ascii NOT NULL,
  `perm_id` int(10) unsigned NOT NULL,
  `postbox` enum('false','true') NOT NULL DEFAULT 'false',
  `account_id` int(10) unsigned NOT NULL,
  `redirect` enum('false','true') NOT NULL DEFAULT 'false',
  `redir_addr` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `mail_group` enum('false','true') NOT NULL DEFAULT 'false',
  `autoresponder` enum('false','true') NOT NULL DEFAULT 'false',
  `spamfilter` enum('false','true') NOT NULL DEFAULT 'true',
  `virusfilter` enum('none','incoming','outgoing','any') NOT NULL DEFAULT 'none',
  `mbox_quota` bigint(20) NOT NULL DEFAULT '-1',
  `dom_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dom_id` (`dom_id`,`mail_name`),
  KEY `account_id` (`account_id`),
  KEY `perm_id` (`perm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1

CREATE TABLE `mail` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `userId` int(10) unsigned NOT NULL DEFAULT '0', `mail_name` varchar(245) CHARACTER SET ascii NOT NULL, `perm_id` int(10) unsigned NOT NULL, `postbox` enum('false','true') NOT NULL DEFAULT 'false', `account_id` int(10) unsigned NOT NULL, `redirect` enum('false','true') NOT NULL DEFAULT 'false', `redir_addr` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `mail_group` enum('false','true') NOT NULL DEFAULT 'false', `autoresponder` enum('false','true') NOT NULL DEFAULT 'false', `spamfilter` enum('false','true') NOT NULL DEFAULT 'true', `virusfilter` enum('none','incoming','outgoing','any') NOT NULL DEFAULT 'none', `mbox_quota` bigint(20) NOT NULL DEFAULT '-1', `dom_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `dom_id` (`dom_id`,`mail_name`), KEY `account_id` (`account_id`), KEY `perm_id` (`perm_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1