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

  create_table "info_requests", :force => true do |t|
    t.column "title",   :text
    t.column "user_id", :integer
  end

  create_table "public_bodies", :force => true do |t|
    t.column "name",            :text
    t.column "short_name",      :text
    t.column "request_email",   :text
    t.column "complaint_email", :text
    t.column "version",         :integer
  end

  create_table "public_body_versions", :force => true do |t|
    t.column "public_body_id",  :integer
    t.column "version",         :integer
    t.column "name",            :text
    t.column "short_name",      :text
    t.column "request_email",   :text
    t.column "complaint_email", :text
    t.column "updated_at",      :datetime
  end

  create_table "sessions", :force => true do |t|
    t.column "session_id", :string
    t.column "data",       :text
    t.column "updated_at", :datetime
  end

  add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
  add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"

  create_table "users", :force => true do |t|
    t.column "email",           :string
    t.column "name",            :string
    t.column "hashed_password", :string
    t.column "salt",            :string
  end

end