Database accounts running on localhost

# phpMyAdmin MySQL-Dump
# version 2.2.6
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jun 25, 2003 at 05:12 PM
# Server version: 3.23.54
# PHP Version: 4.1.2
# Database : `accounts`
# --------------------------------------------------------

#
# Table structure for table `accountuser`
#

CREATE TABLE accountuser (
  username varchar(30) NOT NULL default '',
  password varchar(30) binary NOT NULL default '',
  prefix varchar(30) NOT NULL default '',
  domain_name varchar(255) NOT NULL default '',
  UNIQUE KEY username (username)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `adminuser`
#

CREATE TABLE adminuser (
  username varchar(30) NOT NULL default '',
  password varchar(30) binary NOT NULL default '',
  type int(11) NOT NULL default '0',
  SID varchar(255) NOT NULL default '',
  home varchar(255) NOT NULL default '',
  PRIMARY KEY  (username)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `alias`
#

CREATE TABLE alias (
  alias varchar(255) NOT NULL default '',
  dest longtext,
  username varchar(30) NOT NULL default '',
  status int(11) NOT NULL default '1',
  PRIMARY KEY  (alias)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `domain`
#

CREATE TABLE domain (
  domain_name varchar(255) NOT NULL default '',
  prefix varchar(30) NOT NULL default '',
  maxaccounts int(11) NOT NULL default '20',
  quota int(10) NOT NULL default '20000',
  PRIMARY KEY  (domain_name)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `domainadmin`
#

CREATE TABLE domainadmin (
  domain_name varchar(255) NOT NULL default '',
  adminuser varchar(255) NOT NULL default ''
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `ptr`
#

CREATE TABLE ptr (
  id int(10) unsigned NOT NULL auto_increment,
  ip int(10) unsigned NOT NULL default '0',
  name char(255) NOT NULL default '',
  ttl int(10) unsigned NOT NULL default '86400',
  PRIMARY KEY  (id),
  UNIQUE KEY ip (ip)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `rr`
#

CREATE TABLE rr (
  id int(10) unsigned NOT NULL auto_increment,
  zone int(10) unsigned NOT NULL default '0',
  name char(63) NOT NULL default '',
  type enum('A','AAAA','CNAME','MX','NS','TXT') default NULL,
  data char(255) NOT NULL default '',
  aux int(10) unsigned NOT NULL default '0',
  ttl int(10) unsigned NOT NULL default '86400',
  PRIMARY KEY  (id),
  UNIQUE KEY rr (zone,name,type,data)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `search`
#

CREATE TABLE search (
  search_id varchar(255) NOT NULL default '',
  search_sql text NOT NULL,
  perpage int(11) NOT NULL default '0',
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (search_id),
  KEY search_id (search_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `soa`
#

CREATE TABLE soa (
  id int(10) unsigned NOT NULL auto_increment,
  origin char(78) NOT NULL default '',
  ns char(255) NOT NULL default '',
  mbox char(255) NOT NULL default '',
  serial int(10) unsigned NOT NULL default '1',
  refresh int(10) unsigned NOT NULL default '28800',
  retry int(10) unsigned NOT NULL default '7200',
  expire int(10) unsigned NOT NULL default '604800',
  minimum int(10) unsigned NOT NULL default '86400',
  ttl int(10) unsigned NOT NULL default '86400',
  PRIMARY KEY  (id),
  UNIQUE KEY origin (origin)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `users`
#

CREATE TABLE users (
  User varchar(64) NOT NULL default '',
  Password varchar(64) NOT NULL default '',
  Uid int(11) NOT NULL default '-1',
  Gid int(11) NOT NULL default '-1',
  Dir varchar(128) NOT NULL default '',
  PRIMARY KEY  (User),
  UNIQUE KEY User (User)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `virtual`
#

CREATE TABLE virtual (
  alias varchar(255) NOT NULL default '',
  dest longtext,
  username varchar(30) NOT NULL default '',
  status int(11) NOT NULL default '1',
  PRIMARY KEY  (alias),
  UNIQUE KEY alias (alias)
) TYPE=MyISAM;