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