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

  create_table "addresses", :force => true do |t|
    t.integer "user_id",                         :null => false
    t.string  "name"
    t.string  "line_1",          :default => "", :null => false
    t.string  "line_2"
    t.string  "city",            :default => "", :null => false
    t.integer "state_id",                        :null => false
    t.string  "province_region"
    t.string  "zip_postal_code"
    t.integer "country_id",                      :null => false
    t.float   "lat"
    t.float   "long"
  end

  create_table "bow_wows", :force => true do |t|
    t.string   "name"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "cats", :force => true do |t|
    t.string   "name"
    t.string   "cat_type"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "citations", :force => true do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "citations_items", :force => true do |t|
    t.integer  "citation_id",                 :null => false
    t.integer  "item_id",                     :null => false
    t.string   "item_type",   :default => "", :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "eaters_foodstuffs", :force => true do |t|
    t.integer  "foodstuff_id"
    t.integer  "eater_id"
    t.integer  "some_attribute", :default => 0
    t.string   "eater_type"
    t.datetime "created_at",                    :null => false
    t.datetime "updated_at",                    :null => false
  end

  create_table "fish", :force => true do |t|
    t.string   "name"
    t.integer  "speed"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "frogs", :force => true do |t|
    t.string   "name"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "keep_your_enemies_close", :force => true do |t|
    t.integer  "enemy_id"
    t.string   "enemy_type"
    t.integer  "protector_id"
    t.string   "protector_type"
    t.datetime "created_at",     :null => false
    t.datetime "updated_at",     :null => false
  end

  create_table "little_whale_pupils", :force => true do |t|
    t.integer  "whale_id"
    t.integer  "aquatic_pupil_id"
    t.string   "aquatic_pupil_type"
    t.datetime "created_at",         :null => false
    t.datetime "updated_at",         :null => false
  end

  create_table "parentships", :force => true do |t|
    t.integer  "parent_id"
    t.string   "child_type"
    t.integer  "kid_id"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "people", :force => true do |t|
    t.string   "name"
    t.integer  "age"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "petfoods", :id => false, :force => true do |t|
    t.integer  "the_petfood_primary_key", :null => false
    t.string   "name"
    t.datetime "created_at",              :null => false
    t.datetime "updated_at",              :null => false
  end

  create_table "sellers", :force => true do |t|
    t.integer  "user_id",                         :null => false
    t.string   "company_name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.float    "capitalization", :default => 0.0
  end

  create_table "states", :force => true do |t|
    t.string "name",         :default => "", :null => false
    t.string "abbreviation", :default => "", :null => false
  end

  create_table "users", :force => true do |t|
    t.string   "login",            :limit => 64, :default => "",    :null => false
    t.string   "email",                          :default => "",    :null => false
    t.string   "crypted_password", :limit => 64, :default => "",    :null => false
    t.string   "salt",             :limit => 64, :default => "",    :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "deleted",                        :default => false
  end

  create_table "whales", :force => true do |t|
    t.string   "name"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "wild_boars", :force => true do |t|
    t.string   "name"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

end