-- Run this if you already imported sql/schema.sql before Phase 10.
-- Adds SMTP email settings and backup retention count to site_settings.
-- Safe to re-run - uses INSERT IGNORE so it won't overwrite existing values.

INSERT IGNORE INTO site_settings (setting_key, setting_value) VALUES
('smtp_host',''),
('smtp_port','587'),
('smtp_username',''),
('smtp_password',''),
('smtp_encryption','tls'),
('smtp_from_email',''),
('backup_retention_count','14');