psa.MailLists

Overview
The MailLists table contains information about mailman’s mailing lists.

Column Descriptions
id – primary key that is automatically incremented
dom_id – links to id in domains table
name – mailing list name (left side of the e-mail address)
status – 0 if enabled, 16 if disabled

Table Structure

CREATE TABLE `MailLists` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `dom_id` int(10) unsigned NOT NULL default '0',
 `name` varchar(255) character set ascii NOT NULL default '',
 `status` bigint(20) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `dom_id` (`dom_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Related documentation

September 23rd, 2008 in All Tables, Mail | tags: ,