From eac1145e29e1a2a2ff5d9654ca010071a5840843 Mon Sep 17 00:00:00 2001
From: Martin Kagamino Lehoux <martin@lehoux.net>
Date: Fri, 14 Aug 2026 15:23:48 +0200
Subject: feat: add official climb workflow

---
 db/schema.sql | 15 ++++++++++++---
 1 file changed, 12 insertions(+), 3 deletions(-)

(limited to 'db/schema.sql')

diff --git a/db/schema.sql b/db/schema.sql
index 1a3d62a..6c8f8ac 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -27,8 +27,16 @@ 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'))
+, cotacol_score real, cotacol_algo_version text);
+CREATE TABLE official_climbs (
+    id integer primary key,
+    name text not null,
+    start_latitude real not null,
+    start_longitude real not null,
+    end_latitude real not null,
+    end_longitude 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'))
 );
@@ -37,4 +45,5 @@ INSERT INTO "schema_migrations" (version) VALUES
   ('20250802140659'),
   ('20260802090000'),
   ('20260804000000'),
-  ('20260807000000');
+  ('20260807000000'),
+  ('20260813000000');
-- 
cgit v1.2.3

