-- Seed: Sample Cases
-- Insert sample patient cases

SET @doctor_id = (SELECT id FROM users WHERE role = 'doctor' LIMIT 1);

INSERT INTO `cases` (`user_id`, `patient_name`, `patient_mobile`, `patient_age`, `patient_gender`, 
                    `chief_complaint`, `case_history`, `status`) VALUES
(@doctor_id, 'John Doe', '9876543210', 35, 'M', 
 'Chronic headache for 5 years', 'Patient has history of migraines since childhood. Headaches are throbbing, worse on right side.', 'active'),
 
(@doctor_id, 'Jane Smith', '9876543211', 28, 'F', 
 'Anxiety and panic attacks', 'Patient reports sudden onset of anxiety, worse in crowds. Better after exercise.', 'follow-up'),
 
(@doctor_id, 'Robert Johnson', '9876543212', 45, 'M', 
 'Digestive issues and bloating', 'Bloating after meals, worse 4-8 PM. Craves sweets.', 'active'),
 
(@doctor_id, 'Mary Williams', '9876543213', 52, 'F', 
 'Joint pain and stiffness', 'Arthritic pain in knees, worse in cold weather. Better from warmth.', 'closed'),
 
(@doctor_id, 'David Brown', '9876543214', 60, 'M', 
 'Skin rash and itching', 'Eczema on arms and legs, worse from bathing. Better from cold application.', 'follow-up')
ON DUPLICATE KEY UPDATE id=id;