Mercurial > hg > soundsoftware-site

view db/migrate/20091017213910_add_missing_indexes_to_issues.rb @ 573:aed210f6095b feature_36

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Layout changes for publication edit page. Still requires correct authorships number in heading, and for the new authorship to be added in its proper place.
author Chris Cannam <chris.cannam@soundsoftware.ac.uk>
date Wed, 10 Aug 2011 14:24:53 +0100
parents 513646585e45
children
line wrap: on
line source
class AddMissingIndexesToIssues < ActiveRecord::Migration
  def self.up
    add_index :issues, :status_id
    add_index :issues, :category_id
    add_index :issues, :assigned_to_id
    add_index :issues, :fixed_version_id
    add_index :issues, :tracker_id
    add_index :issues, :priority_id
    add_index :issues, :author_id
  end

  def self.down
    remove_index :issues, :status_id
    remove_index :issues, :category_id
    remove_index :issues, :assigned_to_id
    remove_index :issues, :fixed_version_id
    remove_index :issues, :tracker_id
    remove_index :issues, :priority_id
    remove_index :issues, :author_id
  end
end