1 files changed, 16 insertions, 0 deletions
diff --git a/db/migrations/20260827000000_mountain_pass_category.sql b/db/migrations/20260827000000_mountain_pass_category.sql
new file mode 100644
index 0000000..0bb3181
--- /dev/null
+++ b/db/migrations/20260827000000_mountain_pass_category.sql
@@ -0,0 +1,16 @@
+-- migrate:up
+ALTER TABLE mountain_passes ADD COLUMN category TEXT NOT NULL DEFAULT 'unknown' CHECK (category IN ('road', 'track', 'path', 'hiking', 'unknown'));
+
+-- migrate:down
+CREATE TABLE mountain_passes_backup (
+    id integer primary key,
+    osm_id integer unique not null,
+    name text,
+    elevation integer,
+    latitude real not null,
+    longitude real not null
+);
+INSERT INTO mountain_passes_backup (id, osm_id, name, elevation, latitude, longitude)
+SELECT id, osm_id, name, elevation, latitude, longitude FROM mountain_passes;
+DROP TABLE mountain_passes;
+ALTER TABLE mountain_passes_backup RENAME TO mountain_passes;