Merge remote branch 'origin/xorg/f/geocoding' into xorg/master

[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 139b5bd..058ad93 100644 (file)
--- a/upgrade/newdirectory-0.0.1/09_education.sql
+++ b/upgrade/newdirectory-0.0.1/09_education.sql
@@ -153,7 +153,7 @@ SET abbreviation = 'Sciences Po', name = 'Institut d\'Études Politiques de Pari
 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'