From 2de139ad47e0c320154959b1f7f225636ce16cf2 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Thu, 24 Sep 2009 01:34:12 +0200 Subject: [PATCH] Adds Purdue University. --- 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 53099e6..19356a1 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -308,6 +308,9 @@ WHERE name = 'Univ of North Carolina at Chapel Hill'; UPDATE profile_education_enum SET abbreviation = 'UM', country = 'US' WHERE name = 'University of Miami'; +UPDATE profile_education_enum +SET country = 'US' +WHERE name = 'Purdue University'; UPDATE profile_education_enum SET abbreviation = 'TU Berlin', name = 'Technische Universität Berlin', country = 'DE' @@ -538,7 +541,6 @@ INSERT INTO profile_education_enum (name, url, country, abbreviation) ('Royal College of Art', 'http://www.rca.ac.uk/', 'GB', 'RCA'), ('Uniwersytet Gdański', 'http://www.univ.gda.pl/', 'PL', ''), ('College of Europe', 'http://www.coleurope.eu/', '', ''), - ('Purdue University', 'http://www.purdue.edu/', 'US', ''), ('Queen\'s University', 'http://www.queensu.ca/', 'CA', 'Queen\'s'), ('Université de Bretagne Occidentale', 'http://www.univ-brest.fr/', 'FR', 'UBO'), ('University of California, Davis', 'http://www.ucdavis.edu/', 'US', 'UC Davis'), -- 2.1.4