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

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

  add_index "features", ["name"], :name => "features_name_index", :unique => true

  create_table "monkey_features", :force => true do |t|
    t.column "monkey_id", :integer, :default => 0, :null => false
    t.column "feature_id", :integer, :default => 0, :null => false
    t.column "feature_value", :string, :default => "", :null => false
  end

  add_index "monkey_features", ["monkey_id", "feature_id"], :name => "monkey_features_monkey_id_index", :unique => true

  create_table "monkeys", :force => true do |t|
    t.column "name", :string, :default => "", :null => false
    t.column "species_id", :integer, :default => 0, :null => false
  end

  add_index "monkeys", ["name", "species_id"], :name => "monkeys_name_index", :unique => true

  create_table "species", :force => true do |t|
    t.column "common_name", :string, :default => "", :null => false
    t.column "latin_name", :string, :default => "", :null => false
  end

  add_index "species", ["common_name"], :name => "species_common_name_index", :unique => true
  add_index "species", ["latin_name"], :name => "species_latin_name_index", :unique => true

end