Pastie Support Pastie or read my Pastie << self blog

class AddEnumTypeColumnToUserEvents < ActiveRecord::Migration
  def self.up
    execute("ALTER TABLE user_events ADD COLUMN event_type ENUM('user', 'account') DEFAULT 'user'")
    #set default
    execute("UPDATE user_events SET event_type = 'user'")
  end

  def self.down
    execute("ALTER TABLE user_events DROP COLUMN event_type")
  end
end