-- WARNING: Do not modify this script. Make a new one instead.

-- New AX identifiants
UPDATE profiles SET ax_id = 20100029 WHERE pid = 43956;
UPDATE profiles SET ax_id = 20100030 WHERE pid = 43959;
UPDATE profiles SET ax_id = 20100031 WHERE pid = 44079;
UPDATE profiles SET ax_id = 20100032 WHERE pid = 43961;
UPDATE profiles SET ax_id = 20100033 WHERE pid = 43964;
UPDATE profiles SET ax_id = 20100034 WHERE pid = 43965;
UPDATE profiles SET ax_id = 20100035 WHERE pid = 43966;
UPDATE profiles SET ax_id = 20100037 WHERE pid = 43968;
UPDATE profiles SET ax_id = 20100038 WHERE pid = 43969;
UPDATE profiles SET ax_id = 20100039 WHERE pid = 43970;
UPDATE profiles SET ax_id = 20100040 WHERE pid = 43971;
UPDATE profiles SET ax_id = 20100041 WHERE pid = 43972;
UPDATE profiles SET ax_id = 20100042 WHERE pid = 43973;
UPDATE profiles SET ax_id = 20100043 WHERE pid = 43974;
UPDATE profiles SET ax_id = 20100044 WHERE pid = 43976;
UPDATE profiles SET ax_id = 20100045 WHERE pid = 43977;
UPDATE profiles SET ax_id = 20100046 WHERE pid = 43978;
UPDATE profiles SET ax_id = 20100047 WHERE pid = 43979;
UPDATE profiles SET ax_id = 20100048 WHERE pid = 43980;
UPDATE profiles SET ax_id = 20100049 WHERE pid = 43981;
UPDATE profiles SET ax_id = 20100050 WHERE pid = 43983;
UPDATE profiles SET ax_id = 20100051 WHERE pid = 43984;
UPDATE profiles SET ax_id = 20100052 WHERE pid = 43985;
UPDATE profiles SET ax_id = 20100053 WHERE pid = 43986;
UPDATE profiles SET ax_id = 20100054 WHERE pid = 43987;
UPDATE profiles SET ax_id = 20100055 WHERE pid = 43988;
UPDATE profiles SET ax_id = 20100056 WHERE pid = 43989;
UPDATE profiles SET ax_id = 20100057 WHERE pid = 43990;
UPDATE profiles SET ax_id = 20100058 WHERE pid = 43991;
UPDATE profiles SET ax_id = 20100059 WHERE pid = 43993;
UPDATE profiles SET ax_id = 20100060 WHERE pid = 43994;
UPDATE profiles SET ax_id = 20100061 WHERE pid = 43997;
UPDATE profiles SET ax_id = 20100062 WHERE pid = 43998;
UPDATE profiles SET ax_id = 20100063 WHERE pid = 43999;
UPDATE profiles SET ax_id = 20100064 WHERE pid = 44000;
UPDATE profiles SET ax_id = 20100065 WHERE pid = 44002;
UPDATE profiles SET ax_id = 20100066 WHERE pid = 44003;
UPDATE profiles SET ax_id = 20100067 WHERE pid = 44004;
UPDATE profiles SET ax_id = 20100068 WHERE pid = 44005;
UPDATE profiles SET ax_id = 20100069 WHERE pid = 44006;
UPDATE profiles SET ax_id = 20100070 WHERE pid = 44010;
UPDATE profiles SET ax_id = 20100071 WHERE pid = 44011;
UPDATE profiles SET ax_id = 20100072 WHERE pid = 44012;
UPDATE profiles SET ax_id = 20100073 WHERE pid = 44013;
UPDATE profiles SET ax_id = 20100074 WHERE pid = 44014;
UPDATE profiles SET ax_id = 20100075 WHERE pid = 44015;
UPDATE profiles SET ax_id = 20100076 WHERE pid = 44016;
UPDATE profiles SET ax_id = 20100077 WHERE pid = 44017;
UPDATE profiles SET ax_id = 20100078 WHERE pid = 44018;
UPDATE profiles SET ax_id = 20100079 WHERE pid = 44019;
UPDATE profiles SET ax_id = 20100080 WHERE pid = 44021;
UPDATE profiles SET ax_id = 20100081 WHERE pid = 44022;
UPDATE profiles SET ax_id = 20100082 WHERE pid = 44023;
UPDATE profiles SET ax_id = 20100083 WHERE pid = 44024;
UPDATE profiles SET ax_id = 20100084 WHERE pid = 44025;
UPDATE profiles SET ax_id = 20100085 WHERE pid = 44026;
UPDATE profiles SET ax_id = 20100086 WHERE pid = 44028;
UPDATE profiles SET ax_id = 20100087 WHERE pid = 44029;
UPDATE profiles SET ax_id = 20100088 WHERE pid = 44030;
UPDATE profiles SET ax_id = 20100089 WHERE pid = 44031;
UPDATE profiles SET ax_id = 20100090 WHERE pid = 44032;
UPDATE profiles SET ax_id = 20100091 WHERE pid = 44033;
UPDATE profiles SET ax_id = 20100092 WHERE pid = 44034;
UPDATE profiles SET ax_id = 20100093 WHERE pid = 44035;
UPDATE profiles SET ax_id = 20100094 WHERE pid = 44036;
UPDATE profiles SET ax_id = 20100095 WHERE pid = 44037;
UPDATE profiles SET ax_id = 20100096 WHERE pid = 44038;
UPDATE profiles SET ax_id = 20100097 WHERE pid = 44040;
UPDATE profiles SET ax_id = 20100098 WHERE pid = 44042;
UPDATE profiles SET ax_id = 20100099 WHERE pid = 44043;
UPDATE profiles SET ax_id = 20100100 WHERE pid = 44044;
UPDATE profiles SET ax_id = 20100101 WHERE pid = 44045;
UPDATE profiles SET ax_id = 20100102 WHERE pid = 44046;
UPDATE profiles SET ax_id = 20100103 WHERE pid = 44047;
UPDATE profiles SET ax_id = 20100104 WHERE pid = 44048;
UPDATE profiles SET ax_id = 20100105 WHERE pid = 44049;
UPDATE profiles SET ax_id = 20100106 WHERE pid = 44050;
UPDATE profiles SET ax_id = 20100107 WHERE pid = 44051;
UPDATE profiles SET ax_id = 20100108 WHERE pid = 44053;
UPDATE profiles SET ax_id = 20100109 WHERE pid = 44054;
UPDATE profiles SET ax_id = 20100110 WHERE pid = 44055;
UPDATE profiles SET ax_id = 20100111 WHERE pid = 44056;
UPDATE profiles SET ax_id = 20100112 WHERE pid = 44057;
UPDATE profiles SET ax_id = 20100113 WHERE pid = 44058;
UPDATE profiles SET ax_id = 20100114 WHERE pid = 44060;
UPDATE profiles SET ax_id = 20100115 WHERE pid = 44062;
UPDATE profiles SET ax_id = 20100116 WHERE pid = 44063;
UPDATE profiles SET ax_id = 20100117 WHERE pid = 44064;
UPDATE profiles SET ax_id = 20100118 WHERE pid = 44065;
UPDATE profiles SET ax_id = 20100119 WHERE pid = 44087;
UPDATE profiles SET ax_id = 20100120 WHERE pid = 44066;
UPDATE profiles SET ax_id = 20100121 WHERE pid = 44067;
UPDATE profiles SET ax_id = 20100122 WHERE pid = 44068;
UPDATE profiles SET ax_id = 20100123 WHERE pid = 44069;
UPDATE profiles SET ax_id = 20100124 WHERE pid = 44070;
UPDATE profiles SET ax_id = 20100125 WHERE pid = 44071;
UPDATE profiles SET ax_id = 20100126 WHERE pid = 44072;
UPDATE profiles SET ax_id = 20100127 WHERE pid = 44073;
UPDATE profiles SET ax_id = 20100128 WHERE pid = 44074;
UPDATE profiles SET ax_id = 20100129 WHERE pid = 44075;
UPDATE profiles SET ax_id = 20100130 WHERE pid = 44076;
UPDATE profiles SET ax_id = 20100131 WHERE pid = 44077;
UPDATE profiles SET ax_id = 20100132 WHERE pid = 44078;
UPDATE profiles SET ax_id = 20100133 WHERE pid = 44080;
UPDATE profiles SET ax_id = 20100134 WHERE pid = 44082;
UPDATE profiles SET ax_id = 20100135 WHERE pid = 44083;
UPDATE profiles SET ax_id = 20100136 WHERE pid = 44084;
UPDATE profiles SET ax_id = 20100137 WHERE pid = 44085;
UPDATE profiles SET ax_id = 20100138 WHERE pid = 44086;
UPDATE profiles SET ax_id = 20100139 WHERE pid = 44094;
UPDATE profiles SET ax_id = 20100140 WHERE pid = 44095;
UPDATE profiles SET ax_id = 20100141 WHERE pid = 44096;
UPDATE profiles SET ax_id = 20100142 WHERE pid = 44097;
UPDATE profiles SET ax_id = 20100143 WHERE pid = 44098;
UPDATE profiles SET ax_id = 20100144 WHERE pid = 44099;
UPDATE profiles SET ax_id = 20100145 WHERE pid = 44100;
UPDATE profiles SET ax_id = 20100146 WHERE pid = 44101;
UPDATE profiles SET ax_id = 20100147 WHERE pid = 44102;
UPDATE profiles SET ax_id = 20100148 WHERE pid = 44103;
UPDATE profiles SET ax_id = 20100149 WHERE pid = 44105;
UPDATE profiles SET ax_id = 20100150 WHERE pid = 44106;
UPDATE profiles SET ax_id = 20100151 WHERE pid = 44107;
UPDATE profiles SET ax_id = 20100152 WHERE pid = 44108;
UPDATE profiles SET ax_id = 20100153 WHERE pid = 44109;
UPDATE profiles SET ax_id = 20100154 WHERE pid = 44110;
UPDATE profiles SET ax_id = 20100155 WHERE pid = 44111;
UPDATE profiles SET ax_id = 20100156 WHERE pid = 44112;
UPDATE profiles SET ax_id = 20100157 WHERE pid = 44113;
UPDATE profiles SET ax_id = 20100158 WHERE pid = 44114;
UPDATE profiles SET ax_id = 20100159 WHERE pid = 44115;
UPDATE profiles SET ax_id = 20100160 WHERE pid = 44116;
UPDATE profiles SET ax_id = 20100161 WHERE pid = 44117;
UPDATE profiles SET ax_id = 20100162 WHERE pid = 44118;
UPDATE profiles SET ax_id = 20100163 WHERE pid = 44119;
UPDATE profiles SET ax_id = 20100164 WHERE pid = 44120;
UPDATE profiles SET ax_id = 20100165 WHERE pid = 44122;
UPDATE profiles SET ax_id = 20100166 WHERE pid = 44123;
UPDATE profiles SET ax_id = 20100167 WHERE pid = 44125;
UPDATE profiles SET ax_id = 20100168 WHERE pid = 44127;
UPDATE profiles SET ax_id = 20100169 WHERE pid = 44126;
UPDATE profiles SET ax_id = 20100170 WHERE pid = 44128;
UPDATE profiles SET ax_id = 20100171 WHERE pid = 44129;
UPDATE profiles SET ax_id = 20100172 WHERE pid = 44130;
UPDATE profiles SET ax_id = 20100173 WHERE pid = 44131;
UPDATE profiles SET ax_id = 20100174 WHERE pid = 44132;
UPDATE profiles SET ax_id = 20100175 WHERE pid = 44133;
UPDATE profiles SET ax_id = 20100176 WHERE pid = 44134;
UPDATE profiles SET ax_id = 20100177 WHERE pid = 44135;
UPDATE profiles SET ax_id = 20100178 WHERE pid = 44136;
UPDATE profiles SET ax_id = 20100179 WHERE pid = 44137;
UPDATE profiles SET ax_id = 20100180 WHERE pid = 44138;
UPDATE profiles SET ax_id = 20100181 WHERE pid = 44140;
UPDATE profiles SET ax_id = 20100182 WHERE pid = 44141;
UPDATE profiles SET ax_id = 20100183 WHERE pid = 44142;
UPDATE profiles SET ax_id = 20100184 WHERE pid = 44143;
UPDATE profiles SET ax_id = 20100185 WHERE pid = 44144;
UPDATE profiles SET ax_id = 20100186 WHERE pid = 44145;
UPDATE profiles SET ax_id = 20100187 WHERE pid = 44146;
UPDATE profiles SET ax_id = 20100188 WHERE pid = 44147;
UPDATE profiles SET ax_id = 20100189 WHERE pid = 44148;
UPDATE profiles SET ax_id = 20100190 WHERE pid = 44149;
UPDATE profiles SET ax_id = 20100191 WHERE pid = 44150;
UPDATE profiles SET ax_id = 20100192 WHERE pid = 44151;
UPDATE profiles SET ax_id = 20100193 WHERE pid = 44152;
UPDATE profiles SET ax_id = 20100194 WHERE pid = 44153;
UPDATE profiles SET ax_id = 20100195 WHERE pid = 44154;
UPDATE profiles SET ax_id = 20100196 WHERE pid = 44155;
UPDATE profiles SET ax_id = 20100197 WHERE pid = 44156;
UPDATE profiles SET ax_id = 20100198 WHERE pid = 44157;
UPDATE profiles SET ax_id = 20100199 WHERE pid = 44158;
UPDATE profiles SET ax_id = 20100200 WHERE pid = 44159;
UPDATE profiles SET ax_id = 20100201 WHERE pid = 44160;
UPDATE profiles SET ax_id = 20100202 WHERE pid = 44161;
UPDATE profiles SET ax_id = 20100203 WHERE pid = 44162;
UPDATE profiles SET ax_id = 20100204 WHERE pid = 44164;
UPDATE profiles SET ax_id = 20100205 WHERE pid = 44166;
UPDATE profiles SET ax_id = 20100206 WHERE pid = 44167;
UPDATE profiles SET ax_id = 20100207 WHERE pid = 44168;
UPDATE profiles SET ax_id = 20100208 WHERE pid = 44169;
UPDATE profiles SET ax_id = 20100209 WHERE pid = 44172;
UPDATE profiles SET ax_id = 20100210 WHERE pid = 44173;
UPDATE profiles SET ax_id = 20100211 WHERE pid = 44174;
UPDATE profiles SET ax_id = 20100212 WHERE pid = 44175;
UPDATE profiles SET ax_id = 20100213 WHERE pid = 44176;
UPDATE profiles SET ax_id = 20100214 WHERE pid = 44177;
UPDATE profiles SET ax_id = 20100215 WHERE pid = 44178;
UPDATE profiles SET ax_id = 20100216 WHERE pid = 44179;
UPDATE profiles SET ax_id = 20100217 WHERE pid = 44180;
UPDATE profiles SET ax_id = 20100218 WHERE pid = 44181;
UPDATE profiles SET ax_id = 20100219 WHERE pid = 44182;
UPDATE profiles SET ax_id = 20100220 WHERE pid = 44183;
UPDATE profiles SET ax_id = 20100221 WHERE pid = 44184;
UPDATE profiles SET ax_id = 20100222 WHERE pid = 44185;
UPDATE profiles SET ax_id = 20100223 WHERE pid = 44186;
UPDATE profiles SET ax_id = 20100224 WHERE pid = 44187;
UPDATE profiles SET ax_id = 20100225 WHERE pid = 44188;
UPDATE profiles SET ax_id = 20100226 WHERE pid = 44190;
UPDATE profiles SET ax_id = 20100227 WHERE pid = 44191;
UPDATE profiles SET ax_id = 20100228 WHERE pid = 44192;
UPDATE profiles SET ax_id = 20100229 WHERE pid = 44194;
UPDATE profiles SET ax_id = 20100230 WHERE pid = 44195;
UPDATE profiles SET ax_id = 20100231 WHERE pid = 44196;
UPDATE profiles SET ax_id = 20100232 WHERE pid = 44198;
UPDATE profiles SET ax_id = 20100233 WHERE pid = 44199;
UPDATE profiles SET ax_id = 20100234 WHERE pid = 44200;
UPDATE profiles SET ax_id = 20100235 WHERE pid = 44201;
UPDATE profiles SET ax_id = 20100236 WHERE pid = 44203;
UPDATE profiles SET ax_id = 20100237 WHERE pid = 44204;
UPDATE profiles SET ax_id = 20100238 WHERE pid = 44205;
UPDATE profiles SET ax_id = 20100239 WHERE pid = 44206;
UPDATE profiles SET ax_id = 20100240 WHERE pid = 44207;
UPDATE profiles SET ax_id = 20100241 WHERE pid = 44208;
UPDATE profiles SET ax_id = 20100242 WHERE pid = 44210;
UPDATE profiles SET ax_id = 20100243 WHERE pid = 44213;
UPDATE profiles SET ax_id = 20100244 WHERE pid = 44215;
UPDATE profiles SET ax_id = 20100245 WHERE pid = 44216;
UPDATE profiles SET ax_id = 20100246 WHERE pid = 44217;
UPDATE profiles SET ax_id = 20100247 WHERE pid = 44218;
UPDATE profiles SET ax_id = 20100248 WHERE pid = 44219;
UPDATE profiles SET ax_id = 20100249 WHERE pid = 44220;
UPDATE profiles SET ax_id = 20100250 WHERE pid = 44221;
UPDATE profiles SET ax_id = 20100251 WHERE pid = 44222;
UPDATE profiles SET ax_id = 20100252 WHERE pid = 44088;
UPDATE profiles SET ax_id = 20100253 WHERE pid = 44223;
UPDATE profiles SET ax_id = 20100254 WHERE pid = 44224;
UPDATE profiles SET ax_id = 20100255 WHERE pid = 44225;
UPDATE profiles SET ax_id = 20100256 WHERE pid = 44226;
UPDATE profiles SET ax_id = 20100257 WHERE pid = 44214;
UPDATE profiles SET ax_id = 20100258 WHERE pid = 44227;
UPDATE profiles SET ax_id = 20100259 WHERE pid = 44228;
UPDATE profiles SET ax_id = 20100260 WHERE pid = 44229;
UPDATE profiles SET ax_id = 20100261 WHERE pid = 44230;
UPDATE profiles SET ax_id = 20100262 WHERE pid = 44231;
UPDATE profiles SET ax_id = 20100263 WHERE pid = 44232;
UPDATE profiles SET ax_id = 20100264 WHERE pid = 44233;
UPDATE profiles SET ax_id = 20100265 WHERE pid = 44234;
UPDATE profiles SET ax_id = 20100266 WHERE pid = 44235;
UPDATE profiles SET ax_id = 20100267 WHERE pid = 44237;
UPDATE profiles SET ax_id = 20100268 WHERE pid = 44238;
UPDATE profiles SET ax_id = 20100269 WHERE pid = 44239;
UPDATE profiles SET ax_id = 20100270 WHERE pid = 44240;
UPDATE profiles SET ax_id = 20100271 WHERE pid = 44241;
UPDATE profiles SET ax_id = 20100272 WHERE pid = 44089;
UPDATE profiles SET ax_id = 20100273 WHERE pid = 44242;
UPDATE profiles SET ax_id = 20100274 WHERE pid = 44243;
UPDATE profiles SET ax_id = 20100275 WHERE pid = 44244;
UPDATE profiles SET ax_id = 20100276 WHERE pid = 44245;
UPDATE profiles SET ax_id = 20100277 WHERE pid = 44250;
UPDATE profiles SET ax_id = 20100278 WHERE pid = 44251;
UPDATE profiles SET ax_id = 20100279 WHERE pid = 44252;
UPDATE profiles SET ax_id = 20100280 WHERE pid = 44253;
UPDATE profiles SET ax_id = 20100281 WHERE pid = 44254;
UPDATE profiles SET ax_id = 20100282 WHERE pid = 44255;
UPDATE profiles SET ax_id = 20100283 WHERE pid = 44256;
UPDATE profiles SET ax_id = 20100284 WHERE pid = 44257;
UPDATE profiles SET ax_id = 20100285 WHERE pid = 44258;
UPDATE profiles SET ax_id = 20100286 WHERE pid = 44259;
UPDATE profiles SET ax_id = 20100287 WHERE pid = 44090;
UPDATE profiles SET ax_id = 20100288 WHERE pid = 44261;
UPDATE profiles SET ax_id = 20100289 WHERE pid = 44262;
UPDATE profiles SET ax_id = 20100290 WHERE pid = 44263;
UPDATE profiles SET ax_id = 20100291 WHERE pid = 44264;
UPDATE profiles SET ax_id = 20100292 WHERE pid = 44265;
UPDATE profiles SET ax_id = 20100293 WHERE pid = 44266;
UPDATE profiles SET ax_id = 20100294 WHERE pid = 44267;
UPDATE profiles SET ax_id = 20100295 WHERE pid = 44268;
UPDATE profiles SET ax_id = 20100296 WHERE pid = 44270;
UPDATE profiles SET ax_id = 20100297 WHERE pid = 44271;
UPDATE profiles SET ax_id = 20100298 WHERE pid = 44272;
UPDATE profiles SET ax_id = 20100299 WHERE pid = 44273;
UPDATE profiles SET ax_id = 20100300 WHERE pid = 44274;
UPDATE profiles SET ax_id = 20100301 WHERE pid = 44275;
UPDATE profiles SET ax_id = 20100302 WHERE pid = 44091;
UPDATE profiles SET ax_id = 20100303 WHERE pid = 44276;
UPDATE profiles SET ax_id = 20100304 WHERE pid = 44277;
UPDATE profiles SET ax_id = 20100305 WHERE pid = 44278;
UPDATE profiles SET ax_id = 20100306 WHERE pid = 44279;
UPDATE profiles SET ax_id = 20100307 WHERE pid = 44280;
UPDATE profiles SET ax_id = 20100308 WHERE pid = 44281;
UPDATE profiles SET ax_id = 20100309 WHERE pid = 44282;
UPDATE profiles SET ax_id = 20100310 WHERE pid = 44283;
UPDATE profiles SET ax_id = 20100311 WHERE pid = 44284;
UPDATE profiles SET ax_id = 20100312 WHERE pid = 44285;
UPDATE profiles SET ax_id = 20100313 WHERE pid = 44287;
UPDATE profiles SET ax_id = 20100314 WHERE pid = 44286;
UPDATE profiles SET ax_id = 20100315 WHERE pid = 44288;
UPDATE profiles SET ax_id = 20100316 WHERE pid = 44289;
UPDATE profiles SET ax_id = 20100317 WHERE pid = 44291;
UPDATE profiles SET ax_id = 20100318 WHERE pid = 44292;
UPDATE profiles SET ax_id = 20100319 WHERE pid = 44296;
UPDATE profiles SET ax_id = 20100320 WHERE pid = 44297;
UPDATE profiles SET ax_id = 20100321 WHERE pid = 44298;
UPDATE profiles SET ax_id = 20100322 WHERE pid = 44299;
UPDATE profiles SET ax_id = 20100323 WHERE pid = 44301;
UPDATE profiles SET ax_id = 20100324 WHERE pid = 44302;
UPDATE profiles SET ax_id = 20100325 WHERE pid = 44304;
UPDATE profiles SET ax_id = 20100326 WHERE pid = 44305;
UPDATE profiles SET ax_id = 20100327 WHERE pid = 44306;
UPDATE profiles SET ax_id = 20100328 WHERE pid = 44307;
UPDATE profiles SET ax_id = 20100329 WHERE pid = 44308;
UPDATE profiles SET ax_id = 20100330 WHERE pid = 44309;
UPDATE profiles SET ax_id = 20100331 WHERE pid = 44310;
UPDATE profiles SET ax_id = 20100332 WHERE pid = 44311;
UPDATE profiles SET ax_id = 20100333 WHERE pid = 44312;
UPDATE profiles SET ax_id = 20100334 WHERE pid = 44313;
UPDATE profiles SET ax_id = 20100335 WHERE pid = 44314;
UPDATE profiles SET ax_id = 20100336 WHERE pid = 44315;
UPDATE profiles SET ax_id = 20100337 WHERE pid = 44316;
UPDATE profiles SET ax_id = 20100338 WHERE pid = 44317;
UPDATE profiles SET ax_id = 20100339 WHERE pid = 44318;
UPDATE profiles SET ax_id = 20100340 WHERE pid = 44319;
UPDATE profiles SET ax_id = 20100341 WHERE pid = 44320;
UPDATE profiles SET ax_id = 20100342 WHERE pid = 44321;
UPDATE profiles SET ax_id = 20100343 WHERE pid = 44322;
UPDATE profiles SET ax_id = 20100344 WHERE pid = 44323;
UPDATE profiles SET ax_id = 20100345 WHERE pid = 44324;
UPDATE profiles SET ax_id = 20100346 WHERE pid = 44325;
UPDATE profiles SET ax_id = 20100347 WHERE pid = 44326;
UPDATE profiles SET ax_id = 20100348 WHERE pid = 44327;
UPDATE profiles SET ax_id = 20100349 WHERE pid = 44328;
UPDATE profiles SET ax_id = 20100350 WHERE pid = 44329;
UPDATE profiles SET ax_id = 20100351 WHERE pid = 44330;
UPDATE profiles SET ax_id = 20100352 WHERE pid = 44331;
UPDATE profiles SET ax_id = 20100353 WHERE pid = 44332;
UPDATE profiles SET ax_id = 20100354 WHERE pid = 44333;
UPDATE profiles SET ax_id = 20100355 WHERE pid = 44334;
UPDATE profiles SET ax_id = 20100356 WHERE pid = 44335;
UPDATE profiles SET ax_id = 20100357 WHERE pid = 44336;
UPDATE profiles SET ax_id = 20100358 WHERE pid = 44337;
UPDATE profiles SET ax_id = 20100359 WHERE pid = 44338;
UPDATE profiles SET ax_id = 20100360 WHERE pid = 44339;
UPDATE profiles SET ax_id = 20100361 WHERE pid = 44340;
UPDATE profiles SET ax_id = 20100362 WHERE pid = 44341;
UPDATE profiles SET ax_id = 20100363 WHERE pid = 44342;
UPDATE profiles SET ax_id = 20100364 WHERE pid = 44343;
UPDATE profiles SET ax_id = 20100365 WHERE pid = 44345;
UPDATE profiles SET ax_id = 20100366 WHERE pid = 44346;
UPDATE profiles SET ax_id = 20100367 WHERE pid = 44347;
UPDATE profiles SET ax_id = 20100368 WHERE pid = 44348;
UPDATE profiles SET ax_id = 20100369 WHERE pid = 44349;
UPDATE profiles SET ax_id = 20100370 WHERE pid = 44350;
UPDATE profiles SET ax_id = 20100371 WHERE pid = 44351;
UPDATE profiles SET ax_id = 20100372 WHERE pid = 44352;
UPDATE profiles SET ax_id = 20100373 WHERE pid = 44353;
UPDATE profiles SET ax_id = 20100374 WHERE pid = 44354;
UPDATE profiles SET ax_id = 20100375 WHERE pid = 44355;
UPDATE profiles SET ax_id = 20100376 WHERE pid = 44356;
UPDATE profiles SET ax_id = 20100377 WHERE pid = 44357;
UPDATE profiles SET ax_id = 20100378 WHERE pid = 44358;
UPDATE profiles SET ax_id = 20100379 WHERE pid = 44359;
UPDATE profiles SET ax_id = 20100380 WHERE pid = 44362;
UPDATE profiles SET ax_id = 20100381 WHERE pid = 44363;
UPDATE profiles SET ax_id = 20100382 WHERE pid = 44364;
UPDATE profiles SET ax_id = 20100383 WHERE pid = 44366;
UPDATE profiles SET ax_id = 20100384 WHERE pid = 44367;
UPDATE profiles SET ax_id = 20100385 WHERE pid = 44092;
UPDATE profiles SET ax_id = 20100386 WHERE pid = 44368;
UPDATE profiles SET ax_id = 20100387 WHERE pid = 44369;
UPDATE profiles SET ax_id = 20100388 WHERE pid = 44093;
UPDATE profiles SET ax_id = 20100389 WHERE pid = 44370;
UPDATE profiles SET ax_id = 20100390 WHERE pid = 44371;
UPDATE profiles SET ax_id = 20100391 WHERE pid = 44372;
UPDATE profiles SET ax_id = 20100392 WHERE pid = 44373;
UPDATE profiles SET ax_id = 20100393 WHERE pid = 44374;
UPDATE profiles SET ax_id = 20100394 WHERE pid = 44377;
UPDATE profiles SET ax_id = 20100395 WHERE pid = 44378;
UPDATE profiles SET ax_id = 20100396 WHERE pid = 44379;
UPDATE profiles SET ax_id = 20100397 WHERE pid = 44380;
UPDATE profiles SET ax_id = 20100398 WHERE pid = 44382;
UPDATE profiles SET ax_id = 20100399 WHERE pid = 44361;
UPDATE profiles SET ax_id = 20100400 WHERE pid = 44383;
UPDATE profiles SET ax_id = 20100401 WHERE pid = 44384;
UPDATE profiles SET ax_id = 20100402 WHERE pid = 44385;
UPDATE profiles SET ax_id = 20100403 WHERE pid = 44386;
UPDATE profiles SET ax_id = 20100404 WHERE pid = 44388;
UPDATE profiles SET ax_id = 20100405 WHERE pid = 44389;
UPDATE profiles SET ax_id = 20100406 WHERE pid = 44390;
UPDATE profiles SET ax_id = 20100407 WHERE pid = 44392;
UPDATE profiles SET ax_id = 20100408 WHERE pid = 44393;
UPDATE profiles SET ax_id = 20100409 WHERE pid = 44394;
UPDATE profiles SET ax_id = 20100410 WHERE pid = 44395;
UPDATE profiles SET ax_id = 20100411 WHERE pid = 44398;
UPDATE profiles SET ax_id = 20100412 WHERE pid = 44399;
UPDATE profiles SET ax_id = 20100413 WHERE pid = 44400;
UPDATE profiles SET ax_id = 20100414 WHERE pid = 44401;
UPDATE profiles SET ax_id = 20100415 WHERE pid = 44402;
UPDATE profiles SET ax_id = 20100416 WHERE pid = 44403;
UPDATE profiles SET ax_id = 20100417 WHERE pid = 44404;
UPDATE profiles SET ax_id = 20100418 WHERE pid = 44405;
UPDATE profiles SET ax_id = 20100419 WHERE pid = 44406;
UPDATE profiles SET ax_id = 20100420 WHERE pid = 44411;
UPDATE profiles SET ax_id = 20100421 WHERE pid = 44412;
UPDATE profiles SET ax_id = 20100422 WHERE pid = 44413;
UPDATE profiles SET ax_id = 20100423 WHERE pid = 44414;
UPDATE profiles SET ax_id = 20100424 WHERE pid = 44415;
UPDATE profiles SET ax_id = 20100425 WHERE pid = 44417;
UPDATE profiles SET ax_id = 20100426 WHERE pid = 44420;
UPDATE profiles SET ax_id = 20100427 WHERE pid = 44423;
UPDATE profiles SET ax_id = 20100428 WHERE pid = 44428;
UPDATE profiles SET ax_id = 20100429 WHERE pid = 43957;
UPDATE profiles SET ax_id = 20100430 WHERE pid = 43958;
UPDATE profiles SET ax_id = 20100431 WHERE pid = 43960;
UPDATE profiles SET ax_id = 20100432 WHERE pid = 43962;
UPDATE profiles SET ax_id = 20100433 WHERE pid = 43963;
UPDATE profiles SET ax_id = 20100434 WHERE pid = 43975;
UPDATE profiles SET ax_id = 20100435 WHERE pid = 43982;
UPDATE profiles SET ax_id = 20100436 WHERE pid = 43992;
UPDATE profiles SET ax_id = 20100437 WHERE pid = 43995;
UPDATE profiles SET ax_id = 20100438 WHERE pid = 43996;
UPDATE profiles SET ax_id = 20100439 WHERE pid = 44001;
UPDATE profiles SET ax_id = 20100440 WHERE pid = 44007;
UPDATE profiles SET ax_id = 20100441 WHERE pid = 44008;
UPDATE profiles SET ax_id = 20100442 WHERE pid = 44009;
UPDATE profiles SET ax_id = 20100443 WHERE pid = 44020;
UPDATE profiles SET ax_id = 20100444 WHERE pid = 44027;
UPDATE profiles SET ax_id = 20100445 WHERE pid = 44039;
UPDATE profiles SET ax_id = 20100446 WHERE pid = 44041;
UPDATE profiles SET ax_id = 20100447 WHERE pid = 44052;
UPDATE profiles SET ax_id = 20100448 WHERE pid = 44059;
UPDATE profiles SET ax_id = 20100449 WHERE pid = 44061;
UPDATE profiles SET ax_id = 20100450 WHERE pid = 44081;
UPDATE profiles SET ax_id = 20100451 WHERE pid = 44104;
UPDATE profiles SET ax_id = 20100452 WHERE pid = 44121;
UPDATE profiles SET ax_id = 20100453 WHERE pid = 44124;
UPDATE profiles SET ax_id = 20100454 WHERE pid = 44139;
UPDATE profiles SET ax_id = 20100455 WHERE pid = 44163;
UPDATE profiles SET ax_id = 20100456 WHERE pid = 44165;
UPDATE profiles SET ax_id = 20100457 WHERE pid = 44170;
UPDATE profiles SET ax_id = 20100458 WHERE pid = 44171;
UPDATE profiles SET ax_id = 20100459 WHERE pid = 44189;
UPDATE profiles SET ax_id = 20100460 WHERE pid = 44193;
UPDATE profiles SET ax_id = 20100461 WHERE pid = 44197;
UPDATE profiles SET ax_id = 20100462 WHERE pid = 44202;
UPDATE profiles SET ax_id = 20100463 WHERE pid = 44209;
UPDATE profiles SET ax_id = 20100464 WHERE pid = 44211;
UPDATE profiles SET ax_id = 20100465 WHERE pid = 44212;
UPDATE profiles SET ax_id = 20100466 WHERE pid = 44236;
UPDATE profiles SET ax_id = 20100467 WHERE pid = 44247;
UPDATE profiles SET ax_id = 20100468 WHERE pid = 44246;
UPDATE profiles SET ax_id = 20100469 WHERE pid = 44248;
UPDATE profiles SET ax_id = 20100470 WHERE pid = 44249;
UPDATE profiles SET ax_id = 20100471 WHERE pid = 44260;
UPDATE profiles SET ax_id = 20100472 WHERE pid = 44269;
UPDATE profiles SET ax_id = 20100474 WHERE pid = 44290;
UPDATE profiles SET ax_id = 20100475 WHERE pid = 44293;
UPDATE profiles SET ax_id = 20100476 WHERE pid = 44294;
UPDATE profiles SET ax_id = 20100477 WHERE pid = 44295;
UPDATE profiles SET ax_id = 20100478 WHERE pid = 44300;
UPDATE profiles SET ax_id = 20100480 WHERE pid = 44303;
UPDATE profiles SET ax_id = 20100481 WHERE pid = 44344;
UPDATE profiles SET ax_id = 20100482 WHERE pid = 44360;
UPDATE profiles SET ax_id = 20100483 WHERE pid = 44365;
UPDATE profiles SET ax_id = 20100484 WHERE pid = 44375;
UPDATE profiles SET ax_id = 20100485 WHERE pid = 44376;
UPDATE profiles SET ax_id = 20100486 WHERE pid = 44381;
UPDATE profiles SET ax_id = 20100487 WHERE pid = 44387;
UPDATE profiles SET ax_id = 20100488 WHERE pid = 44391;
UPDATE profiles SET ax_id = 20100489 WHERE pid = 44396;
UPDATE profiles SET ax_id = 20100490 WHERE pid = 44397;
UPDATE profiles SET ax_id = 20100491 WHERE pid = 44407;
UPDATE profiles SET ax_id = 20100492 WHERE pid = 44408;
UPDATE profiles SET ax_id = 20100493 WHERE pid = 44409;
UPDATE profiles SET ax_id = 20100494 WHERE pid = 44410;
UPDATE profiles SET ax_id = 20100495 WHERE pid = 44416;
UPDATE profiles SET ax_id = 20100496 WHERE pid = 44418;
UPDATE profiles SET ax_id = 20100497 WHERE pid = 44419;
UPDATE profiles SET ax_id = 20100498 WHERE pid = 44421;
UPDATE profiles SET ax_id = 20100499 WHERE pid = 44422;
UPDATE profiles SET ax_id = 20100500 WHERE pid = 44424;
UPDATE profiles SET ax_id = 20100501 WHERE pid = 44425;
UPDATE profiles SET ax_id = 20100502 WHERE pid = 44426;
UPDATE profiles SET ax_id = 20100503 WHERE pid = 44427;

-- Updates promo for oranjes who only stated their orajisation to AX.
-- WARNING: this does not affect the display of their promotion anywhere. It will just allow them to attend events to both promotions.
-- Also they wiil not need to require a validation if they want to change promo on the site.

UPDATE  profile_education
   SET  grad_year = grad_year + 1
   WHERE  FIND_IN_SET('primary', flags) AND pid IN (42018, 42216, 43135, 43216, 42981, 43039, 41827, 42322);

-- Same as before but double orajisation.
UPDATE  profile_education
   SET  grad_year = grad_year + 2
 WHERE  FIND_IN_SET('primary', flags) AND pid = 41291;

-- Fixes erroneous data
UPDATE  profile_education
   SET  entry_year = 1951, grad_year = 1954
 WHERE  FIND_IN_SET('primary', flags) AND pid = 29674;
UPDATE  profile_display
   SET  promo = 'X1951'
 WHERE  pid = 29674;

-- Inserts missing couple (education, degree) required by AX data.
INSERT IGNORE INTO  profile_education_degree (eduid, degreeid)
            VALUES  (182, 2);

-- vim:set syntax=mysql:;
