Skip to main content

Adding Column to rails 2 and rails3

##add cloumn to rails

rails g  migration AddStatusToUsers
class AddStatusToUser < ActiveRecord::Migration
  def change
          #add_column :table_name, :column_name, :type, default: "Your value"
        add_cloumn :users,:status,:string
  end
end
###############change column names to rails
rails g migration ChangeNameToUsers
class RenameStatusToUser < ActiveRecord::Migration
  def change
      #rename_column :table_name, :old_column1, :new_column1
    rename_column :users,:name,:full_name
  end
end
  (or)
class RenameStatusToUser < ActiveRecord::Migration
  def change
    change_table :table_name do |t|
      t.rename :old_column1, :new_column1
      t.rename :old_column2, :new_column2
    end
end

########ROR migration change a column type from Date to DateTime
rails g migration change_date_format_in_my_table
class ChangeFormatInUser< ActiveRecord::Migration
  def change
    #change_column :my_table, :my_column, :my_new_type
    change_column :users
  end
end


##for rails2 adding column
ruby script/generate migration AddIsAdminToUsers
class AddIsAdminToUser < ActiveRecord::Migration
  def self.up
   add_column :users, :is_admin, :boolean, :default=>false, :null=>false
  end
 def self.down
   remove_column :users, :is_admin
  end
end

Comments