db/migrate/028_add_more_changeset_indexes.rb

   1 require 'migrate'
   2
   3 class AddMoreChangesetIndexes < ActiveRecord::Migration
   4   def self.up
   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", ["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   end
  15 end