-- Migration: Add closure reason and notes to emergency_requests
-- Run this to add closure_reason and closure_notes fields

USE `blood_bank`;

ALTER TABLE `emergency_requests` 
ADD COLUMN `closure_reason` enum('success','failed','cancelled') DEFAULT NULL AFTER `closed_at`,
ADD COLUMN `closure_notes` text DEFAULT NULL AFTER `closure_reason`;

