From b62be36bc636e303764792a36165be27d5802675 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Thu, 8 Apr 2010 21:53:33 +0200 Subject: [PATCH] Education update. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/newdirectory-0.0.1/09_education.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql index 776662b..7321f66 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/' @@ -161,6 +161,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 -- 2.1.4