-- Pickup GPS coordinates + customer audio notes on booking

USE fiac_db;

ALTER TABLE service_bookings
  ADD COLUMN pickup_lat DECIMAL(10, 7) DEFAULT NULL AFTER pickup_notes,
  ADD COLUMN pickup_lng DECIMAL(10, 7) DEFAULT NULL AFTER pickup_lat,
  ADD COLUMN customer_audio_notes_url VARCHAR(500) DEFAULT NULL AFTER customer_notes;