CREATE DATABASE mail;
USE mail;

-- --------------------------------------------
-- Estrutura da tabela `aliases`
CREATE TABLE `aliases` (
`alias` varchar(255) NOT NULL default '',
`rcpt` varchar(255) default NULL,
KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------

-- Estrutura da tabela `domain`

CREATE TABLE `domain` (
`name` char(128) NOT NULL default '',
`quota` char( 255 ) NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------

-- Estrutura da tabela `users`
CREATE TABLE `users` (
`id` int(32) unsigned NOT NULL auto_increment,
`mail` char(128) NOT NULL default '',
`pass` char(128) default NULL,
`uid` int(10) unsigned default '105',
`gid` int(10) unsigned default '105',
`home` char(255) default NULL,
`maildir` char(255) default NULL,
`date_add` date default NULL,
`time_add` time default NULL,
`domain` char(128) default NULL,
`name` char(255) default NULL,
`ok` tinyint(3) unsigned default '1',
`quota` char(255) default '250000000',
PRIMARY KEY (`mail`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-----------------------------------------------------------

--- Criando Usuário

GRANT ALL PRIVILEGES ON mail.* TO sceo@localhost IDENTIFIED BY "minhasenha" WITH GRANT OPTION;

FLUSH PRIVILEGES;