X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F09_education.sql;h=003a0a1546c6c3f1a9d053c9ca70a60fdd0a7186;hb=5660032ac785d410f90e3f5b0d6948dc90b0cfea;hp=53099e61ef06f9be154e41cdea9d90cd5fa2c0b6;hpb=7c4e0f19204fa7ac1dfa0915ab11e6bee8c2edf0;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql
index 53099e6..003a0a1 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
@@ -308,6 +311,17 @@ 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 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'
@@ -533,12 +547,10 @@ 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', ''),
              ('College of Europe', 'http://www.coleurope.eu/', '', ''),
-             ('Purdue University', 'http://www.purdue.edu/', 'US', ''),
              ('Queen\'s University', 'http://www.queensu.ca/', 'CA', 'Queen\'s'),
              ('Université de Bretagne Occidentale', 'http://www.univ-brest.fr/', 'FR', 'UBO'),
              ('University of California, Davis', 'http://www.ucdavis.edu/', 'US', 'UC Davis'),
@@ -553,7 +565,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'),