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');