--
-- Host: localhost    Database: mail
-- ------------------------------------------------------


--
-- Table structure for table `aliases`
--

CREATE TABLE `aliases` (
  `alias` varchar(255) NOT NULL DEFAULT '',
  `rcpt` varchar(255) NOT NULL DEFAULT '',
  `comment` text,
  PRIMARY KEY (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aliases`
--

INSERT INTO `aliases` VALUES ('qqww@miranet.ru','admin@miranet.ru',NULL);

--
-- Table structure for table `forward`
--

CREATE TABLE `forward` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL DEFAULT 'delivered-to',
  `mask` varchar(255) NOT NULL DEFAULT '.+',
  `forward_addr` varchar(255) NOT NULL DEFAULT 'root',
  `what` char(1) NOT NULL DEFAULT 'i',
  `comment` text,
  PRIMARY KEY (`id`),
  KEY `what` (`what`),
  KEY `type_mask` (`type`,`mask`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forward`
--

INSERT INTO `forward` VALUES (1,'delivered-to','qqww@miranet.ru','info@miranet.ru','e','exclude forward test mail');

--
-- Table structure for table `transport`
--

CREATE TABLE `transport` (
  `domain` varchar(255) NOT NULL DEFAULT '',
  `transport` varchar(255) NOT NULL DEFAULT '',
  `comment` text,
  PRIMARY KEY (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transport`
--

INSERT INTO `transport` VALUES ('miranet.ru','maildrop:','MiraNet Mail'),('yalagina.ru','maildrop:','Uran'),('rusinkom.ru','virtual:','Flex'),('oaoyuz.ru','virtual:','OAO Yugozapadnoe'),('dmitriy-x.ru','maildrop:','Dmitriy Khodyrev');


