-- Initialize Email Settings in Database
-- This will set up the email configuration with the current values from email.php
-- Admin can update these from the admin panel

INSERT INTO site_settings (setting_key, setting_value, setting_type, description) VALUES
('smtp_host', 'mail.horizondrillingco.com', 'text', 'SMTP Server Host'),
('smtp_user', 'info@horizondrillingco.com', 'text', 'SMTP Username/Email'),
('smtp_pass', 'Horizon@drilling254', 'text', 'SMTP Password'),
('smtp_port', '587', 'text', 'SMTP Port (587 for TLS, 465 for SSL)'),
('smtp_secure', 'tls', 'text', 'SMTP Security (tls or ssl)'),
('smtp_from_email', 'info@horizondrillingco.com', 'text', 'From Email Address'),
('smtp_from_name', 'Horizon Drilling Co. Ltd', 'text', 'From Name')
ON DUPLICATE KEY UPDATE 
    setting_value = VALUES(setting_value),
    description = VALUES(description);