diff options
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 7 |
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'); |
