To check out this repository please hg clone the following URL, or open the URL using EasyMercurial or your preferred Mercurial client.

Statistics Download as Zip
| Branch: | Tag: | Revision:

root / db / migrate / 20091017213910_add_missing_indexes_to_issues.rb @ 442:753f1380d6bc

History | View | Annotate | Download (636 Bytes)

1
class AddMissingIndexesToIssues < ActiveRecord::Migration
2
  def self.up
3
    add_index :issues, :status_id
4
    add_index :issues, :category_id
5
    add_index :issues, :assigned_to_id
6
    add_index :issues, :fixed_version_id
7
    add_index :issues, :tracker_id
8
    add_index :issues, :priority_id
9
    add_index :issues, :author_id
10
  end
11

    
12
  def self.down
13
    remove_index :issues, :status_id
14
    remove_index :issues, :category_id
15
    remove_index :issues, :assigned_to_id
16
    remove_index :issues, :fixed_version_id
17
    remove_index :issues, :tracker_id
18
    remove_index :issues, :priority_id
19
    remove_index :issues, :author_id
20
  end
21
end