-- MySQL dump 8.22
--
-- Host: localhost    Database: maildb
---------------------------------------------------------
-- Server version	3.23.51-log

--
-- Table structure for table 'aliases'
--  mysql equivalent to the /etc/aliases file
--

CREATE TABLE aliases (
  id int(11) unsigned NOT NULL auto_increment,
  lookup varchar(128) NOT NULL default '',
  value varchar(255) NOT NULL default '',
  status int(1) unsigned NOT NULL default '1',
  comment varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY aliases_lookup_uidx (lookup)
) TYPE=MyISAM;

--
-- Table structure for table 'domains'
--  all domains in here are recognised as local domains
--

CREATE TABLE domains (
  id int(11) unsigned NOT NULL auto_increment,
  domain varchar(128) NOT NULL default '',
  status int(1) unsigned NOT NULL default '1',
  comment varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY domains_domain_uidx (domain)
) TYPE=MyISAM;

--
-- Table structure for table 'userpref'
--  used by spamassassin
--

CREATE TABLE userpref (
  id int(11) unsigned NOT NULL auto_increment,
  username varchar(8) NOT NULL default '',
  preference varchar(30) NOT NULL default '',
  value varchar(100) NOT NULL default '',
  comment varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY userprefs_username_idx (username)
) TYPE=MyISAM;

--
-- Table structure for table 'vusers'
--

CREATE TABLE vusers (
  id int(11) unsigned NOT NULL auto_increment,
  user varchar(8) NOT NULL default '',
  name varchar(128) NOT NULL default '',
  clear varchar(128) NOT NULL default '',
  crypt varchar(128) NOT NULL default '',
  uid int(10) unsigned NOT NULL default '8',
  gid int(10) unsigned NOT NULL default '8',
  home varchar(255) NOT NULL default '',
  maildir varchar(255) NOT NULL default '',
  forward varchar(255) NOT NULL default '',
  quota varchar(255) NOT NULL default '',
  status int(1) unsigned NOT NULL default '1',
  asmtp int(1) unsigned NOT NULL default '0',
  pop int(1) unsigned NOT NULL default '0',
  privlevel int(3) unsigned NOT NULL default '0',
  comment varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY vusers_user_uidx (user)
) TYPE=MyISAM;