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

[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 976aeb19e69d388f17b3aaf6e0ad182611f5e27d..fcbc24ed71292123e644ebab9e4792a6a37e09d2 100644 (file)
--- a/db/migrate/028_add_more_changeset_indexes.rb
+++ b/db/migrate/028_add_more_changeset_indexes.rb
@@ -1,15 +1,17 @@
-require "migrate"
-
-class AddMoreChangesetIndexes < ActiveRecord::Migration
+class AddMoreChangesetIndexes < ActiveRecord::Migration[4.2]
   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", %w(min_lat max_lat min_lon max_lon), :name => "changesets_bbox_idx"
+    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"
+
+    disable_extension "btree_gist"
   end
 end