# This file is auto-generated from the current state of the database. Instead of editing this file, 
# please use the migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your database schema. If you need
# to create the application database on another system, you should be using db:schema:load, not running
# all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended to check this file into your version control system.

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

  create_table "attachments", :force => true do |t|
    t.string  "original_filename", :default => "", :null => false
    t.string  "content_type",      :default => "", :null => false
    t.string  "attachable_type",   :default => "", :null => false
    t.integer "attachable_id",     :default => 0,  :null => false
  end

  add_index "attachments", ["attachable_type", "attachable_id"], :name => "i_att_on_type_and_id"

  create_table "blog_comments", :force => true do |t|
    t.integer  "blog_post_id"
    t.string   "author"
    t.string   "email"
    t.text     "content"
    t.datetime "created_at"
    t.boolean  "approved",     :default => false, :null => false
    t.boolean  "spam",         :default => false, :null => false
  end

  add_index "blog_comments", ["blog_post_id"], :name => "i_bposts_on_bpost_id"

  create_table "blog_posts", :force => true do |t|
    t.string   "title"
    t.text     "content"
    t.integer  "user_id"
    t.integer  "project_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "blog_comments_count"
  end

  add_index "blog_posts", ["user_id"], :name => "i_bposts_on_user_id"
  add_index "blog_posts", ["project_id"], :name => "i_bposts_on_project_id"

  create_table "changes", :force => true do |t|
    t.integer "changeset_id"
    t.integer "revision",                     :default => 0,  :null => false
    t.string  "name",          :limit => 2,   :default => "", :null => false
    t.string  "path",          :limit => 256, :default => ""
    t.string  "from_path",     :limit => 256
    t.integer "from_revision"
    t.integer "repository_id"
  end

  add_index "changes", ["changeset_id"], :name => "i_changes_on_changeset"
  add_index "changes", ["repository_id"], :name => "i_changes_on_repository_id"

  create_table "changesets", :force => true do |t|
    t.string   "revision",      :limit => 40
    t.string   "author",        :limit => 50
    t.text     "log"
    t.datetime "created_at"
    t.datetime "revised_at"
    t.integer  "repository_id",               :default => 0, :null => false
  end

  add_index "changesets", ["repository_id"], :name => "i_cs_on_repository_id"

  create_table "factory_hashcashes", :force => true do |t|
    t.string   "key"
    t.string   "salt"
    t.string   "result"
    t.datetime "created_at"
  end

  create_table "groups", :force => true do |t|
    t.string  "name",                   :limit => 40
    t.text    "permissions"
    t.boolean "access_to_all_projects",               :default => false, :null => false
  end

  create_table "groups_projects", :id => false, :force => true do |t|
    t.integer "group_id"
    t.integer "project_id"
  end

  add_index "groups_projects", ["group_id", "project_id"], :name => "i_gp_on_group_and_project"

  create_table "groups_users", :id => false, :force => true do |t|
    t.integer "group_id"
    t.integer "user_id"
  end

  add_index "groups_users", ["group_id", "user_id"], :name => "i_gu_on_group_and_user"

  create_table "milestones", :force => true do |t|
    t.string   "name",        :limit => 75
    t.text     "info"
    t.date     "due"
    t.datetime "created_at"
    t.integer  "project_id"
    t.date     "finished_on"
    t.integer  "rank",        :limit => 4,  :default => 9999
  end

  add_index "milestones", ["project_id"], :name => "i_mst_on_project_id"
  add_index "milestones", ["rank"], :name => "i_mst_on_rank"

  create_table "priorities", :force => true do |t|
    t.string  "name",          :limit => 50
    t.integer "rank",          :limit => 4,  :default => 9999
    t.boolean "default_value",               :default => false, :null => false
  end

  add_index "priorities", ["rank"], :name => "i_prt_on_rank"

  create_table "projects", :force => true do |t|
    t.string  "name"
    t.text    "info"
    t.string  "short_name"
    t.boolean "closed",                                   :default => false
    t.integer "repository_id"
    t.string  "root_path",                 :limit => 256, :default => ""
    t.text    "existing_wiki_page_titles"
    t.text    "disabled_modules"
    t.text    "existing_tickets"
    t.text    "existing_revisions"
    t.string  "locale",                    :limit => 12
  end

  add_index "projects", ["short_name"], :name => "i_projects_on_short_name"
  add_index "projects", ["repository_id"], :name => "i_projects_on_repository_id"

  create_table "queued_mails", :force => true do |t|
    t.text   "object"
    t.string "mailer_class_name"
  end

  create_table "repositories", :force => true do |t|
    t.string  "name"
    t.string  "path"
    t.boolean "use_svnsync",                :default => false, :null => false
    t.string  "svnsync_args", :limit => 80
    t.string  "type",         :limit => 40
  end

  add_index "repositories", ["type"], :name => "i_repositories_on_type"

  create_table "sessions", :force => true do |t|
    t.string   "session_id"
    t.text     "data"
    t.datetime "updated_at"
  end

  add_index "sessions", ["session_id"], :name => "i_sessions_on_session_id"

  create_table "statuses", :force => true do |t|
    t.string  "name",          :limit => 25
    t.integer "rank",          :limit => 4,  :default => 9999
    t.boolean "default_value",               :default => false, :null => false
    t.integer "state_id",      :limit => 1
  end

  add_index "statuses", ["rank"], :name => "i_status_on_rank"

  create_table "taggings", :force => true do |t|
    t.integer "tag_id"
    t.integer "taggable_id"
    t.string  "taggable_type"
  end

  add_index "taggings", ["tag_id", "taggable_id", "taggable_type"], :name => "i_taggings_on_references"

  create_table "tags", :force => true do |t|
    t.string "name"
  end

  add_index "tags", ["name"], :name => "i_tags_on_name"

  create_table "tans", :force => true do |t|
    t.string   "value"
    t.datetime "expires_at"
  end

  create_table "ticket_changes", :force => true do |t|
    t.integer  "ticket_id"
    t.string   "author",     :limit => 75
    t.text     "content"
    t.datetime "created_at"
    t.text     "changes"
    t.boolean  "approved",                 :default => false, :null => false
    t.boolean  "spam",                     :default => false, :null => false
    t.string   "email",      :limit => 75
    t.integer  "user_id"
  end

  add_index "ticket_changes", ["ticket_id"], :name => "i_tchanges_on_ticket_id"
  add_index "ticket_changes", ["created_at"], :name => "i_tchanges_on_created_at"

  create_table "ticket_properties", :force => true do |t|
    t.string  "name",                    :limit => 40
    t.integer "rank",                    :limit => 4
    t.integer "ticket_property_type_id"
  end

  add_index "ticket_properties", ["rank"], :name => "i_tprops_on_rank"
  add_index "ticket_properties", ["ticket_property_type_id"], :name => "i_t_props_on_tptype_id"

  create_table "ticket_properties_tickets", :id => false, :force => true do |t|
    t.integer "ticket_id"
    t.integer "ticket_property_id"
  end

  add_index "ticket_properties_tickets", ["ticket_id", "ticket_property_id"], :name => "ui_tprops_on_tickets", :unique => true

  create_table "ticket_property_types", :force => true do |t|
    t.string  "name",       :limit => 20
    t.integer "project_id"
    t.integer "rank",                     :default => 9999
  end

  add_index "ticket_property_types", ["project_id"], :name => "i_tptypes_on_project_id"
  add_index "ticket_property_types", ["rank"], :name => "i_prop_types_on_rank"

  create_table "ticket_reports", :force => true do |t|
    t.string  "name",           :limit => 100
    t.integer "rank",           :limit => 4,   :default => 9999
    t.text    "filter_options"
    t.integer "time_interval"
    t.integer "project_id"
  end

  add_index "ticket_reports", ["project_id"], :name => "i_treports_on_project_id"

  create_table "ticket_subscribers", :id => false, :force => true do |t|
    t.integer "ticket_id"
    t.integer "user_id"
  end

  add_index "ticket_subscribers", ["ticket_id"], :name => "i_tsubscribers_on_ticket_id"
  add_index "ticket_subscribers", ["user_id"], :name => "i_tsubscribers_on_user_id"

  create_table "tickets", :force => true do |t|
    t.integer  "milestone_id"
    t.integer  "priority_id"
    t.integer  "status_id"
    t.string   "author",           :limit => 75
    t.string   "summary"
    t.text     "content"
    t.string   "author_host",      :limit => 100
    t.datetime "created_at"
    t.integer  "project_id"
    t.integer  "assigned_user_id"
    t.boolean  "approved",                        :default => false, :null => false
    t.boolean  "spam",                            :default => false, :null => false
    t.string   "email",            :limit => 75
    t.datetime "updated_at"
    t.integer  "user_id"
  end

  add_index "tickets", ["milestone_id"], :name => "i_tickets_on_milestone_id"
  add_index "tickets", ["priority_id"], :name => "i_tickets_on_priority_id"
  add_index "tickets", ["status_id"], :name => "i_tickets_on_status_id"
  add_index "tickets", ["project_id"], :name => "i_tickets_on_project_id"
  add_index "tickets", ["assigned_user_id"], :name => "i_tickets_on_auser_id"
  add_index "tickets", ["user_id"], :name => "i_tickets_on_user_id"

  create_table "users", :force => true do |t|
    t.string   "login",           :limit => 80
    t.string   "password",        :limit => 40
    t.datetime "created_at"
    t.boolean  "admin",                         :default => false, :null => false
    t.string   "name",            :limit => 80
    t.string   "email",           :limit => 80
    t.string   "salt",            :limit => 8
    t.boolean  "active",                        :default => true,  :null => false
    t.string   "activation_code"
    t.string   "private_key",     :limit => 72
  end

  add_index "users", ["private_key"], :name => "i_users_on_private_key"
  add_index "users", ["login"], :name => "i_users_on_login"

  create_table "wiki_pages", :force => true do |t|
    t.string   "title"
    t.integer  "project_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "wiki_pages", ["title"], :name => "i_wiki_pages_on_title"
  add_index "wiki_pages", ["project_id"], :name => "i_wiki_pages_on_project_id"

  create_table "wiki_versions", :force => true do |t|
    t.integer  "project_id"
    t.integer  "wiki_page_id"
    t.string   "author"
    t.integer  "user_id"
    t.datetime "created_at"
    t.text     "content"
  end

  add_index "wiki_versions", ["project_id"], :name => "i_wversions_on_project_id"
  add_index "wiki_versions", ["wiki_page_id"], :name => "i_wversions_on_wpage_id"
  add_index "wiki_versions", ["user_id"], :name => "i_wversions_on_user_id"

end