Update annotations to show 'using' clause on indexes

diff --git a/app/models/changeset.rb b/app/models/changeset.rb
index 2c4c6d85c277c051b5317fd45a1d74464a30d89a..d57086a8e040062af55313a99cbb8b8dd477ab60 100644 (file)
--- a/app/models/changeset.rb
+++ b/app/models/changeset.rb
@@ -14,7 +14,7 @@
 #
 # Indexes
 #
 #
 # Indexes
 #

-#  changesets_bbox_idx                (min_lat,max_lat,min_lon,max_lon)
+#  changesets_bbox_idx                (min_lat,max_lat,min_lon,max_lon) USING gist

 #  changesets_closed_at_idx           (closed_at)
 #  changesets_created_at_idx          (created_at)
 #  changesets_user_id_created_at_idx  (user_id,created_at)
 #  changesets_closed_at_idx           (closed_at)
 #  changesets_created_at_idx          (created_at)
 #  changesets_user_id_created_at_idx  (user_id,created_at)

diff --git a/app/models/note_comment.rb b/app/models/note_comment.rb
index 065c37a5c73e44eef2ef9c2eec60d427af9b6f7d..388f890a67c4fb5ea0939be59cef429475e2ca0a 100644 (file)
--- a/app/models/note_comment.rb
+++ b/app/models/note_comment.rb
@@ -13,7 +13,7 @@
 #
 # Indexes
 #
 #
 # Indexes
 #

-#  index_note_comments_on_body        (to_tsvector('english'::regconfig, body))
+#  index_note_comments_on_body        (to_tsvector('english'::regconfig, body)) USING gin

 #  index_note_comments_on_created_at  (created_at)
 #  note_comments_note_id_idx          (note_id)
 #
 #  index_note_comments_on_created_at  (created_at)
 #  note_comments_note_id_idx          (note_id)
 #