ALTER TABLE affiliate_users
  MODIFY status ENUM('pending', 'active', 'suspended') NOT NULL DEFAULT 'pending',
  ADD COLUMN IF NOT EXISTS telegram VARCHAR(120) NULL AFTER email,
  ADD COLUMN IF NOT EXISTS affiliate_manager_name VARCHAR(120) NULL AFTER commission_override_note,
  ADD COLUMN IF NOT EXISTS affiliate_manager_email VARCHAR(190) NULL AFTER affiliate_manager_name,
  ADD COLUMN IF NOT EXISTS affiliate_manager_telegram VARCHAR(120) NULL AFTER affiliate_manager_email,
  ADD COLUMN IF NOT EXISTS review_note VARCHAR(255) NULL AFTER affiliate_manager_telegram;