class AddDiaryCreationIndexes < ActiveRecord::Migration
  def self.up
    add_index :diary_entries, [:created_at], :name => "diary_entry_created_at_index"
    add_index :diary_entries, [:user_id, :created_at], :name => "diary_entry_user_id_created_at_index"
    add_index :diary_entries, [:language_code, :created_at], :name => "diary_entry_language_code_created_at_index"
  end

  def self.down
    remove_index :diary_entries, :name => "diary_entry_language_code_created_at_index"
    remove_index :diary_entries, :name => "diary_entry_user_id_created_at_index"
    remove_index :diary_entries, :name => "diary_entry_created_at_index"
  end
end

Add some indexes to diary entries to let recent entries be found efficiently for the various diary entry lists and feeds.
Add some indexes to diary entries to let recent entries be found
efficiently for the various diary entry lists and feeds.


