view db/migrate/.svn/text-base/20091225164732_remove_enumerations_opt.rb.svn-base @ 436:4eb486dbf730 bug_169

If the remote repo URL changes, move aside the existing local mirror and start afresh.
(Not yet tested: checkpointing this prior to working on a different aspect of the problem)

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.update_all("opt = 'IPRI'", "type = 'IssuePriority'")
    Enumeration.update_all("opt = 'DCAT'", "type = 'DocumentCategory'")
    Enumeration.update_all("opt = 'ACTI'", "type = 'TimeEntryActivity'")
  end
end