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
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 = '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 = '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';
+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
SET abbreviation = 'Berkeley', name = 'University of California, Berkeley', country = 'US'
WHERE name = 'Univ Berkeley';
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 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 abbreviation = 'Columbia University', name = 'Columbia University in the City of New York', country = 'US'
WHERE name = 'Univ Columbia';
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
UPDATE profile_education_enum
SET abbreviation = 'UM', country = 'US'
WHERE name = 'University of Miami';
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'
UPDATE profile_education_enum
SET abbreviation = 'TU Berlin', name = 'Technische Universität Berlin', country = 'DE'
UPDATE profile_education_enum
SET abbreviation = 'Technion', name = 'Israel Institute of Technology', country = 'IL'
WHERE name = 'Univ Technion';
UPDATE profile_education_enum
SET abbreviation = 'Technion', name = 'Israel Institute of Technology', country = 'IL'
WHERE name = 'Univ Technion';
UPDATE profile_education_enum
SET abbreviation = 'Oxford', name = 'University of Oxford', country = 'GB'
UPDATE profile_education_enum
SET abbreviation = 'Oxford', name = 'University of Oxford', country = 'GB'
SET abbreviation = '', country = 'GB'
WHERE name = 'University of Surrey';
UPDATE profile_education_enum
SET abbreviation = '', country = 'GB'
WHERE name = 'University of Surrey';
UPDATE profile_education_enum
+SET abbreviation = '', country = 'GB'
+WHERE name = 'Heriot-Watt University';
+UPDATE profile_education_enum
+SET abbreviation = 'UCL', country = 'GB'
+WHERE name = 'University College London';
+
+UPDATE profile_education_enum
SET abbreviation = 'OIV', country = 'FR'
WHERE name = 'Organisme International de la Vigne et du Vin';
UPDATE profile_education_enum
SET abbreviation = 'OIV', country = 'FR'
WHERE name = 'Organisme International de la Vigne et du Vin';
UPDATE profile_education_enum
SET abbreviation = 'IITs', country = 'IN'
WHERE name = 'Indian Institutes of Technology';
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/',
+abbreviation = 'CHEAr'
+WHERE name = 'CHEAr';
+
-- Cleans duplicated entries
UPDATE profile_education SET eduid = 0 WHERE eduid = 70;
DELETE FROM profile_education_enum WHERE id = 70;
-- Cleans duplicated entries
UPDATE profile_education SET eduid = 0 WHERE eduid = 70;
DELETE FROM profile_education_enum WHERE id = 70;
-- 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'),
-- 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'),
('É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'),
('É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'),
('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'),
('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'),
- ('University College London', 'http://www.ucl.ac.uk/', 'GB', 'UCL'),
- ('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/', '', ''),
('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/', '', ''),
('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'),
('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', ''),
('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'),
('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 Rome', '', 'IT', ''),
('University of Sheffield', 'http://www.shef.ac.uk/', 'GB', ''),
('University of Utah', 'http://www.utah.edu/', 'US', ''),
('University of Rome', '', 'IT', ''),
('University of Sheffield', 'http://www.shef.ac.uk/', 'GB', ''),
('University of Utah', 'http://www.utah.edu/', 'US', ''),
('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'),
('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'),
('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'),
('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'),
-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")
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")