summaryrefslogtreecommitdiff
path: root/db/schema.sql
blob: e6796c871a90af3bde231d1c74114c726d734a2f (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
CREATE TABLE IF NOT EXISTS "schema_migrations" (version varchar(255) primary key);
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
);
-- Dbmate schema migrations
INSERT INTO "schema_migrations" (version) VALUES
  ('20250802140659');