-- 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
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'
('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'),
('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'),