From 9da52d7355f5a77f0adc9a658619b3bfef03ba3c Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Fri, 21 Aug 2026 06:56:12 +0200 Subject: feat(ride): persist canonical moving time, preserve Strava reference --- db/schema.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'db/schema.sql') diff --git a/db/schema.sql b/db/schema.sql index 6c8f8ac..4c03183 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -23,13 +23,13 @@ CREATE TABLE rides ( type text not null, start_date text not null, distance_m real not null, - moving_time_s integer not null, + external_moving_time_s integer not null, elapsed_time_s integer not null, total_elevation_gain_m real not null, average_speed_mps real not null, created_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')), updated_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')) -, cotacol_score real, cotacol_algo_version text); +, cotacol_score real, cotacol_algo_version text, moving_time_s integer, moving_time_algo_version text); CREATE TABLE official_climbs ( id integer primary key, name text not null, @@ -46,4 +46,5 @@ INSERT INTO "schema_migrations" (version) VALUES ('20260802090000'), ('20260804000000'), ('20260807000000'), - ('20260813000000'); + ('20260813000000'), + ('20260820184307'); -- cgit v1.3