From f2b2b26c889e13fbf851fef38319abf76ead7c36 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Mon, 11 Jan 2010 22:43:32 +0100 Subject: [PATCH] Adds University of Pennsylvania. 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 | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql index 800b2fb..6b4b7a6 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -265,6 +265,9 @@ UPDATE profile_education_enum SET abbreviation = 'The Wharton School', name = 'The Wharton School of the University of Pennsylvania', country = 'US', url = 'http://www.wharton.upenn.edu/' WHERE name = 'Univ Wharton'; UPDATE profile_education_enum +SET country = 'US' +WHERE name = 'University of Pennsylvania'; +UPDATE profile_education_enum SET abbreviation = 'Columbia University', name = 'Columbia University in the City of New York', country = 'US' WHERE name = 'Univ Columbia'; UPDATE profile_education_enum @@ -567,7 +570,6 @@ INSERT INTO profile_education_enum (name, url, country, abbreviation) ('Universität Stuttgarti', 'http://www.uni-stuttgart.de/', 'DE', ''), ('Universitatea Politehnica din Bucureşti', 'http://www.pub.ro/', 'RO', 'Politehnica din Bucureşti'), ('University of Birmingham', 'http://www.bham.ac.uk/', 'GB', ''), - ('University of Pennsylvania', 'http://www.upenn.edu/', 'US', ''), ('University of Rome', '', 'IT', ''), ('University of Sheffield', 'http://www.shef.ac.uk/', 'GB', ''), ('University of Utah', 'http://www.utah.edu/', 'US', ''), -- 2.1.4