Chris@909: class AddMissingIndexesToIssues < ActiveRecord::Migration Chris@909: def self.up Chris@909: add_index :issues, :status_id Chris@909: add_index :issues, :category_id Chris@909: add_index :issues, :assigned_to_id Chris@909: add_index :issues, :fixed_version_id Chris@909: add_index :issues, :tracker_id Chris@909: add_index :issues, :priority_id Chris@909: add_index :issues, :author_id Chris@909: end Chris@909: Chris@909: def self.down Chris@909: remove_index :issues, :status_id Chris@909: remove_index :issues, :category_id Chris@909: remove_index :issues, :assigned_to_id Chris@909: remove_index :issues, :fixed_version_id Chris@909: remove_index :issues, :tracker_id Chris@909: remove_index :issues, :priority_id Chris@909: remove_index :issues, :author_id Chris@909: end Chris@909: end