Adding an index for sequence numbers in merge request

2 files changed, 11 insertions, 1 deletions

diff --git a/db/migrate/20091119090036_adding_index_to_sequence_numbers.rb b/db/migrate/20091119090036_adding_index_to_sequence_numbers.rb
new file mode 100644
index 0000000..050e7bb
--- /dev/null
+++ b/db/migrate/20091119090036_adding_index_to_sequence_numbers.rb
@@ -0,0 +1,9 @@
+class AddingIndexToSequenceNumbers < ActiveRecord::Migration
+  def self.up
+    add_index :merge_requests, :sequence_number
+  end
+
+  def self.down
+    remove_index :merge_requests, :sequence_number
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 91ee79f..a5f2582 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 => 20091117101216) do
+ActiveRecord::Schema.define(:version => 20091119090036) do
 
   create_table "cloners", :force => true do |t|
     t.string   "ip"
@@ -165,6 +165,7 @@ ActiveRecord::Schema.define(:version => 20091117101216) do
     t.integer  "sequence_number"
   end
 
+  add_index "merge_requests", ["sequence_number"], :name => "index_merge_requests_on_sequence_number"
   add_index "merge_requests", ["source_repository_id"], :name => "index_merge_requests_on_source_repository_id"
   add_index "merge_requests", ["status"], :name => "index_merge_requests_on_status"
   add_index "merge_requests", ["target_repository_id"], :name => "index_merge_requests_on_target_repository_id"