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-2.0.0.pre.beta	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.2.29	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.2.28	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.28	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.27	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.26	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.25	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.24	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.23	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.22	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.21	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.20	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.19	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.18	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.17	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.16	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.15	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.14	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.13	db/migrate/20081203140407_add_indexes.rb
trusty-cms-1.1.12	db/migrate/20081203140407_add_indexes.rb