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

+-----------+--------------+------+-----+---------------------+-------+ DROP TABLE IF EXISTS `log`; CREATE TABLE `log` (

`timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `username` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `data` text NOT NULL, KEY `timestamp` (`timestamp`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Log';

17

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

LOCK TABLES `log` WRITE;

INSERT INTO `log` VALUES ('2011-12-12 13:00:33','admin@163.com

(192.168.137.1)','yt.com','create_mailbox','mm@yt.com'),('2011-12-12 13:01:19','admin@163.com (192.168.137.1)','yt.com','create_mailbox','mm2@yt.com'),('2011-12-12 23:43:06','mm2@yt.com (192.168.137.1)','yt.com','edit_password','mm2@yt.com'),('2011-12-13 06:09:33','admin@163.com (192.168.137.1)','yt.com','edit_mailbox','mm2@yt.com'),('2011-12-14 09:06:07','admin@163.com (192.168.137.1)','myt.com','create_alias','ftm@myt.com -> m@yt.com'); UNLOCK TABLES; /*邮件箱表*/ mysql> desc mailbox;

+------------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------------------+-------+ | username | varchar(255) | NO | PRI | NULL | | | password | varchar(255) | NO | | NULL | | | name | varchar(255) | NO | | NULL | | | maildir | varchar(255) | NO | | NULL | | | quota | bigint(20) | NO | | 0 | | | local_part | varchar(255) | NO | | NULL | | | domain | varchar(255) | NO | MUL | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | |

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

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

`name` varchar(255) CHARACTER SET utf8 NOT NULL, `maildir` varchar(255) NOT NULL,

`quota` bigint(20) NOT NULL DEFAULT '0', `local_part` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL,

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

18

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

PRIMARY KEY (`username`), KEY `domain` (`domain`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes'; LOCK TABLES `mailbox` WRITE;

INSERT INTO `mailbox` VALUES ('mm@yt.com','$1$ba4c2966$Xamg4aeMTEyYu7My9tY2g0','灏忎簲

','yt.com/mm/',0,'mm','yt.com','2011-12-12 13:00:33','2011-12-12 13:00:33',1),('mm2@yt.com', '$1$698466ef$jE9tVGrNvD1.4wbOL1XHj1','','yt.com/mm2/',0,'mm2','yt.com','2011-12-12

13:01:19','2011-12-13 06:09:33',1),('m3@yt.com','m3','','yt.com/m3',0,'','','0000-00-00 00:00:00','0000-00-00 00:00:00',1); UNLOCK TABLES; /*用户配额表*/ mysql> desc quota;

+----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | username | varchar(255) | NO | PRI | NULL | | | path | varchar(100) | NO | PRI | NULL | | | current | bigint(20) | YES | | NULL | | +----------+--------------+------+-----+---------+-------+ DROP TABLE IF EXISTS `quota`; CREATE TABLE `quota` (

`username` varchar(255) NOT NULL, `path` varchar(100) NOT NULL, `current` bigint(20) DEFAULT NULL, PRIMARY KEY (`username`,`path`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1; LOCK TABLES `quota` WRITE; UNLOCK TABLES; /*邮箱配额表2*/

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

`username` varchar(100) NOT NULL, `bytes` bigint(20) NOT NULL DEFAULT '0', `messages` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`username`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1; LOCK TABLES `quota2` WRITE; UNLOCK TABLES;

19

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

/*创建自动回复表*/ mysql> desc vacation;

+---------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------------------+-------+ | email | varchar(255) | NO | PRI | NULL | | | subject | varchar(255) | NO | | NULL | | | body | text | NO | | NULL | | | cache | text | NO | | NULL | | | domain | varchar(255) | NO | | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | |

+---------+--------------+------+-----+---------------------+-------+ DROP TABLE IF EXISTS `vacation`; CREATE TABLE `vacation` ( `email` varchar(255) NOT NULL,

`subject` varchar(255) CHARACTER SET utf8 NOT NULL, `body` text CHARACTER SET utf8 NOT NULL, `cache` text 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', PRIMARY KEY (`email`), KEY `email` (`email`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Vacation'; LOCK TABLES `vacation` …… 此处隐藏：3601字，全部文档内容请下载后查看。喜欢就下载吧 ……