Corrects birthdate when birthdate is null and birthdate_ref is correct.

[platal.git] / upgrade / 1.1.12 / 08_correct_birthdate.sql

UPDATE profiles as p
LEFT JOIN account_profiles AS ap ON p.pid = ap.pid
LEFT JOIN accounts AS a ON a.uid = ap.uid
SET p.birthdate = p.birthdate_ref
WHERE p.birthdate_ref AND NOT p.birthdate AND a.state = 'active';