Add index, thanks Alex.

2 files changed, 12 insertions, 1 deletions

diff --git a/db/migrate/077_add_exim_log_index.rb b/db/migrate/077_add_exim_log_index.rb
new file mode 100644
index 000000000..c2d04d7ca
--- /dev/null
+++ b/db/migrate/077_add_exim_log_index.rb
@@ -0,0 +1,9 @@
+class AddEximLogIndex < ActiveRecord::Migration
+  def self.up
+    add_index :exim_logs, :exim_log_done_id
+  end
+
+  def self.down
+    remove_index :exim_logs, :exim_log_done_id
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index e805235b1..2da739ae1 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -9,7 +9,7 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 76) do
+ActiveRecord::Schema.define(:version => 77) do
 
   create_table "acts_as_xapian_jobs", :force => true do |t|
     t.string  "model",    :null => false
@@ -59,6 +59,8 @@ ActiveRecord::Schema.define(:version => 76) do
     t.datetime "updated_at",       :null => false
   end
 
+  add_index "exim_logs", ["exim_log_done_id"], :name => "index_exim_logs_on_exim_log_done_id"
+
   create_table "holidays", :force => true do |t|
     t.date "day"
     t.text "description"