From a1e0b7faa4eac18db7841f90d77ef2b106350630 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Wed, 18 Feb 2026 18:38:24 +0000
Subject: [PATCH] Drop redundant index on gpx_files table

---
 .database_consistency.yml                                 | 3 ---
 app/models/trace.rb                                       | 1 -
 db/migrate/20260218183352_drop_gpx_files_user_id_index.rb | 7 +++++++
 db/structure.sql                                          | 8 +-------
 4 files changed, 8 insertions(+), 11 deletions(-)
 create mode 100644 db/migrate/20260218183352_drop_gpx_files_user_id_index.rb

diff --git a/.database_consistency.yml b/.database_consistency.yml
index 03cbda6f6..9bf9d8a4c 100644
--- a/.database_consistency.yml
+++ b/.database_consistency.yml
@@ -362,9 +362,6 @@ Trace:
   description:
     ColumnPresenceChecker:
       enabled: false
-  gpx_files_user_id_idx:
-    RedundantIndexChecker:
-      enabled: false
   inserted:
     NullConstraintChecker:
       enabled: false
diff --git a/app/models/trace.rb b/app/models/trace.rb
index 975f22b1b..d07d6ea8d 100644
--- a/app/models/trace.rb
+++ b/app/models/trace.rb
@@ -19,7 +19,6 @@
 # Indexes
 #
 #  gpx_files_timestamp_idx            (timestamp)
-#  gpx_files_user_id_idx              (user_id)
 #  gpx_files_visible_visibility_idx   (visible,visibility)
 #  index_gpx_files_on_user_id_and_id  (user_id,id)
 #
diff --git a/db/migrate/20260218183352_drop_gpx_files_user_id_index.rb b/db/migrate/20260218183352_drop_gpx_files_user_id_index.rb
new file mode 100644
index 000000000..60a0cbd8f
--- /dev/null
+++ b/db/migrate/20260218183352_drop_gpx_files_user_id_index.rb
@@ -0,0 +1,7 @@
+# frozen_string_literal: true
+
+class DropGpxFilesUserIdIndex < ActiveRecord::Migration[8.1]
+  def change
+    remove_index :gpx_files, [:user_id], :name => "gpx_files_user_id_idx"
+  end
+end
diff --git a/db/structure.sql b/db/structure.sql
index 6b13ee431..15e703dec 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -2442,13 +2442,6 @@ CREATE INDEX gpx_file_tags_tag_idx ON public.gpx_file_tags USING btree (tag);
 CREATE INDEX gpx_files_timestamp_idx ON public.gpx_files USING btree ("timestamp");
 
 
---
--- Name: gpx_files_user_id_idx; Type: INDEX; Schema: public; Owner: -
---
-
-CREATE INDEX gpx_files_user_id_idx ON public.gpx_files USING btree (user_id);
-
-
 --
 -- Name: gpx_files_visible_visibility_idx; Type: INDEX; Schema: public; Owner: -
 --
@@ -3570,6 +3563,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('23'),
 ('22'),
 ('21'),
+('20260218183352'),
 ('20251218105716'),
 ('20251121134648'),
 ('20250704143751'),
-- 
2.39.5