add index migration adding column instead of migration

Question

I am trying to add a index to a column which already exists in my table by.

I want to add a index on item_id on product_images table

bundle exec rails generate migration AddIndexToProductImages item_id:integer:index

but the code i see in the migration file is

class AddIndexToProductImages < ActiveRecord::Migration
  def change
    add_column :product_images, :item_id, :integer
  end
end

Not sure what could be causing this, can anyone help? Thanks.

Deepak Mahakale · Accepted Answer · 2016-11-22 09:09:35Z

2

Rails will not autogenerate the migration with content just for index

Edit the generated migration with following:

class AddIndexToProductImages < ActiveRecord::Migration
  def change
    add_index :product_images, :item_id
  end
end

answered Nov 22, 2016 at 9:09

Deepak Mahakale

23.8k10 gold badges73 silver badges94 bronze badges

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

1 Comment

opensource-developer Over a year ago

Thanks deepak, have accepeted your answer but is there any official documentation that says so or link where i can read more about "Rails will not autogenerate the migration with content just for index"

Saurabh · Accepted Answer · 2016-11-22 09:44:30Z

1

Following is the command to generate index migration File:

bundle exec rails generate migration AddIndexesToProductImages item_id:integer:index

In case it does not have proper command to add index, you can edit the generated file with the appropriate index you want to add. You will have to wring following in the change function.

def change
  add_index :product_images, :item_id
end

edited Nov 22, 2016 at 9:44

answered Nov 22, 2016 at 9:15

Saurabh

73.8k44 gold badges193 silver badges251 bronze badges

Collectives™ on Stack Overflow

add index migration adding column instead of migration

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related