Commit | Line | Data |
---|---|---|
444f4855 SJ |
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:; |