diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-08-08 10:05:05 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-08-08 10:05:05 +0200 |
| commit | 2c00b74cc02b55e26d68fef108596aae56080d5a (patch) | |
| tree | 793b37a40979b13f05135151814783003ba6bf44 /db/schema.sql | |
| parent | 7aa64b0917130fcc1dc9f3da30d8f825136fe541 (diff) | |
feat: Persist Cotacol ride values
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index 6a22bc5..1a3d62a 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -27,6 +27,8 @@ CREATE TABLE rides ( elapsed_time_s integer not null, total_elevation_gain_m real not null, average_speed_mps real not null, + cotacol_score real, + cotacol_algo_version text, 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')) ); @@ -34,4 +36,5 @@ CREATE TABLE rides ( INSERT INTO "schema_migrations" (version) VALUES ('20250802140659'), ('20260802090000'), - ('20260804000000'); + ('20260804000000'), + ('20260807000000'); |