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

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

  create_table "cached_feeds", :force => true do |t|
    t.column "href", :string
    t.column "title", :string
    t.column "link", :string
    t.column "feed_data", :text
    t.column "feed_data_type", :string
    t.column "http_headers", :text
    t.column "last_retrieved", :datetime
  end

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

  create_table "categories_items", :id => false, :force => true do |t|
    t.column "item_id", :integer
    t.column "category_id", :integer
  end

  add_index "categories_items", ["item_id"], :name => "item_id"
  add_index "categories_items", ["category_id"], :name => "category_id"

  create_table "feeds", :force => true do |t|
    t.column "authority_id", :integer, :default => 0, :null => false
    t.column "error_tag", :integer, :default => 0, :null => false
    t.column "link", :string
    t.column "title", :string
    t.column "description", :text
    t.column "pubDate", :datetime
    t.column "language", :string
    t.column "site_url", :string, :default => "", :null => false
    t.column "guid", :string
  end

  create_table "items", :force => true do |t|
    t.column "feed_id", :integer, :default => 0, :null => false
    t.column "title", :string
    t.column "link", :string
    t.column "pubDate", :datetime
    t.column "comments", :string
    t.column "author", :string
    t.column "commentRss", :string
    t.column "description", :text
    t.column "expired", :integer
  end

  add_index "items", ["feed_id"], :name => "feed_id"

  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"

end