summaryrefslogtreecommitdiff
path: root/db/migrate/20130505034059_add_missing_indexes.rb
blob: 83efafbce63ca4a7d5d8d79ae8456b62f08bb4f8 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
class AddMissingIndexes < ActiveRecord::Migration
  def change
    add_index :creations, :user_id
    add_index :creations_categories, [:category_id, :creation_id]
    add_index :creations_categories, [:creation_id, :category_id]
    add_index :taggings, :tagger_id
    add_index :avatars, :user_id
    add_index :comments, :parent_id
    add_index :comments, [:commentable_id, :commentable_type]
    add_index :favorites, :user_id
    add_index :favorites, :creation_id
    add_index :tutorials, :user_id
    add_index :users_interests, [:interest_id, :user_id]
  end
end