upgrade/merge-0.0.1/03_corps.sql

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