From 08a10e30ba489205570c6f4fd9c3e8c201ec8958 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sun, 6 Sep 2009 15:04:01 +0200 Subject: [PATCH] Adds IITs. --- upgrade/newdirectory-0.0.1/09_education.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql index 6ba922e..dba7342 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -474,6 +474,10 @@ UPDATE profile_education_enum SET abbreviation = 'NSU', name = 'Novosibirsk State University', url = 'http://www.nsu.ru/', country = 'RU' WHERE name = 'Université de Novossibirsk (Новосибирский Государственный Университет)'; +UPDATE profile_education_enum +SET abbreviation = 'IITs', country = 'IN' +WHERE name = 'Indian Institutes of Technology'; + -- Cleans duplicated entries UPDATE profile_education SET eduid = 0 WHERE eduid = 70; DELETE FROM profile_education_enum WHERE id = 70; -- 2.1.4