2 files changed, 26 insertions, 3 deletions
diff --git a/db/migrations/20260813000000_official_climbs.sql b/db/migrations/20260813000000_official_climbs.sql
new file mode 100644
index 0000000..0b1696a
--- /dev/null
+++ b/db/migrations/20260813000000_official_climbs.sql
@@ -0,0 +1,14 @@
+-- migrate:up
+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'))
+);
+
+-- migrate:down
+drop table official_climbs;
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');