-- Add subject and recipient_email to tickets for email notifications.
-- Run this migration before using the ticketing feature (raise ticket + auto email).
-- Example: mysql -u user -p database < add_ticket_subject_recipient.sql
ALTER TABLE tickets ADD COLUMN subject VARCHAR(255) NULL AFTER description;
ALTER TABLE tickets ADD COLUMN recipient_email VARCHAR(255) NULL AFTER subject;
