-- Migration: Add arrival time fields to events and arrival_choice to participations
-- Run this on existing databases. New databases created from schema.sql already include these columns.

ALTER TABLE events
  ADD COLUMN arrival_time_piste TIME NULL AFTER available_seats,
  ADD COLUMN arrival_time_venue TIME NULL AFTER arrival_time_piste;

ALTER TABLE participations
  ADD COLUMN arrival_choice ENUM('piste', 'venue') NULL AFTER notes;
