diff options
| author | Eric Davis <edavis@littlestreamsoftware.com> | 2009-12-20 19:13:22 +0000 |
|---|---|---|
| committer | Eric Davis <edavis@littlestreamsoftware.com> | 2009-12-20 19:13:22 +0000 |
| commit | 1ebb78e412a73c3ed2d5d0feadc0ef6e7235979f (patch) | |
| tree | bd09373e5322dec25bbafe8ec8730e4ef24b0c22 /db/migrate/20091220184736_add_indexes_to_issue_status.rb | |
| parent | 7955e1eb9facf7349dd9b2ec1fb389b1eedb4a34 (diff) | |
| download | redmine-1ebb78e412a73c3ed2d5d0feadc0ef6e7235979f.tar.gz redmine-1ebb78e412a73c3ed2d5d0feadc0ef6e7235979f.zip | |
Added some database indexes to commonly queried fields.
git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3206 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'db/migrate/20091220184736_add_indexes_to_issue_status.rb')
| -rw-r--r-- | db/migrate/20091220184736_add_indexes_to_issue_status.rb | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/db/migrate/20091220184736_add_indexes_to_issue_status.rb b/db/migrate/20091220184736_add_indexes_to_issue_status.rb new file mode 100644 index 000000000..2497a1e6a --- /dev/null +++ b/db/migrate/20091220184736_add_indexes_to_issue_status.rb @@ -0,0 +1,13 @@ +class AddIndexesToIssueStatus < ActiveRecord::Migration + def self.up + add_index :issue_statuses, :position + add_index :issue_statuses, :is_closed + add_index :issue_statuses, :is_default + end + + def self.down + remove_index :issue_statuses, :position + remove_index :issue_statuses, :is_closed + remove_index :issue_statuses, :is_default + end +end |