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

  create_table "auction_items", :force => true do |t|
    t.column "auction_id", :integer, :default => 0, :null => false
    t.column "position", :integer, :default => 0, :null => false
    t.column "name", :string, :limit => 200
    t.column "description", :text
  end

  add_index "auction_items", ["auction_id"], :name => "auction_id"
  add_index "auction_items", ["id"], :name => "id"

  create_table "auctions", :force => true do |t|
    t.column "name", :string, :limit => 200
    t.column "datetime", :datetime
    t.column "location", :string, :limit => 200
    t.column "description", :text
    t.column "online_url", :string
  end

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

  create_table "images", :force => true do |t|
    t.column "name", :string
    t.column "description", :text
    t.column "image", :text
    t.column "auction_item_id", :integer
    t.column "item_id", :integer
    t.column "position", :integer
  end

  create_table "items", :force => true do |t|
    t.column "name", :string, :limit => 200
    t.column "description", :text
    t.column "category_id", :integer
    t.column "position", :integer
  end

  create_table "photos", :force => true do |t|
    t.column "title", :string, :limit => 200
    t.column "description", :text
    t.column "image", :binary
    t.column "thumb", :binary
    t.column "auction_item_id", :integer
    t.column "position", :integer
  end

end