feat(ride): persist canonical moving time, preserve Strava reference

1 files changed, 4 insertions, 3 deletions

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');