upgrade/1.0.2/xx_data_update_01.sql

   1 -- WARNING: Do not modify this script. Make a new one instead.
   2
   3 -- New AX identifiants
   4 UPDATE profiles SET ax_id = 20100029 WHERE pid = 43956;
   5 UPDATE profiles SET ax_id = 20100030 WHERE pid = 43959;
   6 UPDATE profiles SET ax_id = 20100031 WHERE pid = 44079;
   7 UPDATE profiles SET ax_id = 20100032 WHERE pid = 43961;
   8 UPDATE profiles SET ax_id = 20100033 WHERE pid = 43964;
   9 UPDATE profiles SET ax_id = 20100034 WHERE pid = 43965;
  10 UPDATE profiles SET ax_id = 20100035 WHERE pid = 43966;
  11 UPDATE profiles SET ax_id = 20100037 WHERE pid = 43968;
  12 UPDATE profiles SET ax_id = 20100038 WHERE pid = 43969;
  13 UPDATE profiles SET ax_id = 20100039 WHERE pid = 43970;
  14 UPDATE profiles SET ax_id = 20100040 WHERE pid = 43971;
  15 UPDATE profiles SET ax_id = 20100041 WHERE pid = 43972;
  16 UPDATE profiles SET ax_id = 20100042 WHERE pid = 43973;
  17 UPDATE profiles SET ax_id = 20100043 WHERE pid = 43974;
  18 UPDATE profiles SET ax_id = 20100044 WHERE pid = 43976;
  19 UPDATE profiles SET ax_id = 20100045 WHERE pid = 43977;
  20 UPDATE profiles SET ax_id = 20100046 WHERE pid = 43978;
  21 UPDATE profiles SET ax_id = 20100047 WHERE pid = 43979;
  22 UPDATE profiles SET ax_id = 20100048 WHERE pid = 43980;
  23 UPDATE profiles SET ax_id = 20100049 WHERE pid = 43981;
  24 UPDATE profiles SET ax_id = 20100050 WHERE pid = 43983;
  25 UPDATE profiles SET ax_id = 20100051 WHERE pid = 43984;
  26 UPDATE profiles SET ax_id = 20100052 WHERE pid = 43985;
  27 UPDATE profiles SET ax_id = 20100053 WHERE pid = 43986;
  28 UPDATE profiles SET ax_id = 20100054 WHERE pid = 43987;
  29 UPDATE profiles SET ax_id = 20100055 WHERE pid = 43988;
  30 UPDATE profiles SET ax_id = 20100056 WHERE pid = 43989;
  31 UPDATE profiles SET ax_id = 20100057 WHERE pid = 43990;
  32 UPDATE profiles SET ax_id = 20100058 WHERE pid = 43991;
  33 UPDATE profiles SET ax_id = 20100059 WHERE pid = 43993;
  34 UPDATE profiles SET ax_id = 20100060 WHERE pid = 43994;
  35 UPDATE profiles SET ax_id = 20100061 WHERE pid = 43997;
  36 UPDATE profiles SET ax_id = 20100062 WHERE pid = 43998;
  37 UPDATE profiles SET ax_id = 20100063 WHERE pid = 43999;
  38 UPDATE profiles SET ax_id = 20100064 WHERE pid = 44000;
  39 UPDATE profiles SET ax_id = 20100065 WHERE pid = 44002;
  40 UPDATE profiles SET ax_id = 20100066 WHERE pid = 44003;
  41 UPDATE profiles SET ax_id = 20100067 WHERE pid = 44004;
  42 UPDATE profiles SET ax_id = 20100068 WHERE pid = 44005;
  43 UPDATE profiles SET ax_id = 20100069 WHERE pid = 44006;
  44 UPDATE profiles SET ax_id = 20100070 WHERE pid = 44010;
  45 UPDATE profiles SET ax_id = 20100071 WHERE pid = 44011;
  46 UPDATE profiles SET ax_id = 20100072 WHERE pid = 44012;
  47 UPDATE profiles SET ax_id = 20100073 WHERE pid = 44013;
  48 UPDATE profiles SET ax_id = 20100074 WHERE pid = 44014;
  49 UPDATE profiles SET ax_id = 20100075 WHERE pid = 44015;
  50 UPDATE profiles SET ax_id = 20100076 WHERE pid = 44016;
  51 UPDATE profiles SET ax_id = 20100077 WHERE pid = 44017;
  52 UPDATE profiles SET ax_id = 20100078 WHERE pid = 44018;
  53 UPDATE profiles SET ax_id = 20100079 WHERE pid = 44019;
  54 UPDATE profiles SET ax_id = 20100080 WHERE pid = 44021;
  55 UPDATE profiles SET ax_id = 20100081 WHERE pid = 44022;
  56 UPDATE profiles SET ax_id = 20100082 WHERE pid = 44023;
  57 UPDATE profiles SET ax_id = 20100083 WHERE pid = 44024;
  58 UPDATE profiles SET ax_id = 20100084 WHERE pid = 44025;
  59 UPDATE profiles SET ax_id = 20100085 WHERE pid = 44026;
  60 UPDATE profiles SET ax_id = 20100086 WHERE pid = 44028;
  61 UPDATE profiles SET ax_id = 20100087 WHERE pid = 44029;
  62 UPDATE profiles SET ax_id = 20100088 WHERE pid = 44030;
  63 UPDATE profiles SET ax_id = 20100089 WHERE pid = 44031;
  64 UPDATE profiles SET ax_id = 20100090 WHERE pid = 44032;
  65 UPDATE profiles SET ax_id = 20100091 WHERE pid = 44033;
  66 UPDATE profiles SET ax_id = 20100092 WHERE pid = 44034;
  67 UPDATE profiles SET ax_id = 20100093 WHERE pid = 44035;
  68 UPDATE profiles SET ax_id = 20100094 WHERE pid = 44036;
  69 UPDATE profiles SET ax_id = 20100095 WHERE pid = 44037;
  70 UPDATE profiles SET ax_id = 20100096 WHERE pid = 44038;
  71 UPDATE profiles SET ax_id = 20100097 WHERE pid = 44040;
  72 UPDATE profiles SET ax_id = 20100098 WHERE pid = 44042;
  73 UPDATE profiles SET ax_id = 20100099 WHERE pid = 44043;
  74 UPDATE profiles SET ax_id = 20100100 WHERE pid = 44044;
  75 UPDATE profiles SET ax_id = 20100101 WHERE pid = 44045;
  76 UPDATE profiles SET ax_id = 20100102 WHERE pid = 44046;
  77 UPDATE profiles SET ax_id = 20100103 WHERE pid = 44047;
  78 UPDATE profiles SET ax_id = 20100104 WHERE pid = 44048;
  79 UPDATE profiles SET ax_id = 20100105 WHERE pid = 44049;
  80 UPDATE profiles SET ax_id = 20100106 WHERE pid = 44050;
  81 UPDATE profiles SET ax_id = 20100107 WHERE pid = 44051;
  82 UPDATE profiles SET ax_id = 20100108 WHERE pid = 44053;
  83 UPDATE profiles SET ax_id = 20100109 WHERE pid = 44054;
  84 UPDATE profiles SET ax_id = 20100110 WHERE pid = 44055;
  85 UPDATE profiles SET ax_id = 20100111 WHERE pid = 44056;
  86 UPDATE profiles SET ax_id = 20100112 WHERE pid = 44057;
  87 UPDATE profiles SET ax_id = 20100113 WHERE pid = 44058;
  88 UPDATE profiles SET ax_id = 20100114 WHERE pid = 44060;
  89 UPDATE profiles SET ax_id = 20100115 WHERE pid = 44062;
  90 UPDATE profiles SET ax_id = 20100116 WHERE pid = 44063;
  91 UPDATE profiles SET ax_id = 20100117 WHERE pid = 44064;
  92 UPDATE profiles SET ax_id = 20100118 WHERE pid = 44065;
  93 UPDATE profiles SET ax_id = 20100119 WHERE pid = 44087;
  94 UPDATE profiles SET ax_id = 20100120 WHERE pid = 44066;
  95 UPDATE profiles SET ax_id = 20100121 WHERE pid = 44067;
  96 UPDATE profiles SET ax_id = 20100122 WHERE pid = 44068;
  97 UPDATE profiles SET ax_id = 20100123 WHERE pid = 44069;
  98 UPDATE profiles SET ax_id = 20100124 WHERE pid = 44070;
  99 UPDATE profiles SET ax_id = 20100125 WHERE pid = 44071;
 100 UPDATE profiles SET ax_id = 20100126 WHERE pid = 44072;
 101 UPDATE profiles SET ax_id = 20100127 WHERE pid = 44073;
 102 UPDATE profiles SET ax_id = 20100128 WHERE pid = 44074;
 103 UPDATE profiles SET ax_id = 20100129 WHERE pid = 44075;
 104 UPDATE profiles SET ax_id = 20100130 WHERE pid = 44076;
 105 UPDATE profiles SET ax_id = 20100131 WHERE pid = 44077;
 106 UPDATE profiles SET ax_id = 20100132 WHERE pid = 44078;
 107 UPDATE profiles SET ax_id = 20100133 WHERE pid = 44080;
 108 UPDATE profiles SET ax_id = 20100134 WHERE pid = 44082;
 109 UPDATE profiles SET ax_id = 20100135 WHERE pid = 44083;
 110 UPDATE profiles SET ax_id = 20100136 WHERE pid = 44084;
 111 UPDATE profiles SET ax_id = 20100137 WHERE pid = 44085;
 112 UPDATE profiles SET ax_id = 20100138 WHERE pid = 44086;
 113 UPDATE profiles SET ax_id = 20100139 WHERE pid = 44094;
 114 UPDATE profiles SET ax_id = 20100140 WHERE pid = 44095;
 115 UPDATE profiles SET ax_id = 20100141 WHERE pid = 44096;
 116 UPDATE profiles SET ax_id = 20100142 WHERE pid = 44097;
 117 UPDATE profiles SET ax_id = 20100143 WHERE pid = 44098;
 118 UPDATE profiles SET ax_id = 20100144 WHERE pid = 44099;
 119 UPDATE profiles SET ax_id = 20100145 WHERE pid = 44100;
 120 UPDATE profiles SET ax_id = 20100146 WHERE pid = 44101;
 121 UPDATE profiles SET ax_id = 20100147 WHERE pid = 44102;
 122 UPDATE profiles SET ax_id = 20100148 WHERE pid = 44103;
 123 UPDATE profiles SET ax_id = 20100149 WHERE pid = 44105;
 124 UPDATE profiles SET ax_id = 20100150 WHERE pid = 44106;
 125 UPDATE profiles SET ax_id = 20100151 WHERE pid = 44107;
 126 UPDATE profiles SET ax_id = 20100152 WHERE pid = 44108;
 127 UPDATE profiles SET ax_id = 20100153 WHERE pid = 44109;
 128 UPDATE profiles SET ax_id = 20100154 WHERE pid = 44110;
 129 UPDATE profiles SET ax_id = 20100155 WHERE pid = 44111;
 130 UPDATE profiles SET ax_id = 20100156 WHERE pid = 44112;
 131 UPDATE profiles SET ax_id = 20100157 WHERE pid = 44113;
 132 UPDATE profiles SET ax_id = 20100158 WHERE pid = 44114;
 133 UPDATE profiles SET ax_id = 20100159 WHERE pid = 44115;
 134 UPDATE profiles SET ax_id = 20100160 WHERE pid = 44116;
 135 UPDATE profiles SET ax_id = 20100161 WHERE pid = 44117;
 136 UPDATE profiles SET ax_id = 20100162 WHERE pid = 44118;
 137 UPDATE profiles SET ax_id = 20100163 WHERE pid = 44119;
 138 UPDATE profiles SET ax_id = 20100164 WHERE pid = 44120;
 139 UPDATE profiles SET ax_id = 20100165 WHERE pid = 44122;
 140 UPDATE profiles SET ax_id = 20100166 WHERE pid = 44123;
 141 UPDATE profiles SET ax_id = 20100167 WHERE pid = 44125;
 142 UPDATE profiles SET ax_id = 20100168 WHERE pid = 44127;
 143 UPDATE profiles SET ax_id = 20100169 WHERE pid = 44126;
 144 UPDATE profiles SET ax_id = 20100170 WHERE pid = 44128;
 145 UPDATE profiles SET ax_id = 20100171 WHERE pid = 44129;
 146 UPDATE profiles SET ax_id = 20100172 WHERE pid = 44130;
 147 UPDATE profiles SET ax_id = 20100173 WHERE pid = 44131;
 148 UPDATE profiles SET ax_id = 20100174 WHERE pid = 44132;
 149 UPDATE profiles SET ax_id = 20100175 WHERE pid = 44133;
 150 UPDATE profiles SET ax_id = 20100176 WHERE pid = 44134;
 151 UPDATE profiles SET ax_id = 20100177 WHERE pid = 44135;
 152 UPDATE profiles SET ax_id = 20100178 WHERE pid = 44136;
 153 UPDATE profiles SET ax_id = 20100179 WHERE pid = 44137;
 154 UPDATE profiles SET ax_id = 20100180 WHERE pid = 44138;
 155 UPDATE profiles SET ax_id = 20100181 WHERE pid = 44140;
 156 UPDATE profiles SET ax_id = 20100182 WHERE pid = 44141;
 157 UPDATE profiles SET ax_id = 20100183 WHERE pid = 44142;
 158 UPDATE profiles SET ax_id = 20100184 WHERE pid = 44143;
 159 UPDATE profiles SET ax_id = 20100185 WHERE pid = 44144;
 160 UPDATE profiles SET ax_id = 20100186 WHERE pid = 44145;
 161 UPDATE profiles SET ax_id = 20100187 WHERE pid = 44146;
 162 UPDATE profiles SET ax_id = 20100188 WHERE pid = 44147;
 163 UPDATE profiles SET ax_id = 20100189 WHERE pid = 44148;
 164 UPDATE profiles SET ax_id = 20100190 WHERE pid = 44149;
 165 UPDATE profiles SET ax_id = 20100191 WHERE pid = 44150;
 166 UPDATE profiles SET ax_id = 20100192 WHERE pid = 44151;
 167 UPDATE profiles SET ax_id = 20100193 WHERE pid = 44152;
 168 UPDATE profiles SET ax_id = 20100194 WHERE pid = 44153;
 169 UPDATE profiles SET ax_id = 20100195 WHERE pid = 44154;
 170 UPDATE profiles SET ax_id = 20100196 WHERE pid = 44155;
 171 UPDATE profiles SET ax_id = 20100197 WHERE pid = 44156;
 172 UPDATE profiles SET ax_id = 20100198 WHERE pid = 44157;
 173 UPDATE profiles SET ax_id = 20100199 WHERE pid = 44158;
 174 UPDATE profiles SET ax_id = 20100200 WHERE pid = 44159;
 175 UPDATE profiles SET ax_id = 20100201 WHERE pid = 44160;
 176 UPDATE profiles SET ax_id = 20100202 WHERE pid = 44161;
 177 UPDATE profiles SET ax_id = 20100203 WHERE pid = 44162;
 178 UPDATE profiles SET ax_id = 20100204 WHERE pid = 44164;
 179 UPDATE profiles SET ax_id = 20100205 WHERE pid = 44166;
 180 UPDATE profiles SET ax_id = 20100206 WHERE pid = 44167;
 181 UPDATE profiles SET ax_id = 20100207 WHERE pid = 44168;
 182 UPDATE profiles SET ax_id = 20100208 WHERE pid = 44169;
 183 UPDATE profiles SET ax_id = 20100209 WHERE pid = 44172;
 184 UPDATE profiles SET ax_id = 20100210 WHERE pid = 44173;
 185 UPDATE profiles SET ax_id = 20100211 WHERE pid = 44174;
 186 UPDATE profiles SET ax_id = 20100212 WHERE pid = 44175;
 187 UPDATE profiles SET ax_id = 20100213 WHERE pid = 44176;
 188 UPDATE profiles SET ax_id = 20100214 WHERE pid = 44177;
 189 UPDATE profiles SET ax_id = 20100215 WHERE pid = 44178;
 190 UPDATE profiles SET ax_id = 20100216 WHERE pid = 44179;
 191 UPDATE profiles SET ax_id = 20100217 WHERE pid = 44180;
 192 UPDATE profiles SET ax_id = 20100218 WHERE pid = 44181;
 193 UPDATE profiles SET ax_id = 20100219 WHERE pid = 44182;
 194 UPDATE profiles SET ax_id = 20100220 WHERE pid = 44183;
 195 UPDATE profiles SET ax_id = 20100221 WHERE pid = 44184;
 196 UPDATE profiles SET ax_id = 20100222 WHERE pid = 44185;
 197 UPDATE profiles SET ax_id = 20100223 WHERE pid = 44186;
 198 UPDATE profiles SET ax_id = 20100224 WHERE pid = 44187;
 199 UPDATE profiles SET ax_id = 20100225 WHERE pid = 44188;
 200 UPDATE profiles SET ax_id = 20100226 WHERE pid = 44190;
 201 UPDATE profiles SET ax_id = 20100227 WHERE pid = 44191;
 202 UPDATE profiles SET ax_id = 20100228 WHERE pid = 44192;
 203 UPDATE profiles SET ax_id = 20100229 WHERE pid = 44194;
 204 UPDATE profiles SET ax_id = 20100230 WHERE pid = 44195;
 205 UPDATE profiles SET ax_id = 20100231 WHERE pid = 44196;
 206 UPDATE profiles SET ax_id = 20100232 WHERE pid = 44198;
 207 UPDATE profiles SET ax_id = 20100233 WHERE pid = 44199;
 208 UPDATE profiles SET ax_id = 20100234 WHERE pid = 44200;
 209 UPDATE profiles SET ax_id = 20100235 WHERE pid = 44201;
 210 UPDATE profiles SET ax_id = 20100236 WHERE pid = 44203;
 211 UPDATE profiles SET ax_id = 20100237 WHERE pid = 44204;
 212 UPDATE profiles SET ax_id = 20100238 WHERE pid = 44205;
 213 UPDATE profiles SET ax_id = 20100239 WHERE pid = 44206;
 214 UPDATE profiles SET ax_id = 20100240 WHERE pid = 44207;
 215 UPDATE profiles SET ax_id = 20100241 WHERE pid = 44208;
 216 UPDATE profiles SET ax_id = 20100242 WHERE pid = 44210;
 217 UPDATE profiles SET ax_id = 20100243 WHERE pid = 44213;
 218 UPDATE profiles SET ax_id = 20100244 WHERE pid = 44215;
 219 UPDATE profiles SET ax_id = 20100245 WHERE pid = 44216;
 220 UPDATE profiles SET ax_id = 20100246 WHERE pid = 44217;
 221 UPDATE profiles SET ax_id = 20100247 WHERE pid = 44218;
 222 UPDATE profiles SET ax_id = 20100248 WHERE pid = 44219;
 223 UPDATE profiles SET ax_id = 20100249 WHERE pid = 44220;
 224 UPDATE profiles SET ax_id = 20100250 WHERE pid = 44221;
 225 UPDATE profiles SET ax_id = 20100251 WHERE pid = 44222;
 226 UPDATE profiles SET ax_id = 20100252 WHERE pid = 44088;
 227 UPDATE profiles SET ax_id = 20100253 WHERE pid = 44223;
 228 UPDATE profiles SET ax_id = 20100254 WHERE pid = 44224;
 229 UPDATE profiles SET ax_id = 20100255 WHERE pid = 44225;
 230 UPDATE profiles SET ax_id = 20100256 WHERE pid = 44226;
 231 UPDATE profiles SET ax_id = 20100257 WHERE pid = 44214;
 232 UPDATE profiles SET ax_id = 20100258 WHERE pid = 44227;
 233 UPDATE profiles SET ax_id = 20100259 WHERE pid = 44228;
 234 UPDATE profiles SET ax_id = 20100260 WHERE pid = 44229;
 235 UPDATE profiles SET ax_id = 20100261 WHERE pid = 44230;
 236 UPDATE profiles SET ax_id = 20100262 WHERE pid = 44231;
 237 UPDATE profiles SET ax_id = 20100263 WHERE pid = 44232;
 238 UPDATE profiles SET ax_id = 20100264 WHERE pid = 44233;
 239 UPDATE profiles SET ax_id = 20100265 WHERE pid = 44234;
 240 UPDATE profiles SET ax_id = 20100266 WHERE pid = 44235;
 241 UPDATE profiles SET ax_id = 20100267 WHERE pid = 44237;
 242 UPDATE profiles SET ax_id = 20100268 WHERE pid = 44238;
 243 UPDATE profiles SET ax_id = 20100269 WHERE pid = 44239;
 244 UPDATE profiles SET ax_id = 20100270 WHERE pid = 44240;
 245 UPDATE profiles SET ax_id = 20100271 WHERE pid = 44241;
 246 UPDATE profiles SET ax_id = 20100272 WHERE pid = 44089;
 247 UPDATE profiles SET ax_id = 20100273 WHERE pid = 44242;
 248 UPDATE profiles SET ax_id = 20100274 WHERE pid = 44243;
 249 UPDATE profiles SET ax_id = 20100275 WHERE pid = 44244;
 250 UPDATE profiles SET ax_id = 20100276 WHERE pid = 44245;
 251 UPDATE profiles SET ax_id = 20100277 WHERE pid = 44250;
 252 UPDATE profiles SET ax_id = 20100278 WHERE pid = 44251;
 253 UPDATE profiles SET ax_id = 20100279 WHERE pid = 44252;
 254 UPDATE profiles SET ax_id = 20100280 WHERE pid = 44253;
 255 UPDATE profiles SET ax_id = 20100281 WHERE pid = 44254;
 256 UPDATE profiles SET ax_id = 20100282 WHERE pid = 44255;
 257 UPDATE profiles SET ax_id = 20100283 WHERE pid = 44256;
 258 UPDATE profiles SET ax_id = 20100284 WHERE pid = 44257;
 259 UPDATE profiles SET ax_id = 20100285 WHERE pid = 44258;
 260 UPDATE profiles SET ax_id = 20100286 WHERE pid = 44259;
 261 UPDATE profiles SET ax_id = 20100287 WHERE pid = 44090;
 262 UPDATE profiles SET ax_id = 20100288 WHERE pid = 44261;
 263 UPDATE profiles SET ax_id = 20100289 WHERE pid = 44262;
 264 UPDATE profiles SET ax_id = 20100290 WHERE pid = 44263;
 265 UPDATE profiles SET ax_id = 20100291 WHERE pid = 44264;
 266 UPDATE profiles SET ax_id = 20100292 WHERE pid = 44265;
 267 UPDATE profiles SET ax_id = 20100293 WHERE pid = 44266;
 268 UPDATE profiles SET ax_id = 20100294 WHERE pid = 44267;
 269 UPDATE profiles SET ax_id = 20100295 WHERE pid = 44268;
 270 UPDATE profiles SET ax_id = 20100296 WHERE pid = 44270;
 271 UPDATE profiles SET ax_id = 20100297 WHERE pid = 44271;
 272 UPDATE profiles SET ax_id = 20100298 WHERE pid = 44272;
 273 UPDATE profiles SET ax_id = 20100299 WHERE pid = 44273;
 274 UPDATE profiles SET ax_id = 20100300 WHERE pid = 44274;
 275 UPDATE profiles SET ax_id = 20100301 WHERE pid = 44275;
 276 UPDATE profiles SET ax_id = 20100302 WHERE pid = 44091;
 277 UPDATE profiles SET ax_id = 20100303 WHERE pid = 44276;
 278 UPDATE profiles SET ax_id = 20100304 WHERE pid = 44277;
 279 UPDATE profiles SET ax_id = 20100305 WHERE pid = 44278;
 280 UPDATE profiles SET ax_id = 20100306 WHERE pid = 44279;
 281 UPDATE profiles SET ax_id = 20100307 WHERE pid = 44280;
 282 UPDATE profiles SET ax_id = 20100308 WHERE pid = 44281;
 283 UPDATE profiles SET ax_id = 20100309 WHERE pid = 44282;
 284 UPDATE profiles SET ax_id = 20100310 WHERE pid = 44283;
 285 UPDATE profiles SET ax_id = 20100311 WHERE pid = 44284;
 286 UPDATE profiles SET ax_id = 20100312 WHERE pid = 44285;
 287 UPDATE profiles SET ax_id = 20100313 WHERE pid = 44287;
 288 UPDATE profiles SET ax_id = 20100314 WHERE pid = 44286;
 289 UPDATE profiles SET ax_id = 20100315 WHERE pid = 44288;
 290 UPDATE profiles SET ax_id = 20100316 WHERE pid = 44289;
 291 UPDATE profiles SET ax_id = 20100317 WHERE pid = 44291;
 292 UPDATE profiles SET ax_id = 20100318 WHERE pid = 44292;
 293 UPDATE profiles SET ax_id = 20100319 WHERE pid = 44296;
 294 UPDATE profiles SET ax_id = 20100320 WHERE pid = 44297;
 295 UPDATE profiles SET ax_id = 20100321 WHERE pid = 44298;
 296 UPDATE profiles SET ax_id = 20100322 WHERE pid = 44299;
 297 UPDATE profiles SET ax_id = 20100323 WHERE pid = 44301;
 298 UPDATE profiles SET ax_id = 20100324 WHERE pid = 44302;
 299 UPDATE profiles SET ax_id = 20100325 WHERE pid = 44304;
 300 UPDATE profiles SET ax_id = 20100326 WHERE pid = 44305;
 301 UPDATE profiles SET ax_id = 20100327 WHERE pid = 44306;
 302 UPDATE profiles SET ax_id = 20100328 WHERE pid = 44307;
 303 UPDATE profiles SET ax_id = 20100329 WHERE pid = 44308;
 304 UPDATE profiles SET ax_id = 20100330 WHERE pid = 44309;
 305 UPDATE profiles SET ax_id = 20100331 WHERE pid = 44310;
 306 UPDATE profiles SET ax_id = 20100332 WHERE pid = 44311;
 307 UPDATE profiles SET ax_id = 20100333 WHERE pid = 44312;
 308 UPDATE profiles SET ax_id = 20100334 WHERE pid = 44313;
 309 UPDATE profiles SET ax_id = 20100335 WHERE pid = 44314;
 310 UPDATE profiles SET ax_id = 20100336 WHERE pid = 44315;
 311 UPDATE profiles SET ax_id = 20100337 WHERE pid = 44316;
 312 UPDATE profiles SET ax_id = 20100338 WHERE pid = 44317;
 313 UPDATE profiles SET ax_id = 20100339 WHERE pid = 44318;
 314 UPDATE profiles SET ax_id = 20100340 WHERE pid = 44319;
 315 UPDATE profiles SET ax_id = 20100341 WHERE pid = 44320;
 316 UPDATE profiles SET ax_id = 20100342 WHERE pid = 44321;
 317 UPDATE profiles SET ax_id = 20100343 WHERE pid = 44322;
 318 UPDATE profiles SET ax_id = 20100344 WHERE pid = 44323;
 319 UPDATE profiles SET ax_id = 20100345 WHERE pid = 44324;
 320 UPDATE profiles SET ax_id = 20100346 WHERE pid = 44325;
 321 UPDATE profiles SET ax_id = 20100347 WHERE pid = 44326;
 322 UPDATE profiles SET ax_id = 20100348 WHERE pid = 44327;
 323 UPDATE profiles SET ax_id = 20100349 WHERE pid = 44328;
 324 UPDATE profiles SET ax_id = 20100350 WHERE pid = 44329;
 325 UPDATE profiles SET ax_id = 20100351 WHERE pid = 44330;
 326 UPDATE profiles SET ax_id = 20100352 WHERE pid = 44331;
 327 UPDATE profiles SET ax_id = 20100353 WHERE pid = 44332;
 328 UPDATE profiles SET ax_id = 20100354 WHERE pid = 44333;
 329 UPDATE profiles SET ax_id = 20100355 WHERE pid = 44334;
 330 UPDATE profiles SET ax_id = 20100356 WHERE pid = 44335;
 331 UPDATE profiles SET ax_id = 20100357 WHERE pid = 44336;
 332 UPDATE profiles SET ax_id = 20100358 WHERE pid = 44337;
 333 UPDATE profiles SET ax_id = 20100359 WHERE pid = 44338;
 334 UPDATE profiles SET ax_id = 20100360 WHERE pid = 44339;
 335 UPDATE profiles SET ax_id = 20100361 WHERE pid = 44340;
 336 UPDATE profiles SET ax_id = 20100362 WHERE pid = 44341;
 337 UPDATE profiles SET ax_id = 20100363 WHERE pid = 44342;
 338 UPDATE profiles SET ax_id = 20100364 WHERE pid = 44343;
 339 UPDATE profiles SET ax_id = 20100365 WHERE pid = 44345;
 340 UPDATE profiles SET ax_id = 20100366 WHERE pid = 44346;
 341 UPDATE profiles SET ax_id = 20100367 WHERE pid = 44347;
 342 UPDATE profiles SET ax_id = 20100368 WHERE pid = 44348;
 343 UPDATE profiles SET ax_id = 20100369 WHERE pid = 44349;
 344 UPDATE profiles SET ax_id = 20100370 WHERE pid = 44350;
 345 UPDATE profiles SET ax_id = 20100371 WHERE pid = 44351;
 346 UPDATE profiles SET ax_id = 20100372 WHERE pid = 44352;
 347 UPDATE profiles SET ax_id = 20100373 WHERE pid = 44353;
 348 UPDATE profiles SET ax_id = 20100374 WHERE pid = 44354;
 349 UPDATE profiles SET ax_id = 20100375 WHERE pid = 44355;
 350 UPDATE profiles SET ax_id = 20100376 WHERE pid = 44356;
 351 UPDATE profiles SET ax_id = 20100377 WHERE pid = 44357;
 352 UPDATE profiles SET ax_id = 20100378 WHERE pid = 44358;
 353 UPDATE profiles SET ax_id = 20100379 WHERE pid = 44359;
 354 UPDATE profiles SET ax_id = 20100380 WHERE pid = 44362;
 355 UPDATE profiles SET ax_id = 20100381 WHERE pid = 44363;
 356 UPDATE profiles SET ax_id = 20100382 WHERE pid = 44364;
 357 UPDATE profiles SET ax_id = 20100383 WHERE pid = 44366;
 358 UPDATE profiles SET ax_id = 20100384 WHERE pid = 44367;
 359 UPDATE profiles SET ax_id = 20100385 WHERE pid = 44092;
 360 UPDATE profiles SET ax_id = 20100386 WHERE pid = 44368;
 361 UPDATE profiles SET ax_id = 20100387 WHERE pid = 44369;
 362 UPDATE profiles SET ax_id = 20100388 WHERE pid = 44093;
 363 UPDATE profiles SET ax_id = 20100389 WHERE pid = 44370;
 364 UPDATE profiles SET ax_id = 20100390 WHERE pid = 44371;
 365 UPDATE profiles SET ax_id = 20100391 WHERE pid = 44372;
 366 UPDATE profiles SET ax_id = 20100392 WHERE pid = 44373;
 367 UPDATE profiles SET ax_id = 20100393 WHERE pid = 44374;
 368 UPDATE profiles SET ax_id = 20100394 WHERE pid = 44377;
 369 UPDATE profiles SET ax_id = 20100395 WHERE pid = 44378;
 370 UPDATE profiles SET ax_id = 20100396 WHERE pid = 44379;
 371 UPDATE profiles SET ax_id = 20100397 WHERE pid = 44380;
 372 UPDATE profiles SET ax_id = 20100398 WHERE pid = 44382;
 373 UPDATE profiles SET ax_id = 20100399 WHERE pid = 44361;
 374 UPDATE profiles SET ax_id = 20100400 WHERE pid = 44383;
 375 UPDATE profiles SET ax_id = 20100401 WHERE pid = 44384;
 376 UPDATE profiles SET ax_id = 20100402 WHERE pid = 44385;
 377 UPDATE profiles SET ax_id = 20100403 WHERE pid = 44386;
 378 UPDATE profiles SET ax_id = 20100404 WHERE pid = 44388;
 379 UPDATE profiles SET ax_id = 20100405 WHERE pid = 44389;
 380 UPDATE profiles SET ax_id = 20100406 WHERE pid = 44390;
 381 UPDATE profiles SET ax_id = 20100407 WHERE pid = 44392;
 382 UPDATE profiles SET ax_id = 20100408 WHERE pid = 44393;
 383 UPDATE profiles SET ax_id = 20100409 WHERE pid = 44394;
 384 UPDATE profiles SET ax_id = 20100410 WHERE pid = 44395;
 385 UPDATE profiles SET ax_id = 20100411 WHERE pid = 44398;
 386 UPDATE profiles SET ax_id = 20100412 WHERE pid = 44399;
 387 UPDATE profiles SET ax_id = 20100413 WHERE pid = 44400;
 388 UPDATE profiles SET ax_id = 20100414 WHERE pid = 44401;
 389 UPDATE profiles SET ax_id = 20100415 WHERE pid = 44402;
 390 UPDATE profiles SET ax_id = 20100416 WHERE pid = 44403;
 391 UPDATE profiles SET ax_id = 20100417 WHERE pid = 44404;
 392 UPDATE profiles SET ax_id = 20100418 WHERE pid = 44405;
 393 UPDATE profiles SET ax_id = 20100419 WHERE pid = 44406;
 394 UPDATE profiles SET ax_id = 20100420 WHERE pid = 44411;
 395 UPDATE profiles SET ax_id = 20100421 WHERE pid = 44412;
 396 UPDATE profiles SET ax_id = 20100422 WHERE pid = 44413;
 397 UPDATE profiles SET ax_id = 20100423 WHERE pid = 44414;
 398 UPDATE profiles SET ax_id = 20100424 WHERE pid = 44415;
 399 UPDATE profiles SET ax_id = 20100425 WHERE pid = 44417;
 400 UPDATE profiles SET ax_id = 20100426 WHERE pid = 44420;
 401 UPDATE profiles SET ax_id = 20100427 WHERE pid = 44423;
 402 UPDATE profiles SET ax_id = 20100428 WHERE pid = 44428;
 403 UPDATE profiles SET ax_id = 20100429 WHERE pid = 43957;
 404 UPDATE profiles SET ax_id = 20100430 WHERE pid = 43958;
 405 UPDATE profiles SET ax_id = 20100431 WHERE pid = 43960;
 406 UPDATE profiles SET ax_id = 20100432 WHERE pid = 43962;
 407 UPDATE profiles SET ax_id = 20100433 WHERE pid = 43963;
 408 UPDATE profiles SET ax_id = 20100434 WHERE pid = 43975;
 409 UPDATE profiles SET ax_id = 20100435 WHERE pid = 43982;
 410 UPDATE profiles SET ax_id = 20100436 WHERE pid = 43992;
 411 UPDATE profiles SET ax_id = 20100437 WHERE pid = 43995;
 412 UPDATE profiles SET ax_id = 20100438 WHERE pid = 43996;
 413 UPDATE profiles SET ax_id = 20100439 WHERE pid = 44001;
 414 UPDATE profiles SET ax_id = 20100440 WHERE pid = 44007;
 415 UPDATE profiles SET ax_id = 20100441 WHERE pid = 44008;
 416 UPDATE profiles SET ax_id = 20100442 WHERE pid = 44009;
 417 UPDATE profiles SET ax_id = 20100443 WHERE pid = 44020;
 418 UPDATE profiles SET ax_id = 20100444 WHERE pid = 44027;
 419 UPDATE profiles SET ax_id = 20100445 WHERE pid = 44039;
 420 UPDATE profiles SET ax_id = 20100446 WHERE pid = 44041;
 421 UPDATE profiles SET ax_id = 20100447 WHERE pid = 44052;
 422 UPDATE profiles SET ax_id = 20100448 WHERE pid = 44059;
 423 UPDATE profiles SET ax_id = 20100449 WHERE pid = 44061;
 424 UPDATE profiles SET ax_id = 20100450 WHERE pid = 44081;
 425 UPDATE profiles SET ax_id = 20100451 WHERE pid = 44104;
 426 UPDATE profiles SET ax_id = 20100452 WHERE pid = 44121;
 427 UPDATE profiles SET ax_id = 20100453 WHERE pid = 44124;
 428 UPDATE profiles SET ax_id = 20100454 WHERE pid = 44139;
 429 UPDATE profiles SET ax_id = 20100455 WHERE pid = 44163;
 430 UPDATE profiles SET ax_id = 20100456 WHERE pid = 44165;
 431 UPDATE profiles SET ax_id = 20100457 WHERE pid = 44170;
 432 UPDATE profiles SET ax_id = 20100458 WHERE pid = 44171;
 433 UPDATE profiles SET ax_id = 20100459 WHERE pid = 44189;
 434 UPDATE profiles SET ax_id = 20100460 WHERE pid = 44193;
 435 UPDATE profiles SET ax_id = 20100461 WHERE pid = 44197;
 436 UPDATE profiles SET ax_id = 20100462 WHERE pid = 44202;
 437 UPDATE profiles SET ax_id = 20100463 WHERE pid = 44209;
 438 UPDATE profiles SET ax_id = 20100464 WHERE pid = 44211;
 439 UPDATE profiles SET ax_id = 20100465 WHERE pid = 44212;
 440 UPDATE profiles SET ax_id = 20100466 WHERE pid = 44236;
 441 UPDATE profiles SET ax_id = 20100467 WHERE pid = 44247;
 442 UPDATE profiles SET ax_id = 20100468 WHERE pid = 44246;
 443 UPDATE profiles SET ax_id = 20100469 WHERE pid = 44248;
 444 UPDATE profiles SET ax_id = 20100470 WHERE pid = 44249;
 445 UPDATE profiles SET ax_id = 20100471 WHERE pid = 44260;
 446 UPDATE profiles SET ax_id = 20100472 WHERE pid = 44269;
 447 UPDATE profiles SET ax_id = 20100474 WHERE pid = 44290;
 448 UPDATE profiles SET ax_id = 20100475 WHERE pid = 44293;
 449 UPDATE profiles SET ax_id = 20100476 WHERE pid = 44294;
 450 UPDATE profiles SET ax_id = 20100477 WHERE pid = 44295;
 451 UPDATE profiles SET ax_id = 20100478 WHERE pid = 44300;
 452 UPDATE profiles SET ax_id = 20100480 WHERE pid = 44303;
 453 UPDATE profiles SET ax_id = 20100481 WHERE pid = 44344;
 454 UPDATE profiles SET ax_id = 20100482 WHERE pid = 44360;
 455 UPDATE profiles SET ax_id = 20100483 WHERE pid = 44365;
 456 UPDATE profiles SET ax_id = 20100484 WHERE pid = 44375;
 457 UPDATE profiles SET ax_id = 20100485 WHERE pid = 44376;
 458 UPDATE profiles SET ax_id = 20100486 WHERE pid = 44381;
 459 UPDATE profiles SET ax_id = 20100487 WHERE pid = 44387;
 460 UPDATE profiles SET ax_id = 20100488 WHERE pid = 44391;
 461 UPDATE profiles SET ax_id = 20100489 WHERE pid = 44396;
 462 UPDATE profiles SET ax_id = 20100490 WHERE pid = 44397;
 463 UPDATE profiles SET ax_id = 20100491 WHERE pid = 44407;
 464 UPDATE profiles SET ax_id = 20100492 WHERE pid = 44408;
 465 UPDATE profiles SET ax_id = 20100493 WHERE pid = 44409;
 466 UPDATE profiles SET ax_id = 20100494 WHERE pid = 44410;
 467 UPDATE profiles SET ax_id = 20100495 WHERE pid = 44416;
 468 UPDATE profiles SET ax_id = 20100496 WHERE pid = 44418;
 469 UPDATE profiles SET ax_id = 20100497 WHERE pid = 44419;
 470 UPDATE profiles SET ax_id = 20100498 WHERE pid = 44421;
 471 UPDATE profiles SET ax_id = 20100499 WHERE pid = 44422;
 472 UPDATE profiles SET ax_id = 20100500 WHERE pid = 44424;
 473 UPDATE profiles SET ax_id = 20100501 WHERE pid = 44425;
 474 UPDATE profiles SET ax_id = 20100502 WHERE pid = 44426;
 475 UPDATE profiles SET ax_id = 20100503 WHERE pid = 44427;
 476
 477 -- Updates promo for oranjes who only stated their orajisation to AX.
 478 -- WARNING: this does not affect the display of their promotion anywhere. It will just allow them to attend events to both promotions.
 479 -- Also they wiil not need to require a validation if they want to change promo on the site.
 480
 481 UPDATE  profile_education
 482    SET  grad_year = grad_year + 1
 483    WHERE  FIND_IN_SET('primary', flags) AND pid IN (42018, 42216, 43135, 43216, 42981, 43039, 41827, 42322);
 484
 485 -- Same as before but double orajisation.
 486 UPDATE  profile_education
 487    SET  grad_year = grad_year + 2
 488  WHERE  FIND_IN_SET('primary', flags) AND pid = 41291;
 489
 490 -- Fixes erroneous data
 491 UPDATE  profile_education
 492    SET  entry_year = 1951, grad_year = 1954
 493  WHERE  FIND_IN_SET('primary', flags) AND pid = 29674;
 494 UPDATE  profile_display
 495    SET  promo = 'X1951'
 496  WHERE  pid = 29674;
 497
 498 -- Inserts missing couple (education, degree) required by AX data.
 499 INSERT IGNORE INTO  profile_education_degree (eduid, degreeid)
 500             VALUES  (182, 2);
 501
 502 -- vim:set syntax=mysql:;