ActiveRecord::Schema.define :version => 0 do
  create_table "taggings", :force => true do |t|
    t.integer  "tag_id",        :limit => 11
    t.integer  "taggable_id",   :limit => 11
    t.string   "taggable_type"
    t.string   "context"
    t.datetime "created_at"
    t.integer  "tagger_id",     :limit => 11
    t.string   "tagger_type"
  end

  add_index "taggings", ["tag_id"], :name => "index_taggings_on_tag_id"
  add_index "taggings", ["taggable_id", "taggable_type", "context"], :name => "index_taggings_on_taggable_id_and_taggable_type_and_context"

  create_table "tags", :force => true do |t|
    t.string "name"
  end
  
  create_table "alias_tags", :force => true, :id => false do |t|
    t.integer "tag_id"
    t.integer "alias_id" 
  end

  add_index "alias_tags", ["tag_id"]
  add_index "alias_tags", ["alias_id"]

  create_table :taggable_models, :force => true do |t|
    t.column :user_id, :integer
    t.column :name, :string
    t.column :type, :string
    t.column :foo,  :string
  end
  
  create_table :non_standard_id_taggable_models, :primary_key => "an_id", :force => true do |t|
    t.column :name, :string
    t.column :type, :string
  end
  
  create_table :untaggable_models, :force => true do |t|
    t.column :taggable_model_id, :integer
    t.column :name, :string
  end
  
  create_table :cached_models, :force => true do |t|
    t.column :name, :string
    t.column :type, :string
    t.column :cached_tag_list, :string
  end
  
  create_table :other_cached_models, :force => true do |t|
    t.column :name, :string
    t.column :type, :string
    t.column :cached_language_list, :string    
    t.column :cached_status_list, :string
    t.column :cached_glass_list, :string
  end
  
  create_table :users, :force => true do |t|
    t.column :name, :string
  end
  
  create_table :other_taggable_models, :force => true do |t|
    t.column :name, :string
    t.column :type, :string
  end
end
