From da496b3758c9185e2d031f59707d037557d19a41 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 9 Sep 2009 23:44:29 +0200 Subject: [PATCH] Adds IHEDN and CHEAr to the education list. --- modules/fusionax/formation.pl | 2 +- upgrade/newdirectory-0.0.1/09_education.sql | 11 ++++++++++- 2 files changed, 11 insertions(+), 2 deletions(-) diff --git a/modules/fusionax/formation.pl b/modules/fusionax/formation.pl index 3ee392a..0c61e53 100755 --- a/modules/fusionax/formation.pl +++ b/modules/fusionax/formation.pl @@ -103,7 +103,7 @@ while () s/CESDR\t//; s/CFAF\t//; s/CHEA\t//; - s/CHEAR\t//; + s/CHEAR\t/CHEAr/; s/CHEE&DD Session 9\t//; s/CESB\t//; s/CESSID\t//; diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql index dba7342..43e1261 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -478,6 +478,16 @@ UPDATE profile_education_enum SET abbreviation = 'IITs', country = 'IN' WHERE name = 'Indian Institutes of Technology'; +UPDATE profile_education_enum +SET name = 'Institut des Hautes Études de Défense Nationale', country = 'FR', url ='http://www.ihedn.fr/', +abbreviation = 'IHEDN' +WHERE name = 'IHEDN'; + +UPDATE profile_education_enum +SET name = "Centre des Hautes Études de l'Armement", country = 'FR', url ='http://www.chear.defense.gouv.fr/', +WHERE name = 'CHEAr' +WHERE name = 'CHEAr'; + -- Cleans duplicated entries UPDATE profile_education SET eduid = 0 WHERE eduid = 70; DELETE FROM profile_education_enum WHERE id = 70; @@ -490,7 +500,6 @@ DELETE FROM profile_education_degree WHERE eduid = 106; -- Adds new universities needed for the AX directory INSERT INTO profile_education_enum (name, url, country, abbreviation) VALUES ('Institut Supérieur de l\'Aéronautique et de l\'Espace', 'http://www.isae.fr/', 'FR', 'ISAE'), - ('Institut des Hautes Études de Défense Nationale', 'http://www.ihedn.fr/', 'FR', 'IHEDN'), ('École du Personnel Navigant d\'Essais et de Réception', 'http://www.defense.gouv.fr/dga/archives/l_epner_ecole_du_personnel_navigant_d_essais_et_de_reception', 'FR', 'EPNER'), ('Agrocampus Ouest', 'http://www.agrocampus-ouest.fr/', 'FR', 'ENSAR'), -- 2.1.4