1 files changed, 17 insertions, 0 deletions
diff --git a/db/migrations/20260802090000_osm_passes.sql b/db/migrations/20260802090000_osm_passes.sql
new file mode 100644
index 0000000..873e80a
--- /dev/null
+++ b/db/migrations/20260802090000_osm_passes.sql
@@ -0,0 +1,17 @@
+-- migrate:up
+create table osm_passes (
+    id integer primary key,
+    osm_id integer unique not null,
+    name text,
+    elevation integer,
+    latitude real not null,
+    longitude real not null
+);
+
+alter table mountain_passes add column latitude real;
+alter table mountain_passes add column longitude real;
+
+-- migrate:down
+alter table mountain_passes drop column latitude;
+alter table mountain_passes drop column longitude;
+drop table osm_passes;