psa.mail
Overview
Column Descriptions
id –
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
Related documentation
March 13th, 2013 in
Uncategorized