-- Add optional client email on invoices (B2C simplified)

ALTER TABLE invoices
  ADD COLUMN client_email VARCHAR(320) NULL AFTER capsule_id,
  ADD KEY idx_invoices_client_email (client_email);

