From 50b278467aa6360346f79e3aa8df5e7b2d543335 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 7 Jan 2009 16:34:57 +0100 Subject: [PATCH] =?utf8?q?M=C3=A9decine=20is=20not=20a=20university=20but?= =?utf8?q?=20an=20educational=20field.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- upgrade/newdirectory-0.0.1/09_education.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql index abf3ba6..d899916 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -546,5 +546,18 @@ INSERT INTO profile_education_enum (name, url, country, abbreviation) ('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'); + +-- 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: -- 2.1.4