From eac1145e29e1a2a2ff5d9654ca010071a5840843 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Fri, 14 Aug 2026 15:23:48 +0200 Subject: feat: add official climb workflow --- db/migrations/20260813000000_official_climbs.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 db/migrations/20260813000000_official_climbs.sql (limited to 'db/migrations') diff --git a/db/migrations/20260813000000_official_climbs.sql b/db/migrations/20260813000000_official_climbs.sql new file mode 100644 index 0000000..0b1696a --- /dev/null +++ b/db/migrations/20260813000000_official_climbs.sql @@ -0,0 +1,14 @@ +-- migrate:up +create table official_climbs ( + id integer primary key, + name text not null, + start_latitude real not null, + start_longitude real not null, + end_latitude real not null, + end_longitude real not null, + created_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')), + updated_at text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')) +); + +-- migrate:down +drop table official_climbs; -- cgit v1.2.3