From 827b55f610119d553b965ceb4d3631f0481bbb3b Mon Sep 17 00:00:00 2001
From: Martin Kagamino Lehoux <martin@lehoux.net>
Date: Fri, 28 Aug 2026 22:38:57 +0200
Subject: Rename rides.type to external_sport_type, infer bike type from Strava
 sport type and display categories in UI

---
 db/schema.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'db/schema.sql')

diff --git a/db/schema.sql b/db/schema.sql
index 79f4c62..a97b7f1 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,7 +4,7 @@ CREATE TABLE rides (
     external_id text unique not null,
     gpx_path text not null,
     name text not null,
-    type text not null,
+    external_sport_type text not null,
     start_date text not null,
     distance_m real not null,
     external_moving_time_s integer not null,
@@ -44,4 +44,5 @@ INSERT INTO "schema_migrations" (version) VALUES
   ('20260823000000'),
   ('20260827000000'),
   ('20260828000000'),
-  ('20260829000000');
+  ('20260829000000'),
+  ('20260831000000');
-- 
cgit v1.3