Persist official climb attempts with climbs pages

Record one attempt row per (ride, climb, occurrence) when a ride detail
loads, snapshotting distance, elevation gain, slope, cotacol and attempt
timestamps; a climbs-backfill CLI command seeds all existing rides.

New /climbs list page aggregates attempts (medians computed in Go, best
time as min duration) with sortable columns, and /climbs/{id} shows the
median scalar stats, a median normalized elevation profile (50 steps
over each attempt's own length), the full-precision recorded route of
the median-distance attempt on an OSM map, and every attempt with time
at second precision.

1 files changed, 18 insertions, 0 deletions

diff --git a/db/migrations/20260913000000_ride_official_climb_attempts.sql b/db/migrations/20260913000000_ride_official_climb_attempts.sql
new file mode 100644
index 0000000..880f81b
--- /dev/null
+++ b/db/migrations/20260913000000_ride_official_climb_attempts.sql
@@ -0,0 +1,18 @@
+-- migrate:up
+CREATE TABLE ride_official_climb_attempts (
+    ride_id integer not null references rides(id),
+    climb_id integer not null references official_climbs(id),
+    occurrence integer not null,
+    distance_m real not null,
+    elevation_gain_m real not null,
+    slope_percent real not null,
+    cotacol real not null,
+    cotacol_algo_version text not null,
+    started_at text not null,
+    ended_at text not null,
+    created_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
+    primary key (ride_id, climb_id, occurrence)
+);
+
+-- migrate:down
+DROP TABLE ride_official_climb_attempts;