summaryrefslogtreecommitdiffstats
path: root/db/migrate/20091225164732_remove_enumerations_opt.rb
blob: 2a445dd3a50a50cb8abf94334a4869913e28dc44 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
class RemoveEnumerationsOpt < ActiveRecord::Migration
  def self.up
    remove_column :enumerations, :opt
  end

  def self.down
    add_column :enumerations, :opt, :string, :limit => 4, :default => '', :null => false
    Enumeration.where("type = 'IssuePriority'").update_all("opt = 'IPRI'")
    Enumeration.where("type = 'DocumentCategory'").update_all("opt = 'DCAT'")
    Enumeration.where("type = 'TimeEntryActivity'").update_all("opt = 'ACTI'")
  end
end