-- MySQL dump 9.07 -- -- Host: localhost Database: qmail --------------------------------------------------------- -- Server version 4.0.10-gamma-log -- -- Table structure for table 'alias' -- CREATE TABLE alias ( id mediumint(9) NOT NULL auto_increment, username varchar(32) NOT NULL default '', alias varchar(128) NOT NULL default '', alias_username varchar(32) NOT NULL default '', alias_host varchar(128) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY user_alias (username,alias,alias_username,alias_host), KEY username (username), KEY alias (alias) ) TYPE=InnoDB; -- -- Table structure for table 'mailbox' -- CREATE TABLE mailbox ( id mediumint(9) NOT NULL auto_increment, username varchar(32) NOT NULL default '', uid mediumint(9) NOT NULL default '0', gid mediumint(9) NOT NULL default '0', home varchar(128) NOT NULL default '', password varchar(16) NOT NULL default '', password_type enum('Password','Crypt-Password','MySQL-Password') NOT NULL default 'Password', suspended enum('N','Y') NOT NULL default 'N', PRIMARY KEY (id), UNIQUE KEY username (username), UNIQUE KEY home (home), KEY password (password) ) TYPE=InnoDB; -- -- Table structure for table 'rcpthosts' -- CREATE TABLE rcpthosts ( id mediumint(9) NOT NULL auto_increment, host varchar(128) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY host (host) ) TYPE=InnoDB; -- -- Table structure for table 'virtual' -- CREATE TABLE virtual ( id mediumint(9) NOT NULL auto_increment, username varchar(32) NOT NULL default '', ext varchar(128) NOT NULL default '', virtual_username varchar(32) NOT NULL default '', virtual_host varchar(128) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY address (virtual_username,virtual_host), UNIQUE KEY virtual (username,ext,virtual_username,virtual_host), KEY virtual_username (virtual_username), KEY virtual_host (virtual_host) ) TYPE=InnoDB;