Fixes retrieval of deceased from AX database.

[platal.git] / upgrade / newdirectory-0.0.1 / 09_education.sql

diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql
index 732a155..058ad93 100644 (file)
--- a/upgrade/newdirectory-0.0.1/09_education.sql
+++ b/upgrade/newdirectory-0.0.1/09_education.sql
@@ -146,14 +146,14 @@ UPDATE profile_education_enum
 SET abbreviation = 'ENS Cachan', name = 'École Normale Supérieure de Cachan'
 WHERE name = 'ENS Cachan';
 UPDATE profile_education_enum
-xSET abbreviation = 'ESPCI', name = 'ESPCI ParisTech'
+SET abbreviation = 'ESPCI', name = 'ESPCI ParisTech'
 WHERE name = 'ESPCI';
 UPDATE profile_education_enum
 SET abbreviation = 'Sciences Po', name = 'Institut d\'Études Politiques de Paris'
 WHERE name = 'IEP Paris';
 UPDATE profile_education_enum
 SET abbreviation = 'Sciences Po Aix', name = 'Institut d\'Études Politiques d\'Aix-en-Provence'
-WHERE name = 'IEP Aix'
+WHERE name = 'IEP Aix';
 UPDATE profile_education_enum
 SET abbreviation = 'EHESS', name = 'École des Hautes Études en Sciences Sociales'
 WHERE name = 'EHESS';
@@ -220,6 +220,9 @@ WHERE name = 'Conservatoire national supérieur de musique et de danse de Paris'
 UPDATE profile_education_enum
 SET name = 'École Normale de Musique de Paris'
 WHERE name = 'École normale de musique de Paris';
+UPDATE profile_education_enum
+SET abbreviation = 'ENSMN'
+WHERE name = 'École Nationale Supérieure des Mines de Nancy';
 
 UPDATE profile_education_enum
 SET abbreviation = 'NDU', country = 'US'
@@ -492,6 +495,9 @@ WHERE name = 'Univ Cardiff';
 UPDATE profile_education_enum
 SET abbreviation = 'UNSW', name = 'The University of New South Wales', country = 'AU'
 WHERE name = 'Univ New South Wales  (Sydney Australia)';
+UPDATE profile_education_enum
+SET abbreviation = 'USyd', country = 'AU'
+WHERE name = 'University of Sydney';
 
 UPDATE profile_education_enum
 SET abbreviation = 'THU', name = 'Tsinghua University', country = 'CN'