Merge remote-tracking branch 'upstream/pull/5389'

[rails.git] / db / migrate / 028_add_more_changeset_indexes.rb

diff --git a/db/migrate/028_add_more_changeset_indexes.rb b/db/migrate/028_add_more_changeset_indexes.rb
index d93cc79e752c002e1be7e2e19463e7e509894f7a..fcbc24ed71292123e644ebab9e4792a6a37e09d2 100644 (file)
--- a/db/migrate/028_add_more_changeset_indexes.rb
+++ b/db/migrate/028_add_more_changeset_indexes.rb
@@ -1,13 +1,17 @@
-class AddMoreChangesetIndexes < ActiveRecord::Migration
+class AddMoreChangesetIndexes < ActiveRecord::Migration[4.2]

   def self.up
   def self.up

+    enable_extension "btree_gist"
+

     add_index "changesets", ["created_at"], :name => "changesets_created_at_idx"
     add_index "changesets", ["closed_at"], :name => "changesets_closed_at_idx"
     add_index "changesets", ["created_at"], :name => "changesets_created_at_idx"
     add_index "changesets", ["closed_at"], :name => "changesets_closed_at_idx"

-    add_index "changesets", ["min_lat","max_lat","min_lon","max_lon"], :name => "changesets_bbox_idx", :method => "GIST"
+    add_index "changesets", %w[min_lat max_lat min_lon max_lon], :name => "changesets_bbox_idx", :using => "GIST"

   end
 
   def self.down
     remove_index "changesets", :name => "changesets_bbox_idx"
     remove_index "changesets", :name => "changesets_closed_at_idx"
     remove_index "changesets", :name => "changesets_created_at_idx"
   end
 
   def self.down
     remove_index "changesets", :name => "changesets_bbox_idx"
     remove_index "changesets", :name => "changesets_closed_at_idx"
     remove_index "changesets", :name => "changesets_created_at_idx"

+
+    disable_extension "btree_gist"

   end
 end
   end
 end