From f54f7ebc7e3b8cc049592bb267dbf739da87283e Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Tue, 13 Apr 2010 16:05:37 +0200 Subject: [PATCH] Updates education upgrade script. 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 7321f66..732a155 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -146,12 +146,15 @@ UPDATE profile_education_enum SET abbreviation = 'ENS Cachan', name = 'École Normale Supérieure de Cachan' WHERE name = 'ENS Cachan'; UPDATE profile_education_enum -SET abbreviation = 'ESPCI', name = 'ESPCI ParisTech' +xSET 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' +UPDATE profile_education_enum SET abbreviation = 'EHESS', name = 'École des Hautes Études en Sciences Sociales' WHERE name = 'EHESS'; UPDATE profile_education_enum -- 2.1.4