| 1 | -- Updates diplomas |
| 2 | UPDATE profile_education_degree_enum SET abbreviation = 'PhD', degree = 'Doctorat', level = 8 WHERE degree = 'PhD'; |
| 3 | UPDATE profile_education_degree_enum SET abbreviation = 'Lic.', level = 3 WHERE degree = 'Licence'; |
| 4 | UPDATE profile_education_degree_enum SET abbreviation = 'MSc', degree = 'Master of Science', level = 5 WHERE degree = 'MS'; |
| 5 | UPDATE profile_education_degree_enum SET abbreviation = 'DEA', degree = "Diplôme d'Études Approfondies", level = 5 WHERE degree = 'DEA'; |
| 6 | UPDATE profile_education_degree_enum SET abbreviation = 'ME', degree = 'Master of Economics', level = 5 WHERE degree = 'ME'; |
| 7 | UPDATE profile_education_degree_enum SET abbreviation = 'MBA', degree = 'Master of Business Administration', level = 5 WHERE degree = 'MBA'; |
| 8 | UPDATE profile_education_degree_enum SET abbreviation = 'MiF', degree = 'Master in Finance', level = 5 WHERE degree = 'MiF'; |
| 9 | UPDATE profile_education_degree_enum SET abbreviation = 'MPA', degree = 'Master of Public Administration', level = 5 WHERE degree = 'MPA'; |
| 10 | UPDATE profile_education_degree_enum SET abbreviation = 'MIA', degree = 'Master of International Affairs', level = 5 WHERE degree = 'MIA'; |
| 11 | UPDATE profile_education_degree_enum SET abbreviation = 'Corps', degree = 'Corps', level = 5 WHERE degree = 'Corps'; |
| 12 | UPDATE profile_education_degree_enum SET abbreviation = 'Ing.', degree = 'Ingénieur', level = 5 WHERE degree = 'Ingénieur'; |
| 13 | UPDATE profile_education_degree_enum SET abbreviation = 'Dipl.', degree = 'Diplôme', level = 0 WHERE degree = 'Diplôme'; |
| 14 | |
| 15 | INSERT INTO profile_education_degree_enum (abbreviation, degree, level) |
| 16 | VALUES ('Agr.', 'Agrégation', 4), ('CAPES', 'Certificat d\'Aptitude au Professorat de l\'Enseignement du Second degré', 4), |
| 17 | ('DESS', 'Diplôme d\'Études Supérieures Spécialisées', 5), ('BTS', 'Brevet de Technicien Supérieur', 2), ('MA', 'Master of Arts', 5), |
| 18 | ('Maîtr.', 'Maîtrise', 4), ('HDR', 'Habilitation à Diriger des Recherches', 8), ('DEUG', 'Diplôme d\'Études Universitaires Générales', 2), |
| 19 | ('MEE', 'Master of Electrical Engineering', 5), ('MPhil', 'Master of Philosophy', 5), ('MUP', 'Master of Urban Planning', 5), |
| 20 | ('MME', 'Master of Mechanical Engineering', 5), ('MCP', 'Master of City Planning', 5), ('BA', 'Bachelor of Arts', 3), |
| 21 | ('MEl', 'Master of Electronics', 5), ('MM', 'Master of Management', 5), ('MIB', 'Master of International Business', 5), |
| 22 | ('MC', 'Master of Chemistry', 5), ('MEM', 'Master of Engineering in Manufacturing', 5), ('MEng', 'Master of Engineering', 5), |
| 23 | ('MCE', 'Master of Chemical Engineering', 5), ('M', 'Master', 5), ('MMS', 'Master of Military Studies', 5), |
| 24 | ('MSI', 'Master of Science in Information', 5), |
| 25 | ('DESCF', 'Diplôme d\'Études Supérieures Comptables et Financières', 5), ('MB', 'Master of Biotechnology', 5); |
| 26 | |
| 27 | -- Updates universities |
| 28 | UPDATE profile_education_enum |
| 29 | SET abbreviation = 'Université Claude Bernard', name = 'Université Claude Bernard (Lyon I)' |
| 30 | WHERE name = 'Université Claude Bernard'; |
| 31 | UPDATE profile_education_enum |
| 32 | SET abbreviation = 'Télécom', name = 'Télécom ParisTech', url = 'http://www.telecom-paristech.fr/' |
| 33 | WHERE name = 'Télécom'; |
| 34 | UPDATE profile_education_enum |
| 35 | SET abbreviation = 'ENGREF', name = 'École Nationale du Génie Rural des Eaux et des Forêts', url = 'http://www.agroparistech.fr/-Ecole-interne-ENGREF-.html' |
| 36 | WHERE name = 'ENGREF'; |
| 37 | UPDATE profile_education_enum |
| 38 | SET abbreviation = 'INSEE', name = 'Institut National de la Statistique et des Études Économiques' |
| 39 | WHERE name = 'INSEE'; |
| 40 | UPDATE profile_education_enum |
| 41 | SET abbreviation = 'Météo', name = 'École Nationale de la Météorologie' |
| 42 | WHERE name = 'Météo'; |
| 43 | UPDATE profile_education_enum |
| 44 | SET abbreviation = 'Mines', name = 'Mines ParisTech' |
| 45 | WHERE name = 'Mines'; |
| 46 | UPDATE profile_education_enum |
| 47 | SET abbreviation = 'Ponts', name = 'École des Ponts ParisTech' |
| 48 | WHERE name = 'Ponts'; |
| 49 | UPDATE profile_education_enum |
| 50 | SET abbreviation = 'ENSAE', name = 'École Nationale de la Statistique et de l\'Administration Économique ParisTech' |
| 51 | WHERE name = 'ENSAE'; |
| 52 | UPDATE profile_education_enum |
| 53 | SET abbreviation = 'ENSAM', name = 'Arts et Métiers ParisTech' |
| 54 | WHERE name = 'ENSAM'; |
| 55 | UPDATE profile_education_enum |
| 56 | SET abbreviation = 'ENSEEIHT', name = 'École Nationale Supérieure d\'Électrotechnique, d\'Électronique, d\'Informatique, d\'Hydraulique et des Télécommunications' |
| 57 | WHERE name = 'ENSEEIHT'; |
| 58 | UPDATE profile_education_enum |
| 59 | SET abbreviation = 'ENSIMAG', name = 'École Nationale Supérieure d\'Informatique et de Mathématiques Appliquées de Grenoble', url = 'http://ensimag.grenoble-inp.fr/' |
| 60 | WHERE name = 'ENSIMAG'; |
| 61 | UPDATE profile_education_enum |
| 62 | SET abbreviation = 'ENSTA', name = 'École Nationale Supérieure de Techniques Avancées' |
| 63 | WHERE name = 'ENSTA'; |
| 64 | UPDATE profile_education_enum |
| 65 | SET abbreviation = 'ENSPM', name = 'École Nationale Supérieure du Pétrole et des Moteurs' |
| 66 | WHERE name = 'ENSPM'; |
| 67 | UPDATE profile_education_enum |
| 68 | SET abbreviation = 'INAPG', name = 'Institut National Agronomique Paris-Grignon', url = 'http://www.agroparistech.fr/' |
| 69 | WHERE name = 'INAPG'; |
| 70 | UPDATE profile_education_enum |
| 71 | SET abbreviation = 'HEC', name = 'École des Hautes Études Commerciales' |
| 72 | WHERE name = 'HEC'; |
| 73 | UPDATE profile_education_enum |
| 74 | SET abbreviation = 'X', name = 'École polytechnique', url = 'http://www.polytechnique.edu/' |
| 75 | WHERE name = 'X'; |
| 76 | UPDATE profile_education_enum |
| 77 | SET abbreviation = 'SUPAERO', name = 'École Nationale Supérieure de l\'Aéronautique et de l\'Espace', url = 'http://www.isae.fr/' |
| 78 | WHERE name = 'Supaéro'; |
| 79 | UPDATE profile_education_enum |
| 80 | SET abbreviation = 'SupOptique', name = 'Institut d\'Optique Théorique et Appliquée' |
| 81 | WHERE name = 'Supoptique'; |
| 82 | UPDATE profile_education_enum |
| 83 | SET abbreviation = 'Supélec', name = 'École Supérieure d\'Électricité' |
| 84 | WHERE name = 'Supélec'; |
| 85 | UPDATE profile_education_enum |
| 86 | SET abbreviation = 'ENA', name = 'École Nationale d\'Administration' |
| 87 | WHERE name = 'ENA'; |
| 88 | UPDATE profile_education_enum |
| 89 | SET abbreviation = 'INSEAD', name = 'Institut Européen d\'Administration des Affaires', url = 'http://www.insead.edu/' |
| 90 | WHERE name = 'INSEAD'; |
| 91 | UPDATE profile_education_enum |
| 92 | SET abbreviation = 'Chimie Paris', name = 'Chimie Paris ParisTech', url = 'http://www.enscp.fr/' |
| 93 | WHERE name = 'Chimie Paris'; |
| 94 | UPDATE profile_education_enum |
| 95 | SET abbreviation = 'INSTN', name = 'Institut National des Sciences et Techniques Nucléaires' |
| 96 | WHERE name = 'INSTN'; |
| 97 | UPDATE profile_education_enum |
| 98 | SET abbreviation = 'UMPC', name = 'Université Pierre-et-Marie-Curie (Paris-VI)', url = 'http://www.upmc.fr/' |
| 99 | WHERE name = 'Univ Paris 6 (Pierre et Marie Curie - Jussieu)'; |
| 100 | UPDATE profile_education_enum |
| 101 | SET abbreviation = 'Paris-Sud', name = 'Université Paris-Sud (Paris-XI)' |
| 102 | WHERE name = 'Univ Paris 11 (Orsay)'; |
| 103 | UPDATE profile_education_enum |
| 104 | SET abbreviation = 'Paris-Diderot', name = 'Université Denis Diderot (Paris-VII)', url = 'http://www.univ-paris7.fr/' |
| 105 | WHERE name = 'Univ Paris 7 (Denis Diderot - Jussieu)'; |
| 106 | UPDATE profile_education_enum |
| 107 | SET abbreviation = 'Dauphine', name = 'Université de Technologie en Sciences des Organisations et de la Décision de Paris-Dauphine (Paris-IX)' |
| 108 | WHERE name = 'Univ Paris 9 (Dauphine)'; |
| 109 | UPDATE profile_education_enum |
| 110 | SET abbreviation = 'Panthéon-Sorbonne', name = 'Université Panthéon-Sorbonne (Paris-I)' |
| 111 | WHERE name = 'Univ Paris 1 (Panthéon-Sorbonne)'; |
| 112 | UPDATE profile_education_enum |
| 113 | SET abbreviation = 'Nanterre', name = 'Université de Paris Ouest - Nanterre La Défense (Paris-X)' |
| 114 | WHERE name = 'Univ Paris 10 (Nanterre)'; |
| 115 | UPDATE profile_education_enum |
| 116 | SET abbreviation = 'Paris-Descartes', name = 'Université Paris Descartes (Paris-V)' |
| 117 | WHERE name = 'Univ Paris 5 (René Descartes)'; |
| 118 | UPDATE profile_education_enum |
| 119 | SET abbreviation = 'Sorbonne Nouvelle', name = 'Université Sorbonne Nouvelle (Paris-III)' |
| 120 | WHERE name = 'Univ Paris 3 (Sorbonne Nouvelle)'; |
| 121 | UPDATE profile_education_enum |
| 122 | SET abbreviation = 'Vincennes-Saint-Denis', name = 'Université de Vincennes à Saint-Denis (Paris-VIII)' |
| 123 | WHERE name = 'Univ Paris 8 (Vincennes - Saint Denis)'; |
| 124 | UPDATE profile_education_enum |
| 125 | SET abbreviation = 'Paris-Val de Marne', name = 'Université Paris-Val de Marne (Paris-XII)' |
| 126 | WHERE name = 'Univ Paris 12 (Val de Marne)'; |
| 127 | UPDATE profile_education_enum |
| 128 | SET abbreviation = 'Paris-Nord', name = 'Université Paris-Nord (Paris-XIII)' |
| 129 | WHERE name = 'Univ Paris 13 (Nord)'; |
| 130 | UPDATE profile_education_enum |
| 131 | SET abbreviation = 'Paris-Sorbonne', name = 'Université Paris-Sorbonne (Paris-IV)' |
| 132 | WHERE name = 'Univ Paris 4 (Sorbonne)'; |
| 133 | UPDATE profile_education_enum |
| 134 | SET abbreviation = 'Assas', name = 'Université Panthéon-Assas (Paris-II)' |
| 135 | WHERE name = 'Univ Paris 2 (Panthéon - Assas)'; |
| 136 | UPDATE profile_education_enum |
| 137 | SET abbreviation = 'CDI', name = 'Collège des Ingénieurs' |
| 138 | WHERE name = 'Collège des Ingénieurs'; |
| 139 | UPDATE profile_education_enum |
| 140 | SET abbreviation = 'ENS Ulm', name = 'École Normale Supérieure' |
| 141 | WHERE name = 'ENS Ulm'; |
| 142 | UPDATE profile_education_enum |
| 143 | SET abbreviation = 'ENS Lyon', name = 'École Normale Supérieure de Lyon ' |
| 144 | WHERE name = 'ENS Lyon'; |
| 145 | UPDATE profile_education_enum |
| 146 | SET abbreviation = 'ENS Cachan', name = 'École Normale Supérieure de Cachan' |
| 147 | WHERE name = 'ENS Cachan'; |
| 148 | UPDATE profile_education_enum |
| 149 | SET abbreviation = 'ESPCI', name = 'ESPCI ParisTech' |
| 150 | WHERE name = 'ESPCI'; |
| 151 | UPDATE profile_education_enum |
| 152 | SET abbreviation = 'Sciences Po', name = 'Institut d\'Études Politiques de Paris' |
| 153 | WHERE name = 'IEP Paris'; |
| 154 | UPDATE profile_education_enum |
| 155 | SET abbreviation = 'EHESS', name = 'École des Hautes Études en Sciences Sociales' |
| 156 | WHERE name = 'EHESS'; |
| 157 | UPDATE profile_education_enum |
| 158 | SET abbreviation = 'ENSIC', name = 'École Nationale Supérieure des Industries Chimiques' |
| 159 | WHERE name = 'ENSIC'; |
| 160 | UPDATE profile_education_enum |
| 161 | SET abbreviation = 'Grenoble INP', name = 'Institut Polytechnique de Grenoble', url = 'http://www.grenoble-inp.fr/' |
| 162 | WHERE name = 'INPG'; |
| 163 | UPDATE profile_education_enum |
| 164 | SET abbreviation = 'ESSEC', name = 'École Supérieure des Sciences Économiques et Commerciales' |
| 165 | WHERE name = 'ESSEC'; |
| 166 | UPDATE profile_education_enum |
| 167 | SET abbreviation = 'INPL', name = 'Institut National Polytechnique de Lorraine' |
| 168 | WHERE name = 'INPL'; |
| 169 | UPDATE profile_education_enum |
| 170 | SET abbreviation = 'ENSAPB', name = 'École Nationale Supérieure d\'Architecture de Paris-Belleville' |
| 171 | WHERE name = 'EAPB (Ecole Architecture Paris Belleville)'; |
| 172 | UPDATE profile_education_enum |
| 173 | SET abbreviation = 'ENSAPLV', name = 'École Nationale Supérieure d\'Architecture de Paris-La Villette' |
| 174 | WHERE name = 'EAPLV (Ecole Architecture Paris La Villette)'; |
| 175 | UPDATE profile_education_enum |
| 176 | SET abbreviation = 'EAVT', name = 'École d\'Architecture de la Ville et des Territoires à Marne-la-Vallée' |
| 177 | WHERE name = 'EAVT (Ecole d\'architecture de Marne La Vallee)'; |
| 178 | UPDATE profile_education_enum |
| 179 | SET abbreviation = 'ENSP', name = 'École Nationale Supérieure du Paysage' |
| 180 | WHERE name = 'ENSP Versailles'; |
| 181 | UPDATE profile_education_enum |
| 182 | SET abbreviation = '', name = 'École Nationale Supérieure du Génie Maritime', url = 'http://www.ensta.fr/' |
| 183 | WHERE name = 'Génie maritime (Ecole nationale supérieur du)'; |
| 184 | UPDATE profile_education_enum |
| 185 | SET abbreviation = 'CPA de Paris', name = 'Centre de Perfectionnement aux Affaires de Paris', url = '' |
| 186 | WHERE name = 'Centre de Perfectionnement aux Affaires'; |
| 187 | UPDATE profile_education_enum |
| 188 | SET abbreviation = '', name = 'ESCP-EAP', url = 'http://www.escp-eap.eu/' |
| 189 | WHERE name = 'ESCP-EAP'; |
| 190 | UPDATE profile_education_enum |
| 191 | SET abbreviation = 'CEPE', name = 'Centre d\'Études des Programmes Économiques' |
| 192 | WHERE name = 'CEPE'; |
| 193 | UPDATE profile_education_enum |
| 194 | SET abbreviation = '', name = 'Institut des Actuaires', url = 'http://www.institutdesactuaires.com/' |
| 195 | WHERE name = 'Institut des actuaires'; |
| 196 | UPDATE profile_education_enum |
| 197 | SET abbreviation = 'CEIPI', name = 'Centre d\'Études Internationales de la Propriété Industrielle' |
| 198 | WHERE name = 'CEIPI'; |
| 199 | UPDATE profile_education_enum |
| 200 | SET abbreviation = 'Université Paul-Sabatier', name = 'Université Paul-Sabatier (Toulouse III)' |
| 201 | WHERE name = 'Univ Toulouse III (Paul Sabatier)'; |
| 202 | UPDATE profile_education_enum |
| 203 | SET abbreviation = 'Université de Provence', name = 'Université de Provence (Aix-Marseille I)' |
| 204 | WHERE name = 'Université de Provence'; |
| 205 | UPDATE profile_education_enum |
| 206 | SET abbreviation = 'INSA Rouen', name = 'Institut National des Sciences Appliquées de Rouen' |
| 207 | WHERE name = 'INSA Rouen'; |
| 208 | UPDATE profile_education_enum |
| 209 | SET abbreviation = 'IAE de Paris', name = 'Institut d\'Administration des Entreprises de Paris', url = 'http://iae.univ-paris1.fr/' |
| 210 | WHERE name = 'Institut d\'Administration des Entreprises'; |
| 211 | SET abbreviation = 'CNSMDP', name = 'Conservatoire National Supérieur de Musique et de Danse de Paris' |
| 212 | WHERE name = 'Conservatoire national supérieur de musique et de danse de Paris'; |
| 213 | SET name = 'École Normale de Musique de Paris' |
| 214 | WHERE name = 'École normale de musique de Paris'; |
| 215 | |
| 216 | UPDATE profile_education_enum |
| 217 | SET abbreviation = 'NDU', country = 'US' |
| 218 | WHERE name = 'National Defense University'; |
| 219 | UPDATE profile_education_enum |
| 220 | SET abbreviation = 'Brown', country = 'US' |
| 221 | WHERE name = 'Brown University'; |
| 222 | UPDATE profile_education_enum |
| 223 | SET abbreviation = 'Berkeley', name = 'University of California, Berkeley', country = 'US' |
| 224 | WHERE name = 'Univ Berkeley'; |
| 225 | UPDATE profile_education_enum |
| 226 | SET abbreviation = 'CalTech', name = 'California Institute of Technology', country = 'US' |
| 227 | WHERE name = 'CalTech'; |
| 228 | UPDATE profile_education_enum |
| 229 | SET abbreviation = 'MIT', name = 'Massachusetts Institute of Technology', country = 'US' |
| 230 | WHERE name = 'Massachusetts Institute of Technology'; |
| 231 | UPDATE profile_education_enum |
| 232 | SET abbreviation = 'Cornell', name = 'Cornell University', country = 'US' |
| 233 | WHERE name = 'Univ Cornell'; |
| 234 | UPDATE profile_education_enum |
| 235 | SET abbreviation = 'Stanford', name = 'Stanford University', country = 'US' |
| 236 | WHERE name = 'Univ Stanford'; |
| 237 | UPDATE profile_education_enum |
| 238 | SET abbreviation = 'UCLA', name = 'University of California, Los Angeles', country = 'US' |
| 239 | WHERE name = 'Univ UCLA'; |
| 240 | UPDATE profile_education_enum |
| 241 | SET abbreviation = '', name = 'University of Illinois', country = 'US' |
| 242 | WHERE name = 'Univ Illinois'; |
| 243 | UPDATE profile_education_enum |
| 244 | SET abbreviation = 'Michigan', name = 'University of Michigan, Ann Arbor', country = 'US' |
| 245 | WHERE name = 'Univ Michigan'; |
| 246 | UPDATE profile_education_enum |
| 247 | SET abbreviation = '', name = 'Seattle University', country = 'US' |
| 248 | WHERE name = 'Univ Seattle'; |
| 249 | UPDATE profile_education_enum |
| 250 | SET abbreviation = 'UGA', name = 'University of Georgia', country = 'US' |
| 251 | WHERE name = 'Univ Georgia'; |
| 252 | UPDATE profile_education_enum |
| 253 | SET abbreviation = 'UT Austin', name = 'University of Texas at Austin', country = 'US' |
| 254 | WHERE name = 'Univ Texas'; |
| 255 | UPDATE profile_education_enum |
| 256 | SET abbreviation = 'RIP', name = 'Rensselaer Polytechnic Institute', country = 'US' |
| 257 | WHERE name = 'Univ Rensselaer'; |
| 258 | UPDATE profile_education_enum |
| 259 | SET abbreviation = 'NYU', name = 'New York University', country = 'US' |
| 260 | WHERE name = 'Univ New York'; |
| 261 | UPDATE profile_education_enum |
| 262 | SET abbreviation = 'Harvard', name = 'Harvard University', country = 'US' |
| 263 | WHERE name = 'Univ Harvard'; |
| 264 | UPDATE profile_education_enum |
| 265 | SET abbreviation = 'The Wharton School', name = 'The Wharton School of the University of Pennsylvania', country = 'US', url = 'http://www.wharton.upenn.edu/' |
| 266 | WHERE name = 'Univ Wharton'; |
| 267 | UPDATE profile_education_enum |
| 268 | SET country = 'US' |
| 269 | WHERE name = 'University of Pennsylvania'; |
| 270 | UPDATE profile_education_enum |
| 271 | SET abbreviation = 'Columbia University', name = 'Columbia University in the City of New York', country = 'US' |
| 272 | WHERE name = 'Univ Columbia'; |
| 273 | UPDATE profile_education_enum |
| 274 | SET abbreviation = 'WSBS', name = 'Watson School of Biological Sciences', country = 'US' |
| 275 | WHERE name = 'Watson School of Biological Sciences'; |
| 276 | UPDATE profile_education_enum |
| 277 | SET abbreviation = '', name = 'Colorado School of Mines', country = 'US' |
| 278 | WHERE name = 'Univ Colorado School of Mines'; |
| 279 | UPDATE profile_education_enum |
| 280 | SET abbreviation = 'Princeton', name = 'Princeton University', country = 'US' |
| 281 | WHERE name = 'Univ Princeton'; |
| 282 | UPDATE profile_education_enum |
| 283 | SET abbreviation = 'Georgia Tech', name = 'Georgia Institute of Technology', country = 'US' |
| 284 | WHERE name = 'GeorgiaTech'; |
| 285 | UPDATE profile_education_enum |
| 286 | SET abbreviation = 'JHU', name = 'Johns Hopkins University', country = 'US' |
| 287 | WHERE name = 'Univ Johns Hopkins'; |
| 288 | UPDATE profile_education_enum |
| 289 | SET abbreviation = '', name = 'University of Chicago', country = 'US' |
| 290 | WHERE name = 'Univ Chicago'; |
| 291 | UPDATE profile_education_enum |
| 292 | SET abbreviation = 'Yale', name = 'Yale University', country = 'US' |
| 293 | WHERE name = 'Univ Yale'; |
| 294 | UPDATE profile_education_enum |
| 295 | SET abbreviation = 'TAMU', name = 'Texas A&M University', country = 'US' |
| 296 | WHERE name = 'Texas A&M University'; |
| 297 | UPDATE profile_education_enum |
| 298 | SET abbreviation = 'UCSB', name = 'University of California, Santa Barbara', country = 'US' |
| 299 | WHERE name = 'Univ Santa-Barbara'; |
| 300 | UPDATE profile_education_enum |
| 301 | SET abbreviation = 'Kellogg', name = 'Kellogg School of Management', country = 'US' |
| 302 | WHERE name = 'Kellogg School of Management'; |
| 303 | UPDATE profile_education_enum |
| 304 | SET abbreviation = '', name = 'University of Iowa', country = 'US' |
| 305 | WHERE name = 'Univ Iowa'; |
| 306 | UPDATE profile_education_enum |
| 307 | SET abbreviation = 'UW-Madison', name = 'University of Wisconsin-Madison', country = 'US', url = 'http://www.wisc.edu/' |
| 308 | WHERE name = 'Univ Wisconsin-Madison'; |
| 309 | UPDATE profile_education_enum |
| 310 | SET abbreviation = 'UCSD', name = 'University of California, San Diego', country = 'US' |
| 311 | WHERE name = 'Univ San Diego'; |
| 312 | UPDATE profile_education_enum |
| 313 | SET abbreviation = 'NU', name = 'Northwestern University', country = 'US' |
| 314 | WHERE name = 'Univ Northwestern'; |
| 315 | UPDATE profile_education_enum |
| 316 | SET abbreviation = 'CU', name = 'University of Colorado at Boulder', country = 'US' |
| 317 | WHERE name = 'Univ Colorado at Boulder'; |
| 318 | UPDATE profile_education_enum |
| 319 | SET abbreviation = 'CMU', name = 'Carnegie Mellon University', country = 'US' |
| 320 | WHERE name = 'Univ Carnegie Mellon'; |
| 321 | UPDATE profile_education_enum |
| 322 | SET abbreviation = 'Carolina', name = 'University of North Carolina at Chapel Hill', country = 'US' |
| 323 | WHERE name = 'Univ of North Carolina at Chapel Hill'; |
| 324 | UPDATE profile_education_enum |
| 325 | SET abbreviation = 'UM', country = 'US' |
| 326 | WHERE name = 'University of Miami'; |
| 327 | UPDATE profile_education_enum |
| 328 | SET country = 'US' |
| 329 | WHERE name = 'Purdue University'; |
| 330 | UPDATE profile_education_enum |
| 331 | SET abbreviation = 'CFA Institute', name = 'Chartered Financial Analyst Institute', country = 'US' |
| 332 | WHERE name = 'CFA Institute'; |
| 333 | |
| 334 | |
| 335 | UPDATE profile_education_enum |
| 336 | SET country = 'HK', abbreviation = 'CityU' |
| 337 | WHERE name = 'City University of Hong Kong'; |
| 338 | |
| 339 | UPDATE profile_education_enum |
| 340 | SET abbreviation = 'TU Berlin', name = 'Technische Universität Berlin', country = 'DE' |
| 341 | WHERE name = 'Univ TU Berlin'; |
| 342 | UPDATE profile_education_enum |
| 343 | SET abbreviation = 'TU Darmstadt', name = 'Technische Universität Darmstadt', country = 'DE' |
| 344 | WHERE name = 'Univ TU Darmstadt'; |
| 345 | UPDATE profile_education_enum |
| 346 | SET abbreviation = 'TU München', name = 'Technische Universität München', country = 'DE' |
| 347 | WHERE name = 'Univ TU München'; |
| 348 | UPDATE profile_education_enum |
| 349 | SET abbreviation = 'Universität Karlsruhe', name = 'Universität Karlsruhe (TH)', country = 'DE' |
| 350 | WHERE name = 'Univ Karlsruhe'; |
| 351 | UPDATE profile_education_enum |
| 352 | SET abbreviation = 'RWTH', name = 'RWTH Aachen University', country = 'DE' |
| 353 | WHERE name = 'Univ RWTH-Aachen'; |
| 354 | UPDATE profile_education_enum |
| 355 | SET abbreviation = '', name = 'Universität Stuttgart', country = 'DE' |
| 356 | WHERE name = 'Univ Stuttgart'; |
| 357 | |
| 358 | UPDATE profile_education_enum |
| 359 | SET abbreviation = 'EPM', name = 'École Polytechnique de Montréal', country = 'CA' |
| 360 | WHERE name = 'EP Montréal'; |
| 361 | UPDATE profile_education_enum |
| 362 | SET abbreviation = 'UBC', name = 'University of British Columbia', country = 'CA' |
| 363 | WHERE name = 'Univ British Columbia'; |
| 364 | UPDATE profile_education_enum |
| 365 | SET abbreviation = 'McGill', name = 'McGill University', country = 'CA' |
| 366 | WHERE name = 'Univ McGill'; |
| 367 | UPDATE profile_education_enum |
| 368 | SET abbreviation = 'UQÀM', name = 'Université du Québec à Montréal', country = 'CA' WHERE id = 125; |
| 369 | |
| 370 | UPDATE profile_education_enum |
| 371 | SET abbreviation = 'UPC', name = 'Universitat Politècnica de Catalunya', country = 'ES' |
| 372 | WHERE name = 'Univ Catalunya'; |
| 373 | UPDATE profile_education_enum |
| 374 | SET abbreviation = 'UPM', name = 'Universidad Politècnica de Madrid', country = 'ES' |
| 375 | WHERE name = 'Univ Madrid'; |
| 376 | UPDATE profile_education_enum |
| 377 | SET abbreviation = 'UPF', name = 'Universitat Pompeu Fabra', country = 'ES' |
| 378 | WHERE name = 'Univ Pompeu Fabra'; |
| 379 | |
| 380 | UPDATE profile_education_enum |
| 381 | SET abbreviation = 'Chalmers', name = 'Chalmers Tekniska Högskola', country = 'SE' |
| 382 | WHERE name = 'Univ Chalmers'; |
| 383 | UPDATE profile_education_enum |
| 384 | SET abbreviation = 'KTH', name = 'Kungliga Tekniska Högskolan', country = 'SE' |
| 385 | WHERE name = 'Univ KTH'; |
| 386 | UPDATE profile_education_enum |
| 387 | SET abbreviation = '', name = 'Stockholms Universitet', country = 'SE' |
| 388 | WHERE name = 'Univ Stockholm'; |
| 389 | |
| 390 | UPDATE profile_education_enum |
| 391 | SET abbreviation = 'TU Delft', name = 'Technische Universiteit Delft', country = 'NL' |
| 392 | WHERE name = 'Univ TU Delft'; |
| 393 | UPDATE profile_education_enum |
| 394 | SET abbreviation = 'RSM', name = 'Rotterdam School of Management, Erasmus University', country = 'NL' |
| 395 | WHERE name = 'RSM'; |
| 396 | UPDATE profile_education_enum |
| 397 | SET abbreviation = '', name = 'Universiteit Leiden', country = 'NL' |
| 398 | WHERE name = 'Univ Leiden'; |
| 399 | |
| 400 | UPDATE profile_education_enum |
| 401 | SET abbreviation = '', name = 'Kyoto University', country = 'JP' |
| 402 | WHERE name = 'Univ Kyoto'; |
| 403 | UPDATE profile_education_enum |
| 404 | SET abbreviation = 'Todai', name = 'University of Tokyo', country = 'JP' |
| 405 | WHERE name = 'Univ Tokyo'; |
| 406 | UPDATE profile_education_enum |
| 407 | SET abbreviation = 'Tokyo Tech', name = 'Tokyo Institute of Technology', country = 'JP' |
| 408 | WHERE name = 'Tokyo Institute of Technology'; |
| 409 | |
| 410 | UPDATE profile_education_enum |
| 411 | SET abbreviation = 'UNIL', name = 'Université de Lausanne', country = 'CH' |
| 412 | WHERE name = 'Univ Lausanne'; |
| 413 | UPDATE profile_education_enum |
| 414 | SET abbreviation = '', name = 'Universität Zürich', country = 'CH' |
| 415 | WHERE name = 'Univ Zürich'; |
| 416 | UPDATE profile_education_enum |
| 417 | SET abbreviation = 'EPFL', name = 'École Polytechnique Fédérale de Lausanne', country = 'CH' |
| 418 | WHERE name = 'EP Fédérale Lausanne'; |
| 419 | UPDATE profile_education_enum |
| 420 | SET abbreviation = 'IMD', name = 'International Institute for Management Development', country = 'CH' |
| 421 | WHERE name = 'Institute for Management Development'; |
| 422 | UPDATE profile_education_enum |
| 423 | SET abbreviation = 'ETH Zürich', name = 'Eidgenössische Technische Hochschule Zürich', country = 'CH' |
| 424 | WHERE name = 'ETH Zürich'; |
| 425 | |
| 426 | UPDATE profile_education_enum |
| 427 | SET abbreviation = 'UNIMI', name = 'Università degli Studi di Milano', country = 'IT' |
| 428 | WHERE name = 'Univ Milano'; |
| 429 | UPDATE profile_education_enum |
| 430 | SET abbreviation = 'UNITO', name = 'Università degli Studi di Torino', country = 'IT' |
| 431 | WHERE name = 'Univ Torino'; |
| 432 | UPDATE profile_education_enum |
| 433 | SET abbreviation = '', name = 'Politecnico di Milano', country = 'IT' |
| 434 | WHERE name = 'Politecnico di Milano'; |
| 435 | UPDATE profile_education_enum |
| 436 | SET abbreviation = 'EUI', name = 'European University Institute', country = 'IT' |
| 437 | WHERE name = 'Institut Universitaire Européen'; |
| 438 | UPDATE profile_education_enum |
| 439 | SET abbreviation = 'Università Bocconi', name = 'Università Commerciale Luigi Bocconi', url = 'http://www.unibocconi.it/', country = 'IT' |
| 440 | WHERE name = 'Université Bocconi'; |
| 441 | |
| 442 | UPDATE profile_education_enum |
| 443 | SET abbreviation = 'MGU', name = 'Lomonosov Moscow State University', country = 'RU' |
| 444 | WHERE name = 'Univ Moscow (lomonosov)'; |
| 445 | UPDATE profile_education_enum |
| 446 | SET abbreviation = 'Bauman MSTU', name = 'Bauman Moscow State Technical University', country = 'RU', url = 'http://www.bmstu.ru/' |
| 447 | WHERE name = 'Univ Moscow (Bauman)'; |
| 448 | |
| 449 | UPDATE profile_education_enum |
| 450 | SET abbreviation = 'Technion', name = 'Israel Institute of Technology', country = 'IL' |
| 451 | WHERE name = 'Univ Technion'; |
| 452 | UPDATE profile_education_enum |
| 453 | SET abbreviation = '', name = 'Weizmann Institute of Science', country = 'IL' |
| 454 | WHERE name = 'Institut Weizmann'; |
| 455 | |
| 456 | UPDATE profile_education_enum |
| 457 | SET abbreviation = 'Oxford', name = 'University of Oxford', country = 'GB' |
| 458 | WHERE name = 'Univ Oxford'; |
| 459 | UPDATE profile_education_enum |
| 460 | SET abbreviation = '', name = 'London Business School', country = 'GB' |
| 461 | WHERE name = 'London Business School'; |
| 462 | UPDATE profile_education_enum |
| 463 | SET abbreviation = 'LSE', name = 'The London School of Economics and Political Science', country = 'GB' |
| 464 | WHERE name = 'London School of Economics'; |
| 465 | UPDATE profile_education_enum |
| 466 | SET abbreviation = 'Cambridge', name = 'University of Cambridge', country = 'GB' |
| 467 | WHERE name = 'Univ Cambridge'; |
| 468 | UPDATE profile_education_enum |
| 469 | SET abbreviation = 'Imperial College', name = 'Imperial College London', country = 'GB', url = 'http://www3.imperial.ac.uk/' |
| 470 | WHERE name = 'Imperial College'; |
| 471 | UPDATE profile_education_enum |
| 472 | SET abbreviation = 'Henley', name = 'Henley Management College', country = 'GB', url = 'http://www.henley.reading.ac.uk/' |
| 473 | WHERE name = 'Henley Management College'; |
| 474 | UPDATE profile_education_enum |
| 475 | SET abbreviation = '', name = 'University of Southampton', country = 'GB', url = 'http://www.soton.ac.uk/' |
| 476 | WHERE name = 'Univ Southampton'; |
| 477 | UPDATE profile_education_enum |
| 478 | SET abbreviation = '', name = 'Cardiff University', country = 'GB' |
| 479 | WHERE name = 'Univ Cardiff'; |
| 480 | |
| 481 | UPDATE profile_education_enum |
| 482 | SET abbreviation = 'UNSW', name = 'The University of New South Wales', country = 'AU' |
| 483 | WHERE name = 'Univ New South Wales (Sydney Australia)'; |
| 484 | |
| 485 | UPDATE profile_education_enum |
| 486 | SET abbreviation = 'THU', name = 'Tsinghua University', country = 'CN' |
| 487 | WHERE name = 'Univ Tsinghua'; |
| 488 | |
| 489 | UPDATE profile_education_enum |
| 490 | SET abbreviation = 'NUS', name = 'National University of Singapore', country = 'SG' |
| 491 | WHERE name = 'National University of Singapore'; |
| 492 | |
| 493 | UPDATE profile_education_enum |
| 494 | SET abbreviation = 'NTNU', name = 'Norwegian University of Science and Technology', country = 'NO', url = 'http://www.ntnu.no/' |
| 495 | WHERE name = 'Univ Trondheim'; |
| 496 | |
| 497 | UPDATE profile_education_enum |
| 498 | SET abbreviation = '', country = 'GB' |
| 499 | WHERE name = 'University of Surrey'; |
| 500 | UPDATE profile_education_enum |
| 501 | SET abbreviation = '', country = 'GB' |
| 502 | WHERE name = 'Heriot-Watt University'; |
| 503 | UPDATE profile_education_enum |
| 504 | SET abbreviation = 'UCL', country = 'GB' |
| 505 | WHERE name = 'University College London'; |
| 506 | |
| 507 | UPDATE profile_education_enum |
| 508 | SET abbreviation = 'OIV', country = 'FR' |
| 509 | WHERE name = 'Organisme International de la Vigne et du Vin'; |
| 510 | UPDATE profile_education_enum |
| 511 | SET abbreviation = 'NSU', name = 'Novosibirsk State University', url = 'http://www.nsu.ru/', country = 'RU' |
| 512 | WHERE name = 'Université de Novossibirsk (Новосибирский Государственный Университет)'; |
| 513 | |
| 514 | UPDATE profile_education_enum |
| 515 | SET abbreviation = 'IITs', country = 'IN' |
| 516 | WHERE name = 'Indian Institutes of Technology'; |
| 517 | |
| 518 | UPDATE profile_education_enum |
| 519 | SET name = 'Institut des Hautes Études de Défense Nationale', country = 'FR', url ='http://www.ihedn.fr/', |
| 520 | abbreviation = 'IHEDN' |
| 521 | WHERE name = 'IHEDN'; |
| 522 | |
| 523 | UPDATE profile_education_enum |
| 524 | SET name = "Centre des Hautes Études de l'Armement", country = 'FR', url ='http://www.chear.defense.gouv.fr/', |
| 525 | WHERE name = 'CHEAr' |
| 526 | WHERE name = 'CHEAr'; |
| 527 | |
| 528 | -- Cleans duplicated entries |
| 529 | UPDATE profile_education SET eduid = 0 WHERE eduid = 70; |
| 530 | DELETE FROM profile_education_enum WHERE id = 70; |
| 531 | DELETE FROM profile_education_degree WHERE eduid = 70; |
| 532 | |
| 533 | UPDATE profile_education SET eduid = 91 WHERE eduid = 106; |
| 534 | DELETE FROM profile_education_enum WHERE id = 106; |
| 535 | DELETE FROM profile_education_degree WHERE eduid = 106; |
| 536 | |
| 537 | -- Adds new universities needed for the AX directory |
| 538 | INSERT INTO profile_education_enum (name, url, country, abbreviation) |
| 539 | VALUES ('Institut Supérieur de l\'Aéronautique et de l\'Espace', 'http://www.isae.fr/', 'FR', 'ISAE'), |
| 540 | ('École du Personnel Navigant d\'Essais et de Réception', |
| 541 | 'http://www.defense.gouv.fr/dga/archives/l_epner_ecole_du_personnel_navigant_d_essais_et_de_reception', 'FR', 'EPNER'), |
| 542 | ('Agrocampus Ouest', 'http://www.agrocampus-ouest.fr/', 'FR', 'ENSAR'), |
| 543 | ('Montpellier SupAgro', 'http://www.supagro.fr/', 'fr', ''), |
| 544 | ('Institut Supérieur des Matériaux et de la Construction Mécanique Saint-Ouen', 'http://www.cefi.org/BOUCHON/BS/ISMCM_Saint-Ouen.htm', |
| 545 | 'FR', 'ISMCM Saint-Ouen'), |
| 546 | ('École Centrale d\'Électronique ', 'http://www.ece.fr/', 'FR', 'ECE'), |
| 547 | ('École Nationale de l\'Aviation Civile', 'http://www.enac.fr/', 'FR', 'ENAC'), |
| 548 | ('Centre des Hautes Études de la Construction', 'http://www.chec.fr/', 'FR', 'CHEC'), |
| 549 | ('École de l\'Air', 'http://www.ecole-air.air.defense.gouv.fr/index.php?option=com_content&task=view&id=203&Itemid=251', 'FR', ''), |
| 550 | ('Institut Supérieur des Affaires', '', 'FR', 'ISA'), |
| 551 | ('École Supérieure de Gestion de Paris', 'http://www.esg.fr/', 'FR', 'ESG Paris'), |
| 552 | ('Institut des Hautes Études Européennes', 'http://www-ihee.u-strasbg.fr/', 'FR', 'IHEE'), |
| 553 | ('École Nationale de la Magistrature', 'http://www.enm.justice.fr/', 'FR', 'ENM'), |
| 554 | ('Institut de Formation Supérieure BioMédicale', 'http://www.igr.fr/ifsbm/', 'FR', 'IFSBM'), |
| 555 | ('Institut Supérieur de l\'AgroAlimentaire', 'http://www.isaa.fr/', 'FR', 'ISAA'), |
| 556 | ('École des Mines d\'Alès', 'http://www.ema.fr/', 'FR', 'EMA'), |
| 557 | ('Syracuse University', 'http://www.syr.edu/', 'US', 'SU'), |
| 558 | ('Dartmouth College', 'http://www.dartmouth.edu/', 'US', ''), |
| 559 | ('International Teachers Programme', 'http://www.itp-schools.org/', '', 'ITP'), |
| 560 | ('University of Kentucky', 'http://www.uky.edu/', 'US', 'UK'), |
| 561 | ('Marine Corps University', 'http://www.mcu.usmc.mil/', 'US', 'MCU'), |
| 562 | ('Chartered Institute of Management Accountants', 'http://www.cimaglobal.com/', 'GB', 'CIMA'), |
| 563 | ('Naval Postgraduate School', 'http://www.nps.edu/', 'US', 'NPS'), |
| 564 | ('Royal College of Art', 'http://www.rca.ac.uk/', 'GB', 'RCA'), |
| 565 | ('Uniwersytet Gdański', 'http://www.univ.gda.pl/', 'PL', ''), |
| 566 | ('College of Europe', 'http://www.coleurope.eu/', '', ''), |
| 567 | ('Queen\'s University', 'http://www.queensu.ca/', 'CA', 'Queen\'s'), |
| 568 | ('Université de Bretagne Occidentale', 'http://www.univ-brest.fr/', 'FR', 'UBO'), |
| 569 | ('University of California, Davis', 'http://www.ucdavis.edu/', 'US', 'UC Davis'), |
| 570 | ('Universität Stuttgarti', 'http://www.uni-stuttgart.de/', 'DE', ''), |
| 571 | ('Universitatea Politehnica din Bucureşti', 'http://www.pub.ro/', 'RO', 'Politehnica din Bucureşti'), |
| 572 | ('University of Birmingham', 'http://www.bham.ac.uk/', 'GB', ''), |
| 573 | ('University of Rome', '', 'IT', ''), |
| 574 | ('University of Sheffield', 'http://www.shef.ac.uk/', 'GB', ''), |
| 575 | ('University of Utah', 'http://www.utah.edu/', 'US', ''), |
| 576 | ('University of Washington', 'http://www.washington.edu/', 'US', ''), |
| 577 | ('Urbana University', 'http://www.urbana.edu/', 'US', ''), |
| 578 | ('Université de Technologie de Compiègne', 'http://www.utc.fr/', 'FR', 'UTC'), |
| 579 | ('Virginia Polytechnic Institute and State University', 'http://www.vt.edu/', 'US', 'Virginia Tech'), |
| 580 | ('Cleveland State University', 'http://www.csuohio.edu/', 'US', 'CSU'), |
| 581 | ('Centre de Perfectionnement aux Affaires du Nord', '', 'FR', 'CPA du Nord'), |
| 582 | ('Centre de Perfectionnement aux Affaires de Lyon', '', '', 'CPA de Lyon'), |
| 583 | ('Amherst College', 'http://www.amherst.edu/', 'US', ''), |
| 584 | ('Ottawa University', 'http://www.ottawa.edu/', 'US', 'OU'), |
| 585 | ('Indiana University', 'http://www.indiana.edu/', 'US', ''), |
| 586 | ('University of Notre Dame du Lac', 'http://www.nd.edu/', 'US', 'Notre Dame'), |
| 587 | ('University of Maryland, College Park ', 'http://www.umd.edu/', 'US', 'UMCP'), |
| 588 | ('Vanderbilt University', 'http://www.vanderbilt.edu/', 'US', ''), |
| 589 | ('Institut National Polytechnique de Toulouse', 'http://www.inp-toulouse.fr/', 'FR', 'INP Toulouse'), |
| 590 | ('University of Houston', 'http://www.uh.edu/', 'US', 'UH'), |
| 591 | ('École Spéciale des Travaux Publics, du Bâtiment et de l\'Industrie', 'http://www.estp.fr/', 'FR', 'ESTP'), |
| 592 | ('Université Jean-Moulin (Lyon-III)', 'http://www.univ-lyon3.fr/', 'FR', 'Université Jean-Moulin'), |
| 593 | ('École Nationale Supérieure d\'Ingénieurs Électriciens de Grenoble', 'http://ense3.grenoble-inp.fr/', 'FR', 'ENSIEG'), |
| 594 | ('École Nationale Supérieure d\'Hydraulique et de Mécanique de Grenoble', 'http://ense3.grenoble-inp.fr/', 'FR', 'ENSHMG'), |
| 595 | ('Université de Rennes 1', 'http://www.univ-rennes1.fr/', 'FR', ''), |
| 596 | ('École Centrale Paris', 'http://www.ecp.fr/', 'FR', 'Centrale Paris'), |
| 597 | ('University of Dallas', 'http://www.udallas.edu/', 'US', ''), |
| 598 | ('Pontifical Catholic University of Chile', 'http://www.uc.cl/', 'CL', 'PUC'), |
| 599 | ('Universitat Oberta de Catalunya', 'http://www.uoc.edu/web/eng/', 'ES', 'UOC'), |
| 600 | ('University of California, Irvine', 'http://www.uci.edu/', 'US', 'UCI'), |
| 601 | ('Association Francophone de Management de Projet', 'http://www.afitep.fr/', 'FR', 'AFITEP'), |
| 602 | ('Centre Européen d\'Éducation Permanente', 'http://www.cedep.fr/', 'FR', 'CEDEP'), |
| 603 | ('Collège Interarmées de Défense', 'http://www.college.interarmees.defense.gouv.fr/', 'FR', ''), |
| 604 | ('Centre de Formation des Journalistes', 'http://www.cfpj.com/', 'FR', 'CFJ'), |
| 605 | ('Institut National des Hautes Études de Sécurité', 'http://www.inhes.interieur.gouv.fr/', 'FR', 'INHES'), |
| 606 | ('Université d\'Orléans', 'http://www.univ-orleans.fr/', 'FR', ''); |
| 607 | |
| 608 | |
| 609 | -- Médecine is not a university but an educational field |
| 610 | REPLACE INTO profile_education (uid, id, fieldid, eduid, degreeid) |
| 611 | SELECT e.uid, e.id, f.id, 0, d.id |
| 612 | FROM profile_education AS e |
| 613 | INNER JOIN profile_education_enum AS l ON (l.id = e.eduid) |
| 614 | INNER JOIN profile_education_degree_enum AS d ON (d.degree = "Doctorat") |
| 615 | INNER JOIN profile_education_field_enum AS f ON (f.field = "Médecine") |
| 616 | WHERE l.name = "Médecine"; |
| 617 | |
| 618 | DELETE FROM profile_education_enum |
| 619 | WHERE name = "Médecine"; |
| 620 | |
| 621 | # vim:set syntax=mysql: |
| 622 | |