annotate db/migrate/.svn/text-base/20091225164732_remove_enumerations_opt.rb.svn-base @ 408:cd3158bf28b5 feature_36

added a new column to the publications table: reviewed. Attention: need to rebuild the db schema for the plugin.
author luisf <luis.figueira@eecs.qmul.ac.uk>
date Fri, 15 Apr 2011 16:58:37 +0100
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