-- Add missing company settings for invoice generation
INSERT INTO admin_settings (setting_key, setting_value, setting_type, description) VALUES
('companyAddress', '7 Temasek Boulevard #12-07 Suntec Tower One', 'text', 'Company address line 1'),
('companyAddress2', 'Singapore 038987', 'text', 'Company address line 2'),
('companyPhone', '+65 1234 5678', 'text', 'Company phone number'),
('invoiceTermsConditions', '• Payment is due within 7 days of invoice date\n• Please include the reference number with your payment\n• For any queries, contact us at finance@appliedhe.com\n• All prices are in USD and subject to change without notice\n• Registration is confirmed upon receipt of payment', 'text', 'Invoice terms and conditions'),
('eventName', 'AppliedHE Xchange 2025', 'text', 'Event name')
ON DUPLICATE KEY UPDATE 
    setting_value = VALUES(setting_value),
    description = VALUES(description);
