-- Add SMTP settings to system_settings table

INSERT INTO system_settings (setting_key, setting_value, description) VALUES
('smtp_host', 'mail.webappsofttech.com', 'SMTP Server hostname'),
('smtp_user', 'info@webappsofttech.com', 'SMTP Username'),
('smtp_pass', '8kArn,Tg*yC3*IQ#', 'SMTP Password'),
('smtp_port', '465', 'SMTP Port (e.g., 465 for SSL, 587 for TLS)'),
('smtp_crypto', 'ssl', 'SMTP Encryption (ssl or tls)'),
('smtp_from_email', 'info@webappsofttech.com', 'Email address emails are sent from'),
('smtp_from_name', 'Flex Market', 'Name displayed as the sender')
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value);