view db/migrate/20090401221305_update_enumerations_to_sti.rb @ 671:9fabf0da3b09 live

Select only the columns named in the GROUP BY clause, fixing #289

class UpdateEnumerationsToSti < ActiveRecord::Migration
  def self.up
    Enumeration.update_all("type = 'IssuePriority'", "opt = 'IPRI'")
    Enumeration.update_all("type = 'DocumentCategory'", "opt = 'DCAT'")
    Enumeration.update_all("type = 'TimeEntryActivity'", "opt = 'ACTI'")
  end

  def self.down
    # no-op
  end
end