diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-08-01 22:40:08 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-08-01 22:40:08 +0200 |
| commit | 80f2e72cd4818a4c0a5b5d4afb93dc23f04208e2 (patch) | |
| tree | d6f0323ed7e9e29190742750d70ee8ec392573c5 /db/migrations/20250802140659_mountain_passes.sql | |
| parent | ef12ceb8105c21cbfd9cd7ac9935893086d5af51 (diff) | |
feat: Download mountain passes from centcols into SQLite
Diffstat (limited to 'db/migrations/20250802140659_mountain_passes.sql')
| -rw-r--r-- | db/migrations/20250802140659_mountain_passes.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/db/migrations/20250802140659_mountain_passes.sql b/db/migrations/20250802140659_mountain_passes.sql new file mode 100644 index 0000000..afe3218 --- /dev/null +++ b/db/migrations/20250802140659_mountain_passes.sql @@ -0,0 +1,12 @@ +-- migrate:up +create table mountain_passes ( + id integer primary key, + external_id text unique not null, + name text not null, + country_code text not null, + department_code text not null, + elevation integer not null +); + +-- migrate:down +drop table mountain_passes; |