-- SMTP ayarlarını mail_settings tablosuna ekle
ALTER TABLE mail_settings
ADD COLUMN smtp_enabled TINYINT(1) DEFAULT 0 AFTER auto_send,
ADD COLUMN smtp_host VARCHAR(255) DEFAULT 'smtp.gmail.com' AFTER smtp_enabled,
ADD COLUMN smtp_port INT DEFAULT 587 AFTER smtp_host,
ADD COLUMN smtp_encryption VARCHAR(10) DEFAULT 'tls' AFTER smtp_port,
ADD COLUMN smtp_username VARCHAR(255) DEFAULT '' AFTER smtp_encryption,
ADD COLUMN smtp_password VARCHAR(255) DEFAULT '' AFTER smtp_username;

-- Varsayılan değerleri güncelle
UPDATE mail_settings SET smtp_enabled = 1, smtp_host = 'smtp.gmail.com', smtp_port = 587, smtp_encryption = 'tls';
