More indices for asscociations. related to #2159

1 files changed, 26 insertions, 0 deletions

diff --git a/db/migrate/20121203160507_more_indices.rb b/db/migrate/20121203160507_more_indices.rb
new file mode 100644
index 00000000000..52170a7c597
--- /dev/null
+++ b/db/migrate/20121203160507_more_indices.rb
@@ -0,0 +1,26 @@
+class MoreIndices < ActiveRecord::Migration
+  def change
+    add_index :notes, :project_id
+    add_index :namespaces, :owner_id
+    add_index :keys, :user_id
+
+    add_index :projects, :namespace_id
+    add_index :projects, :owner_id
+
+    add_index :services, :project_id
+    add_index :snippets, :project_id
+
+    add_index :users_projects, :project_id
+
+    # Issues
+    add_index :issues, :assignee_id
+    add_index :issues, :milestone_id
+    add_index :issues, :author_id
+
+    # Merge Requests
+    add_index :merge_requests, :assignee_id
+    add_index :merge_requests, :milestone_id
+    add_index :merge_requests, :author_id
+
+  end
+end