-- Update settings for Dongola Specialized Hospital, Sudan
-- Run this to update existing settings

USE `blood_bank`;

-- Update hospital information
UPDATE `settings` SET 
    `value` = 'المستشفى التخصصي دنقلا',
    `updated_at` = NOW()
WHERE `key` = 'hospital_name';

UPDATE `settings` SET 
    `value` = 'دنقلا',
    `updated_at` = NOW()
WHERE `key` = 'hospital_city';

UPDATE `settings` SET 
    `value` = 'السودان',
    `updated_at` = NOW()
WHERE `key` = 'hospital_country';

UPDATE `settings` SET 
    `value` = 'دنقلا، السودان',
    `updated_at` = NOW()
WHERE `key` = 'hospital_address';

UPDATE `settings` SET 
    `value` = '+249 123 456 789',
    `updated_at` = NOW()
WHERE `key` = 'hospital_phone';

UPDATE `settings` SET 
    `value` = 'info@dongola-hospital.sd',
    `updated_at` = NOW()
WHERE `key` = 'hospital_email';

-- Insert new settings if they don't exist
INSERT INTO `settings` (`key`, `value`, `description`) VALUES
('hospital_city', 'دنقلا', 'المدينة'),
('hospital_country', 'السودان', 'البلد')
ON DUPLICATE KEY UPDATE 
    `value` = VALUES(`value`),
    `updated_at` = NOW();

