DROP DATABASE provider; CREATE DATABASE provider; USE provider; # # Tabellenstruktur für Tabelle `alias` # DROP TABLE IF EXISTS alias; CREATE TABLE alias ( id int(11) NOT NULL auto_increment, alias varchar(128) NOT NULL default '', destination varchar(128) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `customers` # DROP TABLE IF EXISTS customers; CREATE TABLE customers ( customer varchar(8) NOT NULL default '', realname varchar(30) NOT NULL default '', password tinytext NOT NULL, PRIMARY KEY (customer) ) TYPE=MyISAM; # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `domains` # DROP TABLE IF EXISTS domains; CREATE TABLE domains ( customer varchar(8) NOT NULL default '', domain varchar(60) NOT NULL default '' ) TYPE=MyISAM; # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `relocated` # DROP TABLE IF EXISTS relocated; CREATE TABLE relocated ( id int(11) NOT NULL auto_increment, email varchar(128) NOT NULL default '', destination varchar(128) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `transport` # DROP TABLE IF EXISTS transport; CREATE TABLE transport ( id int(11) NOT NULL auto_increment, domain varchar(128) NOT NULL default '', destination varchar(128) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY domain (domain) ) TYPE=MyISAM; # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `users` # DROP TABLE IF EXISTS users; CREATE TABLE users ( id int(11) NOT NULL auto_increment, email varchar(128) NOT NULL default '', password varchar(128) NOT NULL default '', name tinytext NOT NULL, uid int(11) NOT NULL default '1008', gid int(11) NOT NULL default '1008', homedir varchar(128) NOT NULL default '/home/vmail', maildir varchar(128) NOT NULL, quota varchar(128) NOT NULL, postfix enum('Y','N') NOT NULL default 'Y', PRIMARY KEY (id), UNIQUE KEY email (email) ) TYPE=MyISAM; # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `virtual` # DROP TABLE IF EXISTS virtual; CREATE TABLE virtual ( id int(11) NOT NULL auto_increment, email varchar(50) NOT NULL default '', destination text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;