20130111232201_aggressive_indexing_strategy3.rb 605 Bytes
Edit Raw Blame History



1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23


class AggressiveIndexingStrategy3 < ActiveRecord::Migration
  def self.up
    add_index :articles, :slug
    add_index :articles, :parent_id
    add_index :articles, :profile_id
    add_index :articles, :translation_of_id

    add_index :article_versions, :article_id

    add_index :comments, [:source_id, :spam]
  end

  def self.down
    remove_index :articles, :slug
    remove_index :articles, :parent_id
    remove_index :articles, :profile_id
    remove_index :articles, :translation_of_id

    remove_index :article_versions, :article_id

    remove_index :comments, [:source_id, :spam]
  end
end