From 6e5f284135aa2aabd3d400921caec8c5a9073c68 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Sun, 3 Jan 2010 11:56:41 +0000 Subject: [PATCH] Add some indexes to diary entries to let recent entries be found efficiently for the various diary entry lists and feeds. --- db/migrate/048_add_diary_creation_indexes.rb | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 db/migrate/048_add_diary_creation_indexes.rb diff --git a/db/migrate/048_add_diary_creation_indexes.rb b/db/migrate/048_add_diary_creation_indexes.rb new file mode 100644 index 000000000..d99831a3a --- /dev/null +++ b/db/migrate/048_add_diary_creation_indexes.rb @@ -0,0 +1,13 @@ +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 -- 2.43.2