summaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorJean-Philippe Lang <jp_lang@yahoo.fr>2009-12-25 17:13:58 +0000
committerJean-Philippe Lang <jp_lang@yahoo.fr>2009-12-25 17:13:58 +0000
commit8db9ecef08ee8afe600bdb2d95ead0162b8b43d4 (patch)
treeecf477a4dd955203267a82331cfca67b090b781a /db
parent9fb40b1a2f700ce6e5bd31438fe9c9ef737555ab (diff)
downloadredmine-8db9ecef08ee8afe600bdb2d95ead0162b8b43d4.tar.gz
redmine-8db9ecef08ee8afe600bdb2d95ead0162b8b43d4.zip
Removes column opt in enumerations table.
git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3240 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20091225164732_remove_enumerations_opt.rb12
1 files changed, 12 insertions, 0 deletions
diff --git a/db/migrate/20091225164732_remove_enumerations_opt.rb b/db/migrate/20091225164732_remove_enumerations_opt.rb
new file mode 100644
index 000000000..72c39e05b
--- /dev/null
+++ b/db/migrate/20091225164732_remove_enumerations_opt.rb
@@ -0,0 +1,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.update_all("opt = 'IPRI'", "type = 'IssuePriority'")
+ Enumeration.update_all("opt = 'DCAT'", "type = 'DocumentCategory'")
+ Enumeration.update_all("opt = 'ACTI'", "type = 'TimeEntryActivity'")
+ end
+end