[精]搭建postfix+dovecot+ courier-authlib+sasl2+mysql邮件系统(6)

(精)搭建postfix+dovecot+ courier-authlib+sasl2+mysql邮件系统

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Domains'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `domain` WRITE;

INSERT INTO `domain` VALUES ('ALL','',0,0,0,0,'',0,'0000-00-00 00:00:00','0000-00-00 00:00:00',1),('yt.cmm','鐜夊爞',10,10,0,0,'virtual',0,'2011-12-12 10:31:20','2011-12-12 10:36:26',1),('yt.com','鐪熸槸

鐨?,10,10,0,0,'virtual',0,'2011-12-12 12:59:48','2011-12-14 09:48:35',1),('myt.com','',10,10,10,0,'virtual',0,'2011-12-14 09:04:03','2011-12-14 09:04:03',1); UNLOCK TABLES; /*域管理表*/

mysql> desc domain_admins;

+----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------------------+-------+ | username | varchar(255) | NO | MUL | NULL | | | domain | varchar(255) | NO | | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | |

+----------+--------------+------+-----+---------------------+-------+ DROP TABLE IF EXISTS `domain_admins`;

/*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `domain_admins` ( `username` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL,

`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL DEFAULT '1', KEY `username` (`username`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Domain Admins'; LOCK TABLES `domain_admins` WRITE;

INSERT INTO `domain_admins` VALUES ('admin@163.com','ALL','2011-12-12 10:30:12',1),

('yt@yt.com','yt.cmm','2011-12-12 12:59:59',1),('yt@yt.com','yt.com','2011-12-12 12:59:59',1);

UNLOCK TABLES; /**抓取邮件表*/

DROP TABLE IF EXISTS `fetchmail`; CREATE TABLE `fetchmail` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT, `mailbox` varchar(255) NOT NULL, `src_server` varchar(255) NOT NULL,

16

(精)搭建postfix+dovecot+ courier-authlib+sasl2+mysql邮件系统

`src_auth` enum('password','kerberos_v5','kerberos','kerberos_v4','gssapi','cram-md5','otp','ntlm','msn','ssh','any') DEFAULT NULL,

`src_user` varchar(255) NOT NULL, `src_password` varchar(255) NOT NULL, `src_folder` varchar(255) NOT NULL,

`poll_time` int(11) unsigned NOT NULL DEFAULT '10', `fetchall` tinyint(1) unsigned NOT NULL DEFAULT '0', `keep` tinyint(1) unsigned NOT NULL DEFAULT '0',

`protocol` enum('POP3','IMAP','POP2','ETRN','AUTO') DEFAULT NULL, `usessl` tinyint(1) unsigned NOT NULL DEFAULT '0', `extra_options` text, `returned_text` text,

`mda` varchar(255) NOT NULL,

`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1; LOCK TABLES `fetchmail` WRITE; UNLOCK TABLES; /*日志表*/ mysql> desc log;

+-----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------------------+-------+ | timestamp | datetime | NO | MUL | 0000-00-00 00:00:00 | | | username | varchar(255) | NO | | NULL | | | domain | varchar(255) | NO | | NULL | | | action | varchar(255) | NO | | NULL | | | data | text | NO | | NULL | | …… 此处隐藏：1203字，全部文档内容请下载后查看。喜欢就下载吧 ……