Chris@1295: class AddEnumerationsPosition < ActiveRecord::Migration
Chris@1295:   def self.up
Chris@1295:     add_column(:enumerations, :position, :integer, :default => 1) unless Enumeration.column_names.include?('position')
Chris@1295:     Enumeration.all.group_by(&:opt).each do |opt, enums|
Chris@1295:       enums.each_with_index do |enum, i|
Chris@1295:         # do not call model callbacks
Chris@1295:         Enumeration.update_all "position = #{i+1}", {:id => enum.id}
Chris@1295:       end
Chris@1295:     end
Chris@1295:   end
Chris@1295: 
Chris@1295:   def self.down
Chris@1295:     remove_column :enumerations, :position
Chris@1295:   end
Chris@1295: end