# 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 => 41) do

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

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

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

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

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

  add_index "changes", ["changeset_id"], :name => "changes_changeset_id_index"

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

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

  create_table "components", :force => true do |t|
    t.column "name",       :string,  :limit => 50
    t.column "project_id", :integer
  end

  add_index "components", ["project_id"], :name => "components_project_id_index"

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

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

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

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

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

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

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

  add_index "milestones", ["project_id"], :name => "milestones_project_id_index"

  create_table "priorities", :force => true do |t|
    t.column "position", :integer
    t.column "name",     :string,  :limit => 50
  end

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

  add_index "projects", ["short_name"], :name => "projects_short_name_index"
  add_index "projects", ["repository_id"], :name => "projects_repository_id_index"

  create_table "releases", :force => true do |t|
    t.column "name",       :string,  :limit => 25
    t.column "project_id", :integer
  end

  add_index "releases", ["project_id"], :name => "releases_project_id_index"

  create_table "repositories", :force => true do |t|
    t.column "name", :string
    t.column "path", :string
  end

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

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

  create_table "status", :force => true do |t|
    t.column "name", :string, :limit => 25
  end

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

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

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

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

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

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

  add_index "ticket_changes", ["ticket_id"], :name => "ticket_changes_ticket_id_index"

  create_table "ticket_reports", :force => true do |t|
    t.column "time_interval",  :integer
    t.column "name",           :string,  :limit => 100
    t.column "position",       :integer,                :default => 2147483647, :null => false
    t.column "filter_options", :text
    t.column "project_id",     :integer
  end

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

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

  add_index "tickets", ["milestone_id"], :name => "tickets_milestone_id_index"
  add_index "tickets", ["component_id"], :name => "tickets_component_id_index"
  add_index "tickets", ["priority_id"], :name => "tickets_priority_id_index"
  add_index "tickets", ["release_id"], :name => "tickets_release_id_index"
  add_index "tickets", ["status_id"], :name => "tickets_status_id_index"
  add_index "tickets", ["project_id"], :name => "tickets_project_id_index"
  add_index "tickets", ["assigned_user_id"], :name => "tickets_assigned_user_id_index"

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

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

  add_index "wiki_pages", ["title"], :name => "wiki_pages_title_index"
  add_index "wiki_pages", ["project_id"], :name => "wiki_pages_project_id_index"

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

  add_index "wiki_versions", ["project_id"], :name => "wiki_versions_project_id_index"
  add_index "wiki_versions", ["wiki_page_id"], :name => "wiki_versions_wiki_page_id_index"
  add_index "wiki_versions", ["user_id"], :name => "wiki_versions_user_id_index"

end