-- MySQL dump 9.07
--
-- Host: localhost    Database: nospam
---------------------------------------------------------
-- Server version	4.0.12

--
-- Table structure for table 'dotqmail'
--

CREATE TABLE dotqmail (
  id int(11) NOT NULL auto_increment,
  username varchar(50) NOT NULL default '',
  filename varchar(150) NOT NULL default '',
  lastprefchange bigint(20) NOT NULL default '0',
  md5sum varchar(36) NOT NULL default '',
  version float(6,5) NOT NULL default '1.00000',
  active enum('0','1') NOT NULL default '0',
  error enum('0','1') NOT NULL default '0',
  history text NOT NULL,
  ts timestamp(14) NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY username (username)
) TYPE=MyISAM;

--
-- Table structure for table 'userpref'
--

CREATE TABLE userpref (
  username varchar(50) NOT NULL default '',
  preference varchar(30) NOT NULL default '',
  value varchar(100) NOT NULL default '',
  id int(11) NOT NULL auto_increment,
  ts timestamp(14) NOT NULL,
  PRIMARY KEY  (id),
  KEY username (username)
) TYPE=MyISAM;