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

  create_table "authors", :force => true do |t|
    t.column "name", :string
    t.column "ip", :string
    t.column "book_id", :integer
  end

  create_table "books", :force => true do |t|
    t.column "name", :string
    t.column "url_name", :string
    t.column "existing_page_titles", :text
    t.column "premiere", :boolean, :default => false
  end

  create_table "pages", :force => true do |t|
    t.column "title", :string
    t.column "book_id", :integer
    t.column "created_at", :datetime
    t.column "updated_at", :datetime
  end

  create_table "versions", :force => true do |t|
    t.column "page_id", :integer
    t.column "author_id", :integer
    t.column "created_at", :datetime
    t.column "body", :text
    t.column "book_id", :integer
  end

end