-- 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" serial primary key,
  "address" text,
  "active" boolean DEFAULT 't',
  "delivery_attempts" integer DEFAULT 0,
  "bounces" integer DEFAULT 0
);

CREATE TABLE addresses_mailinglists (
  "address_id" integer,
  "mailinglist_id" integer
);

CREATE TABLE admin_messages (
  "id" serial primary key,
  "message" text NOT NULL
);

CREATE TABLE confirmationcodes (
  "id" serial primary key,
  "mailinglist_id" integer,
  "address_id" integer,
  "code" text NOT NULL,
  "confirmed" boolean DEFAULT 'f'
);

CREATE TABLE domains (
  "id" serial primary key,
  "name" character varying(255) NOT NULL,
  "password" text NOT NULL
);

CREATE TABLE mailinglist_classes (
  "id" serial primary key,
  "name" text NOT NULL,
  "description" text,
  "public" boolean DEFAULT 'f' NOT NULL,
  "closed" boolean DEFAULT 'f' NOT NULL,
  "moderated" boolean DEFAULT 'f' NOT NULL,
  "confirmation" boolean DEFAULT 't' NOT NULL,
  "joinable" boolean DEFAULT 't' NOT NULL,
  "archived" boolean DEFAULT 'f',
  "proxify" boolean DEFAULT 'f'
);

CREATE TABLE mailinglists (
  "id" serial primary key,
  "user_id" integer,
  "name" text NOT NULL,
  "description" text,
  "welcome_admin_message_id" integer DEFAULT 1,
  "confirmed_admin_message_id" integer DEFAULT 2,
  "sayonara_admin_message_id" integer DEFAULT 3,
  "mailinglist_class_id" integer
);

CREATE TABLE messages (
  "id" serial primary key,
  "mailinglist_id" integer,
  "address_id" integer,
  "parent_id" integer,
  "subject" character varying(255),
  "messageid" character varying(255),
  "timestamp" timestamp,
  "headers" text,
  "body" text,
  "envelope_from" text,
  "envelope_to" text
);

CREATE TABLE proxy_links (
  "id" serial primary key,
  "mailinglist_id" integer NOT NULL,
  "address_id" integer NOT NULL
);

CREATE TABLE users (
  "id" serial primary key,
  "login" text NOT NULL,
  "password" text NOT NULL,
  "mailinglist_id" integer,
  "domainadmin" boolean DEFAULT 'f',
  "domain_id" integer,
  "mailinglistadmin" boolean DEFAULT 'f',
  "virtual" boolean DEFAULT 'f'
);


-- schema version meta-info 

CREATE TABLE schema_info (
  "version" integer
);

insert into schema_info (version) values (25);