| 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 | |
| 5 | CREATE TABLE profile_corps ( |
| 6 | pid INT(11) NOT NULL, |
| 7 | original_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 1, |
| 8 | current_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 1, |
| 9 | rankid INT(4) UNSIGNED NOT NULL DEFAULT 1, |
| 10 | corps_pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private', |
| 11 | PRIMARY KEY(pid) |
| 12 | ) ENGINE=InnoDB, CHARSET=utf8; |
| 13 | |
| 14 | |
| 15 | CREATE TABLE profile_corps_enum ( |
| 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) |
| 23 | ) ENGINE=InnoDB, CHARSET=utf8; |
| 24 | |
| 25 | |
| 26 | CREATE TABLE profile_corps_rank_enum ( |
| 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) |
| 33 | ) ENGINE=InnoDB, CHARSET=utf8; |
| 34 | |
| 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"); |
| 580 | |
| 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); |
| 658 | |
| 659 | ALTER TABLE watch_profile |
| 660 | MODIFY field ENUM('nom', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3', |
| 661 | 'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals', |
| 662 | 'cv', 'jobs', 'photo', 'corps'); |
| 663 | |
| 664 | -- vim:set syntax=mysql: |