#
# this file was contributed by James Harr.
#

# Host: cerberus2.grickle.org
# Database: maildb
# Table: 'aliases'
# 
CREATE TABLE `aliases` (
  `type` set('site','system') NOT NULL default 'site',
  `email` char(128) NOT NULL default '',
  `dest` char(128) NOT NULL default '',
  PRIMARY KEY  (`email`)
) TYPE=MyISAM; 

# Host: cerberus2.grickle.org
# Database: maildb
# Table: 'domains'
# 
CREATE TABLE `domains` (
  `domain` char(128) NOT NULL default '',
  `type` enum('local','relay','manual_relay') NOT NULL default 'local',
  `relay_host` char(128) NOT NULL default '',
  PRIMARY KEY  (`domain`)
) TYPE=MyISAM; 

# Host: cerberus2.grickle.org
# Database: maildb
# Table: 'passwd'
# 
CREATE TABLE `passwd` (
  `email` char(128) NOT NULL default '',
  `crypt` char(128) NOT NULL default '',
  `clear` char(128) NOT NULL default '',
  `name` char(128) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '65534',
  `gid` int(10) unsigned NOT NULL default '12',
  `home` char(255) NOT NULL default '',
  `maildir` char(255) NOT NULL default '',
  `quota` char(255) NOT NULL default '',
  PRIMARY KEY  (`email`)
) TYPE=MyISAM; 

