-- Migration: Add destination_latitude and destination_longitude to ambulance_requests table
-- Run this migration if the table already exists

ALTER TABLE ambulance_requests 
ADD COLUMN destination_latitude DECIMAL(10, 8) NULL AFTER longitude,
ADD COLUMN destination_longitude DECIMAL(11, 8) NULL AFTER destination_latitude;

