20130111232201_aggressive_indexing_strategy3.rb
1.01 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
class AggressiveIndexingStrategy3 < ActiveRecord::Migration
def self.up
add_index :articles, :slug
add_index :articles, :parent_id
add_index :articles, :profile_id
add_index :articles, :name
add_index :article_versions, :article_id
add_index :comments, [:source_id, :spam]
add_index :profiles, :identifier
add_index :friendships, :person_id
add_index :friendships, :friend_id
add_index :friendships, [:person_id, :friend_id], :uniq => true
add_index :external_feeds, :blog_id
end
def self.down
remove_index :articles, :slug
remove_index :articles, :parent_id
remove_index :articles, :profile_id
remove_index :articles, :name
remove_index :article_versions, :article_id
remove_index :comments, [:source_id, :spam]
remove_index :profiles, :identifier
remove_index :friendships, :person_id
remove_index :friendships, :friend_id
remove_index :friendships, [:person_id, :friend_id]
remove_index :external_feeds, :blog_id
end
end