Add some indexes to diary entries to let recent entries be found

efficiently for the various diary entry lists and feeds.

diff --git a/db/migrate/048_add_diary_creation_indexes.rb b/db/migrate/048_add_diary_creation_indexes.rb
new file mode 100644 (file)
index 0000000..d99831a
--- /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