USE `blood_bank`;

-- Add priority column to emergency_requests table
ALTER TABLE `emergency_requests` 
ADD COLUMN `priority` ENUM('normal', 'urgent') NOT NULL DEFAULT 'normal' AFTER `status`;

-- Add index for priority
ALTER TABLE `emergency_requests` 
ADD INDEX `priority` (`priority`);

