Sha256: a635bd5a33c00487d6d3c1e0d59b998a293e9f124bb5445c797674aeaa69cc23

Contents?: true

Size: 1.33 KB

Versions: 10

Compression:

Stored size: 1.33 KB

Contents

class AddingIndexes < ActiveRecord::Migration
  def self.up
    add_index :comments, :recipient_id
    add_index :photos, :parent_id
    add_index :taggings, :tag_id
    add_index :comments, :created_at
    add_index :users, :avatar_id
    add_index :users, :featured_writer    
    add_index :comments, :commentable_type
    add_index :comments, :commentable_id    
    add_index :taggings, :taggable_type
    add_index :taggings, :taggable_id    
    add_index :users, :activated_at
    add_index :users, :vendor
    add_index :posts, :category_id
    add_index :users, :login_slug
    add_index :friendships, :user_id
    add_index :friendships, :friendship_status_id  
  end

  def self.down
    remove_index :comments, :recipient_id
    remove_index :photos, :parent_id
    remove_index :taggings, :tag_id
    remove_index :comments, :created_at
    remove_index :users, :avatar_id
    remove_index :users, :featured_writer
    remove_index :comments, :commentable_type
    remove_index :comments, :commentable_id
    remove_index :taggings, :taggable_type
    remove_index :taggings, :taggable_id    
    remove_index :users, :activated_at
    remove_index :users, :vendor
    remove_index :posts, :category_id
    remove_index :users, :login_slug
    remove_index :friendships, :user_id
    remove_index :friendships, :friendship_status_id
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version Path
community_engine-3.2.0 db/migrate/045_adding_indexes.rb
community_engine-3.0.0 db/migrate/045_adding_indexes.rb
community_engine-2.3.2 db/migrate/045_adding_indexes.rb
community_engine-2.3.1 db/migrate/045_adding_indexes.rb
community_engine-2.3.0 db/migrate/045_adding_indexes.rb
community_engine-2.1.0 db/migrate/045_adding_indexes.rb
community_engine-2.0.0 db/migrate/045_adding_indexes.rb
community_engine-2.0.0.beta3 db/migrate/045_adding_indexes.rb
community_engine-2.0.0.beta2 db/migrate/045_adding_indexes.rb
community_engine-2.0.0.beta1 db/migrate/045_adding_indexes.rb