#esec Table Creation SQL script for mysql.
#
#
#
# Table structure for table `defaults`
#

CREATE TABLE `defaults` (
  `message` text NOT NULL,
  `reply_blurb` text NOT NULL,
  `verified` text NOT NULL,
  `email_whitelists` text default NULL,
  `email_blacklists` text default NULL,
  `header_whitelists` text default NULL,
  `header_blacklists` text default NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `known_bouncers`
#

CREATE TABLE `known_bouncers` (
  `addr` varchar(255) NOT NULL,
  `time` int(4) unsigned NOT NULL,
  PRIMARY KEY (`time`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `challenges`
#

CREATE TABLE `challenges` (
  `qid` tinyint(1) unsigned NOT NULL auto_increment,
  `emailid` smallint(2) unsigned NOT NULL,
  `question` varchar(255) NOT NULL,
  `answer` varchar(255) NOT NULL,
  PRIMARY KEY (`qid`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `email_blacklists`
#

CREATE TABLE `email_blacklists` (
  `id` smallint(2) unsigned NOT NULL auto_increment,
  `addr` varchar(255) NOT NULL,
  `emailid` smallint(2) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `email_whitelists`
#

CREATE TABLE `email_whitelists` (
  `id` smallint(2) unsigned NOT NULL auto_increment,
  `addr` varchar(255) NOT NULL,
  `emailid` smallint(2) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `header_blacklists`
#

CREATE TABLE `header_blacklists` (
  `id` smallint(2) unsigned NOT NULL auto_increment,
  `field` varchar(255) NOT NULL,
  `emailid` smallint(2) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `header_whitelists`
#

CREATE TABLE `header_whitelists` (
  `id` smallint(2) unsigned NOT NULL auto_increment,
  `field` varchar(255) NOT NULL,
  `emailid` smallint(2) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `messages`
#

CREATE TABLE `messages` (
  `filename` varchar(255) NOT NULL,
  `sender` varchar(255) NOT NULL,
  `time` int(4) unsigned NOT NULL,
  `emailid` smallint(2) unsigned NOT NULL,
  `msgid` char(16) NOT NULL,
  PRIMARY KEY (`msgid`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `accounts`
#

CREATE TABLE `accounts` (
  `emailid` smallint(2) unsigned NOT NULL auto_increment,
  `email` varchar(255) NOT NULL,
  `crypt` char(13) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mode` tinyint(1) unsigned NOT NULL default '3',
  `message` text default NULL,
  `verified` text default NULL,
  `reply_blurb` text default NULL,
  `session_id` char(64) default NULL,
  PRIMARY KEY (`emailid`)
) TYPE=MyISAM;
# --------------------------------------------------------