annotate db/migrate/20091225164732_remove_enumerations_opt.rb @ 140:4272e09f4b5f cannam-pre-20110113-merge

Allow list of managers, if more than one row, to overlap with description rather than pushing description down
author Chris Cannam <chris.cannam@soundsoftware.ac.uk>
date Thu, 20 Jan 2011 10:01:33 +0000
parents 513646585e45
children
rev   line source
Chris@0 1 class RemoveEnumerationsOpt < ActiveRecord::Migration
Chris@0 2 def self.up
Chris@0 3 remove_column :enumerations, :opt
Chris@0 4 end
Chris@0 5
Chris@0 6 def self.down
Chris@0 7 add_column :enumerations, :opt, :string, :limit => 4, :default => '', :null => false
Chris@0 8 Enumeration.update_all("opt = 'IPRI'", "type = 'IssuePriority'")
Chris@0 9 Enumeration.update_all("opt = 'DCAT'", "type = 'DocumentCategory'")
Chris@0 10 Enumeration.update_all("opt = 'ACTI'", "type = 'TimeEntryActivity'")
Chris@0 11 end
Chris@0 12 end