-- Quick Registration Fix
-- Optional UNIQUE fields must be NULL when empty so many quick-registered members can be saved without phone/email.
UPDATE members SET phone1 = NULL WHERE phone1 = '';
UPDATE members SET phone2 = NULL WHERE phone2 = '';
UPDATE members SET email = NULL WHERE email = '';