Corrects birthdate when birthdate is null and birthdate_ref is correct.

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

diff --git a/upgrade/1.1.12/08_correct_birthdate.sql b/upgrade/1.1.12/08_correct_birthdate.sql
new file mode 100644 (file)
index 0000000..39d1362
--- /dev/null
+++ b/upgrade/1.1.12/08_correct_birthdate.sql
@@ -0,0 +1,5 @@
+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';