X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F09_education.sql;h=058ad93764c8ab96592b5a083b223afa647f6844;hb=304cdf32d7c38afbd381909545021fc44c8a0e05;hp=95340fbd8471b1770cd23cd8f22050e1218ff7fd;hpb=ce0b2c6f3fc4e7c524df32f56f1bc8e8d573bb1a;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql
index 95340fb..058ad93 100644
--- a/upgrade/newdirectory-0.0.1/09_education.sql
+++ b/upgrade/newdirectory-0.0.1/09_education.sql
@@ -26,7 +26,7 @@ INSERT INTO  profile_education_degree_enum (abbreviation, degree, level)
 
 -- Updates universities
 UPDATE profile_education_enum
-SET abbreviation = 'Université Claude Bernard', name = 'Université Claude Bernard (Lyon I)'
+SET abbreviation = 'Université Claude Bernard', name = 'Université Claude Bernard (Lyon 1)'
 WHERE name = 'Université Claude Bernard';
 UPDATE profile_education_enum
 SET abbreviation = 'Télécom', name = 'Télécom ParisTech', url = 'http://www.telecom-paristech.fr/'
@@ -152,6 +152,9 @@ 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';
+UPDATE profile_education_enum
 SET abbreviation = 'EHESS', name = 'École des Hautes Études en Sciences Sociales'
 WHERE name = 'EHESS';
 UPDATE profile_education_enum
@@ -161,6 +164,9 @@ UPDATE profile_education_enum
 SET abbreviation = 'Grenoble INP', name = 'Institut Polytechnique de Grenoble', url = 'http://www.grenoble-inp.fr/'
 WHERE name = 'INPG';
 UPDATE profile_education_enum
+SET abbreviation = 'UJF'
+WHERE name = 'Université Joseph-Fourier (Grenoble 1)';
+UPDATE profile_education_enum
 SET abbreviation = 'ESSEC', name = 'École Supérieure des Sciences Économiques et Commerciales'
 WHERE name = 'ESSEC';
 UPDATE profile_education_enum
@@ -214,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'
@@ -378,6 +387,9 @@ WHERE name = 'Univ Madrid';
 UPDATE profile_education_enum
 SET abbreviation = 'UPF', name = 'Universitat Pompeu Fabra', country = 'ES'
 WHERE name = 'Univ Pompeu Fabra';
+UPDATE profile_education_enum
+SET abbreviation = 'IE', country = 'ES'
+WHERE name = 'Instituto de Empresa';
 
 UPDATE profile_education_enum
 SET abbreviation = 'Chalmers', name = 'Chalmers Tekniska Högskola', country = 'SE'
@@ -483,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'
@@ -610,7 +625,7 @@ INSERT INTO  profile_education_enum (name, url, country, abbreviation)
 
 -- Médecine is not a university but an educational field
 REPLACE INTO  profile_education (pid, id, fieldid, eduid, degreeid)
-      SELECT  e.uid, e.id, f.id, 0, d.id
+      SELECT  e.pid, e.id, f.id, 0, d.id
         FROM  profile_education             AS e
   INNER JOIN  profile_education_enum        AS l ON (l.id = e.eduid)
   INNER JOIN  profile_education_degree_enum AS d ON (d.degree = "Doctorat")