Search code examples
ruby-on-railsrubyrails-migrationsruby-on-rails-5

How to add a new column in an existing table in Rails 5?


I want to add a new column in one of my table in Rails 5. I recently renamed a column by using the following way:

rails g migration ChangeJobsTable

then in 20160802104312_change_jobs_table.rb:

class ChangeJobsTable < ActiveRecord::Migration[5.0]
  def change
    rename_column :jobs, :skills, :skills1
  end
end

then

rails db:migrate

It worked fine, but now if I want to also add a new column skills2, do I need to do it like this?

class ChangeJobsTable < ActiveRecord::Migration[5.0]
  def change
    add_column :jobs, :skills2
  end
end

Solution

  • You forgot to add datatype, below is the updated migration.

    class ChangeJobsTable < ActiveRecord::Migration[5.0]
      def change
        add_column :jobs, :skills2, :string
      end
    end