diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrations/20260807000000_ride_cotacol.sql | 7 | ||||
| -rw-r--r-- | db/schema.sql | 5 |
2 files changed, 11 insertions, 1 deletions
diff --git a/db/migrations/20260807000000_ride_cotacol.sql b/db/migrations/20260807000000_ride_cotacol.sql new file mode 100644 index 0000000..44e3a81 --- /dev/null +++ b/db/migrations/20260807000000_ride_cotacol.sql @@ -0,0 +1,7 @@ +-- migrate:up +alter table rides add column cotacol_score real; +alter table rides add column cotacol_algo_version text; + +-- migrate:down +alter table rides drop column cotacol_algo_version; +alter table rides drop column cotacol_score; 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'); |