aboutsummaryrefslogtreecommitdiff
path: root/db/migrations/20260924000000_official_climb_sample.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations/20260924000000_official_climb_sample.sql')
-rw-r--r--db/migrations/20260924000000_official_climb_sample.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/db/migrations/20260924000000_official_climb_sample.sql b/db/migrations/20260924000000_official_climb_sample.sql
new file mode 100644
index 0000000..6a3990f
--- /dev/null
+++ b/db/migrations/20260924000000_official_climb_sample.sql
@@ -0,0 +1,7 @@
+-- migrate:up
+ALTER TABLE official_climbs ADD COLUMN sample_distance_m real;
+ALTER TABLE official_climbs ADD COLUMN sample_elevation_gain_m real;
+
+-- migrate:down
+ALTER TABLE official_climbs DROP COLUMN sample_distance_m;
+ALTER TABLE official_climbs DROP COLUMN sample_elevation_gain_m;