From 518d3c10abbb6937166a7a26653961062fdf15a4 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Mon, 14 Nov 2011 00:08:48 +0100 Subject: [PATCH] Missing data from AX. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.1.4/14_ax_id.sql | 421 +++++++++++++++++++++++++++++++++++++ upgrade/1.1.4/15_deceased.sql | 468 ++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 889 insertions(+) create mode 100644 upgrade/1.1.4/14_ax_id.sql create mode 100644 upgrade/1.1.4/15_deceased.sql diff --git a/upgrade/1.1.4/14_ax_id.sql b/upgrade/1.1.4/14_ax_id.sql new file mode 100644 index 0000000..e2a2c42 --- /dev/null +++ b/upgrade/1.1.4/14_ax_id.sql @@ -0,0 +1,421 @@ +UPDATE profiles SET ax_id = '20110001' WHERE pid = '44429'; +UPDATE profiles SET ax_id = '20110002' WHERE pid = '44430'; +UPDATE profiles SET ax_id = '20110004' WHERE pid = '44431'; +UPDATE profiles SET ax_id = '20110005' WHERE pid = '44432'; +UPDATE profiles SET ax_id = '20110006' WHERE pid = '44433'; +UPDATE profiles SET ax_id = '20110007' WHERE pid = '44434'; +UPDATE profiles SET ax_id = '20110008' WHERE pid = '44435'; +UPDATE profiles SET ax_id = '20110009' WHERE pid = '44436'; +UPDATE profiles SET ax_id = '20110010' WHERE pid = '44437'; +UPDATE profiles SET ax_id = '20110011' WHERE pid = '44438'; +UPDATE profiles SET ax_id = '20110012' WHERE pid = '44439'; +UPDATE profiles SET ax_id = '20110013' WHERE pid = '44440'; +UPDATE profiles SET ax_id = '20110014' WHERE pid = '44441'; +UPDATE profiles SET ax_id = '20110015' WHERE pid = '44442'; +UPDATE profiles SET ax_id = '20110017' WHERE pid = '44443'; +UPDATE profiles SET ax_id = '20110016' WHERE pid = '44444'; +UPDATE profiles SET ax_id = '20110018' WHERE pid = '44445'; +UPDATE profiles SET ax_id = '20110019' WHERE pid = '44446'; +UPDATE profiles SET ax_id = '20110020' WHERE pid = '44447'; +UPDATE profiles SET ax_id = '20110021' WHERE pid = '44448'; +UPDATE profiles SET ax_id = '20110022' WHERE pid = '44449'; +UPDATE profiles SET ax_id = '20110023' WHERE pid = '44450'; +UPDATE profiles SET ax_id = '20110024' WHERE pid = '44451'; +UPDATE profiles SET ax_id = '20110025' WHERE pid = '44452'; +UPDATE profiles SET ax_id = '20110028' WHERE pid = '44454'; +UPDATE profiles SET ax_id = '20110029' WHERE pid = '44455'; +UPDATE profiles SET ax_id = '20110030' WHERE pid = '44456'; +UPDATE profiles SET ax_id = '20110031' WHERE pid = '44457'; +UPDATE profiles SET ax_id = '20110032' WHERE pid = '44458'; +UPDATE profiles SET ax_id = '20110033' WHERE pid = '44459'; +UPDATE profiles SET ax_id = '20110034' WHERE pid = '46436'; +UPDATE profiles SET ax_id = '20110035' WHERE pid = '46437'; +UPDATE profiles SET ax_id = '20110036' WHERE pid = '46438'; +UPDATE profiles SET ax_id = '20110037' WHERE pid = '46439'; +UPDATE profiles SET ax_id = '20110038' WHERE pid = '46440'; +UPDATE profiles SET ax_id = '20110039' WHERE pid = '46441'; +UPDATE profiles SET ax_id = '20110040' WHERE pid = '46442'; +UPDATE profiles SET ax_id = '20110041' WHERE pid = '46443'; +UPDATE profiles SET ax_id = '20110042' WHERE pid = '46444'; +UPDATE profiles SET ax_id = '20110043' WHERE pid = '46445'; +UPDATE profiles SET ax_id = '20110044' WHERE pid = '46446'; +UPDATE profiles SET ax_id = '20110045' WHERE pid = '46447'; +UPDATE profiles SET ax_id = '20110046' WHERE pid = '46448'; +UPDATE profiles SET ax_id = '20110047' WHERE pid = '46449'; +UPDATE profiles SET ax_id = '20110048' WHERE pid = '46450'; +UPDATE profiles SET ax_id = '20110049' WHERE pid = '46451'; +UPDATE profiles SET ax_id = '20110050' WHERE pid = '46452'; +UPDATE profiles SET ax_id = '20110051' WHERE pid = '46453'; +UPDATE profiles SET ax_id = '20110052' WHERE pid = '46454'; +UPDATE profiles SET ax_id = '20110053' WHERE pid = '46455'; +UPDATE profiles SET ax_id = '20110054' WHERE pid = '46456'; +UPDATE profiles SET ax_id = '20110055' WHERE pid = '46457'; +UPDATE profiles SET ax_id = '20110056' WHERE pid = '46458'; +UPDATE profiles SET ax_id = '20110057' WHERE pid = '46459'; +UPDATE profiles SET ax_id = '20110058' WHERE pid = '46460'; +UPDATE profiles SET ax_id = '20110060' WHERE pid = '46461'; +UPDATE profiles SET ax_id = '20110061' WHERE pid = '46462'; +UPDATE profiles SET ax_id = '20110062' WHERE pid = '46463'; +UPDATE profiles SET ax_id = '20110063' WHERE pid = '46464'; +UPDATE profiles SET ax_id = '20110064' WHERE pid = '46465'; +UPDATE profiles SET ax_id = '20110065' WHERE pid = '46466'; +UPDATE profiles SET ax_id = '20110066' WHERE pid = '46467'; +UPDATE profiles SET ax_id = '20110067' WHERE pid = '46468'; +UPDATE profiles SET ax_id = '20110068' WHERE pid = '46469'; +UPDATE profiles SET ax_id = '20110069' WHERE pid = '46470'; +UPDATE profiles SET ax_id = '20110070' WHERE pid = '46471'; +UPDATE profiles SET ax_id = '20110071' WHERE pid = '46472'; +UPDATE profiles SET ax_id = '20110072' WHERE pid = '46473'; +UPDATE profiles SET ax_id = '20110073' WHERE pid = '46474'; +UPDATE profiles SET ax_id = '20110074' WHERE pid = '46475'; +UPDATE profiles SET ax_id = '20110075' WHERE pid = '46476'; +UPDATE profiles SET ax_id = '20110076' WHERE pid = '46477'; +UPDATE profiles SET ax_id = '20110077' WHERE pid = '46478'; +UPDATE profiles SET ax_id = '20110078' WHERE pid = '46479'; +UPDATE profiles SET ax_id = '20110079' WHERE pid = '46480'; +UPDATE profiles SET ax_id = '20110080' WHERE pid = '46481'; +UPDATE profiles SET ax_id = '20110081' WHERE pid = '46482'; +UPDATE profiles SET ax_id = '20110082' WHERE pid = '46483'; +UPDATE profiles SET ax_id = '20110083' WHERE pid = '46484'; +UPDATE profiles SET ax_id = '20110084' WHERE pid = '46485'; +UPDATE profiles SET ax_id = '20110085' WHERE pid = '46486'; +UPDATE profiles SET ax_id = '20110086' WHERE pid = '46487'; +UPDATE profiles SET ax_id = '20110087' WHERE pid = '46488'; +UPDATE profiles SET ax_id = '20110088' WHERE pid = '46489'; +UPDATE profiles SET ax_id = '20110089' WHERE pid = '46490'; +UPDATE profiles SET ax_id = '20110090' WHERE pid = '46491'; +UPDATE profiles SET ax_id = '20110091' WHERE pid = '46492'; +UPDATE profiles SET ax_id = '20110092' WHERE pid = '46493'; +UPDATE profiles SET ax_id = '20110093' WHERE pid = '46494'; +UPDATE profiles SET ax_id = '20110094' WHERE pid = '46495'; +UPDATE profiles SET ax_id = '20110095' WHERE pid = '46496'; +UPDATE profiles SET ax_id = '20110097' WHERE pid = '46497'; +UPDATE profiles SET ax_id = '20110098' WHERE pid = '46498'; +UPDATE profiles SET ax_id = '20110099' WHERE pid = '46499'; +UPDATE profiles SET ax_id = '20110100' WHERE pid = '46500'; +UPDATE profiles SET ax_id = '20110101' WHERE pid = '46501'; +UPDATE profiles SET ax_id = '20110102' WHERE pid = '46502'; +UPDATE profiles SET ax_id = '20110103' WHERE pid = '46503'; +UPDATE profiles SET ax_id = '20110104' WHERE pid = '46504'; +UPDATE profiles SET ax_id = '20110105' WHERE pid = '46505'; +UPDATE profiles SET ax_id = '20110107' WHERE pid = '46506'; +UPDATE profiles SET ax_id = '20110108' WHERE pid = '46507'; +UPDATE profiles SET ax_id = '20110109' WHERE pid = '46508'; +UPDATE profiles SET ax_id = '20110110' WHERE pid = '46509'; +UPDATE profiles SET ax_id = '20110111' WHERE pid = '46510'; +UPDATE profiles SET ax_id = '20110113' WHERE pid = '46511'; +UPDATE profiles SET ax_id = '20110114' WHERE pid = '46512'; +UPDATE profiles SET ax_id = '20110115' WHERE pid = '46513'; +UPDATE profiles SET ax_id = '20110116' WHERE pid = '46514'; +UPDATE profiles SET ax_id = '20110117' WHERE pid = '46515'; +UPDATE profiles SET ax_id = '20110118' WHERE pid = '46516'; +UPDATE profiles SET ax_id = '20110119' WHERE pid = '46517'; +UPDATE profiles SET ax_id = '20110120' WHERE pid = '46518'; +UPDATE profiles SET ax_id = '20110121' WHERE pid = '46519'; +UPDATE profiles SET ax_id = '20110122' WHERE pid = '46520'; +UPDATE profiles SET ax_id = '20110123' WHERE pid = '46521'; +UPDATE profiles SET ax_id = '20110124' WHERE pid = '46522'; +UPDATE profiles SET ax_id = '20110125' WHERE pid = '46523'; +UPDATE profiles SET ax_id = '20110126' WHERE pid = '46524'; +UPDATE profiles SET ax_id = '20110127' WHERE pid = '46525'; +UPDATE profiles SET ax_id = '20110128' WHERE pid = '46526'; +UPDATE profiles SET ax_id = '20110130' WHERE pid = '46527'; +UPDATE profiles SET ax_id = '20110131' WHERE pid = '46528'; +UPDATE profiles SET ax_id = '20110132' WHERE pid = '46529'; +UPDATE profiles SET ax_id = '20110133' WHERE pid = '46530'; +UPDATE profiles SET ax_id = '20110134' WHERE pid = '46531'; +UPDATE profiles SET ax_id = '20110135' WHERE pid = '46532'; +UPDATE profiles SET ax_id = '20110136' WHERE pid = '46533'; +UPDATE profiles SET ax_id = '20110137' WHERE pid = '46534'; +UPDATE profiles SET ax_id = '20110138' WHERE pid = '46535'; +UPDATE profiles SET ax_id = '20110139' WHERE pid = '46536'; +UPDATE profiles SET ax_id = '20110140' WHERE pid = '46537'; +UPDATE profiles SET ax_id = '20110141' WHERE pid = '46538'; +UPDATE profiles SET ax_id = '20110142' WHERE pid = '46539'; +UPDATE profiles SET ax_id = '20110143' WHERE pid = '46540'; +UPDATE profiles SET ax_id = '20110144' WHERE pid = '46541'; +UPDATE profiles SET ax_id = '20110145' WHERE pid = '46542'; +UPDATE profiles SET ax_id = '20110146' WHERE pid = '46543'; +UPDATE profiles SET ax_id = '20110147' WHERE pid = '46544'; +UPDATE profiles SET ax_id = '20110148' WHERE pid = '46545'; +UPDATE profiles SET ax_id = '20110149' WHERE pid = '46546'; +UPDATE profiles SET ax_id = '20110150' WHERE pid = '46547'; +UPDATE profiles SET ax_id = '20110151' WHERE pid = '46548'; +UPDATE profiles SET ax_id = '20110096' WHERE pid = '46549'; +UPDATE profiles SET ax_id = '20110112' WHERE pid = '46550'; +UPDATE profiles SET ax_id = '20110175' WHERE pid = '46551'; +UPDATE profiles SET ax_id = '20110152' WHERE pid = '46552'; +UPDATE profiles SET ax_id = '20110153' WHERE pid = '46553'; +UPDATE profiles SET ax_id = '20110199' WHERE pid = '46554'; +UPDATE profiles SET ax_id = '20110244' WHERE pid = '46555'; +UPDATE profiles SET ax_id = '20110251' WHERE pid = '46556'; +UPDATE profiles SET ax_id = '20110257' WHERE pid = '46557'; +UPDATE profiles SET ax_id = '20110154' WHERE pid = '46558'; +UPDATE profiles SET ax_id = '20110155' WHERE pid = '46559'; +UPDATE profiles SET ax_id = '20110156' WHERE pid = '46560'; +UPDATE profiles SET ax_id = '20110311' WHERE pid = '46561'; +UPDATE profiles SET ax_id = '20110316' WHERE pid = '46562'; +UPDATE profiles SET ax_id = '20110157' WHERE pid = '46563'; +UPDATE profiles SET ax_id = '20110158' WHERE pid = '46564'; +UPDATE profiles SET ax_id = '20110347' WHERE pid = '46565'; +UPDATE profiles SET ax_id = '20110388' WHERE pid = '46566'; +UPDATE profiles SET ax_id = '20110390' WHERE pid = '46567'; +UPDATE profiles SET ax_id = '20110159' WHERE pid = '46568'; +UPDATE profiles SET ax_id = '20110160' WHERE pid = '46569'; +UPDATE profiles SET ax_id = '20110161' WHERE pid = '46570'; +UPDATE profiles SET ax_id = '20110162' WHERE pid = '46571'; +UPDATE profiles SET ax_id = '20110163' WHERE pid = '46572'; +UPDATE profiles SET ax_id = '20110164' WHERE pid = '46573'; +UPDATE profiles SET ax_id = '20110165' WHERE pid = '46574'; +UPDATE profiles SET ax_id = '20110166' WHERE pid = '46575'; +UPDATE profiles SET ax_id = '20110167' WHERE pid = '46576'; +UPDATE profiles SET ax_id = '20110168' WHERE pid = '46577'; +UPDATE profiles SET ax_id = '20110169' WHERE pid = '46578'; +UPDATE profiles SET ax_id = '20110170' WHERE pid = '46579'; +UPDATE profiles SET ax_id = '20110171' WHERE pid = '46580'; +UPDATE profiles SET ax_id = '20110172' WHERE pid = '46581'; +UPDATE profiles SET ax_id = '20110173' WHERE pid = '46582'; +UPDATE profiles SET ax_id = '20110174' WHERE pid = '46583'; +UPDATE profiles SET ax_id = '20110176' WHERE pid = '46584'; +UPDATE profiles SET ax_id = '20110177' WHERE pid = '46585'; +UPDATE profiles SET ax_id = '20110178' WHERE pid = '46586'; +UPDATE profiles SET ax_id = '20110179' WHERE pid = '46587'; +UPDATE profiles SET ax_id = '20110180' WHERE pid = '46588'; +UPDATE profiles SET ax_id = '20110181' WHERE pid = '46589'; +UPDATE profiles SET ax_id = '20110182' WHERE pid = '46590'; +UPDATE profiles SET ax_id = '20110183' WHERE pid = '46591'; +UPDATE profiles SET ax_id = '20110184' WHERE pid = '46592'; +UPDATE profiles SET ax_id = '20110185' WHERE pid = '46593'; +UPDATE profiles SET ax_id = '20110186' WHERE pid = '46594'; +UPDATE profiles SET ax_id = '20110187' WHERE pid = '46595'; +UPDATE profiles SET ax_id = '20110188' WHERE pid = '46596'; +UPDATE profiles SET ax_id = '20110189' WHERE pid = '46597'; +UPDATE profiles SET ax_id = '20110190' WHERE pid = '46598'; +UPDATE profiles SET ax_id = '20110191' WHERE pid = '46599'; +UPDATE profiles SET ax_id = '20110192' WHERE pid = '46600'; +UPDATE profiles SET ax_id = '20110193' WHERE pid = '46601'; +UPDATE profiles SET ax_id = '20110194' WHERE pid = '46602'; +UPDATE profiles SET ax_id = '20110195' WHERE pid = '46603'; +UPDATE profiles SET ax_id = '20110196' WHERE pid = '46604'; +UPDATE profiles SET ax_id = '20110197' WHERE pid = '46605'; +UPDATE profiles SET ax_id = '20110198' WHERE pid = '46606'; +UPDATE profiles SET ax_id = '20110200' WHERE pid = '46607'; +UPDATE profiles SET ax_id = '20110201' WHERE pid = '46608'; +UPDATE profiles SET ax_id = '20110203' WHERE pid = '46609'; +UPDATE profiles SET ax_id = '20110204' WHERE pid = '46610'; +UPDATE profiles SET ax_id = '20110205' WHERE pid = '46611'; +UPDATE profiles SET ax_id = '20110206' WHERE pid = '46612'; +UPDATE profiles SET ax_id = '20110207' WHERE pid = '46613'; +UPDATE profiles SET ax_id = '20110208' WHERE pid = '46614'; +UPDATE profiles SET ax_id = '20110209' WHERE pid = '46615'; +UPDATE profiles SET ax_id = '20110210' WHERE pid = '46616'; +UPDATE profiles SET ax_id = '20110211' WHERE pid = '46617'; +UPDATE profiles SET ax_id = '20110212' WHERE pid = '46618'; +UPDATE profiles SET ax_id = '20110213' WHERE pid = '46619'; +UPDATE profiles SET ax_id = '20110214' WHERE pid = '46620'; +UPDATE profiles SET ax_id = '20110215' WHERE pid = '46621'; +UPDATE profiles SET ax_id = '20110216' WHERE pid = '46622'; +UPDATE profiles SET ax_id = '20110217' WHERE pid = '46623'; +UPDATE profiles SET ax_id = '20110218' WHERE pid = '46624'; +UPDATE profiles SET ax_id = '20110219' WHERE pid = '46625'; +UPDATE profiles SET ax_id = '20110220' WHERE pid = '46626'; +UPDATE profiles SET ax_id = '20110221' WHERE pid = '46627'; +UPDATE profiles SET ax_id = '20110222' WHERE pid = '46628'; +UPDATE profiles SET ax_id = '20110223' WHERE pid = '46629'; +UPDATE profiles SET ax_id = '20110224' WHERE pid = '46630'; +UPDATE profiles SET ax_id = '20110225' WHERE pid = '46631'; +UPDATE profiles SET ax_id = '20110226' WHERE pid = '46632'; +UPDATE profiles SET ax_id = '20110228' WHERE pid = '46634'; +UPDATE profiles SET ax_id = '20110229' WHERE pid = '46635'; +UPDATE profiles SET ax_id = '20110230' WHERE pid = '46636'; +UPDATE profiles SET ax_id = '20110231' WHERE pid = '46637'; +UPDATE profiles SET ax_id = '20110232' WHERE pid = '46638'; +UPDATE profiles SET ax_id = '20110233' WHERE pid = '46639'; +UPDATE profiles SET ax_id = '20110234' WHERE pid = '46640'; +UPDATE profiles SET ax_id = '20110235' WHERE pid = '46641'; +UPDATE profiles SET ax_id = '20110236' WHERE pid = '46642'; +UPDATE profiles SET ax_id = '20110237' WHERE pid = '46643'; +UPDATE profiles SET ax_id = '20110238' WHERE pid = '46644'; +UPDATE profiles SET ax_id = '20110239' WHERE pid = '46645'; +UPDATE profiles SET ax_id = '20110240' WHERE pid = '46646'; +UPDATE profiles SET ax_id = '20110241' WHERE pid = '46647'; +UPDATE profiles SET ax_id = '20110242' WHERE pid = '46648'; +UPDATE profiles SET ax_id = '20110243' WHERE pid = '46649'; +UPDATE profiles SET ax_id = '20110245' WHERE pid = '46650'; +UPDATE profiles SET ax_id = '20110247' WHERE pid = '46651'; +UPDATE profiles SET ax_id = '20110248' WHERE pid = '46652'; +UPDATE profiles SET ax_id = '20110249' WHERE pid = '46653'; +UPDATE profiles SET ax_id = '20110250' WHERE pid = '46654'; +UPDATE profiles SET ax_id = '20110252' WHERE pid = '46655'; +UPDATE profiles SET ax_id = '20110253' WHERE pid = '46656'; +UPDATE profiles SET ax_id = '20110254' WHERE pid = '46657'; +UPDATE profiles SET ax_id = '20110255' WHERE pid = '46658'; +UPDATE profiles SET ax_id = '20110256' WHERE pid = '46659'; +UPDATE profiles SET ax_id = '20110258' WHERE pid = '46660'; +UPDATE profiles SET ax_id = '20110259' WHERE pid = '46661'; +UPDATE profiles SET ax_id = '20110260' WHERE pid = '46662'; +UPDATE profiles SET ax_id = '20110261' WHERE pid = '46663'; +UPDATE profiles SET ax_id = '20110262' WHERE pid = '46664'; +UPDATE profiles SET ax_id = '20110263' WHERE pid = '46665'; +UPDATE profiles SET ax_id = '20110264' WHERE pid = '46666'; +UPDATE profiles SET ax_id = '20110265' WHERE pid = '46667'; +UPDATE profiles SET ax_id = '20110266' WHERE pid = '46668'; +UPDATE profiles SET ax_id = '20110267' WHERE pid = '46669'; +UPDATE profiles SET ax_id = '20110268' WHERE pid = '46670'; +UPDATE profiles SET ax_id = '20110270' WHERE pid = '46671'; +UPDATE profiles SET ax_id = '20110271' WHERE pid = '46672'; +UPDATE profiles SET ax_id = '20110272' WHERE pid = '46673'; +UPDATE profiles SET ax_id = '20110273' WHERE pid = '46674'; +UPDATE profiles SET ax_id = '20110274' WHERE pid = '46675'; +UPDATE profiles SET ax_id = '20110275' WHERE pid = '46676'; +UPDATE profiles SET ax_id = '20110277' WHERE pid = '46677'; +UPDATE profiles SET ax_id = '20110278' WHERE pid = '46678'; +UPDATE profiles SET ax_id = '20110279' WHERE pid = '46679'; +UPDATE profiles SET ax_id = '20110280' WHERE pid = '46680'; +UPDATE profiles SET ax_id = '20110281' WHERE pid = '46681'; +UPDATE profiles SET ax_id = '20110282' WHERE pid = '46682'; +UPDATE profiles SET ax_id = '20110283' WHERE pid = '46683'; +UPDATE profiles SET ax_id = '20110285' WHERE pid = '46684'; +UPDATE profiles SET ax_id = '20110286' WHERE pid = '46685'; +UPDATE profiles SET ax_id = '20110287' WHERE pid = '46686'; +UPDATE profiles SET ax_id = '20110288' WHERE pid = '46687'; +UPDATE profiles SET ax_id = '20110289' WHERE pid = '46688'; +UPDATE profiles SET ax_id = '20110290' WHERE pid = '46689'; +UPDATE profiles SET ax_id = '20110291' WHERE pid = '46690'; +UPDATE profiles SET ax_id = '20110292' WHERE pid = '46691'; +UPDATE profiles SET ax_id = '20110293' WHERE pid = '46692'; +UPDATE profiles SET ax_id = '20110294' WHERE pid = '46693'; +UPDATE profiles SET ax_id = '20110295' WHERE pid = '46694'; +UPDATE profiles SET ax_id = '20110296' WHERE pid = '46695'; +UPDATE profiles SET ax_id = '20110297' WHERE pid = '46696'; +UPDATE profiles SET ax_id = '20110298' WHERE pid = '46697'; +UPDATE profiles SET ax_id = '20110299' WHERE pid = '46698'; +UPDATE profiles SET ax_id = '20110300' WHERE pid = '46699'; +UPDATE profiles SET ax_id = '20110301' WHERE pid = '46700'; +UPDATE profiles SET ax_id = '20110302' WHERE pid = '46701'; +UPDATE profiles SET ax_id = '20110303' WHERE pid = '46702'; +UPDATE profiles SET ax_id = '20110304' WHERE pid = '46703'; +UPDATE profiles SET ax_id = '20110305' WHERE pid = '46704'; +UPDATE profiles SET ax_id = '20110306' WHERE pid = '46705'; +UPDATE profiles SET ax_id = '20110307' WHERE pid = '46706'; +UPDATE profiles SET ax_id = '20110308' WHERE pid = '46707'; +UPDATE profiles SET ax_id = '20110310' WHERE pid = '46708'; +UPDATE profiles SET ax_id = '20110312' WHERE pid = '46709'; +UPDATE profiles SET ax_id = '20110313' WHERE pid = '46710'; +UPDATE profiles SET ax_id = '20110314' WHERE pid = '46711'; +UPDATE profiles SET ax_id = '20110315' WHERE pid = '46712'; +UPDATE profiles SET ax_id = '20110317' WHERE pid = '46713'; +UPDATE profiles SET ax_id = '20110318' WHERE pid = '46714'; +UPDATE profiles SET ax_id = '20110319' WHERE pid = '46715'; +UPDATE profiles SET ax_id = '20110320' WHERE pid = '46716'; +UPDATE profiles SET ax_id = '20110321' WHERE pid = '46717'; +UPDATE profiles SET ax_id = '20110322' WHERE pid = '46718'; +UPDATE profiles SET ax_id = '20110323' WHERE pid = '46719'; +UPDATE profiles SET ax_id = '20110324' WHERE pid = '46720'; +UPDATE profiles SET ax_id = '20110325' WHERE pid = '46721'; +UPDATE profiles SET ax_id = '20110326' WHERE pid = '46722'; +UPDATE profiles SET ax_id = '20110327' WHERE pid = '46723'; +UPDATE profiles SET ax_id = '20110328' WHERE pid = '46724'; +UPDATE profiles SET ax_id = '20110329' WHERE pid = '46725'; +UPDATE profiles SET ax_id = '20110330' WHERE pid = '46726'; +UPDATE profiles SET ax_id = '20110331' WHERE pid = '46727'; +UPDATE profiles SET ax_id = '20110332' WHERE pid = '46728'; +UPDATE profiles SET ax_id = '20110333' WHERE pid = '46729'; +UPDATE profiles SET ax_id = '20110334' WHERE pid = '46730'; +UPDATE profiles SET ax_id = '20110335' WHERE pid = '46731'; +UPDATE profiles SET ax_id = '20110336' WHERE pid = '46732'; +UPDATE profiles SET ax_id = '20110338' WHERE pid = '46733'; +UPDATE profiles SET ax_id = '20110339' WHERE pid = '46734'; +UPDATE profiles SET ax_id = '20110340' WHERE pid = '46735'; +UPDATE profiles SET ax_id = '20110341' WHERE pid = '46736'; +UPDATE profiles SET ax_id = '20110342' WHERE pid = '46737'; +UPDATE profiles SET ax_id = '20110343' WHERE pid = '46738'; +UPDATE profiles SET ax_id = '20110344' WHERE pid = '46739'; +UPDATE profiles SET ax_id = '20110345' WHERE pid = '46740'; +UPDATE profiles SET ax_id = '20110346' WHERE pid = '46741'; +UPDATE profiles SET ax_id = '20110348' WHERE pid = '46742'; +UPDATE profiles SET ax_id = '20110349' WHERE pid = '46743'; +UPDATE profiles SET ax_id = '20110350' WHERE pid = '46744'; +UPDATE profiles SET ax_id = '20110351' WHERE pid = '46745'; +UPDATE profiles SET ax_id = '20110352' WHERE pid = '46746'; +UPDATE profiles SET ax_id = '20110353' WHERE pid = '46747'; +UPDATE profiles SET ax_id = '20110354' WHERE pid = '46748'; +UPDATE profiles SET ax_id = '20110355' WHERE pid = '46749'; +UPDATE profiles SET ax_id = '20110356' WHERE pid = '46750'; +UPDATE profiles SET ax_id = '20110357' WHERE pid = '46751'; +UPDATE profiles SET ax_id = '20110358' WHERE pid = '46752'; +UPDATE profiles SET ax_id = '20110360' WHERE pid = '46753'; +UPDATE profiles SET ax_id = '20110361' WHERE pid = '46754'; +UPDATE profiles SET ax_id = '20110362' WHERE pid = '46755'; +UPDATE profiles SET ax_id = '20110363' WHERE pid = '46756'; +UPDATE profiles SET ax_id = '20110364' WHERE pid = '46757'; +UPDATE profiles SET ax_id = '20110365' WHERE pid = '46758'; +UPDATE profiles SET ax_id = '20110366' WHERE pid = '46759'; +UPDATE profiles SET ax_id = '20110367' WHERE pid = '46760'; +UPDATE profiles SET ax_id = '20110368' WHERE pid = '46761'; +UPDATE profiles SET ax_id = '20110369' WHERE pid = '46762'; +UPDATE profiles SET ax_id = '20110370' WHERE pid = '46763'; +UPDATE profiles SET ax_id = '20110371' WHERE pid = '46764'; +UPDATE profiles SET ax_id = '20110373' WHERE pid = '46766'; +UPDATE profiles SET ax_id = '20110374' WHERE pid = '46767'; +UPDATE profiles SET ax_id = '20110375' WHERE pid = '46768'; +UPDATE profiles SET ax_id = '20110376' WHERE pid = '46769'; +UPDATE profiles SET ax_id = '20110377' WHERE pid = '46770'; +UPDATE profiles SET ax_id = '20110378' WHERE pid = '46771'; +UPDATE profiles SET ax_id = '20110379' WHERE pid = '46772'; +UPDATE profiles SET ax_id = '20110380' WHERE pid = '46773'; +UPDATE profiles SET ax_id = '20110381' WHERE pid = '46774'; +UPDATE profiles SET ax_id = '20110382' WHERE pid = '46775'; +UPDATE profiles SET ax_id = '20110383' WHERE pid = '46776'; +UPDATE profiles SET ax_id = '20110384' WHERE pid = '46777'; +UPDATE profiles SET ax_id = '20110385' WHERE pid = '46778'; +UPDATE profiles SET ax_id = '20110386' WHERE pid = '46779'; +UPDATE profiles SET ax_id = '20110387' WHERE pid = '46780'; +UPDATE profiles SET ax_id = '20110389' WHERE pid = '46781'; +UPDATE profiles SET ax_id = '20110391' WHERE pid = '46782'; +UPDATE profiles SET ax_id = '20110392' WHERE pid = '46783'; +UPDATE profiles SET ax_id = '20110393' WHERE pid = '46784'; +UPDATE profiles SET ax_id = '20110394' WHERE pid = '46785'; +UPDATE profiles SET ax_id = '20110395' WHERE pid = '46786'; +UPDATE profiles SET ax_id = '20110396' WHERE pid = '46787'; +UPDATE profiles SET ax_id = '20110397' WHERE pid = '46788'; +UPDATE profiles SET ax_id = '20110398' WHERE pid = '46789'; +UPDATE profiles SET ax_id = '20110399' WHERE pid = '46790'; +UPDATE profiles SET ax_id = '20110400' WHERE pid = '46791'; +UPDATE profiles SET ax_id = '20110401' WHERE pid = '46792'; +UPDATE profiles SET ax_id = '20110402' WHERE pid = '46793'; +UPDATE profiles SET ax_id = '20110403' WHERE pid = '46794'; +UPDATE profiles SET ax_id = '20110404' WHERE pid = '46795'; +UPDATE profiles SET ax_id = '20110405' WHERE pid = '46796'; +UPDATE profiles SET ax_id = '20110407' WHERE pid = '46797'; +UPDATE profiles SET ax_id = '20110408' WHERE pid = '46798'; +UPDATE profiles SET ax_id = '20110409' WHERE pid = '46799'; +UPDATE profiles SET ax_id = '20110410' WHERE pid = '46800'; +UPDATE profiles SET ax_id = '20110411' WHERE pid = '46801'; +UPDATE profiles SET ax_id = '20110412' WHERE pid = '46802'; +UPDATE profiles SET ax_id = '20110413' WHERE pid = '46803'; +UPDATE profiles SET ax_id = '20110414' WHERE pid = '46804'; +UPDATE profiles SET ax_id = '20110415' WHERE pid = '46805'; +UPDATE profiles SET ax_id = '20110416' WHERE pid = '46806'; +UPDATE profiles SET ax_id = '20110417' WHERE pid = '46807'; +UPDATE profiles SET ax_id = '20110418' WHERE pid = '46808'; +UPDATE profiles SET ax_id = '20110419' WHERE pid = '46809'; +UPDATE profiles SET ax_id = '20110420' WHERE pid = '46810'; +UPDATE profiles SET ax_id = '20110422' WHERE pid = '46811'; +UPDATE profiles SET ax_id = '20110423' WHERE pid = '46812'; +UPDATE profiles SET ax_id = '20110424' WHERE pid = '46813'; +UPDATE profiles SET ax_id = '20110425' WHERE pid = '46814'; +UPDATE profiles SET ax_id = '20110426' WHERE pid = '46815'; +UPDATE profiles SET ax_id = '20110427' WHERE pid = '46816'; +UPDATE profiles SET ax_id = '20110428' WHERE pid = '46817'; +UPDATE profiles SET ax_id = '20110429' WHERE pid = '46818'; +UPDATE profiles SET ax_id = '20110430' WHERE pid = '46819'; +UPDATE profiles SET ax_id = '20110431' WHERE pid = '46820'; +UPDATE profiles SET ax_id = '20110432' WHERE pid = '46821'; +UPDATE profiles SET ax_id = '20110433' WHERE pid = '46822'; +UPDATE profiles SET ax_id = '2009D500' WHERE pid = '44986'; +UPDATE profiles SET ax_id = '20110227' WHERE pid = '46633'; +UPDATE profiles SET ax_id = '20110372' WHERE pid = '46765'; +UPDATE profiles SET ax_id = '20110027' WHERE pid = '44453'; +UPDATE profiles SET ax_id = '20100036' WHERE pid = '43967'; +UPDATE profiles SET ax_id = '20110106' WHERE pid = '46839'; diff --git a/upgrade/1.1.4/15_deceased.sql b/upgrade/1.1.4/15_deceased.sql new file mode 100644 index 0000000..9a33de0 --- /dev/null +++ b/upgrade/1.1.4/15_deceased.sql @@ -0,0 +1,468 @@ +UPDATE profiles SET deathdate = '2009-12-30' WHERE pid = '40567'; +UPDATE profiles SET deathdate = '2009-05-09' WHERE pid = '27332'; +UPDATE profiles SET deathdate = '2010-01-01' WHERE pid = '27967'; +UPDATE profiles SET deathdate = '2011-06-14' WHERE pid = '29729'; +UPDATE profiles SET deathdate = '2011-05-21' WHERE pid = '33273'; +UPDATE profiles SET deathdate = '2010-12-17' WHERE pid = '27450'; +UPDATE profiles SET deathdate = '2007-10-06' WHERE pid = '28697'; +UPDATE profiles SET deathdate = '2010-12-18' WHERE pid = '28905'; +UPDATE profiles SET deathdate = '2011-02-20' WHERE pid = '30350'; +UPDATE profiles SET deathdate = '2009-04-11' WHERE pid = '31008'; +UPDATE profiles SET deathdate = '2010-10-10' WHERE pid = '31375'; +UPDATE profiles SET deathdate = '2010-11-13' WHERE pid = '31322'; +UPDATE profiles SET deathdate = '2003-03-29' WHERE pid = '31396'; +UPDATE profiles SET deathdate = '2006-05-31' WHERE pid = '31627'; +UPDATE profiles SET deathdate = '2006-06-27' WHERE pid = '40619'; +UPDATE profiles SET deathdate = '2007-11-18' WHERE pid = '31861'; +UPDATE profiles SET deathdate = '2010-02-04' WHERE pid = '33187'; +UPDATE profiles SET deathdate = '2011-06-23' WHERE pid = '27914'; +UPDATE profiles SET deathdate = '2010-01-18' WHERE pid = '28029'; +UPDATE profiles SET deathdate = '2007-11-05' WHERE pid = '29261'; +UPDATE profiles SET deathdate = '2010-11-21' WHERE pid = '29579'; +UPDATE profiles SET deathdate = '2009-03-31' WHERE pid = '30986'; +UPDATE profiles SET deathdate = '2007-11-24' WHERE pid = '27361'; +UPDATE profiles SET deathdate = '2009-04-14' WHERE pid = '28209'; +UPDATE profiles SET deathdate = '2011-06-06' WHERE pid = '28224'; +UPDATE profiles SET deathdate = '2009-08-07' WHERE pid = '30868'; +UPDATE profiles SET deathdate = '2007-07-08' WHERE pid = '31016'; +UPDATE profiles SET deathdate = '2011-03-18' WHERE pid = '31772'; +UPDATE profiles SET deathdate = '2008-01-22' WHERE pid = '32548'; +UPDATE profiles SET deathdate = '1979-09-02' WHERE pid = '32820'; +UPDATE profiles SET deathdate = '2010-03-21' WHERE pid = '27582'; +UPDATE profiles SET deathdate = '2011-01-22' WHERE pid = '27587'; +UPDATE profiles SET deathdate = '2007-12-17' WHERE pid = '28552'; +UPDATE profiles SET deathdate = '2010-07-01' WHERE pid = '19620'; +UPDATE profiles SET deathdate = '2010-06-05' WHERE pid = '28878'; +UPDATE profiles SET deathdate = '2010-11-27' WHERE pid = '28917'; +UPDATE profiles SET deathdate = '2011-06-23' WHERE pid = '28984'; +UPDATE profiles SET deathdate = '2008-12-26' WHERE pid = '29364'; +UPDATE profiles SET deathdate = '2009-07-20' WHERE pid = '29382'; +UPDATE profiles SET deathdate = '2004-04-24' WHERE pid = '30579'; +UPDATE profiles SET deathdate = '2010-04-26' WHERE pid = '33144'; +UPDATE profiles SET deathdate = '2010-10-30' WHERE pid = '31034'; +UPDATE profiles SET deathdate = '2010-04-27' WHERE pid = '31082'; +UPDATE profiles SET deathdate = '2005-07-08' WHERE pid = '27298'; +UPDATE profiles SET deathdate = '2008-12-13' WHERE pid = '27463'; +UPDATE profiles SET deathdate = '2011-01-20' WHERE pid = '27693'; +UPDATE profiles SET deathdate = '2007-04-25' WHERE pid = '28007'; +UPDATE profiles SET deathdate = '2009-09-23' WHERE pid = '28112'; +UPDATE profiles SET deathdate = '2008-08-24' WHERE pid = '28644'; +UPDATE profiles SET deathdate = '2011-06-23' WHERE pid = '28688'; +UPDATE profiles SET deathdate = '2011-10-23' WHERE pid = '28867'; +UPDATE profiles SET deathdate = '2011-02-03' WHERE pid = '29547'; +UPDATE profiles SET deathdate = '2008-11-21' WHERE pid = '29816'; +UPDATE profiles SET deathdate = '2010-04-29' WHERE pid = '30645'; +UPDATE profiles SET deathdate = '2010-12-14' WHERE pid = '30966'; +UPDATE profiles SET deathdate = '1999-04-07' WHERE pid = '32592'; +UPDATE profiles SET deathdate = '2011-09-09' WHERE pid = '33027'; +UPDATE profiles SET deathdate = '2010-02-05' WHERE pid = '33305'; +UPDATE profiles SET deathdate = '2011-01-21' WHERE pid = '27060'; +UPDATE profiles SET deathdate = '2010-11-26' WHERE pid = '27084'; +UPDATE profiles SET deathdate = '2010-06-28' WHERE pid = '27421'; +UPDATE profiles SET deathdate = '2005-02-04' WHERE pid = '28636'; +UPDATE profiles SET deathdate = '2009-04-02' WHERE pid = '29108'; +UPDATE profiles SET deathdate = '2011-09-24' WHERE pid = '30107'; +UPDATE profiles SET deathdate = '2008-05-04' WHERE pid = '31002'; +UPDATE profiles SET deathdate = '2009-08-11' WHERE pid = '31342'; +UPDATE profiles SET deathdate = '2007-12-15' WHERE pid = '31517'; +UPDATE profiles SET deathdate = '2011-01-21' WHERE pid = '32101'; +UPDATE profiles SET deathdate = '2010-12-18' WHERE pid = '32450'; +UPDATE profiles SET deathdate = '2009-09-08' WHERE pid = '32486'; +UPDATE profiles SET deathdate = '2011-05-26' WHERE pid = '32635'; +UPDATE profiles SET deathdate = '2010-05-07' WHERE pid = '32778'; +UPDATE profiles SET deathdate = '2009-05-01' WHERE pid = '32932'; +UPDATE profiles SET deathdate = '1992-12-11' WHERE pid = '33104'; +UPDATE profiles SET deathdate = '2010-04-27' WHERE pid = '33158'; +UPDATE profiles SET deathdate = '2011-10-08' WHERE pid = '33189'; +UPDATE profiles SET deathdate = '2011-02-23' WHERE pid = '33215'; +UPDATE profiles SET deathdate = '2010-01-18' WHERE pid = '27324'; +UPDATE profiles SET deathdate = '2010-02-20' WHERE pid = '28190'; +UPDATE profiles SET deathdate = '2008-10-06' WHERE pid = '28365'; +UPDATE profiles SET deathdate = '2010-07-23' WHERE pid = '22565'; +UPDATE profiles SET deathdate = '2009-03-11' WHERE pid = '29051'; +UPDATE profiles SET deathdate = '2010-01-27' WHERE pid = '29202'; +UPDATE profiles SET deathdate = '2011-08-05' WHERE pid = '29538'; +UPDATE profiles SET deathdate = '2010-03-04' WHERE pid = '29558'; +UPDATE profiles SET deathdate = '2009-11-13' WHERE pid = '29619'; +UPDATE profiles SET deathdate = '2010-04-21' WHERE pid = '29923'; +UPDATE profiles SET deathdate = '2011-01-10' WHERE pid = '30026'; +UPDATE profiles SET deathdate = '2009-09-23' WHERE pid = '30145'; +UPDATE profiles SET deathdate = '2011-06-05' WHERE pid = '30688'; +UPDATE profiles SET deathdate = '2010-09-10' WHERE pid = '30698'; +UPDATE profiles SET deathdate = '2007-11-23' WHERE pid = '31106'; +UPDATE profiles SET deathdate = '2011-01-22' WHERE pid = '31487'; +UPDATE profiles SET deathdate = '2010-06-03' WHERE pid = '31784'; +UPDATE profiles SET deathdate = '2009-12-29' WHERE pid = '32078'; +UPDATE profiles SET deathdate = '2007-10-27' WHERE pid = '32320'; +UPDATE profiles SET deathdate = '2009-11-30' WHERE pid = '32692'; +UPDATE profiles SET deathdate = '2009-10-16' WHERE pid = '33190'; +UPDATE profiles SET deathdate = '2011-05-17' WHERE pid = '27270'; +UPDATE profiles SET deathdate = '2009-10-02' WHERE pid = '27393'; +UPDATE profiles SET deathdate = '2011-10-01' WHERE pid = '28059'; +UPDATE profiles SET deathdate = '2010-12-13' WHERE pid = '28149'; +UPDATE profiles SET deathdate = '2007-10-09' WHERE pid = '28151'; +UPDATE profiles SET deathdate = '2010-12-22' WHERE pid = '28435'; +UPDATE profiles SET deathdate = '2005-12-06' WHERE pid = '29034'; +UPDATE profiles SET deathdate = '2010-07-27' WHERE pid = '29341'; +UPDATE profiles SET deathdate = '2009-10-28' WHERE pid = '29460'; +UPDATE profiles SET deathdate = '2007-10-11' WHERE pid = '29567'; +UPDATE profiles SET deathdate = '2010-05-10' WHERE pid = '29844'; +UPDATE profiles SET deathdate = '2011-03-15' WHERE pid = '29918'; +UPDATE profiles SET deathdate = '2009-11-25' WHERE pid = '30364'; +UPDATE profiles SET deathdate = '2007-10-30' WHERE pid = '30668'; +UPDATE profiles SET deathdate = '2007-10-09' WHERE pid = '30761'; +UPDATE profiles SET deathdate = '2007-10-07' WHERE pid = '31159'; +UPDATE profiles SET deathdate = '2009-11-08' WHERE pid = '31877'; +UPDATE profiles SET deathdate = '2010-06-01' WHERE pid = '19986'; +UPDATE profiles SET deathdate = '2011-01-08' WHERE pid = '25361'; +UPDATE profiles SET deathdate = '2010-11-10' WHERE pid = '32383'; +UPDATE profiles SET deathdate = '2009-07-22' WHERE pid = '32530'; +UPDATE profiles SET deathdate = '2009-09-06' WHERE pid = '32580'; +UPDATE profiles SET deathdate = '2011-05-28' WHERE pid = '32633'; +UPDATE profiles SET deathdate = '2007-09-23' WHERE pid = '32908'; +UPDATE profiles SET deathdate = '2009-04-29' WHERE pid = '33275'; +UPDATE profiles SET deathdate = '2009-10-25' WHERE pid = '27182'; +UPDATE profiles SET deathdate = '2009-06-07' WHERE pid = '27379'; +UPDATE profiles SET deathdate = '2011-05-18' WHERE pid = '27828'; +UPDATE profiles SET deathdate = '2009-07-11' WHERE pid = '28027'; +UPDATE profiles SET deathdate = '2009-06-29' WHERE pid = '28600'; +UPDATE profiles SET deathdate = '2011-04-28' WHERE pid = '28930'; +UPDATE profiles SET deathdate = '2011-10-25' WHERE pid = '29013'; +UPDATE profiles SET deathdate = '2011-07-18' WHERE pid = '29372'; +UPDATE profiles SET deathdate = '2010-12-06' WHERE pid = '22499'; +UPDATE profiles SET deathdate = '2011-10-06' WHERE pid = '29722'; +UPDATE profiles SET deathdate = '2009-05-23' WHERE pid = '30568'; +UPDATE profiles SET deathdate = '2007-11-05' WHERE pid = '31218'; +UPDATE profiles SET deathdate = '2011-04-16' WHERE pid = '31701'; +UPDATE profiles SET deathdate = '2009-04-03' WHERE pid = '32089'; +UPDATE profiles SET deathdate = '2009-11-13' WHERE pid = '32124'; +UPDATE profiles SET deathdate = '2009-10-28' WHERE pid = '32356'; +UPDATE profiles SET deathdate = '2007-10-16' WHERE pid = '32453'; +UPDATE profiles SET deathdate = '2010-12-18' WHERE pid = '32853'; +UPDATE profiles SET deathdate = '2007-11-19' WHERE pid = '32999'; +UPDATE profiles SET deathdate = '2009-03-28' WHERE pid = '33126'; +UPDATE profiles SET deathdate = '2011-07-22' WHERE pid = '27067'; +UPDATE profiles SET deathdate = '2010-09-16' WHERE pid = '27216'; +UPDATE profiles SET deathdate = '2011-03-03' WHERE pid = '27826'; +UPDATE profiles SET deathdate = '2010-03-06' WHERE pid = '28040'; +UPDATE profiles SET deathdate = '2010-04-28' WHERE pid = '28195'; +UPDATE profiles SET deathdate = '2010-08-19' WHERE pid = '28592'; +UPDATE profiles SET deathdate = '2011-07-04' WHERE pid = '28783'; +UPDATE profiles SET deathdate = '2010-07-01' WHERE pid = '29306'; +UPDATE profiles SET deathdate = '2009-10-21' WHERE pid = '29793'; +UPDATE profiles SET deathdate = '2010-01-09' WHERE pid = '30161'; +UPDATE profiles SET deathdate = '2009-11-30' WHERE pid = '30363'; +UPDATE profiles SET deathdate = '2010-11-15' WHERE pid = '30756'; +UPDATE profiles SET deathdate = '2011-09-27' WHERE pid = '30863'; +UPDATE profiles SET deathdate = '2009-08-19' WHERE pid = '30888'; +UPDATE profiles SET deathdate = '2010-05-17' WHERE pid = '31074'; +UPDATE profiles SET deathdate = '2011-09-17' WHERE pid = '31127'; +UPDATE profiles SET deathdate = '2011-01-04' WHERE pid = '31236'; +UPDATE profiles SET deathdate = '2011-02-04' WHERE pid = '31340'; +UPDATE profiles SET deathdate = '2009-12-05' WHERE pid = '31508'; +UPDATE profiles SET deathdate = '2009-03-23' WHERE pid = '31530'; +UPDATE profiles SET deathdate = '2011-01-27' WHERE pid = '31984'; +UPDATE profiles SET deathdate = '2010-07-15' WHERE pid = '32082'; +UPDATE profiles SET deathdate = '2009-04-27' WHERE pid = '32112'; +UPDATE profiles SET deathdate = '2010-07-26' WHERE pid = '32407'; +UPDATE profiles SET deathdate = '2007-09-28' WHERE pid = '32886'; +UPDATE profiles SET deathdate = '2009-10-11' WHERE pid = '27358'; +UPDATE profiles SET deathdate = '2011-02-15' WHERE pid = '27763'; +UPDATE profiles SET deathdate = '2009-05-26' WHERE pid = '27851'; +UPDATE profiles SET deathdate = '2009-04-17' WHERE pid = '27932'; +UPDATE profiles SET deathdate = '2009-12-11' WHERE pid = '28299'; +UPDATE profiles SET deathdate = '2010-03-18' WHERE pid = '28363'; +UPDATE profiles SET deathdate = '2010-11-16' WHERE pid = '29012'; +UPDATE profiles SET deathdate = '2009-06-05' WHERE pid = '29339'; +UPDATE profiles SET deathdate = '2011-07-20' WHERE pid = '30742'; +UPDATE profiles SET deathdate = '2010-09-03' WHERE pid = '30839'; +UPDATE profiles SET deathdate = '2010-12-01' WHERE pid = '30992'; +UPDATE profiles SET deathdate = '2010-03-05' WHERE pid = '31278'; +UPDATE profiles SET deathdate = '2009-07-22' WHERE pid = '31740'; +UPDATE profiles SET deathdate = '2010-10-16' WHERE pid = '32009'; +UPDATE profiles SET deathdate = '2009-11-23' WHERE pid = '32109'; +UPDATE profiles SET deathdate = '2011-04-22' WHERE pid = '33188'; +UPDATE profiles SET deathdate = '2011-09-07' WHERE pid = '33225'; +UPDATE profiles SET deathdate = '2010-10-08' WHERE pid = '21088'; +UPDATE profiles SET deathdate = '2009-03-24' WHERE pid = '27510'; +UPDATE profiles SET deathdate = '2009-07-03' WHERE pid = '27759'; +UPDATE profiles SET deathdate = '2007-09-03' WHERE pid = '28319'; +UPDATE profiles SET deathdate = '2011-08-10' WHERE pid = '28512'; +UPDATE profiles SET deathdate = '2011-10-09' WHERE pid = '28531'; +UPDATE profiles SET deathdate = '2008-05-22' WHERE pid = '29410'; +UPDATE profiles SET deathdate = '2011-09-17' WHERE pid = '30254'; +UPDATE profiles SET deathdate = '2010-05-24' WHERE pid = '30415'; +UPDATE profiles SET deathdate = '2009-10-23' WHERE pid = '30858'; +UPDATE profiles SET deathdate = '2010-12-21' WHERE pid = '31033'; +UPDATE profiles SET deathdate = '2011-06-23' WHERE pid = '31736'; +UPDATE profiles SET deathdate = '2009-10-03' WHERE pid = '31909'; +UPDATE profiles SET deathdate = '2009-09-18' WHERE pid = '32302'; +UPDATE profiles SET deathdate = '2009-08-07' WHERE pid = '32441'; +UPDATE profiles SET deathdate = '2010-01-27' WHERE pid = '32713'; +UPDATE profiles SET deathdate = '2011-06-14' WHERE pid = '32787'; +UPDATE profiles SET deathdate = '2007-12-02' WHERE pid = '25067'; +UPDATE profiles SET deathdate = '2007-11-20' WHERE pid = '27210'; +UPDATE profiles SET deathdate = '2010-02-07' WHERE pid = '27640'; +UPDATE profiles SET deathdate = '2010-10-13' WHERE pid = '28057'; +UPDATE profiles SET deathdate = '2010-01-10' WHERE pid = '29077'; +UPDATE profiles SET deathdate = '2009-11-10' WHERE pid = '29902'; +UPDATE profiles SET deathdate = '2009-09-14' WHERE pid = '30218'; +UPDATE profiles SET deathdate = '2011-10-16' WHERE pid = '30543'; +UPDATE profiles SET deathdate = '2007-09-01' WHERE pid = '31032'; +UPDATE profiles SET deathdate = '2007-02-23' WHERE pid = '31052'; +UPDATE profiles SET deathdate = '2009-10-30' WHERE pid = '31266'; +UPDATE profiles SET deathdate = '2009-11-03' WHERE pid = '31671'; +UPDATE profiles SET deathdate = '2010-05-16' WHERE pid = '32332'; +UPDATE profiles SET deathdate = '2009-11-12' WHERE pid = '19360'; +UPDATE profiles SET deathdate = '2010-12-10' WHERE pid = '27764'; +UPDATE profiles SET deathdate = '2009-07-12' WHERE pid = '28769'; +UPDATE profiles SET deathdate = '2010-08-06' WHERE pid = '29671'; +UPDATE profiles SET deathdate = '2010-06-24' WHERE pid = '31120'; +UPDATE profiles SET deathdate = '2011-01-22' WHERE pid = '32236'; +UPDATE profiles SET deathdate = '2007-10-31' WHERE pid = '32600'; +UPDATE profiles SET deathdate = '2011-09-03' WHERE pid = '27238'; +UPDATE profiles SET deathdate = '2007-10-13' WHERE pid = '27755'; +UPDATE profiles SET deathdate = '2011-08-16' WHERE pid = '28298'; +UPDATE profiles SET deathdate = '2010-12-05' WHERE pid = '28348'; +UPDATE profiles SET deathdate = '2007-04-24' WHERE pid = '28359'; +UPDATE profiles SET deathdate = '2011-09-19' WHERE pid = '28732'; +UPDATE profiles SET deathdate = '2011-03-24' WHERE pid = '30660'; +UPDATE profiles SET deathdate = '2009-04-26' WHERE pid = '31354'; +UPDATE profiles SET deathdate = '2010-03-07' WHERE pid = '31566'; +UPDATE profiles SET deathdate = '2010-09-04' WHERE pid = '33123'; +UPDATE profiles SET deathdate = '2010-12-31' WHERE pid = '27300'; +UPDATE profiles SET deathdate = '2011-08-20' WHERE pid = '27439'; +UPDATE profiles SET deathdate = '2009-12-21' WHERE pid = '28266'; +UPDATE profiles SET deathdate = '2010-04-25' WHERE pid = '28553'; +UPDATE profiles SET deathdate = '2011-01-15' WHERE pid = '30854'; +UPDATE profiles SET deathdate = '2011-06-27' WHERE pid = '31695'; +UPDATE profiles SET deathdate = '2011-10-04' WHERE pid = '27344'; +UPDATE profiles SET deathdate = '2010-11-01' WHERE pid = '27838'; +UPDATE profiles SET deathdate = '2010-03-03' WHERE pid = '27847'; +UPDATE profiles SET deathdate = '2010-08-02' WHERE pid = '28114'; +UPDATE profiles SET deathdate = '2011-04-25' WHERE pid = '28203'; +UPDATE profiles SET deathdate = '2010-01-21' WHERE pid = '28221'; +UPDATE profiles SET deathdate = '2010-11-19' WHERE pid = '28366'; +UPDATE profiles SET deathdate = '2011-03-03' WHERE pid = '28401'; +UPDATE profiles SET deathdate = '2010-06-25' WHERE pid = '28585'; +UPDATE profiles SET deathdate = '2010-05-05' WHERE pid = '28834'; +UPDATE profiles SET deathdate = '2009-09-23' WHERE pid = '29657'; +UPDATE profiles SET deathdate = '2009-07-30' WHERE pid = '30857'; +UPDATE profiles SET deathdate = '2010-03-16' WHERE pid = '31133'; +UPDATE profiles SET deathdate = '2010-02-26' WHERE pid = '32503'; +UPDATE profiles SET deathdate = '2007-01-30' WHERE pid = '32785'; +UPDATE profiles SET deathdate = '2010-07-04' WHERE pid = '33255'; +UPDATE profiles SET deathdate = '2011-05-07' WHERE pid = '39636'; +UPDATE profiles SET deathdate = '2010-10-16' WHERE pid = '33263'; +UPDATE profiles SET deathdate = '2011-01-27' WHERE pid = '27215'; +UPDATE profiles SET deathdate = '2010-09-26' WHERE pid = '27702'; +UPDATE profiles SET deathdate = '2011-02-14' WHERE pid = '27986'; +UPDATE profiles SET deathdate = '2011-07-19' WHERE pid = '28431'; +UPDATE profiles SET deathdate = '2011-01-04' WHERE pid = '28463'; +UPDATE profiles SET deathdate = '2008-04-22' WHERE pid = '28557'; +UPDATE profiles SET deathdate = '2010-03-14' WHERE pid = '28635'; +UPDATE profiles SET deathdate = '2010-06-10' WHERE pid = '22531'; +UPDATE profiles SET deathdate = '2011-06-27' WHERE pid = '29680'; +UPDATE profiles SET deathdate = '2010-10-31' WHERE pid = '29714'; +UPDATE profiles SET deathdate = '2011-09-24' WHERE pid = '30192'; +UPDATE profiles SET deathdate = '2011-06-24' WHERE pid = '31457'; +UPDATE profiles SET deathdate = '2010-07-29' WHERE pid = '31594'; +UPDATE profiles SET deathdate = '2010-07-06' WHERE pid = '31725'; +UPDATE profiles SET deathdate = '2011-03-09' WHERE pid = '32131'; +UPDATE profiles SET deathdate = '2009-03-12' WHERE pid = '32251'; +UPDATE profiles SET deathdate = '2007-11-29' WHERE pid = '33100'; +UPDATE profiles SET deathdate = '2011-10-24' WHERE pid = '27085'; +UPDATE profiles SET deathdate = '2011-01-05' WHERE pid = '27649'; +UPDATE profiles SET deathdate = '2010-05-18' WHERE pid = '27790'; +UPDATE profiles SET deathdate = '2009-04-13' WHERE pid = '27939'; +UPDATE profiles SET deathdate = '2011-07-22' WHERE pid = '28080'; +UPDATE profiles SET deathdate = '2007-10-14' WHERE pid = '28117'; +UPDATE profiles SET deathdate = '2010-02-10' WHERE pid = '28668'; +UPDATE profiles SET deathdate = '2010-06-02' WHERE pid = '28942'; +UPDATE profiles SET deathdate = '2011-01-22' WHERE pid = '29264'; +UPDATE profiles SET deathdate = '2010-01-14' WHERE pid = '29509'; +UPDATE profiles SET deathdate = '2010-04-22' WHERE pid = '29654'; +UPDATE profiles SET deathdate = '2011-03-11' WHERE pid = '30171'; +UPDATE profiles SET deathdate = '2010-12-07' WHERE pid = '30515'; +UPDATE profiles SET deathdate = '2011-05-29' WHERE pid = '31090'; +UPDATE profiles SET deathdate = '2009-10-14' WHERE pid = '20185'; +UPDATE profiles SET deathdate = '2011-03-05' WHERE pid = '31429'; +UPDATE profiles SET deathdate = '2010-03-11' WHERE pid = '31696'; +UPDATE profiles SET deathdate = '2009-11-20' WHERE pid = '31925'; +UPDATE profiles SET deathdate = '2009-09-02' WHERE pid = '31982'; +UPDATE profiles SET deathdate = '2011-04-22' WHERE pid = '32349'; +UPDATE profiles SET deathdate = '2007-11-17' WHERE pid = '32377'; +UPDATE profiles SET deathdate = '2010-06-21' WHERE pid = '32887'; +UPDATE profiles SET deathdate = '2009-03-20' WHERE pid = '27552'; +UPDATE profiles SET deathdate = '2011-03-23' WHERE pid = '27553'; +UPDATE profiles SET deathdate = '2011-10-24' WHERE pid = '29172'; +UPDATE profiles SET deathdate = '2009-05-02' WHERE pid = '29313'; +UPDATE profiles SET deathdate = '2010-11-05' WHERE pid = '29470'; +UPDATE profiles SET deathdate = '2010-11-13' WHERE pid = '29831'; +UPDATE profiles SET deathdate = '2010-09-27' WHERE pid = '29938'; +UPDATE profiles SET deathdate = '2009-11-27' WHERE pid = '29977'; +UPDATE profiles SET deathdate = '2010-10-09' WHERE pid = '30198'; +UPDATE profiles SET deathdate = '2011-04-05' WHERE pid = '30963'; +UPDATE profiles SET deathdate = '2010-07-11' WHERE pid = '31076'; +UPDATE profiles SET deathdate = '2009-05-19' WHERE pid = '31953'; +UPDATE profiles SET deathdate = '2011-02-08' WHERE pid = '32278'; +UPDATE profiles SET deathdate = '2011-10-30' WHERE pid = '32298'; +UPDATE profiles SET deathdate = '2009-04-22' WHERE pid = '32333'; +UPDATE profiles SET deathdate = '2011-08-31' WHERE pid = '32801'; +UPDATE profiles SET deathdate = '2009-09-04' WHERE pid = '21078'; +UPDATE profiles SET deathdate = '2010-01-12' WHERE pid = '25062'; +UPDATE profiles SET deathdate = '2011-05-10' WHERE pid = '28483'; +UPDATE profiles SET deathdate = '2010-07-03' WHERE pid = '28916'; +UPDATE profiles SET deathdate = '2010-03-26' WHERE pid = '24187'; +UPDATE profiles SET deathdate = '2010-01-22' WHERE pid = '29355'; +UPDATE profiles SET deathdate = '2007-10-14' WHERE pid = '30025'; +UPDATE profiles SET deathdate = '2010-03-11' WHERE pid = '30995'; +UPDATE profiles SET deathdate = '2011-09-12' WHERE pid = '31753'; +UPDATE profiles SET deathdate = '2011-08-19' WHERE pid = '32069'; +UPDATE profiles SET deathdate = '2011-04-15' WHERE pid = '27211'; +UPDATE profiles SET deathdate = '2011-03-02' WHERE pid = '27464'; +UPDATE profiles SET deathdate = '2011-10-17' WHERE pid = '27750'; +UPDATE profiles SET deathdate = '2010-04-29' WHERE pid = '27927'; +UPDATE profiles SET deathdate = '2010-05-31' WHERE pid = '23320'; +UPDATE profiles SET deathdate = '2009-05-19' WHERE pid = '29413'; +UPDATE profiles SET deathdate = '2010-05-13' WHERE pid = '30642'; +UPDATE profiles SET deathdate = '2009-06-15' WHERE pid = '30911'; +UPDATE profiles SET deathdate = '2010-08-27' WHERE pid = '31151'; +UPDATE profiles SET deathdate = '2009-08-08' WHERE pid = '31352'; +UPDATE profiles SET deathdate = '2010-01-17' WHERE pid = '31367'; +UPDATE profiles SET deathdate = '2009-10-14' WHERE pid = '31608'; +UPDATE profiles SET deathdate = '2011-10-29' WHERE pid = '31928'; +UPDATE profiles SET deathdate = '2009-10-15' WHERE pid = '32328'; +UPDATE profiles SET deathdate = '2009-10-27' WHERE pid = '27477'; +UPDATE profiles SET deathdate = '2011-02-24' WHERE pid = '28271'; +UPDATE profiles SET deathdate = '2010-12-31' WHERE pid = '29001'; +UPDATE profiles SET deathdate = '2009-10-14' WHERE pid = '29512'; +UPDATE profiles SET deathdate = '2009-09-01' WHERE pid = '30693'; +UPDATE profiles SET deathdate = '2007-09-23' WHERE pid = '31267'; +UPDATE profiles SET deathdate = '2010-09-22' WHERE pid = '32323'; +UPDATE profiles SET deathdate = '2007-11-17' WHERE pid = '32559'; +UPDATE profiles SET deathdate = '2010-12-02' WHERE pid = '32768'; +UPDATE profiles SET deathdate = '2009-10-23' WHERE pid = '33142'; +UPDATE profiles SET deathdate = '2009-06-04' WHERE pid = '27733'; +UPDATE profiles SET deathdate = '2010-02-13' WHERE pid = '28749'; +UPDATE profiles SET deathdate = '2008-04-17' WHERE pid = '29016'; +UPDATE profiles SET deathdate = '2010-10-09' WHERE pid = '29079'; +UPDATE profiles SET deathdate = '2010-12-06' WHERE pid = '29698'; +UPDATE profiles SET deathdate = '2010-11-20' WHERE pid = '31567'; +UPDATE profiles SET deathdate = '2011-07-30' WHERE pid = '31955'; +UPDATE profiles SET deathdate = '2011-04-10' WHERE pid = '32288'; +UPDATE profiles SET deathdate = '2010-10-17' WHERE pid = '32307'; +UPDATE profiles SET deathdate = '2011-08-27' WHERE pid = '27349'; +UPDATE profiles SET deathdate = '2011-09-07' WHERE pid = '20937'; +UPDATE profiles SET deathdate = '2010-04-29' WHERE pid = '27917'; +UPDATE profiles SET deathdate = '2009-11-08' WHERE pid = '28188'; +UPDATE profiles SET deathdate = '2010-12-30' WHERE pid = '28844'; +UPDATE profiles SET deathdate = '2010-11-09' WHERE pid = '29232'; +UPDATE profiles SET deathdate = '2011-01-06' WHERE pid = '29674'; +UPDATE profiles SET deathdate = '2001-03-18' WHERE pid = '30926'; +UPDATE profiles SET deathdate = '2009-06-04' WHERE pid = '31771'; +UPDATE profiles SET deathdate = '2009-09-14' WHERE pid = '32103'; +UPDATE profiles SET deathdate = '2008-11-26' WHERE pid = '33150'; +UPDATE profiles SET deathdate = '2007-10-09' WHERE pid = '27671'; +UPDATE profiles SET deathdate = '2007-11-19' WHERE pid = '29310'; +UPDATE profiles SET deathdate = '2011-10-12' WHERE pid = '29319'; +UPDATE profiles SET deathdate = '2009-12-17' WHERE pid = '30179'; +UPDATE profiles SET deathdate = '2009-04-29' WHERE pid = '31557'; +UPDATE profiles SET deathdate = '2010-09-21' WHERE pid = '32168'; +UPDATE profiles SET deathdate = '2010-04-12' WHERE pid = '32566'; +UPDATE profiles SET deathdate = '2010-05-14' WHERE pid = '32830'; +UPDATE profiles SET deathdate = '2011-07-28' WHERE pid = '28663'; +UPDATE profiles SET deathdate = '2010-02-09' WHERE pid = '24442'; +UPDATE profiles SET deathdate = '2010-11-11' WHERE pid = '29331'; +UPDATE profiles SET deathdate = '2008-04-28' WHERE pid = '30092'; +UPDATE profiles SET deathdate = '2011-03-19' WHERE pid = '30237'; +UPDATE profiles SET deathdate = '2010-02-22' WHERE pid = '30883'; +UPDATE profiles SET deathdate = '2009-04-12' WHERE pid = '32363'; +UPDATE profiles SET deathdate = '2011-01-07' WHERE pid = '27449'; +UPDATE profiles SET deathdate = '2009-08-09' WHERE pid = '28086'; +UPDATE profiles SET deathdate = '2011-10-09' WHERE pid = '28228'; +UPDATE profiles SET deathdate = '2010-11-16' WHERE pid = '28414'; +UPDATE profiles SET deathdate = '2011-01-31' WHERE pid = '28466'; +UPDATE profiles SET deathdate = '2009-09-17' WHERE pid = '28586'; +UPDATE profiles SET deathdate = '2010-01-06' WHERE pid = '29665'; +UPDATE profiles SET deathdate = '2010-09-21' WHERE pid = '31454'; +UPDATE profiles SET deathdate = '2010-02-27' WHERE pid = '32289'; +UPDATE profiles SET deathdate = '2009-10-19' WHERE pid = '33031'; +UPDATE profiles SET deathdate = '2009-01-07' WHERE pid = '33234'; +UPDATE profiles SET deathdate = '2010-11-14' WHERE pid = '26728'; +UPDATE profiles SET deathdate = '2009-10-19' WHERE pid = '27385'; +UPDATE profiles SET deathdate = '2010-09-24' WHERE pid = '28753'; +UPDATE profiles SET deathdate = '2009-05-06' WHERE pid = '29262'; +UPDATE profiles SET deathdate = '2011-10-25' WHERE pid = '25083'; +UPDATE profiles SET deathdate = '2010-12-15' WHERE pid = '19615'; +UPDATE profiles SET deathdate = '2011-03-01' WHERE pid = '32535'; +UPDATE profiles SET deathdate = '2010-02-03' WHERE pid = '23206'; +UPDATE profiles SET deathdate = '2011-06-09' WHERE pid = '28116'; +UPDATE profiles SET deathdate = '2011-09-14' WHERE pid = '28895'; +UPDATE profiles SET deathdate = '2011-04-28' WHERE pid = '26768'; +UPDATE profiles SET deathdate = '2009-04-11' WHERE pid = '30027'; +UPDATE profiles SET deathdate = '2011-03-07' WHERE pid = '25594'; +UPDATE profiles SET deathdate = '2011-05-09' WHERE pid = '28193'; +UPDATE profiles SET deathdate = '2011-02-17' WHERE pid = '29447'; +UPDATE profiles SET deathdate = '2008-02-04' WHERE pid = '30744'; +UPDATE profiles SET deathdate = '2009-06-19' WHERE pid = '31044'; +UPDATE profiles SET deathdate = '2010-10-13' WHERE pid = '27167'; +UPDATE profiles SET deathdate = '2011-09-05' WHERE pid = '22455'; +UPDATE profiles SET deathdate = '2011-06-16' WHERE pid = '19924'; +UPDATE profiles SET deathdate = '2010-01-30' WHERE pid = '29593'; +UPDATE profiles SET deathdate = '2010-02-05' WHERE pid = '30504'; +UPDATE profiles SET deathdate = '2009-09-14' WHERE pid = '28206'; +UPDATE profiles SET deathdate = '2011-09-13' WHERE pid = '27528'; +UPDATE profiles SET deathdate = '2008-03-30' WHERE pid = '25852'; +UPDATE profiles SET deathdate = '2009-11-26' WHERE pid = '31382'; +UPDATE profiles SET deathdate = '2011-05-05' WHERE pid = '20557'; +UPDATE profiles SET deathdate = '2010-11-14' WHERE pid = '32350'; +UPDATE profiles SET deathdate = '2007-10-31' WHERE pid = '33148'; +UPDATE profiles SET deathdate = '2011-09-09' WHERE pid = '20669'; +UPDATE profiles SET deathdate = '2011-10-02' WHERE pid = '24256'; +UPDATE profiles SET deathdate = '2011-09-11' WHERE pid = '28312'; +UPDATE profiles SET deathdate = '2010-11-28' WHERE pid = '29340'; +UPDATE profiles SET deathdate = '2009-03-21' WHERE pid = '32163'; +UPDATE profiles SET deathdate = '2011-03-04' WHERE pid = '32876'; +UPDATE profiles SET deathdate = '2011-10-23' WHERE pid = '22049'; +UPDATE profiles SET deathdate = '2011-04-20' WHERE pid = '29234'; +UPDATE profiles SET deathdate = '2009-11-14' WHERE pid = '29636'; +UPDATE profiles SET deathdate = '2007-11-01' WHERE pid = '29838'; +UPDATE profiles SET deathdate = '2009-12-15' WHERE pid = '19882'; +UPDATE profiles SET deathdate = '2010-12-06' WHERE pid = '27501'; +UPDATE profiles SET deathdate = '2011-02-08' WHERE pid = '28131'; +UPDATE profiles SET deathdate = '2009-09-09' WHERE pid = '18402'; +UPDATE profiles SET deathdate = '2009-11-22' WHERE pid = '29639'; +UPDATE profiles SET deathdate = '2011-09-29' WHERE pid = '30146'; +UPDATE profiles SET deathdate = '2009-09-03' WHERE pid = '22566'; +UPDATE profiles SET deathdate = '2011-01-23' WHERE pid = '24995'; +UPDATE profiles SET deathdate = '2010-06-01' WHERE pid = '28723'; +UPDATE profiles SET deathdate = '2009-11-22' WHERE pid = '32224'; +UPDATE profiles SET deathdate = '2011-06-29' WHERE pid = '32233'; +UPDATE profiles SET deathdate = '2009-07-12' WHERE pid = '21042'; +UPDATE profiles SET deathdate = '2009-12-28' WHERE pid = '27743'; +UPDATE profiles SET deathdate = '2010-06-21' WHERE pid = '31338'; +UPDATE profiles SET deathdate = '2011-07-10' WHERE pid = '31465'; +UPDATE profiles SET deathdate = '2008-05-09' WHERE pid = '30172'; +UPDATE profiles SET deathdate = '2010-06-07' WHERE pid = '31716'; +UPDATE profiles SET deathdate = '2009-09-30' WHERE pid = '27874'; +UPDATE profiles SET deathdate = '2009-04-18' WHERE pid = '29947'; +UPDATE profiles SET deathdate = '2009-05-27' WHERE pid = '31220'; +UPDATE profiles SET deathdate = '2010-02-12' WHERE pid = '28154'; +UPDATE profiles SET deathdate = '2007-10-10' WHERE pid = '30970'; +UPDATE profiles SET deathdate = '2010-03-26' WHERE pid = '31821'; +UPDATE profiles SET deathdate = '2010-01-17' WHERE pid = '10353'; +UPDATE profiles SET deathdate = '2011-02-10' WHERE pid = '27535'; +UPDATE profiles SET deathdate = '2010-07-02' WHERE pid = '32639'; +UPDATE profiles SET deathdate = '2010-10-03' WHERE pid = '26033'; +UPDATE profiles SET deathdate = '2009-10-06' WHERE pid = '17286'; +UPDATE profiles SET deathdate = '2011-02-09' WHERE pid = '34300'; +UPDATE profiles SET deathdate = '2010-01-29' WHERE pid = '21993'; +UPDATE profiles SET deathdate = '2010-02-12' WHERE pid = '34915'; +UPDATE profiles SET deathdate = '2008-07-19' WHERE pid = '35052'; +UPDATE profiles SET deathdate = '2011-05-18' WHERE pid = '35550'; +UPDATE profiles SET deathdate = '2010-05-02' WHERE pid = '24416'; +UPDATE profiles SET deathdate = '2007-11-03' WHERE pid = '18161'; +UPDATE profiles SET deathdate = '2011-09-21' WHERE pid = '11703'; +UPDATE profiles SET deathdate = '2010-09-16' WHERE pid = '15609'; +UPDATE profiles SET deathdate = '2011-10-07' WHERE pid = '45532'; -- 2.1.4