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