# Database postfix running on localhost
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 21, 2004 at 03:00 PM
# Server version: 4.0.18
# PHP Version: 4.3.2
#
# Database : `postfix`
#
# --------------------------------------------------------
#
# Table structure for table `postfix_aliases`
#
DROP TABLE IF EXISTS `postfix_aliases`;
CREATE TABLE `postfix_aliases` (
`id` int(32) unsigned NOT NULL auto_increment,
`alias` varchar(255) NOT NULL default '',
`rcpt` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`create_date` datetime NOT NULL default '0000-00-00 00:00:00',
`change_date` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `aliases_unique` (`id`,`alias`),
KEY `aliases_index` (`id`,`alias`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
#
# Dumping data for table `postfix_aliases`
#
INSERT INTO `postfix_aliases` VALUES (3, 'root@example.net', 'postmaster@example.net', 'example.net', '2003-06-26 14:58:46', '2003-06-26 14:58:46', 1);
INSERT INTO `postfix_aliases` VALUES (8, 'postfix@example.net', 'postmaster@example.net', 'example.net', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1);
# --------------------------------------------------------
#
# Table structure for table `postfix_forward`
#
DROP TABLE IF EXISTS `postfix_forward`;
CREATE TABLE `postfix_forward` (
`id` int(32) unsigned NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`domain` varchar(40) NOT NULL default '',
`forward_addr` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `postfix_forward`
#
# --------------------------------------------------------
#
# Table structure for table `postfix_transport`
#
DROP TABLE IF EXISTS `postfix_transport`;
CREATE TABLE `postfix_transport` (
`id` int(32) unsigned NOT NULL auto_increment,
`domain` varchar(128) NOT NULL default 'example.net',
`transport` enum('local:','virtual:','maildrop:') NOT NULL default 'virtual:',
`description` varchar(255) NOT NULL default '',
`begin_date` datetime NOT NULL default '0000-00-00 00:00:00',
`end_date` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `transport_unique` (`domain`),
KEY `transport_index` (`id`,`domain`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
#
# Dumping data for table `postfix_transport`
#
INSERT INTO `postfix_transport` VALUES (1, 'example.net', 'virtual:', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1);
# --------------------------------------------------------
#
# Table structure for table `postfix_users`
#
CREATE TABLE `postfix_users` (
`id` int(32) unsigned NOT NULL auto_increment,
`user` varchar(50) NOT NULL default '',
`name` varchar(60) NOT NULL default '',
`passwd` varchar(128) NOT NULL default '',
`domain` varchar(50) NOT NULL default '9812.net',
`uid` smallint(5) unsigned NOT NULL default '1000',
`gid` smallint(5) unsigned NOT NULL default '1000',
`clearpw` varchar(20) binary NOT NULL default '',
`home` varchar(100) NOT NULL default '/var/mail/',
`maildir` varchar(150) NOT NULL default '',
`imapok` tinyint(3) unsigned NOT NULL default '1',
`quota` varchar(100) NOT NULL default '200000000s,20000c',
`create_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_access` int(10) unsigned NOT NULL default '0',
`status` varchar(5) NOT NULL default 'Y',
PRIMARY KEY (`id`),
UNIQUE KEY `mailbox_unique` (`id`,`name`),
KEY `mailbox_index` (`id`,`name`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;
#
# Dumping data for table `postfix_users`
#
INSERT INTO `postfix_users` VALUES (1, 'chen@example.net', 'chen', 'chen', 'example.net', 1000, 1000, '', '/var/mail/', 'example.net/chen/Maildir/', 1, '200000000s,20000c', '0000-00-00 00:00:00', 0, 'Y');
INSERT INTO `postfix_users` VALUES (2, 'postmaster@example.net', 'postmaster', 'chen', 'example.net', 1000, 1000, '', '/var/mail/', 'postmaster@example.net/Maildir/', 1, '200000000s,20000c', '0000-00-00 00:00:00', 0, 'Y');
|