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/migrations/20260813000000_official_climbs.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 db/migrations/20260813000000_official_climbs.sql

(limited to 'db/migrations/20260813000000_official_climbs.sql')

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;
-- 
cgit v1.2.3

