Contents

class AddIndexes < ActiveRecord::Migration
  def self.up
    add_index :pages,       :class_name,            :name => 'pages_class_name'
    add_index :pages,       :parent_id,             :name => 'pages_parent_id'
    add_index :pages,       %w{slug parent_id},     :name => 'pages_child_slug'
    add_index :pages,       %w{virtual status_id},  :name => 'pages_published'

    add_index :page_parts,  %w{page_id name},       :name => 'parts_by_page'
  end

  def self.down
    remove_index :page_parts, :name => 'parts_by_page'

    remove_index :pages,      :name => 'pages_published'
    remove_index :pages,      :name => 'pages_child_slug'
    remove_index :pages,      :name => 'pages_parent_id'
    remove_index :pages,      :name => 'pages_class_name'
  end
end

Version data entries

74 entries across 74 versions & 1 rubygems

Version	Path
trusty-cms-1.1.11	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.10	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.9	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.8	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.7	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.6	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.5	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.4	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.3	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.2	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.1	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.0	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.0.rc1	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.0.1	db/migrate/20081203140407_add_indexes.rb