From 7c791f302c68be7110deabe73d7c8db97d1d13ef Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Mon, 20 Apr 2009 13:39:20 +0000 Subject: [PATCH 1/1] Add changeset indexes to nodes, ways and relations. --- db/migrate/027_add_changeset_indexes.rb | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 db/migrate/027_add_changeset_indexes.rb diff --git a/db/migrate/027_add_changeset_indexes.rb b/db/migrate/027_add_changeset_indexes.rb new file mode 100644 index 000000000..0d4bba0e8 --- /dev/null +++ b/db/migrate/027_add_changeset_indexes.rb @@ -0,0 +1,13 @@ +class AddChangesetIndexes < ActiveRecord::Migration + def self.up + add_index "nodes", ["changeset_id"], :name => "nodes_changeset_id_idx" + add_index "ways", ["changeset_id"], :name => "ways_changeset_id_idx" + add_index "relations", ["changeset_id"], :name => "relations_changeset_id_idx" + end + + def self.down + remove_index "relations", :name => "relations_changeset_id_idx" + remove_index "ways", :name => "ways_changeset_id_idx" + remove_index "nodes", :name => "nodes_changeset_id_idx" + end +end -- 2.43.2