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 |