X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F09_education.sql;h=7321f66e2b914bf041bf64bf27126c77321e6ca9;hb=b62be36bc636e303764792a36165be27d5802675;hp=58cbc90a97e8e8a9fcc6e91b07c869b5751411f9;hpb=f2b94b096b9a93a27efa95f8c36de63030cba534;p=platal.git diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql index 58cbc90..7321f66 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -26,6 +26,9 @@ INSERT INTO profile_education_degree_enum (abbreviation, degree, level) -- Updates universities UPDATE profile_education_enum +SET abbreviation = 'Université Claude Bernard', name = 'Université Claude Bernard (Lyon 1)' +WHERE name = 'Université Claude Bernard'; +UPDATE profile_education_enum SET abbreviation = 'Télécom', name = 'Télécom ParisTech', url = 'http://www.telecom-paristech.fr/' WHERE name = 'Télécom'; UPDATE profile_education_enum @@ -158,6 +161,9 @@ UPDATE profile_education_enum SET abbreviation = 'Grenoble INP', name = 'Institut Polytechnique de Grenoble', url = 'http://www.grenoble-inp.fr/' WHERE name = 'INPG'; UPDATE profile_education_enum +SET abbreviation = 'UJF' +WHERE name = 'Université Joseph-Fourier (Grenoble 1)'; +UPDATE profile_education_enum SET abbreviation = 'ESSEC', name = 'École Supérieure des Sciences Économiques et Commerciales' WHERE name = 'ESSEC'; UPDATE profile_education_enum @@ -205,8 +211,20 @@ WHERE name = 'INSA Rouen'; UPDATE profile_education_enum SET abbreviation = 'IAE de Paris', name = 'Institut d\'Administration des Entreprises de Paris', url = 'http://iae.univ-paris1.fr/' WHERE name = 'Institut d\'Administration des Entreprises'; +UPDATE profile_education_enum +SET abbreviation = 'CNSMDP', name = 'Conservatoire National Supérieur de Musique et de Danse de Paris' +WHERE name = 'Conservatoire national supérieur de musique et de danse de Paris'; +UPDATE profile_education_enum +SET name = 'École Normale de Musique de Paris' +WHERE name = 'École normale de musique de Paris'; UPDATE profile_education_enum +SET abbreviation = 'NDU', country = 'US' +WHERE name = 'National Defense University'; +UPDATE profile_education_enum +SET abbreviation = 'Brown', country = 'US' +WHERE name = 'Brown University'; +UPDATE profile_education_enum SET abbreviation = 'Berkeley', name = 'University of California, Berkeley', country = 'US' WHERE name = 'Univ Berkeley'; UPDATE profile_education_enum @@ -252,6 +270,9 @@ UPDATE profile_education_enum SET abbreviation = 'The Wharton School', name = 'The Wharton School of the University of Pennsylvania', country = 'US', url = 'http://www.wharton.upenn.edu/' WHERE name = 'Univ Wharton'; UPDATE profile_education_enum +SET country = 'US' +WHERE name = 'University of Pennsylvania'; +UPDATE profile_education_enum SET abbreviation = 'Columbia University', name = 'Columbia University in the City of New York', country = 'US' WHERE name = 'Univ Columbia'; UPDATE profile_education_enum @@ -311,6 +332,9 @@ WHERE name = 'University of Miami'; UPDATE profile_education_enum SET country = 'US' WHERE name = 'Purdue University'; +UPDATE profile_education_enum +SET abbreviation = 'CFA Institute', name = 'Chartered Financial Analyst Institute', country = 'US' +WHERE name = 'CFA Institute'; UPDATE profile_education_enum @@ -357,6 +381,9 @@ WHERE name = 'Univ Madrid'; UPDATE profile_education_enum SET abbreviation = 'UPF', name = 'Universitat Pompeu Fabra', country = 'ES' WHERE name = 'Univ Pompeu Fabra'; +UPDATE profile_education_enum +SET abbreviation = 'IE', country = 'ES' +WHERE name = 'Instituto de Empresa'; UPDATE profile_education_enum SET abbreviation = 'Chalmers', name = 'Chalmers Tekniska Högskola', country = 'SE' @@ -503,7 +530,7 @@ 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' +abbreviation = 'CHEAr' WHERE name = 'CHEAr'; -- Cleans duplicated entries @@ -541,7 +568,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'), - ('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'), ('Uniwersytet Gdański', 'http://www.univ.gda.pl/', 'PL', ''), @@ -552,7 +578,6 @@ INSERT INTO profile_education_enum (name, url, country, abbreviation) ('Universität Stuttgarti', 'http://www.uni-stuttgart.de/', 'DE', ''), ('Universitatea Politehnica din Bucureşti', 'http://www.pub.ro/', 'RO', 'Politehnica din Bucureşti'), ('University of Birmingham', 'http://www.bham.ac.uk/', 'GB', ''), - ('University of Pennsylvania', 'http://www.upenn.edu/', 'US', ''), ('University of Rome', '', 'IT', ''), ('University of Sheffield', 'http://www.shef.ac.uk/', 'GB', ''), ('University of Utah', 'http://www.utah.edu/', 'US', ''), @@ -560,7 +585,6 @@ INSERT INTO profile_education_enum (name, url, country, abbreviation) ('Urbana University', 'http://www.urbana.edu/', 'US', ''), ('Université de Technologie de Compiègne', 'http://www.utc.fr/', 'FR', 'UTC'), ('Virginia Polytechnic Institute and State University', 'http://www.vt.edu/', 'US', 'Virginia Tech'), - ('Université Claude Bernard (Lyon I)', 'http://www.univ-lyon1.fr/', 'FR', 'Université Claude Bernard'), ('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'), @@ -591,8 +615,8 @@ INSERT INTO profile_education_enum (name, url, country, abbreviation) -- 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 +REPLACE INTO profile_education (pid, id, fieldid, eduid, degreeid) + SELECT e.pid, 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")