Contents

# Adds indexes to some tables to speed up the application when many records are present.
# origin: M
class AddMissingIndexes < ActiveRecord::Migration
  def self.up
    add_index :users, :remember_token
    add_index :users, :deleted
    add_index :friendship_requests, :user_id
    add_index :invitations, :recipient_id
    add_index :friendships, :user_id
    add_index :conference_categories, :category_id
    add_index :conference_categories, :conference_id
  end

  def self.down
    remove_index :users, :remember_token
    remove_index :users, :deleted
    remove_index :friendship_requests, :user_id
    remove_index :invitations, :recipient_id
    remove_index :friendships, :user_id
    remove_index :conference_categories, :category_id
    remove_index :conference_categories, :conference_id
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
serum-rails-0.2.1	spec/test_apps/rails-2-3/db/migrate/20110119110857_add_missing_indexes.rb
serum-rails-0.2.0	spec/test_apps/rails-2-3/db/migrate/20110119110857_add_missing_indexes.rb
serum-rails-0.1.1	spec/test_app/db/migrate/20110119110857_add_missing_indexes.rb
serum-rails-0.1.0	spec/test_app/db/migrate/20110119110857_add_missing_indexes.rb