ALTER TABLE affiliate_users
  ADD COLUMN IF NOT EXISTS live_code VARCHAR(40) NULL AFTER affiliate_id,
  ADD COLUMN IF NOT EXISTS live_code_locked_at DATETIME NULL AFTER live_code;

ALTER TABLE affiliate_users
  ADD UNIQUE KEY uq_affiliate_users_live_code (live_code);

ALTER TABLE affiliate_conversions
  MODIFY status ENUM('Inscription', 'Paiement', 'Renouvelé', 'Remboursement', 'Litige') NOT NULL DEFAULT 'Inscription';

ALTER TABLE affiliate_user_commissions
  MODIFY type ENUM('subscription', 'renewal', 'adjustment', 'sub_affiliate', 'refund', 'dispute') NOT NULL DEFAULT 'subscription';