From: Tom Hughes <tom@compton.nu>
Date: Sun, 4 May 2008 11:33:09 +0000 (+0000)
Subject: Add timestamp indexes to current_ways and current_relations.
X-Git-Tag: live~7601^2~369
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/ead1817e11853165a0f7388e250dc96536daea00?hp=0ef056ffbcaa0ec5042478f53f1e5eab4403027d;ds=sidebyside

Add timestamp indexes to current_ways and current_relations.
---

diff --git a/db/migrate/012_add_timestamp_indexes.rb b/db/migrate/012_add_timestamp_indexes.rb
new file mode 100644
index 000000000..c6b3bc7c2
--- /dev/null
+++ b/db/migrate/012_add_timestamp_indexes.rb
@@ -0,0 +1,11 @@
+class AddTimestampIndexes < ActiveRecord::Migration
+  def self.up
+    add_index :current_ways, :timestamp, :name => :current_ways_timestamp_idx
+    add_index :current_relations, :timestamp, :name => :current_relations_timestamp_idx
+  end
+
+  def self.down
+    remove_index :current_ways, :name => :current_ways_timestamp_idx
+    remove_index :current_relations, :name => :current_relations_timestamp_idx
+  end
+end