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

  create_table "assets", :force => true do |t|
    t.column "project_id", :integer
    t.column "path",       :string
    t.column "caption",    :string
    t.column "type",       :string,   :limit => 40
    t.column "is_visible", :boolean,                :default => true
    t.column "created_at", :datetime
    t.column "updated_at", :datetime
    t.column "position",   :integer
  end

  create_table "projects", :force => true do |t|
    t.column "user_id",     :integer
    t.column "name",        :string
    t.column "is_visible",  :boolean,  :default => true
    t.column "created_at",  :datetime
    t.column "updated_at",  :datetime
    t.column "position",    :integer
    t.column "description", :text
  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 => "sessions_session_id_index"

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

  create_table "tags_assets", :id => false, :force => true do |t|
    t.column "tag_id",   :integer
    t.column "asset_id", :integer
  end

  create_table "tags_projects", :id => false, :force => true do |t|
    t.column "tag_id",     :integer
    t.column "project_id", :integer
  end

  create_table "users", :force => true do |t|
    t.column "name",             :string,   :limit => 100
    t.column "company",          :string,   :limit => 100
    t.column "website",          :string
    t.column "login",            :string,   :limit => 40
    t.column "email",            :string,   :limit => 100
    t.column "crypted_password", :string,   :limit => 40
    t.column "salt",             :string,   :limit => 40
    t.column "created_at",       :datetime
    t.column "updated_at",       :datetime
    t.column "description",      :text
  end

end