Rails database add column

Question

When creating a model in Rails, I forgot to add a column amount that I want. How can I add it to the model later?

adimitri · Accepted Answer · 2012-10-20 01:01:21Z

17

Create a new migration via the console with:

rails g migration add_amount_to_items

This should create a migration something like this:

class AddAmountToItems < ActiveRecord::Migration
  def change
    # add_column table_name, :column_name, :column_type
    add_column :items, :amount, :integer
  end
end

answered Oct 20, 2012 at 1:01

adimitri

1,3069 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Valter Ekholm Over a year ago

Hello. I did like this "rails g migration add_priority_to_article" - but the migration file that was generated had no instruction... instead I used "priority:integer" (ending the g-command) and it worked

We Going Nowhere · Accepted Answer · 2012-10-20 11:23:50Z

11

The lazy way:

rails g migration add_amount_to_items amount:integer

answered Oct 20, 2012 at 11:23

We Going Nowhere

3062 silver badges6 bronze badges

3 Comments

BenKoshy Over a year ago

Hi thank you @WeGoingNowhere - what is the proper, dilligent way that will save grief long term. what if you don't want 'quick and dirty'

Arthur Over a year ago

And don't forget to run the migration: bin/rake db:migrate

RanH Over a year ago

this should be the accepted answer

Collectives™ on Stack Overflow

Rails database add column

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related