| 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:; |