]> git.openstreetmap.org Git - rails.git/blobdiff - db/migrate/028_add_more_changeset_indexes.rb
Move api messages resources to api namespace
[rails.git] / db / migrate / 028_add_more_changeset_indexes.rb
index 45d014e9e51a81115ea4eb8a9cdc260382709bb8..fcbc24ed71292123e644ebab9e4792a6a37e09d2 100644 (file)
@@ -1,15 +1,17 @@
-require 'migrate'
-
-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