# 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 "adapters", :force => true do |t|
    t.column "db1_name", :string
    t.column "db1_username", :string
    t.column "db1_password", :string
    t.column "db1_host", :string
    t.column "db2_name", :string
    t.column "db2_username", :string
    t.column "db2_password", :string
    t.column "db2_host", :string
    t.column "type", :string
  end

  create_table "adapters_test_runs", :id => false, :force => true do |t|
    t.column "adapter_id", :integer
    t.column "test_run_id", :integer
  end

  create_table "attachments", :force => true do |t|
    t.column "db_file_id", :integer
    t.column "parent_id", :integer
    t.column "filename", :string
    t.column "content_type", :string
    t.column "size", :integer
    t.column "width", :integer
    t.column "height", :integer
    t.column "patch_id", :integer
  end

  create_table "db_files", :force => true do |t|
    t.column "data", :binary
  end

  create_table "patches", :force => true do |t|
    t.column "name", :string
    t.column "description", :text
    t.column "created_at", :datetime
    t.column "updated_at", :datetime
  end

  create_table "test_runs", :force => true do |t|
    t.column "patch_id", :integer
    t.column "revision", :integer
    t.column "email", :string
    t.column "done", :boolean, :default => false
  end

end