Rails: How to add add_index to existing table

ruby-on-rails indexing migrate
yoshyosh picture yoshyosh · May 24, 2011 · Viewed 13.2k times · Source

I already migrated a table called units with several columns. I was wondering how to migrate in a stand alone 'add_index' to this table using the cmd. Is this code correct:

class AddIndexToUnits < ActiveRecord::Migration
  def self.up
    add_index :units, :lesson_id
  end

  def self.down
    remove :units
  end
end

I have a feeling the self.down could be wrong, I am unsure.

Answer

Kris picture Kris · May 24, 2011

The self.up method is correct. Use this for your self.down:

remove_index :units, :column => :lesson_id

Related questions

Rails: Adding an index after adding column

Suppose I created a table table in a Rails app. Some time later, I add a column running: rails generate migration AddUser_idColumnToTable user_id:string. Then I realize I need to add user_id as an index. I know …

Read More
Index on multiple columns in Ruby on Rails

I'm implementing functionality to track which articles a user has read. create_table "article", :force => true do |t| t.string "title" t.text "content" end This is my migration so far: create_table :user_views do |t| t.integer :…

Read More
Changing Index Page - Ruby on Rails

I am new to rails so go easy. I have developed my blog and deployed it successfully. The entire app is based out of the post_controller. I am wondering how I can reroute the users path to default to …

Read More