1 files changed, 14 insertions, 0 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;