db/migrations/20260802090000_osm_passes.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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;