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