# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.

ActiveRecord::Schema.define(:version => 26) do

  create_table "addresses", :force => true do |t|
    t.column "address", :text
    t.column "active", :boolean, :default => true
    t.column "delivery_attempts", :integer, :default => 0
    t.column "bounces", :integer, :default => 0
  end

  create_table "addresses_mailinglists", :id => false, :force => true do |t|
    t.column "address_id", :integer
    t.column "mailinglist_id", :integer
  end

  create_table "admin_messages", :force => true do |t|
    t.column "message", :text, :null => false
  end

  create_table "confirmationcodes", :force => true do |t|
    t.column "mailinglist_id", :integer
    t.column "address_id", :integer
    t.column "code", :text, :null => false
    t.column "confirmed", :boolean, :default => false
  end

  create_table "domains", :force => true do |t|
    t.column "name", :string, :null => false
    t.column "password", :text, :null => false
  end

  create_table "mailinglist_classes", :force => true do |t|
    t.column "name", :text, :null => false
    t.column "description", :text
    t.column "public", :boolean, :default => false, :null => false
    t.column "closed", :boolean, :default => false, :null => false
    t.column "moderated", :boolean, :default => false, :null => false
    t.column "confirmation", :boolean, :default => true, :null => false
    t.column "joinable", :boolean, :default => true, :null => false
    t.column "archived", :boolean, :default => false, :null => false
    t.column "proxify", :boolean, :default => false
  end

  create_table "mailinglists", :force => true do |t|
    t.column "user_id", :integer
    t.column "name", :text, :null => false
    t.column "description", :text
    t.column "welcome_admin_message_id", :integer, :default => 1
    t.column "confirmed_admin_message_id", :integer, :default => 2
    t.column "sayonara_admin_message_id", :integer, :default => 3
    t.column "mailinglist_class_id", :integer
  end

  create_table "messages", :force => true do |t|
    t.column "mailinglist_id", :integer
    t.column "address_id", :integer
    t.column "parent_id", :integer
    t.column "subject", :string
    t.column "messageid", :string
    t.column "timestamp", :datetime
    t.column "headers", :text
    t.column "body", :text
    t.column "envelope_from", :text
    t.column "envelope_to", :text
  end

  create_table "proxy_links", :force => true do |t|
    t.column "mailinglist_id", :integer, :null => false
    t.column "address_id", :integer, :null => false
  end

  create_table "sys_configs", :force => true do |t|
    t.column "name", :string
    t.column "value", :string
    t.column "description", :string
    t.column "priority", :integer
  end

  create_table "users", :force => true do |t|
    t.column "login", :text, :null => false
    t.column "password", :text, :null => false
    t.column "mailinglist_id", :integer
    t.column "domainadmin", :boolean, :default => false
    t.column "domain_id", :integer
    t.column "mailinglistadmin", :boolean, :default => false
    t.column "virtual", :boolean, :default => false
  end

end