Contents

class AddIndexes < ActiveRecord::Migration[5.2]
  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

127 entries across 127 versions & 1 rubygems

Version	Path
trusty-cms-7.0.22	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.21	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.20	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.19	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.18	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.17	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.16	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.14	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.13	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.12	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.15	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.9.1	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.11	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.10	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.9	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.8	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.7	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.6	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.5	db/migrate/20081203140407_add_indexes.rb
trusty-cms-7.0.4	db/migrate/20081203140407_add_indexes.rb