--
-- 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 `manage`
--

CREATE TABLE `manage` (
  `login` varchar(128) NOT NULL,
  `password` varchar(128) NOT NULL,
  `access` varchar(128) NOT NULL,
  `enabled` int(10) unsigned NOT NULL,
  PRIMARY KEY (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `manage`
--

INSERT INTO `manage` VALUES ('miranet','mira322','miranet.ru',0),('mar','F36ghqG47hjw','1',1),('root','zopazopa943','1',0);

--
-- 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');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `email` varchar(255) NOT NULL,
  `login` varchar(255) NOT NULL,
  `passwd` varchar(255) NOT NULL,
  `quota` varchar(255) NOT NULL DEFAULT '20971520',
  `maildir` varchar(255) NOT NULL DEFAULT '',
  `expired` char(1) DEFAULT '0',
  `antivirus` char(1) DEFAULT '1',
  `antispam` char(1) DEFAULT '1',
  `comment` tinytext,
  PRIMARY KEY (`email`) USING BTREE,
  KEY `login_expired` (`email`,`expired`),
  KEY `login_antivirus` (`email`,`antivirus`),
  KEY `login_antispam` (`email`,`antispam`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES ('dasha@miranet.ru','dasha@miranet.ru','G47hjwG47hjw','41943040S','miranet.ru/dasha/','0','1','1','äÁÛÁ'),('mat@miranet.ru','mat@miranet.ru','132435As','20971520S','miranet.ru/mat/','0','1','1','÷ÉËÅ'),('natasha@miranet.ru','natasha@miranet.ru','132435','20971520S','miranet.ru/natasha/','1','1','1',''),('spam@miranet.ru','spam@miranet.ru','zopazopa12qw','20971520S','miranet.ru/spam/','0','0','0',''),('mar@miranet.ru','mar','G47hjwF36ghq','1073741824S','miranet.ru/mar/','0','1','1','ìÉÞÎÁÑ ÐÏÞÔÁ'),('vika@miranet.ru','vika@miranet.ru','132435As','209715200S','miranet.ru/vika/','0','1','1','÷ÉËÁ'),('julia@miranet.ru','julia@miranet.ru','jul8036220','20971520S','miranet.ru/julia/','0','1','1',''),('uran@miranet.ru','uran@miranet.ru','d1234567wE','209715200S','miranet.ru/uran/','0','1','1',''),('admin@yalagina.ru','admin@yalagina.ru','uran123d123','20971520S','yalagina.ru/admin/','0','1','1',''),('avast@miranet.ru','avast@miranet.ru','g47hjw','20971520S','miranet.ru/avast/','0','1','1','avast');


