-- Delete all MFA data from the database
-- Date: 2025-11-20
-- Description: Remove all multi-factor authentication data from user accounts

-- Note: This will disable MFA for all users and remove all MFA factors

BEGIN;

-- Delete from dependent tables first (due to foreign key constraints)
DELETE FROM user_mfa_webauthn;
DELETE FROM user_mfa_totp;
DELETE FROM user_recovery_codes;

-- Delete from the main MFA factors table last
DELETE FROM user_mfa_factors;


COMMIT;
