X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F09_education.sql;h=6ba922e14084ba159b233db3a7119524a13a81d1;hb=c12cc82e1d97b51e19b294942ea9450a34d929cd;hp=74de7434bdd85cb0f5d3933d923c511aa27346d7;hpb=a16cf1c2e56cc6e4c6cda1e984d2659c4cf0450c;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql
index 74de743..6ba922e 100644
--- a/upgrade/newdirectory-0.0.1/09_education.sql
+++ b/upgrade/newdirectory-0.0.1/09_education.sql
@@ -305,6 +305,9 @@ WHERE name = 'Univ Carnegie Mellon';
 UPDATE profile_education_enum
 SET abbreviation = 'Carolina', name = 'University of North Carolina at Chapel Hill', country = 'US'
 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 abbreviation = 'TU Berlin', name = 'Technische Universität Berlin', country = 'DE'
@@ -461,6 +464,16 @@ UPDATE profile_education_enum
 SET abbreviation = 'NTNU', name = 'Norwegian University of Science and Technology', country = 'NO', url = 'http://www.ntnu.no/'
 WHERE name = 'Univ Trondheim';
 
+UPDATE profile_education_enum
+SET abbreviation = '', country = 'GB'
+WHERE name = 'University of Surrey';
+UPDATE profile_education_enum
+SET abbreviation = 'OIV', country = 'FR'
+WHERE name = 'Organisme International de la Vigne et du Vin';
+UPDATE profile_education_enum
+SET abbreviation = 'NSU', name = 'Novosibirsk State University', url = 'http://www.nsu.ru/', country = 'RU'
+WHERE name = 'Université de Novossibirsk (Новосибирский Государственный Университет)';
+
 -- Cleans duplicated entries
 UPDATE profile_education SET eduid = 0 WHERE eduid = 70;
 DELETE FROM profile_education_enum WHERE id = 70;
@@ -522,7 +535,7 @@ INSERT INTO  profile_education_enum (name, url, country, abbreviation)
              ('Cleveland State University', 'http://www.csuohio.edu/', 'US', 'CSU'),
              ('Centre de Perfectionnement aux Affaires du Nord', '', 'FR', 'CPA du Nord'),
              ('Centre de Perfectionnement aux Affaires de Lyon', '', '', 'CPA de Lyon'),
-             ('Amherst College', 'http://www.amherst.edu/', 'US', '')
+             ('Amherst College', 'http://www.amherst.edu/', 'US', ''),
              ('Ottawa University', 'http://www.ottawa.edu/', 'US', 'OU'),
              ('Indiana University', 'http://www.indiana.edu/', 'US', ''),
              ('University of Notre Dame du Lac', 'http://www.nd.edu/', 'US', 'Notre Dame'),
@@ -544,7 +557,21 @@ INSERT INTO  profile_education_enum (name, url, country, abbreviation)
              ('Centre Européen d\'Éducation Permanente', 'http://www.cedep.fr/', 'FR', 'CEDEP'),
              ('Collège Interarmées de Défense', 'http://www.college.interarmees.defense.gouv.fr/', 'FR', ''),
              ('Centre de Formation des Journalistes', 'http://www.cfpj.com/', 'FR', 'CFJ'),
-             ('Institut National des Hautes Études de Sécurité', 'http://www.inhes.interieur.gouv.fr/', 'FR', 'INHES');
+             ('Institut National des Hautes Études de Sécurité', 'http://www.inhes.interieur.gouv.fr/', 'FR', 'INHES'),
+             ('Université d\'Orléans', 'http://www.univ-orleans.fr/', 'FR', '');
+
+
+-- Médecine is not a university but an educational field
+REPLACE INTO  profile_education (uid, id, fieldid, eduid, degreeid)
+      SELECT  e.uid, e.id, f.id, 0, d.id
+        FROM  profile_education             AS e
+  INNER JOIN  profile_education_enum        AS l ON (l.id = e.eduid)
+  INNER JOIN  profile_education_degree_enum AS d ON (d.degree = "Doctorat")
+  INNER JOIN  profile_education_field_enum  AS f ON (f.field = "Médecine")
+       WHERE  l.name = "Médecine";
+
+DELETE FROM  profile_education_enum
+      WHERE  name = "Médecine";
 
 # vim:set syntax=mysql: