-- Migration: Add arrival tracking fields to emergency_responses (Simple Version)
-- Run this SQL in your database

USE `blood_bank`;

ALTER TABLE `emergency_responses` 
ADD COLUMN `arrived_at` datetime DEFAULT NULL AFTER `accepted_at`,
ADD COLUMN `arrival_notes` text DEFAULT NULL AFTER `arrived_at`;

