aboutsummaryrefslogtreecommitdiff
path: root/db/migrations
diff options
context:
space:
mode:
authorMartin Kagamino Lehoux <martin@lehoux.net>2026-08-21 06:56:12 +0200
committerMartin Kagamino Lehoux <martin@lehoux.net>2026-08-21 06:56:12 +0200
commit9da52d7355f5a77f0adc9a658619b3bfef03ba3c (patch)
treeb9e5f803d0c9787a84696b9e38b06b6721c9ded3 /db/migrations
parent13aeedfbb9271444ca42efb45bbe0986ae7610ce (diff)
feat(ride): persist canonical moving time, preserve Strava reference
Diffstat (limited to 'db/migrations')
-rw-r--r--db/migrations/20260820184307_ride_moving_time.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrations/20260820184307_ride_moving_time.sql b/db/migrations/20260820184307_ride_moving_time.sql
new file mode 100644
index 0000000..6505609
--- /dev/null
+++ b/db/migrations/20260820184307_ride_moving_time.sql
@@ -0,0 +1,9 @@
+-- migrate:up
+alter table rides rename column moving_time_s to external_moving_time_s;
+alter table rides add column moving_time_s integer;
+alter table rides add column moving_time_algo_version text;
+
+-- migrate:down
+alter table rides drop column moving_time_algo_version;
+alter table rides drop column moving_time_s;
+alter table rides rename column external_moving_time_s to moving_time_s; \ No newline at end of file