Indexes for a db

20130214112353_add_indexes_to_tables_1.rb

class AddIndexesToTables1 < ActiveRecord::Migration
  def change
  add_index(:adverts, :category_id)
	add_index(:adverts, :profile_id)
	add_index(:adverts, :video_id)
	add_index(:adverts, :active)

	add_index(:advert_area_mappings, :advert_id)
	add_index(:advert_area_mappings, :area_id)

	add_index(:archives, :profile_id)
	add_index(:archives, :archivable_id)
	add_index(:archives, :archivable_type)

	add_index(:areas, :position)
	add_index(:areas, :name)
	add_index(:areas, :active)

	add_index(:categories, :name)
	add_index(:categories, :position)
	add_index(:categories, :page_id)
	
	add_index(:emails, :email)
	
	add_index(:menus, :name)
	
	add_index(:messages, :sender_id)
	add_index(:messages, :receiver_id)
	add_index(:messages, :sent)
	add_index(:messages, :title)
	add_index(:messages, :status)
	add_index(:messages, :delete_sender)
	add_index(:messages, :delete_receiver)

	add_index(:pages, :name)
	add_index(:pages, :title)
	add_index(:pages, :permalink)

	add_index(:profiles, :area_id)
	add_index(:profiles, :user_id)

	add_index(:settings, :meta_key)

	add_index(:subscribers, :email)
	add_index(:subscribers, :approval)
	add_index(:subscribers, :code_confirmation)
	
	add_index(:tweets, :tweet_id)

	add_index(:videos, :name)
	add_index(:videos, :profile_id)


	
	
  end
end