X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F09_education.sql;h=6906340ec5434c3f563e312ba669f1cdf468cc44;hb=34465ab035104f739a54ec62660f04f874448627;hp=19356a1b38daf71dd622165f41062c71957dbd17;hpb=2de139ad47e0c320154959b1f7f225636ce16cf2;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql
index 19356a1..6906340 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 I)'
+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
@@ -205,8 +208,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 +267,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 +329,14 @@ 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
+SET country = 'HK', abbreviation = 'CityU'
+WHERE name = 'City University of Hong Kong';
 
 UPDATE profile_education_enum
 SET abbreviation = 'TU Berlin', name = 'Technische Universität Berlin', country = 'DE'
@@ -498,7 +524,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
@@ -536,7 +562,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', ''),
@@ -547,7 +572,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', ''),
@@ -555,7 +579,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'),
@@ -586,8 +609,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")