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