]> git.openstreetmap.org Git - rails.git/blob - db/migrate/028_add_more_changeset_indexes.rb
Merge remote-tracking branch 'upstream/pull/5208'
[rails.git] / db / migrate / 028_add_more_changeset_indexes.rb
1 class AddMoreChangesetIndexes < ActiveRecord::Migration[4.2]
2   def self.up
3     enable_extension "btree_gist"
4
5     add_index "changesets", ["created_at"], :name => "changesets_created_at_idx"
6     add_index "changesets", ["closed_at"], :name => "changesets_closed_at_idx"
7     add_index "changesets", %w[min_lat max_lat min_lon max_lon], :name => "changesets_bbox_idx", :using => "GIST"
8   end
9
10   def self.down
11     remove_index "changesets", :name => "changesets_bbox_idx"
12     remove_index "changesets", :name => "changesets_closed_at_idx"
13     remove_index "changesets", :name => "changesets_created_at_idx"
14
15     disable_extension "btree_gist"
16   end
17 end