SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `Access` (
  `Id` int(5) NOT NULL AUTO_INCREMENT,
  `Domain` varchar(255) NOT NULL,
  `Adres` varchar(255) NOT NULL,
  `Durum` varchar(255) NOT NULL DEFAULT '550 No soup for you, next!',
  `Status` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Adres` (`Adres`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `Alias` (
  `Id` int(5) NOT NULL AUTO_INCREMENT,
  `Domain` varchar(255) NOT NULL,
  `Original` varchar(255) NOT NULL,
  `Destination` text NOT NULL,
  `Status` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Original` (`Original`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `BCC` (
  `Id` int(5) NOT NULL AUTO_INCREMENT,
  `Domain` varchar(255) NOT NULL,
  `Original` varchar(255) NOT NULL,
  `Destination` text NOT NULL,
  `Status` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Original` (`Original`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `Domain` (
  `Id` int(5) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL,
  `Password` varchar(32) NOT NULL,
  `Status` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `Transport` (
  `Id` int(5) NOT NULL AUTO_INCREMENT,
  `Original` varchar(255) NOT NULL,
  `Destination` varchar(255) NOT NULL,
  `Status` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Incoming` (`Original`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `User` (
  `Id` int(5) NOT NULL AUTO_INCREMENT,
  `Domain` varchar(255) NOT NULL,
  `Username` varchar(255) NOT NULL,
  `Password` varchar(32) NOT NULL,
  `Quota` int(10) NOT NULL DEFAULT '10485760',
  `Status` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;