-- This file is autogenerated by the Rail schema generator, using
-- the schema defined in db/migration/*.rb
--
-- Do not edit this file.  Instead, add a new migration using
-- ./script/generate migration <name>, and then run
-- ./script/generate schema

-- tables 

CREATE TABLE addresses (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `address` text,
  `active` tinyint(1) DEFAULT 1,
  `delivery_attempts` int(11) DEFAULT 0,
  `bounces` int(11) DEFAULT 0
) ENGINE=InnoDB;

CREATE TABLE addresses_mailinglists (
  `address_id` int(11),
  `mailinglist_id` int(11)
) ENGINE=InnoDB;

CREATE TABLE admin_messages (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `message` text NOT NULL
) ENGINE=InnoDB;

CREATE TABLE confirmationcodes (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `mailinglist_id` int(11),
  `address_id` int(11),
  `code` text NOT NULL,
  `confirmed` tinyint(1) DEFAULT 0
) ENGINE=InnoDB;

CREATE TABLE domains (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `name` varchar(255) NOT NULL,
  `password` text NOT NULL
) ENGINE=InnoDB;

CREATE TABLE mailinglist_classes (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `name` text NOT NULL,
  `description` text,
  `public` tinyint(1) DEFAULT 0 NOT NULL,
  `closed` tinyint(1) DEFAULT 0 NOT NULL,
  `moderated` tinyint(1) DEFAULT 0 NOT NULL,
  `confirmation` tinyint(1) DEFAULT 1 NOT NULL,
  `joinable` tinyint(1) DEFAULT 1 NOT NULL,
  `archived` tinyint(1) DEFAULT 0,
  `proxify` tinyint(1) DEFAULT 0
) ENGINE=InnoDB;

CREATE TABLE mailinglists (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `user_id` int(11),
  `name` text NOT NULL,
  `description` text,
  `welcome_admin_message_id` int(11) DEFAULT 1,
  `confirmed_admin_message_id` int(11) DEFAULT 2,
  `sayonara_admin_message_id` int(11) DEFAULT 3,
  `mailinglist_class_id` int(11)
) ENGINE=InnoDB;

CREATE TABLE messages (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `mailinglist_id` int(11),
  `address_id` int(11),
  `parent_id` int(11),
  `subject` varchar(255),
  `messageid` varchar(255),
  `timestamp` datetime,
  `headers` text,
  `body` text,
  `envelope_from` text,
  `envelope_to` text
) ENGINE=InnoDB;

CREATE TABLE proxy_links (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `mailinglist_id` int(11) NOT NULL,
  `address_id` int(11) NOT NULL
) ENGINE=InnoDB;

CREATE TABLE users (
  `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
  `login` text NOT NULL,
  `password` text NOT NULL,
  `mailinglist_id` int(11),
  `domainadmin` tinyint(1) DEFAULT 0,
  `domain_id` int(11),
  `mailinglistadmin` tinyint(1) DEFAULT 0,
  `virtual` tinyint(1) DEFAULT 0
) ENGINE=InnoDB;


-- schema version meta-info 

CREATE TABLE schema_info (
  `version` int(11)
) ENGINE=InnoDB;

insert into schema_info (version) values (25);