[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';
Commit	Line	Data
f49bd104 AL	1	UPDATE profiles as p
	2	LEFT JOIN account_profiles AS ap ON p.pid = ap.pid
	3	LEFT JOIN accounts AS a ON a.uid = ap.uid
	4	SET p.birthdate = p.birthdate_ref
	5	WHERE p.birthdate_ref AND NOT p.birthdate AND a.state = 'active';