voormedia/rails-erd

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

  create_table "dependencies", :force => true do |t|
    t.string   "requirements"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "rubygem_id"
    t.integer  "version_id"
    t.string   "scope"
  end

  add_index "dependencies", ["rubygem_id"], :name => "index_dependencies_on_rubygem_id"
  add_index "dependencies", ["version_id"], :name => "index_dependencies_on_version_id"

  create_table "downloads", :force => true do |t|
    t.integer  "version_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "downloads", ["version_id"], :name => "index_downloads_on_version_id"

  create_table "linksets", :force => true do |t|
    t.integer  "rubygem_id"
    t.string   "home"
    t.string   "wiki"
    t.string   "docs"
    t.string   "mail"
    t.string   "code"
    t.string   "bugs"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "linksets", ["rubygem_id"], :name => "index_linksets_on_rubygem_id"

  create_table "ownerships", :force => true do |t|
    t.integer  "rubygem_id"
    t.integer  "user_id"
    t.string   "token"
    t.boolean  "approved",   :default => false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "ownerships", ["rubygem_id"], :name => "index_ownerships_on_rubygem_id"
  add_index "ownerships", ["user_id"], :name => "index_ownerships_on_user_id"

  create_table "rubyforgers", :force => true do |t|
    t.string "email"
    t.string "encrypted_password", :limit => 40
  end

  create_table "rubygems", :force => true do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "downloads",  :default => 0
    t.string   "slug"
  end

  add_index "rubygems", ["name"], :name => "index_rubygems_on_name"

  create_table "subscriptions", :force => true do |t|
    t.integer  "rubygem_id"
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "subscriptions", ["rubygem_id"], :name => "index_subscriptions_on_rubygem_id"
  add_index "subscriptions", ["user_id"], :name => "index_subscriptions_on_user_id"

  create_table "users", :force => true do |t|
    t.string   "email"
    t.string   "encrypted_password", :limit => 128
    t.string   "salt",               :limit => 128
    t.string   "token",              :limit => 128
    t.datetime "token_expires_at"
    t.boolean  "email_confirmed",                   :default => false, :null => false
    t.string   "api_key"
    t.string   "confirmation_token", :limit => 128
    t.string   "remember_token",     :limit => 128
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "email_reset"
    t.string   "handle"
  end

  add_index "users", ["email"], :name => "index_users_on_email"
  add_index "users", ["handle"], :name => "index_users_on_handle"
  add_index "users", ["id", "confirmation_token"], :name => "index_users_on_id_and_confirmation_token"
  add_index "users", ["id", "token"], :name => "index_users_on_id_and_token"
  add_index "users", ["remember_token"], :name => "index_users_on_remember_token"
  add_index "users", ["token"], :name => "index_users_on_token"

  create_table "versions", :force => true do |t|
    t.text     "authors"
    t.text     "description"
    t.string   "number"
    t.integer  "rubygem_id"
    t.datetime "built_at"
    t.datetime "updated_at"
    t.string   "rubyforge_project"
    t.text     "summary"
    t.string   "platform"
    t.datetime "created_at"
    t.boolean  "indexed",           :default => true
    t.boolean  "prerelease"
    t.integer  "position"
    t.integer  "downloads_count",   :default => 0
    t.boolean  "latest"
    t.string   "full_name"
  end

  add_index "versions", ["built_at"], :name => "index_versions_on_built_at"
  add_index "versions", ["created_at"], :name => "index_versions_on_created_at"
  add_index "versions", ["full_name"], :name => "index_versions_on_full_name"
  add_index "versions", ["indexed"], :name => "index_versions_on_indexed"
  add_index "versions", ["number"], :name => "index_versions_on_number"
  add_index "versions", ["position"], :name => "index_versions_on_position"
  add_index "versions", ["prerelease"], :name => "index_versions_on_prerelease"
  add_index "versions", ["rubygem_id"], :name => "index_versions_on_rubygem_id"

  create_table "web_hooks", :force => true do |t|
    t.integer  "user_id"
    t.string   "url"
    t.integer  "failure_count", :default => 0
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "rubygem_id"
  end

end