aboutsummaryrefslogtreecommitdiff
path: root/db/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql7
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');