Losing Default Value with Migration

Hi,

I'm wondering if anyone has experienced problems with losing default column values when running a migration. I have a column that defaults to a value of 0, yet when I run a migration I lose the default value which reverts to NULL. My migration is simple:

class RenameRecentLocationId < ActiveRecord::Migration   def self.up     rename_column :devices, :recent_location_id, :recent_reading_id   end

  def self.down     rename_column :devices, :recent_reading_id, :recent_location_id   end end

Am I missing something or is this a known issue? Thanks in advance for any light you can shed on the problem.

Best regards, Dennis

Okay, so it seems I should do a change_column after the rename. Sorry for the waste of bytes and I was expecting Rails to do everything for me with one line of code :slight_smile:

class RenameRecentLocationId < ActiveRecord::Migration   def self.up     rename_column :devices, :recent_location_id, :recent_reading_id     change_column :devices, :recent_reading_id, :integer, :default => 0   end

  def self.down     rename_column :devices, :recent_reading_id, :recent_location_id     change_column :devices, :recent_location_id, :integer, :default => 0   end end