From 7c4e0f19204fa7ac1dfa0915ab11e6bee8c2edf0 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sat, 19 Sep 2009 15:52:58 +0200 Subject: [PATCH] Adds Weizmann Institue of Science and UCL to the education list. --- upgrade/newdirectory-0.0.1/09_education.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql index 8ce3277..53099e6 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -422,6 +422,9 @@ WHERE name = 'Univ Moscow (Bauman)'; UPDATE profile_education_enum SET abbreviation = 'Technion', name = 'Israel Institute of Technology', country = 'IL' WHERE name = 'Univ Technion'; +UPDATE profile_education_enum +SET abbreviation = '', name = 'Weizmann Institute of Science', country = 'IL' +WHERE name = 'Institut Weizmann'; UPDATE profile_education_enum SET abbreviation = 'Oxford', name = 'University of Oxford', country = 'GB' @@ -470,6 +473,9 @@ WHERE name = 'University of Surrey'; UPDATE profile_education_enum SET abbreviation = '', country = 'GB' WHERE name = 'Heriot-Watt University'; +UPDATE profile_education_enum +SET abbreviation = 'UCL', country = 'GB' +WHERE name = 'University College London'; UPDATE profile_education_enum SET abbreviation = 'OIV', country = 'FR' @@ -527,7 +533,6 @@ INSERT INTO profile_education_enum (name, url, country, abbreviation) ('University of Kentucky', 'http://www.uky.edu/', 'US', 'UK'), ('Marine Corps University', 'http://www.mcu.usmc.mil/', 'US', 'MCU'), ('Chartered Institute of Management Accountants', 'http://www.cimaglobal.com/', 'GB', 'CIMA'), - ('University College London', 'http://www.ucl.ac.uk/', 'GB', 'UCL'), ('Chartered Financial Analyst Institute', 'http://www.cfainstitute.org/', 'US', 'CFA Institute'), ('Naval Postgraduate School', 'http://www.nps.edu/', 'US', 'NPS'), ('Royal College of Art', 'http://www.rca.ac.uk/', 'GB', 'RCA'), -- 2.1.4