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
postbox – true if the mailbox is enabled, otherwise false
account_id – links to id in accounts table
redirect – true if e-mail should be redirected, otherwise false
redir_addr – contains an e-mail address for redirection, otherwise empty
mail_group – true if the e-mail account is a mail group, otherwise false
autoresponder – true if the account has an autoresponder, otherwise false
spamfilter – true 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