Add some extra indexes to the changesets table.
[rails.git] / db / migrate / 028_add_more_changeset_indexes.rb
1 class AddMoreChangesetIndexes < ActiveRecord::Migration
2   def self.up
3     add_index "changesets", ["created_at"], :name => "changesets_created_at_idx"
4     add_index "changesets", ["closed_at"], :name => "changesets_closed_at_idx"
5     add_index "changesets", ["min_lat","max_lat","min_lon","max_lon"], :name => "changesets_bbox_idx", :method => "GIST"
6   end
7
8   def self.down
9     remove_index "changesets", :name => "changesets_bbox_idx"
10     remove_index "changesets", :name => "changesets_closed_at_idx"
11     remove_index "changesets", :name => "changesets_created_at_idx"
12   end
13 end