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