Commit | Line | Data |
---|---|---|
d0293d9b FB |
1 | DROP TABLE IF EXISTS profile_corps; |
2 | DROP TABLE IF EXISTS profile_corps_enum; | |
3 | DROP TABLE IF EXISTS profile_corps_rank_enum; | |
4 | ||
ce0b2c6f FB |
5 | CREATE TABLE profile_corps ( |
6 | pid INT(11) NOT NULL, | |
72e96bc0 SJ |
7 | original_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0, |
8 | current_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0, | |
9 | rankid INT(4) UNSIGNED NOT NULL DEFAULT 0, | |
10 | corps_pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private', | |
ce0b2c6f | 11 | PRIMARY KEY(pid) |
950bf4f6 | 12 | ) ENGINE=InnoDB, CHARSET=utf8; |
72e96bc0 SJ |
13 | |
14 | ||
ce0b2c6f | 15 | CREATE TABLE profile_corps_enum ( |
72e96bc0 SJ |
16 | id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT, |
17 | name VARCHAR(255) NOT NULL DEFAULT '', | |
18 | abbreviation CHAR(5) NOT NULL DEFAULT '', | |
19 | still_exists TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, | |
20 | PRIMARY KEY(id), | |
21 | UNIQUE KEY(name), | |
22 | UNIQUE KEY(abbreviation) | |
950bf4f6 | 23 | ) ENGINE=InnoDB, CHARSET=utf8; |
72e96bc0 SJ |
24 | |
25 | ||
ce0b2c6f | 26 | CREATE TABLE profile_corps_rank_enum ( |
72e96bc0 SJ |
27 | id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT, |
28 | name VARCHAR(255) NOT NULL DEFAULT '', | |
29 | abbreviation CHAR(5) NOT NULL DEFAULT '', | |
30 | PRIMARY KEY(id), | |
31 | UNIQUE KEY(name), | |
32 | UNIQUE KEY(abbreviation) | |
950bf4f6 | 33 | ) ENGINE=InnoDB, CHARSET=utf8; |
72e96bc0 | 34 | |
6920f8a6 SJ |
35 | INSERT IGNORE INTO profile_corps_rank_enum (abbreviation, name) |
36 | VALUES (" ", "Aucun"), | |
37 | ("A", "Amiral"), | |
38 | ("A2", "Amiral 2e Son"), | |
39 | ("ADC", "Adm.Civil"), | |
40 | ("ADC2", "Adm.Civil retr."), | |
41 | ("ADC3", "Adm.Civil cg."), | |
42 | ("ADC4", "Adm.Civil dém."), | |
43 | ("ADC5", "Adm.Civil dét."), | |
44 | ("ADC6", "Adm.Civil dis."), | |
45 | ("ADC7", "Adm.Civil (H.C)"), | |
46 | ("ADC8", "Adm.Civil h.cl."), | |
47 | ("ADHC", "Adm. h.cl.INSEE"), | |
48 | ("ADHC2", "Adm.h.cl.INSEE retr."), | |
49 | ("ADHC3", "Adm.h.cl.INSEE cg."), | |
50 | ("ADHC4", "Adm.h.cl.INSEE dém."), | |
51 | ("ADHC5", "Adm.h.cl.INSEE dét."), | |
52 | ("ADHC6", "Adm.h.cl.INSEE dis."), | |
53 | ("ADHC7", "Adm.h.cl.INSEE (H.C.)"), | |
54 | ("ADIN", "Adm.INSEE"), | |
55 | ("ADIN2", "Adm.INSEE retr."), | |
56 | ("ADIN3", "Adm.INSEE cg"), | |
57 | ("ADIN4", "Adm.INSEE dém."), | |
58 | ("ADIN5", "Adm.INSEE dét."), | |
59 | ("ADIN6", "Adm.INSEE dis."), | |
60 | ("ADIN7", "Adm.INSEE (H.C.)"), | |
61 | ("CA", "Contre-Amiral"), | |
62 | ("CA2", "Contre-Amiral 2e Son"), | |
63 | ("CAA", "Contrôleur des Armées"), | |
64 | ("CB", "Chef de bataillon"), | |
65 | ("CB2", "Chef de bataillon retr."), | |
66 | ("CB8", "Chef de bataillon rés."), | |
67 | ("CBH", "Chef de bataillon"), | |
68 | ("CC", "Capitaine de Corvette"), | |
69 | ("CC2", "Capitaine de Corvette retr."), | |
70 | ("CC8", "Capitaine de Corvette rés."), | |
71 | ("CCA", "Commiss. Contr. Ass."), | |
72 | ("CCA2", "Commiss. Contr. Ass. retr."), | |
73 | ("CCA3", "Commiss. Contr. Ass. cg."), | |
74 | ("CCA4", "Commiss. Contr. Ass. dém."), | |
75 | ("CCA5", "Commiss. Contr. Ass. dét."), | |
76 | ("CCA6", "Commiss. Contr. Ass. dis."), | |
77 | ("CCA7", "Commiss. Contr. Ass. (HC)"), | |
78 | ("CCCA", "Commiss. Contr. Ch. Ass."), | |
79 | ("CCCA2", "Commiss. Contr. Ch. Ass. retr."), | |
80 | ("CCCA3", "Commiss. Contr. Ch. Ass. cg."), | |
81 | ("CCCA4", "Commiss. Contr. Ch. Ass. dém."), | |
82 | ("CCCA5", "Commiss. Contr. Ch. Ass. dét."), | |
83 | ("CCCA6", "Commiss. Contr. Ch. Ass. dis."), | |
84 | ("CCCA7", "Commiss. Contr. Ch. Ass. (HC)"), | |
85 | ("CCGA", "Commiss. Contr. Gén. Ass."), | |
86 | ("CCGA2", "Commiss. Contr. Gén. Ass.retr."), | |
87 | ("CCGA3", "Commiss. Contr. Gén. Ass. cg."), | |
88 | ("CCGA4", "Commiss. Contr. Gén. Ass. dém."), | |
89 | ("CCGA5", "Commiss. Contr. Gén. Ass. dét."), | |
90 | ("CCGA6", "Commiss. Contr. Gén. Ass. dis."), | |
91 | ("CCGA7", "Commiss. Contr. Gén. Ass. (HC)"), | |
92 | ("CCH", "Capitaine de Corvette hon."), | |
93 | ("Cdt", "Commandant"), | |
94 | ("Cdt2", "Commandant retr."), | |
95 | ("Cdt5", "Commandant dém."), | |
96 | ("Cdt8", "Commandant de rés."), | |
97 | ("CE", "Chef d'Escadron"), | |
98 | ("CE2", "Chef d'Escadron retr."), | |
99 | ("CE3", "Chef d'Escadrons"), | |
100 | ("CE4", "Chef d'Escadrons"), | |
101 | ("CE5", "Chef d'Escadrons de rés."), | |
102 | ("CF", "Capitaine de Frégate"), | |
103 | ("CF2", "Capitaine de Frégate"), | |
104 | ("CF9", "Capitaine de Frégate (CR)"), | |
105 | ("CFC1", "Ing.ch.SNCF"), | |
106 | ("CFC11", "Ing.ch.h.cl.SNCF"), | |
107 | ("CFC2", "Ing.ch.retr.SNCF"), | |
108 | ("CFC3", "Ing.ch.hon.SNCF"), | |
109 | ("CFC31", "Ing.ch.h.cl.SNCF"), | |
110 | ("CFC4", "Ing.ch.H.C.hon.SNCF"), | |
111 | ("CFC5", "Ing.ch.h.cl.hon.SNCF"), | |
112 | ("CFC6", "Ing.ch.h.cl.retr.SNCF"), | |
113 | ("CFD1", "Direct.Gén.SNCF"), | |
114 | ("CFD2", "Direct.Gén.hon.SNCF"), | |
115 | ("CFD3", "Direct.SNCF"), | |
116 | ("CFD4", "Direct.hon.SNCF"), | |
117 | ("CFD5", "Direct.retr.SNCF"), | |
118 | ("CFD6", "DGA hon.SNCF"), | |
119 | ("CFG1", "Ing.gén.SNCF"), | |
120 | ("CFG2", "Ing.gén.retr.SNCF"), | |
121 | ("CFG3", "Ing.gén.hon.SNCF"), | |
122 | ("CFH", "Capitaine de Frégate hon."), | |
123 | ("CFP1", "Ing.pp.SNCF"), | |
124 | ("CFP2", "Ing.pp.retr.SNCF"), | |
125 | ("CFP3", "Ing.pp.hon.SNCF"), | |
126 | ("CFP4", "Ing.pp.H.C.hon.SNCF"), | |
127 | ("CFP5", "Ing.pp.h.cl.hon.SNCF"), | |
128 | ("CFP6", "Ing.pp.h.cl.SNCF"), | |
129 | ("CGA", "Contrôleur Général des Armées"), | |
130 | ("CGA2", "Contrôl.Gén.des Armées 2e Son"), | |
131 | ("Cne", "Capitaine"), | |
132 | ("Cne2", "Capitaine retr."), | |
133 | ("Cne5", "Capitaine dém."), | |
134 | ("Cne6", "Capitaine dis."), | |
135 | ("Cne8", "Capitaine de rés."), | |
136 | ("Col", "Colonel"), | |
137 | ("Col2", "Colonel retr."), | |
138 | ("Col3", "Colonel Brth retr."), | |
139 | ("Col4", "Colonel (Air) retr."), | |
140 | ("Col5", "Colonel hon.(Air)"), | |
141 | ("Colh", "Colonel hon."), | |
142 | ("COM1C", "Commiss.1e cl.Marine"), | |
143 | ("COM2", "Commiss.Marine retr."), | |
144 | ("COM2C", "Commiss.2e cl.Marine"), | |
145 | ("COM4", "Commiss.Marine dém."), | |
146 | ("COM8", "Commiss.Marine rés."), | |
147 | ("COMC", "Commiss.ch.Marine"), | |
148 | ("COMC1", "Commiss.ch.1e cl.Marine"), | |
149 | ("COMC2", "Commiss.ch.Marine retr."), | |
150 | ("COMC8", "Commiss.ch.Marine rés."), | |
151 | ("COMD", "Commiss.Cdt"), | |
152 | ("COMG", "Comm.Gén.Mar.2e Son"), | |
153 | ("COMG1", "Comm.Gén.1e cl.Mar.2e Son"), | |
154 | ("COMG2", "Comm.Gén.2e cl.Mar.2e Son"), | |
155 | ("COMGP", "Commiss.gén.aux prix hon."), | |
156 | ("COMP", "Commiss.pp.Marine"), | |
157 | ("COMP2", "Commiss.pp Marine retr."), | |
158 | ("COMP8", "Commiss.pp.Marine rés."), | |
159 | ("CONE", "Contrôl.Gén Eco.et Financ."), | |
160 | ("CONE2", "Contrôl.Gén Eco.et Financ.ret"), | |
161 | ("CONE3", "Contrôl.Gén Eco.et Financ.cg."), | |
162 | ("CONE4", "Contrôl.Gén Eco.et Financ.dém."), | |
163 | ("CONE5", "Contrôl.Gén Eco.et Financ.dét."), | |
164 | ("CONE6", "Contrôl.Gén Eco.et Financ. dis"), | |
165 | ("CONE7", "Contrôl.Gén Eco.et Financ.H.C."), | |
166 | ("CONEH", "Contrôl.Gén Eco.et Financ.hon."), | |
167 | ("CV", "Capitaine de Vaisseau"), | |
168 | ("CV2", "Capitaine de Vaisseau retr."), | |
169 | ("CV9", "Capitaine de Vaisseau (CR)"), | |
170 | ("CVH", "Capitaine de Vaisseau hon."), | |
171 | ("DRT", "Direct.rég.Téléc."), | |
172 | ("DRT2", "Direct.rég.Téléc. retr."), | |
173 | ("DRT3", "Direct.rég.Téléc. cg."), | |
174 | ("DRT4", "Direct.rég.Téléc. dém."), | |
175 | ("DRT5", "Direct.rég.Téléc. dét."), | |
176 | ("DRT6", "Direct.rég.Téléc. dis."), | |
177 | ("DRT7", "Direct.rég.Téléc. (H.C.)"), | |
178 | ("DRT8", "Direct.rég.Téléc. hon."), | |
179 | ("EF2", "Ing.EDF retr."), | |
180 | ("EF3", "Ing.EDF cg."), | |
181 | ("EF4", "Ing.EDF dém."), | |
182 | ("EF5", "Ing.EDF dét."), | |
183 | ("EF6", "Ing.EDF dis."), | |
184 | ("EFC2", "Ing.ch.EDF retr."), | |
185 | ("EFC3", "Ing.ch.EDF cg."), | |
186 | ("EFC4", "Ing.ch.EDF dém."), | |
187 | ("EFC5", "Ing.ch.EDF dét."), | |
188 | ("EFC6", "Ing.ch.EDF dis."), | |
189 | ("EFC7", "Ing.ch.EDF (HC)"), | |
190 | ("EFCO1", "Contrôl.gén.hon.EDF"), | |
191 | ("EFD", "Direct. EDF"), | |
192 | ("EFD2", "Direct.hon.EDF"), | |
193 | ("EFDG", "Direct.Gén. EDF"), | |
194 | ("EFDG2", "Direct.Gén.hon.EDF"), | |
195 | ("EFG2", "Ing.gén.EDF retr."), | |
196 | ("EFGH", "Insp.gén.hon.EDF"), | |
197 | ("EFP2", "Ing.pp.EDF retr."), | |
198 | ("EFP3", "Ing.pp.EDF cg."), | |
199 | ("EFP4", "Ing.pp.EDF dém."), | |
200 | ("EFP5", "Ing.pp.EDF dét."), | |
201 | ("EFP6", "Ing.pp.EDF dis."), | |
202 | ("EFP7", "Ing.pp.EDF (HC)"), | |
203 | ("EFS", "Insp.gén.EDF"), | |
204 | ("EFS2", "Insp.gén.EDF retr."), | |
205 | ("EFS3", "Insp.gén.hon. EDF"), | |
206 | ("ESC", "Ing.ch.des Essences"), | |
207 | ("ESC10", "Ing.ch. 1e cl.des Essence CR"), | |
208 | ("ESC2", "Ing.ch.des Essences retr."), | |
209 | ("ESC3", "Ing.ch.des Essences cg."), | |
210 | ("ESC4", "Ing.ch.des Essences dém."), | |
211 | ("ESC5", "Ing.ch.des Essences dét."), | |
212 | ("ESC6", "Ing.ch.des Essences dis."), | |
213 | ("ESC7", "Ing.ch.des Essences (H.C.)"), | |
214 | ("ESC9", "Ing.ch.des Essences CR"), | |
215 | ("ESG", "Ing.gén.des Essences"), | |
216 | ("ESG2", "Ing.gén.des Essences retr."), | |
217 | ("ESG3", "Ing.gén.des Essences cg."), | |
218 | ("ESG4", "Ing.gén.des Essences dém."), | |
219 | ("ESG5", "Ing.gén.des Essences dét."), | |
220 | ("ESG6", "Ing.gén.des Essences dis."), | |
221 | ("ESG7", "Ing.gén.des Essences (H.C.)"), | |
222 | ("ESI", "Ing.des Essences"), | |
223 | ("ESI2", "Ing.des Eseences retr."), | |
224 | ("ESI3", "Ing.des Essences cg."), | |
225 | ("ESI4", "Ing.des Essences dém."), | |
226 | ("ESI5", "Ing.des Essences dét."), | |
227 | ("ESI6", "Ing.des Essences dis."), | |
228 | ("ESI7", "Ing.des Essences (H.C.)"), | |
229 | ("EV", "Enseigne de Vaisseau"), | |
230 | ("GA", "Général d'Armée"), | |
231 | ("GA2", "Général d'Armée 2e Son"), | |
232 | ("GAE", "Général d'Armée Aér."), | |
233 | ("GAE2", "Général d'Armée Aér.2e Son"), | |
234 | ("GB", "Général de Brigade"), | |
235 | ("GB2", "Général de Brigade 2e Son"), | |
236 | ("GBAE", "Général de Brigade Aér."), | |
237 | ("GBAE2", "Général de Brig.Aér.2e Son"), | |
238 | ("GCA", "Général de C.A."), | |
239 | ("GCA2", "Général de C.A. 2e Son"), | |
240 | ("GCAE", "Général de C.A.Aér."), | |
241 | ("GCAE2", "Général de C.A.Aér. 2e Son"), | |
242 | ("GD", "Général de Division"), | |
243 | ("GD2", "Général de Division 2e Son"), | |
244 | ("GDAE", "Général de Division Aér."), | |
245 | ("GDAE2", "Général de Div.Aér. 2e Son"), | |
246 | ("GDFC2", "Contrôleur gén.GDF retr."), | |
247 | ("GDFD3", "Direct.hon.GDF"), | |
248 | ("GDFI", "Insp.gén.hon.GDF"), | |
249 | ("GM2", "Ing. Arm. (GM) retr."), | |
250 | ("GM3", "Ing. Arm. (GM) cg."), | |
251 | ("GM4", "Ing. Arm. (GM) dém."), | |
252 | ("GM7", "Ing. Arm. (GM) H.C"), | |
253 | ("GM8", "Ing. Arm. (GM) rés."), | |
254 | ("GM9", "Ing. Arm. (GM) CR"), | |
255 | ("GMC", "Ing.ch.Arm.(GM)"), | |
256 | ("GMC1", "Ing.ch.Arm (GM)"), | |
257 | ("GMC2", "Ing.ch.Arm.(GM) retr."), | |
258 | ("GMC3", "Ing.ch.Arm.(GM) cg."), | |
259 | ("GMC4", "Ing.ch.Arm.(GM) dém."), | |
260 | ("GMC7", "Ing.ch.Arm.(GM) H.C"), | |
261 | ("GMC8", "Ing.ch.Arm.(GM) rés."), | |
262 | ("GMC9", "Ing.ch.Arm.(GM) CR"), | |
263 | ("GMG", "Ing.Gén.Arm.(GM)"), | |
264 | ("GMG02", "Ing.Gén.Arm.(GM) 2e Son"), | |
265 | ("GMG1", "Ing.Gén.1e cl.Arm.(GM) 2e Son"), | |
266 | ("GMG11", "Ing.Gén.1e cl.Arm.(GM)"), | |
267 | ("GMG2", "Ing.Gén.2e cl.Arm.(GM) 2e Son"), | |
268 | ("GMG22", "Ing.Gén.2e cl.Arm.(GM)"), | |
269 | ("GMP", "Ing.pp.Arm.(GM)"), | |
270 | ("GMP2", "Ing.pp.Arm.(GM) retr."), | |
271 | ("GMP3", "Ing.pp.Arm.(GM) cg."), | |
272 | ("GMP4", "Ing.pp.Arm.(GM) dém."), | |
273 | ("GMP7", "Ing.pp.Arm.(GM) H.C"), | |
274 | ("GMP8", "Ing.pp.Arm.(GM) rés."), | |
275 | ("GMP9", "Ing.pp.Arm.(GM) CR"), | |
276 | ("GMT12", "Ing.Gén.1e cl. Mat. 2e Son"), | |
277 | ("GMT2", "Ing.Gén.du Mat. 2e Son"), | |
278 | ("GMT22", "Ing.Gén.2e cl. Mat. 2e Son"), | |
279 | ("HG02", "Ing.Gén.Arm.(H) 2e Son"), | |
280 | ("IA", "Ing.Arm."), | |
281 | ("IA2", "Ing.Arm. retr."), | |
282 | ("IA3", "Ing.Arm. cg."), | |
283 | ("IA4", "Ing.Arm. dém."), | |
284 | ("IA5", "Ing.Arm. dét."), | |
285 | ("IA6", "Ing.Arm. dis."), | |
286 | ("IA7", "Ing.Arm. (H.C.)"), | |
287 | ("IA8", "Ing.Arm. rés."), | |
288 | ("IA9", "Ing.Arm. (CR)"), | |
289 | ("IAC8", "Ing.ch.Arm. rés."), | |
290 | ("IAv", "Ing.Av.C."), | |
291 | ("IAv2", "Ing.Av.C. retr."), | |
292 | ("IAV3", "Ing.Av.C. cg."), | |
293 | ("IAv4", "Ing.Av.C. dém."), | |
294 | ("IAv5", "Ing.Av.C. dét."), | |
295 | ("IAv6", "Ing.Av.C. dis."), | |
296 | ("IAv7", "Ing.Av.C. (H.C.)"), | |
297 | ("ICA", "Ing.ch.Arm."), | |
298 | ("ICA2", "Ing.ch.Arm.retr."), | |
299 | ("ICA3", "Ing.ch.Arm. cg."), | |
300 | ("ICA4", "Ing.ch.Arm. dém."), | |
301 | ("ICA5", "Ing.ch.Arm. dét."), | |
302 | ("ICA6", "Ing.ch.Arm. dis"), | |
303 | ("ICA7", "Ing.ch.Arm. (H.C.)"), | |
304 | ("ICA8", "Ing.ch.Arm.rés."), | |
305 | ("ICA9", "Ing.ch.Arm. (CR)"), | |
306 | ("ICAv", "Ing.ch.Av.C."), | |
307 | ("ICAv2", "Ing.ch.Av.C. retr."), | |
308 | ("ICAv3", "Ing.ch.Av.C. cg."), | |
309 | ("ICAv4", "Ing.ch.Av.C. dém."), | |
310 | ("ICAv5", "Ing.ch.Av.C. dét."), | |
311 | ("ICAv6", "Ing.ch.Av.C. dis."), | |
312 | ("ICAv7", "Ing.ch.Av.C. (H.C.)"), | |
313 | ("ICG", "Ing.ch.GREF"), | |
314 | ("ICG2", "Ing.ch.GREF retr."), | |
315 | ("ICG3", "Ing.ch.GREF cg."), | |
316 | ("ICG4", "Ing.ch.GREF dém."), | |
317 | ("ICG5", "Ing.ch.GREF dét."), | |
318 | ("ICG6", "Ing.ch.GREF dis."), | |
319 | ("ICG7", "Ing.ch.GREF (H.C.)"), | |
320 | ("ICGO", "Ing.ch.Géog."), | |
321 | ("ICGO2", "Ing.ch.Géog. retr."), | |
322 | ("ICGO3", "Ing.ch.Géog. cg"), | |
323 | ("ICGO4", "Ing.ch.Géog. dém."), | |
324 | ("ICGO5", "Ing.ch.Géog. dét."), | |
325 | ("ICGO6", "Ing.ch.Géog. dis."), | |
326 | ("ICGO7", "Ing.ch.Géog. (H.C.)"), | |
327 | ("ICIM", "Ing.ch.I.M."), | |
328 | ("ICIM2", "Ing.ch.I.M. retr."), | |
329 | ("ICIM3", "Ing.ch.I.M. cg."), | |
330 | ("ICIM4", "Ing.ch.I.M. dém."), | |
331 | ("ICIM5", "Ing.ch.I.M. dét."), | |
332 | ("ICIM6", "Ing.ch.I.M. dis."), | |
333 | ("ICIM7", "Ing.ch.I.M. (H.C.)"), | |
334 | ("ICM", "Ing.ch.Mines"), | |
335 | ("ICM2", "Ing.ch.Mines retr."), | |
336 | ("ICM3", "Ing.ch.Mines cg."), | |
337 | ("ICM4", "Ing.ch.Mines dém."), | |
338 | ("ICM5", "Ing.ch.Mines dét."), | |
339 | ("ICM6", "Ing.ch.Mines dis."), | |
340 | ("ICM7", "Ing.ch.Mines (H.C.)"), | |
341 | ("ICME", "Ing.ch.M.E."), | |
342 | ("ICME2", "Ing.ch.M.E. retr."), | |
343 | ("ICME3", "Ing.ch.M.E. cg."), | |
344 | ("ICME4", "Ing.ch.M.E. dém."), | |
345 | ("ICME5", "Ing.ch.M.E. dét."), | |
346 | ("ICME6", "Ing.ch.M.E. dis."), | |
347 | ("ICME7", "Ing.ch.M.E (H.C.)"), | |
348 | ("ICMO", "Ing.ch.Météo."), | |
349 | ("ICMO2", "Ing.ch.Météo.retr."), | |
350 | ("ICMO3", "Ing.ch.Météo.cg"), | |
351 | ("ICMO4", "Ing.ch.Météo.dém."), | |
352 | ("ICMO5", "Ing.ch.Météo.dét."), | |
353 | ("ICMO6", "Ing.ch.Météo.dis"), | |
354 | ("ICMO7", "Ing.ch.Météo. (H.C.)"), | |
355 | ("ICMT2", "Ing.ch.Mat. retr."), | |
356 | ("ICMT3", "Ing.ch.1e cl. Mat hon."), | |
357 | ("ICMT4", "Ing.ch.2e cl. Mat. hon."), | |
358 | ("ICPC", "Ing.ch.P.C."), | |
359 | ("ICPC2", "Ing.ch.P.C. retr."), | |
360 | ("ICPC3", "Ing.ch.P.C. cg."), | |
361 | ("ICPC4", "Ing.ch.P.C. dém."), | |
362 | ("ICPC5", "Ing.ch.P.C. dét."), | |
363 | ("ICPC6", "Ing.ch.P.C. dis."), | |
364 | ("ICPC7", "Ing.ch.P.C. (H.C.)"), | |
365 | ("ICT", "Ing.ch.Téléc."), | |
366 | ("ICT2", "Ing.ch.Téléc. retr."), | |
367 | ("ICT3", "Ing.ch.Téléc. cg."), | |
368 | ("ICT4", "Ing.ch.Téléc. dém."), | |
369 | ("ICT5", "Ing.ch.Téléc. dét."), | |
370 | ("ICT6", "Ing.ch.Téléc. dis."), | |
371 | ("ICT7", "Ing.ch.Téléc. (H.C.)"), | |
372 | ("ICTH", "Ing.ch.Téléc. hon."), | |
373 | ("IFi", "Insp.des Finances"), | |
374 | ("IFi2", "Insp.des Finances retr."), | |
375 | ("IFi3", "Insp.des Finances cg."), | |
376 | ("IFi4", "Insp.des Finances dém."), | |
377 | ("IFi5", "Insp.des Finances dét."), | |
378 | ("IFi6", "Insp.des Finances dis."), | |
379 | ("IFi7", "Insp.des Finances (H.C.)"), | |
380 | ("IG", "Ing.GREF"), | |
381 | ("IG11", "Ing.Gén.1e cl.Arm."), | |
382 | ("IG12", "Ing.Gén.1e cl.Arm. 2e Son"), | |
383 | ("IG13", "Ing.Gén.1e cl.Arm. cg."), | |
384 | ("IG15", "Ing.Gén.1e cl.Arm. dét."), | |
385 | ("IG16", "Ing.Gén.1e cl.Arm. dis."), | |
386 | ("IG17", "Ing.Gén.1e cl.Arm. (H.C.)"), | |
387 | ("IG19", "Ing.Gén.1e cl.Arm. (CR)"), | |
388 | ("IG2", "Ing.GREF retr."), | |
389 | ("IG21", "Ing.Gén.2e cl.Arm."), | |
390 | ("IG22", "Ing.Gén.2e cl.Arm. 2e Son"), | |
391 | ("IG23", "Ing.Gén.2e cl.Arm. cg."), | |
392 | ("IG25", "Ing.Gén.2e cl.Arm. dét."), | |
393 | ("IG26", "Ing.Gén.2e cl.Arm. dis."), | |
394 | ("IG27", "Ing.Gén.2e cl.Arm. (H.C.)"), | |
395 | ("IG29", "Ing.Gén.2e cl.Arm. (CR)"), | |
396 | ("IG3", "Ing.GREF cg."), | |
397 | ("IG4", "Ing.GREF dém."), | |
398 | ("IG5", "Ing.GREF dét."), | |
399 | ("IG6", "Ing.GREF dis."), | |
400 | ("IG7", "Ing.GREF (H.C.)"), | |
401 | ("IGA", "Ing.gén.Arm."), | |
402 | ("IGA2", "Ing.gén.Arm. 2e Son"), | |
403 | ("IGA3", "Ing.gén.Arm. cg."), | |
404 | ("IGA5", "Ing.gén.Arm. dét."), | |
405 | ("IGA6", "Ing.gén.Arm. dis."), | |
406 | ("IGA7", "Ing.gén.Arm. (H.C.)"), | |
407 | ("IGA8", "Ing.gén.Arm.(C.R.)"), | |
408 | ("IGAv", "Ing.gén.Av.C."), | |
409 | ("IGAv2", "Ing.gén.Av.C. retr."), | |
410 | ("IGAv3", "Ing.gén.Av.C. cg."), | |
411 | ("IGAv4", "Ing.gén.Av.C. dém."), | |
412 | ("IGAv5", "Ing.gén.Av.C. dét."), | |
413 | ("IGAv6", "Ing.gén.Av.C. dis"), | |
414 | ("IGAv7", "Ing.gén.Av.C. (H.C.)"), | |
415 | ("IGE", "Ing.gén.de cl.except.Arm."), | |
416 | ("IGE2", "Ing.gén.de cl.except.Arm.2eSon"), | |
417 | ("IGFi", "Insp.gén.des Finances"), | |
418 | ("IGFi2", "Insp.gén.des Finances retr."), | |
419 | ("IGFi3", "Insp.gén.des Finances cg."), | |
420 | ("IGFi4", "Insp.gén.des Finances dém."), | |
421 | ("IGFi5", "Insp.gén.des Finances dét."), | |
422 | ("IGFi6", "Insp.gén.des Finances dis."), | |
423 | ("IGFi7", "Insp.gén.des Finances (H.C.)"), | |
424 | ("IGG", "Ing.gén.GREF"), | |
425 | ("IGG2", "Ing.gén.GREF retr."), | |
426 | ("IGG3", "Ing.gén.GREF cg."), | |
427 | ("IGG4", "Ing.gén.GREF dém."), | |
428 | ("IGG5", "Ing.gén.GREF dét."), | |
429 | ("IGG6", "Ing.gén.GREF dis."), | |
430 | ("IGG7", "Ing.gén.GREF (H.C.)"), | |
431 | ("IGGO", "Ing.gén.Géog."), | |
432 | ("IGGO2", "Ing.gén.Géog. retr."), | |
433 | ("IGGO3", "Ing.gén.Géog. cg."), | |
434 | ("IGGO4", "Ing.gén.Géog. dém."), | |
435 | ("IGGO5", "Ing.gén.Géog. dét."), | |
436 | ("IGGO6", "Ing.gén.Géog. dis."), | |
437 | ("IGGO7", "Ing.gén.Géog. (H.C.)"), | |
438 | ("IGH", "Ing.gén.hors cl. Arm."), | |
439 | ("IGH2", "Ing.gén.hors cl.Arm.2e Son"), | |
440 | ("IGIM", "Ing.gén.I.M."), | |
441 | ("IGIM2", "Ing.gén.I.M. retr."), | |
442 | ("IGIN", "Insp.gén.INSEE"), | |
443 | ("IGIN2", "Insp.gén.INSEE retr."), | |
444 | ("IGIN3", "Insp.gén.INSEE cg."), | |
445 | ("IGIN4", "Insp.gén.INSEE dém."), | |
446 | ("IGIN5", "Insp.gén.INSEE dét."), | |
447 | ("IGIN6", "Insp.gén.INSEE dis."), | |
448 | ("IGIN7", "Insp.gén.INSEE (H.C.)"), | |
449 | ("IGIN8", "Insp.gén.INSEE hon."), | |
450 | ("IGM", "Ing.gén.Mines"), | |
451 | ("IGM2", "Ing.gén.Mines retr."), | |
452 | ("IGM3", "Ing.gén.Mines cg."), | |
453 | ("IGM4", "Ing.gén.Mines dém."), | |
454 | ("IGM5", "Ing.gén.Mines dét."), | |
455 | ("IGM6", "Ing.gén.Mines dis."), | |
456 | ("IGM7", "Ing.gén.Mines (H.C.)"), | |
457 | ("IGME", "Insp.gén.M.E."), | |
458 | ("IGME2", "Insp.gén.M.E. retr."), | |
459 | ("IGME3", "Insp.gén.M.E. cg"), | |
460 | ("IGME4", "Insp.gén.M.E. dém."), | |
461 | ("IGME5", "Insp.gén.M.E. dét."), | |
462 | ("IGME6", "Insp.gén.M.E. dis."), | |
463 | ("IGME7", "Insp.gén.M.E.(H.C)."), | |
464 | ("IGMO", "Ing.gén.Météo."), | |
465 | ("IGMO2", "Ing.gén.Météo. retr."), | |
466 | ("IGMO3", "Ing.gén.Météo. cg."), | |
467 | ("IGMO4", "Ing.gén.Météo. dém."), | |
468 | ("IGMO5", "Ing.gén.Météo. dét."), | |
469 | ("IGMO6", "Ing.gén.Météo. dis."), | |
470 | ("IGMO7", "Ing.gén.Météo. (H.C.)"), | |
471 | ("IGO", "Ing.Géog."), | |
472 | ("IGO2", "Ing.Géog. retr."), | |
473 | ("IGO3", "Ing.Géog. cg."), | |
474 | ("IGO4", "Ing.Géog. dém."), | |
475 | ("IGO5", "Ing.Géog. dét."), | |
476 | ("IGO6", "Ing.Géog. dis."), | |
477 | ("IGO7", "Ing.Géog. (H.C.)"), | |
478 | ("IGPC", "Ing.gén.P.C."), | |
479 | ("IGPC2", "Ing.gén.P.C. hon."), | |
480 | ("IGPC3", "Ing.gén.P.C. cg."), | |
481 | ("IGPC4", "Ing.gén.P.C. dém."), | |
482 | ("IGPC5", "Ing.gén.P.C. dét."), | |
483 | ("IGPC6", "Ing.gén.P.C. dis."), | |
484 | ("IGPC7", "Ing.gén.P.C. (H.C.)"), | |
485 | ("IGT", "Ing.gén.Téléc."), | |
486 | ("IGT12", "Ing.gén.1e cl.Téléc. retr."), | |
487 | ("IGT2", "Ing.gén.Téléc. retr."), | |
488 | ("IGT22", "Ing.gén.2e cl.Téléc. retr."), | |
489 | ("IGT3", "Ing.gén.Téléc. cg."), | |
490 | ("IGT4", "Ing.gén.Téléc. dém."), | |
491 | ("IGT5", "Ing.gén.Téléc. dét."), | |
492 | ("IGT6", "Ing.gén.Téléc. dis."), | |
493 | ("IGT7", "Ing.gén.Téléc.(H.C.)"), | |
494 | ("IGTH", "Ing.gén.Téléc. hon."), | |
495 | ("IIM", "Ing.I.M."), | |
496 | ("IIM2", "Ing.I.M. retr."), | |
497 | ("IIM3", "Ing.I.M. cg."), | |
498 | ("IIM4", "Ing.I.M. dém."), | |
499 | ("IIM5", "Ing.I.M. dét."), | |
500 | ("IIM6", "Ing.I.M. dis."), | |
501 | ("IIM7", "Ing.I.M. (H.C.)"), | |
502 | ("IM", "Ing.Mines"), | |
503 | ("IM2", "Ing.Mines retr."), | |
504 | ("IM3", "Ing.Mines cg."), | |
505 | ("IM4", "Ing.Mines dém."), | |
506 | ("IM5", "Ing.Mines dét."), | |
507 | ("IM6", "Ing.Mines dis."), | |
508 | ("IM7", "Ing.Mines (H.C.)"), | |
509 | ("IME", "Ing.M.E."), | |
510 | ("IME2", "Ing.M.E. retr."), | |
511 | ("IME3", "Ing.M.E. cg."), | |
512 | ("IME4", "Ing.M.E. dém."), | |
513 | ("IME5", "Ing.M.E. dét."), | |
514 | ("IME6", "Ing.M.E. dis."), | |
515 | ("IME7", "Ing.M.E (H.C.)"), | |
516 | ("IMO", "Ing.Météo."), | |
517 | ("IMO2", "Ing.Météo. retr."), | |
518 | ("IMO3", "Ing.Météo. cg."), | |
519 | ("IMO4", "Ing.Météo.dém."), | |
520 | ("IMO5", "Ing.Météo. dét."), | |
521 | ("IMO6", "Ing.Météo. dis."), | |
522 | ("IMO7", "Ing.Météo. (H.C.)"), | |
523 | ("ININ", "Insp.INSEE"), | |
524 | ("ININ2", "Insp.INSEE retr."), | |
525 | ("ININ3", "Insp.INSEE cg."), | |
526 | ("ININ4", "Insp.INSEE dém."), | |
527 | ("ININ5", "Insp.INSEE dét."), | |
528 | ("ININ6", "Insp.INSEE dis."), | |
529 | ("ININ7", "Insp.INSEE (H.C.)"), | |
530 | ("INT12", "Intent.Milit.1e cl. retr."), | |
531 | ("INT22", "Intent.Milit.2e cl. retr."), | |
532 | ("INTG", "Intent.Gén.2e Son"), | |
533 | ("INTG1", "Intent.Gén.1ere cl.2e Son"), | |
534 | ("INTG2", "Intent.Gén.2e cl.2e Son"), | |
535 | ("IPA", "Ing.pp.Arm."), | |
536 | ("IPA2", "Ing.pp.Arm.retr."), | |
537 | ("IPA3", "Ing.pp.Arm. cg."), | |
538 | ("IPA4", "Ing.pp.Arm. dém."), | |
539 | ("IPA5", "Ing.pp.Arm. dét."), | |
540 | ("IPA6", "Ing.pp.Arm. dis."), | |
541 | ("IPA7", "Ing.pp.Arm. (H.C.)"), | |
542 | ("IPA8", "Ing.pp.Arm. rés."), | |
543 | ("IPA9", "Ing.pp.Arm. (CR)"), | |
544 | ("IPC", "Ing.P.C."), | |
545 | ("IPC2", "Ing.P.C. retr."), | |
546 | ("IPC3", "Ing.P.C. cg."), | |
547 | ("IPC4", "Ing.P.C. dém."), | |
548 | ("IPC5", "Ing.P.C. dét."), | |
549 | ("IPC6", "Ing.P.C. dis."), | |
550 | ("IPC7", "Ing.P.C. (H.C.)"), | |
551 | ("IPG", "Ing.pp.GREF"), | |
552 | ("IPG2", "Ing.pp.GREF retr."), | |
553 | ("IPG3", "Ing.pp.GREF cg."), | |
554 | ("IPG4", "Ing.pp.GREF dém."), | |
555 | ("IPG5", "Ing.pp.GREF dét."), | |
556 | ("IPG6", "Ing.pp.GREF dis."), | |
557 | ("IPG7", "Ing.pp.GREF (H.C.)"), | |
558 | ("ISG2", "Insp.pp.des E.et F.OM.retr."), | |
559 | ("IT", "Ing.Téléc."), | |
560 | ("IT2", "Ing.Téléc. retr."), | |
561 | ("IT3", "Ing.Téléc. cg."), | |
562 | ("IT4", "Ing.Téléc. dém."), | |
563 | ("IT5", "Ing.Téléc. dét."), | |
564 | ("IT6", "Ing.Téléc. dis."), | |
565 | ("IT7", "Ing.Téléc. (H.C.)"), | |
566 | ("L.Co", "Lieut.-Colonel"), | |
567 | ("L.Co2", "Lieut.-Colonel retr."), | |
568 | ("L.Co5", "Lieut.-Colonel dém."), | |
569 | ("L.Co8", "Lieut.-Colonel rés."), | |
570 | ("L.Coh", "Lieut.-Colonel hon."), | |
571 | ("Lt", "Lieutenant"), | |
572 | ("Lt6", "Lieutenant dis."), | |
573 | ("Lt8", "Lieutenant rés."), | |
574 | ("LV", "Lieutenant de Vaisseau"), | |
575 | ("NAéG2", "Ing.gén.N.Aé.retr"), | |
576 | ("VA", "Vice-Amiral"), | |
577 | ("VA2", "Vice-Amiral 2e Son"), | |
578 | ("VAE", "Vice-Amiral d'Escadre"), | |
579 | ("VAE2", "Vice-Amiral d'Escadre 2e Son"); | |
2c8b13ab | 580 | |
6920f8a6 SJ |
581 | INSERT IGNORE INTO profile_corps_enum (abbreviation, name, still_exists) |
582 | VALUES ("D", "Aucun (anc. démissionnaire)", 1), | |
583 | ("Ad.C", "Adm. des Colonies", 0), | |
584 | ("Agr.C", "Agriculture aux Colonies", 0), | |
585 | ("Z", "Ancien élève étranger", 0), | |
586 | ("Aé", "Arm.Aéronautique", 0), | |
587 | ("ABC", "Arme blindée", 0), | |
588 | ("Arm", "Ingénieurs de l'Armement", 1), | |
589 | ("A", "Artillerie", 0), | |
590 | ("AC", "Artillerie coloniale", 0), | |
591 | ("AM", "Artillerie de Marine", 0), | |
592 | ("AN", "Artillerie Navale", 0), | |
593 | ("Av.C", "Aviation Civile", 0), | |
594 | ("B", "Bourse d'études", 0), | |
595 | ("Cav", "Cavalerie", 0), | |
596 | ("Cha", "Chars de Combat", 0), | |
597 | ("C.A", "Commissaire de l'Air", 0), | |
598 | ("C.M", "Commissariat de la Marine", 0), | |
599 | ("C.Ap", "Contrôle des Assurances", 1), | |
600 | ("EF.Ma", "E.& F. du Maroc", 0), | |
601 | ("E.F", "Eaux et Forêts", 0), | |
602 | ("EFC", "Eaux et Forêts des Colonies", 0), | |
603 | ("EFOM", "Eaux et Forêts Outre-Mer", 0), | |
604 | ("ENA", "Ecole Nation.d'Administration", 0), | |
605 | ("-", "Elève à l'Ecole", 0), | |
606 | ("W", "Elève catégorie particulière", 0), | |
607 | ("w", "Elève étranger naturalisé", 0), | |
608 | (" ", "Elève non sorti de l'école", 0), | |
609 | ("FA", "Fabrication d'Armement", 0), | |
610 | ("Gend", "Gendarmerie", 0), | |
611 | ("G", "Génie", 0), | |
612 | ("GM", "Génie Maritime", 0), | |
613 | ("GR", "Génie Rural", 0), | |
614 | ("GREF", "Génie Rural Eaux et Forêts", 1), | |
615 | ("IG", "Géographe", 0), | |
616 | ("Géo.C", "Géologie des Colonies", 0), | |
617 | ("H", "Hydrographes", 0), | |
618 | ("I", "Infanterie", 0), | |
619 | ("I.C", "Infanterie Coloniale", 0), | |
620 | ("I.Ma", "Infanterie de Marine", 0), | |
621 | ("St", "Institut nat.de la statistique", 0), | |
622 | ("IM", "Instruments de mesure", 0), | |
623 | ("ME", "Manufactures Etat Tabacs", 0), | |
624 | ("Mat", "Matériel Armée de Terre", 0), | |
625 | ("Mét", "Météorologie nationale", 0), | |
626 | ("M", "Mines", 1), | |
627 | ("MC", "Mines coloniales", 0), | |
628 | ("MOM", "Mines Outre-Mer", 0), | |
629 | ("N.Aé", "Navigation Aérienne", 0), | |
630 | ("Air", "Offic.de l'Air", 0), | |
631 | ("ORTF", "Office Radio-Télévision franç.", 0), | |
632 | ("BaAir", "Officier des Bases de l'Air", 0), | |
633 | ("Mar", "Officiers de marine", 0), | |
634 | ("OMAir", "Officiers mécaniciens Air", 0), | |
635 | ("PC", "Ponts et Chaussées", 1), | |
636 | ("PCC", "Ponts et Chaussées Colonies", 0), | |
637 | ("PCOM", "Ponts et Chaussées Outre-Mer", 0), | |
638 | ("PTC", "Postes et Télécom.Colonies", 0), | |
639 | ("PTOM", "Postes et Télécom.Outre-Mer", 0), | |
640 | ("P", "Poudres", 0), | |
641 | ("Rad", "Radiodiffusion française", 0), | |
642 | ("Rech", "Recherche", 0), | |
643 | ("R", "Réformé en fin d'études", 0), | |
644 | ("Bât.", "Service des Bâtiments", 0), | |
645 | ("C.F", "SNCF", 0), | |
646 | ("Sp", "Sports", 0), | |
647 | ("Téléc", "Télécommunications", 1), | |
648 | ("Té.A", "Télécommunications d'Armement", 0), | |
649 | ("Tr", "Train", 0), | |
650 | ("Tra", "Transmissions", 0), | |
651 | ("Tra.C", "Transmissions Coloniales", 0), | |
652 | ("TPC", "Travaux publics des Colonies", 0), | |
653 | ("TP Ic", "Travaux publics en Indochine", 0), | |
654 | ("TPOM", "Travaux publics Outre-Mer", 0), | |
655 | ("TdM", "Troupes de Marine", 0), | |
656 | ("INSEE", "Administrateurs de l'INSEE", 1), | |
657 | ("Off", "Officiers des Armées", 1); | |
2c8b13ab | 658 | |
6920f8a6 | 659 | ALTER TABLE watch_profile MODIFY field ENUM('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2', |
ef7d4b7b SJ |
660 | 'nationalite3', 'nick', 'web', 'networking', 'edus', 'addresses', |
661 | 'section', 'binets', 'medals', 'cv', 'jobs', 'photo', 'corps'); | |
662 | ||
72e96bc0 | 663 | -- vim:set syntax=mysql: |