psa.mail

Overview
The mail table contains information about all of the e-mail accounts configured on the server.

Column Descriptions
id – primary key that is automatically incremented
mail_name – the name of the e-mail account (text before the @ sign)
perm_id – links to id in Permissions table
postboxtrue if the mailbox is enabled, otherwise false
account_id – links to id in accounts table
redirecttrue if e-mail should be redirected, otherwise false
redir_addr – contains an e-mail address for redirection, otherwise empty
mail_grouptrue if the e-mail account is a mail group, otherwise false
autorespondertrue if the account has an autoresponder, otherwise false
spamfiltertrue if spam filtering is enabled, otherwise false
virusfilter – contains incoming, outgoing, any, or none
mbox_quota – limit on mailbox size in bytes
dom_id – links to id in domains

Table Structure

CREATE TABLE `mail` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `mail_name` varchar(245) character set ascii NOT NULL default '',
 `perm_id` int(10) unsigned NOT NULL default '0',
 `postbox` enum('false','true') NOT NULL default 'false',
 `account_id` int(10) unsigned NOT NULL default '0',
 `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 'false',
 `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 default '0',
 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=336 DEFAULT CHARSET=latin1

Related documentation