-- Add return journey details to bookings table
-- This allows storing complete return journey information

ALTER TABLE bookings ADD COLUMN return_pickup_location TEXT;
ALTER TABLE bookings ADD COLUMN return_dropoff_location TEXT;
ALTER TABLE bookings ADD COLUMN return_pickup_date DATE;
ALTER TABLE bookings ADD COLUMN return_pickup_time TIME;
ALTER TABLE bookings ADD COLUMN return_distance_miles REAL;

-- Note: These fields are only populated when is_return_journey = 1
-- The return journey shares the same vehicle, passengers, and extras as the outbound journey
