UPDATE bb_users SET user_from_flag = '036' WHERE user_from_flag = 'aus';
UPDATE bb_users SET user_from_flag = '040' WHERE user_from_flag = 'aut';
UPDATE bb_users SET user_from_flag = '031' WHERE user_from_flag = 'aze';
UPDATE bb_users SET user_from_flag = '248' WHERE user_from_flag = 'ala';
UPDATE bb_users SET user_from_flag = '008' WHERE user_from_flag = 'alb';
UPDATE bb_users SET user_from_flag = '012' WHERE user_from_flag = 'dza';
UPDATE bb_users SET user_from_flag = '581' WHERE user_from_flag = 'umi';
UPDATE bb_users SET user_from_flag = '850' WHERE user_from_flag = 'vir';
UPDATE bb_users SET user_from_flag = '016' WHERE user_from_flag = 'asm';
UPDATE bb_users SET user_from_flag = '660' WHERE user_from_flag = 'aia';
UPDATE bb_users SET user_from_flag = '024' WHERE user_from_flag = 'ago';
UPDATE bb_users SET user_from_flag = '020' WHERE user_from_flag = 'and';
UPDATE bb_users SET user_from_flag = '010' WHERE user_from_flag = 'ata';
UPDATE bb_users SET user_from_flag = '028' WHERE user_from_flag = 'atg';
UPDATE bb_users SET user_from_flag = '032' WHERE user_from_flag = 'arg';
UPDATE bb_users SET user_from_flag = '051' WHERE user_from_flag = 'arm';
UPDATE bb_users SET user_from_flag = '533' WHERE user_from_flag = 'abw';
UPDATE bb_users SET user_from_flag = '004' WHERE user_from_flag = 'afg';
UPDATE bb_users SET user_from_flag = '044' WHERE user_from_flag = 'bhs';
UPDATE bb_users SET user_from_flag = '050' WHERE user_from_flag = 'bgd';
UPDATE bb_users SET user_from_flag = '052' WHERE user_from_flag = 'brb';
UPDATE bb_users SET user_from_flag = '048' WHERE user_from_flag = 'bhr';
UPDATE bb_users SET user_from_flag = '084' WHERE user_from_flag = 'blz';
UPDATE bb_users SET user_from_flag = '112' WHERE user_from_flag = 'blr';
UPDATE bb_users SET user_from_flag = '056' WHERE user_from_flag = 'bel';
UPDATE bb_users SET user_from_flag = '204' WHERE user_from_flag = 'ben';
UPDATE bb_users SET user_from_flag = '060' WHERE user_from_flag = 'bmu';
UPDATE bb_users SET user_from_flag = '100' WHERE user_from_flag = 'bgr';
UPDATE bb_users SET user_from_flag = '068' WHERE user_from_flag = 'bol';
UPDATE bb_users SET user_from_flag = '070' WHERE user_from_flag = 'bih';
UPDATE bb_users SET user_from_flag = '072' WHERE user_from_flag = 'bwa';
UPDATE bb_users SET user_from_flag = '076' WHERE user_from_flag = 'bra';
UPDATE bb_users SET user_from_flag = '086' WHERE user_from_flag = 'iot';
UPDATE bb_users SET user_from_flag = '092' WHERE user_from_flag = 'vgb';
UPDATE bb_users SET user_from_flag = '096' WHERE user_from_flag = 'brn';
UPDATE bb_users SET user_from_flag = '854' WHERE user_from_flag = 'bfa';
UPDATE bb_users SET user_from_flag = '108' WHERE user_from_flag = 'bdi';
UPDATE bb_users SET user_from_flag = '064' WHERE user_from_flag = 'btn';
UPDATE bb_users SET user_from_flag = '548' WHERE user_from_flag = 'vut';
UPDATE bb_users SET user_from_flag = '336' WHERE user_from_flag = 'vat';
UPDATE bb_users SET user_from_flag = '826' WHERE user_from_flag = 'gbr';
UPDATE bb_users SET user_from_flag = '348' WHERE user_from_flag = 'hun';
UPDATE bb_users SET user_from_flag = '862' WHERE user_from_flag = 'ven';
UPDATE bb_users SET user_from_flag = '626' WHERE user_from_flag = 'tls';
UPDATE bb_users SET user_from_flag = '704' WHERE user_from_flag = 'vnm';
UPDATE bb_users SET user_from_flag = '266' WHERE user_from_flag = 'gab';
UPDATE bb_users SET user_from_flag = '332' WHERE user_from_flag = 'hti';
UPDATE bb_users SET user_from_flag = '328' WHERE user_from_flag = 'guy';
UPDATE bb_users SET user_from_flag = '270' WHERE user_from_flag = 'gmb';
UPDATE bb_users SET user_from_flag = '288' WHERE user_from_flag = 'gha';
UPDATE bb_users SET user_from_flag = '312' WHERE user_from_flag = 'glp';
UPDATE bb_users SET user_from_flag = '320' WHERE user_from_flag = 'gtm';
UPDATE bb_users SET user_from_flag = '324' WHERE user_from_flag = 'gin';
UPDATE bb_users SET user_from_flag = '624' WHERE user_from_flag = 'gnb';
UPDATE bb_users SET user_from_flag = '276' WHERE user_from_flag = 'deu';
UPDATE bb_users SET user_from_flag = '292' WHERE user_from_flag = 'gib';
UPDATE bb_users SET user_from_flag = '340' WHERE user_from_flag = 'hnd';
UPDATE bb_users SET user_from_flag = '344' WHERE user_from_flag = 'hkg';
UPDATE bb_users SET user_from_flag = '308' WHERE user_from_flag = 'grd';
UPDATE bb_users SET user_from_flag = '304' WHERE user_from_flag = 'grl';
UPDATE bb_users SET user_from_flag = '300' WHERE user_from_flag = 'grc';
UPDATE bb_users SET user_from_flag = '268' WHERE user_from_flag = 'geo';
UPDATE bb_users SET user_from_flag = '316' WHERE user_from_flag = 'gum';
UPDATE bb_users SET user_from_flag = '208' WHERE user_from_flag = 'dnk';
UPDATE bb_users SET user_from_flag = '180' WHERE user_from_flag = 'cod';
UPDATE bb_users SET user_from_flag = '262' WHERE user_from_flag = 'dji';
UPDATE bb_users SET user_from_flag = '212' WHERE user_from_flag = 'dma';
UPDATE bb_users SET user_from_flag = '214' WHERE user_from_flag = 'dom';
UPDATE bb_users SET user_from_flag = '818' WHERE user_from_flag = 'egy';
UPDATE bb_users SET user_from_flag = '894' WHERE user_from_flag = 'zmb';
UPDATE bb_users SET user_from_flag = '732' WHERE user_from_flag = 'esh';
UPDATE bb_users SET user_from_flag = '716' WHERE user_from_flag = 'zwe';
UPDATE bb_users SET user_from_flag = '376' WHERE user_from_flag = 'isr';
UPDATE bb_users SET user_from_flag = '356' WHERE user_from_flag = 'ind';
UPDATE bb_users SET user_from_flag = '360' WHERE user_from_flag = 'idn';
UPDATE bb_users SET user_from_flag = '400' WHERE user_from_flag = 'jor';
UPDATE bb_users SET user_from_flag = '368' WHERE user_from_flag = 'irq';
UPDATE bb_users SET user_from_flag = '364' WHERE user_from_flag = 'irn';
UPDATE bb_users SET user_from_flag = '372' WHERE user_from_flag = 'irl';
UPDATE bb_users SET user_from_flag = '352' WHERE user_from_flag = 'isl';
UPDATE bb_users SET user_from_flag = '724' WHERE user_from_flag = 'esp';
UPDATE bb_users SET user_from_flag = '380' WHERE user_from_flag = 'ita';
UPDATE bb_users SET user_from_flag = '887' WHERE user_from_flag = 'yem';
UPDATE bb_users SET user_from_flag = '408' WHERE user_from_flag = 'prk';
UPDATE bb_users SET user_from_flag = '132' WHERE user_from_flag = 'cpv';
UPDATE bb_users SET user_from_flag = '398' WHERE user_from_flag = 'kaz';
UPDATE bb_users SET user_from_flag = '136' WHERE user_from_flag = 'cym';
UPDATE bb_users SET user_from_flag = '116' WHERE user_from_flag = 'khm';
UPDATE bb_users SET user_from_flag = '120' WHERE user_from_flag = 'cmr';
UPDATE bb_users SET user_from_flag = '124' WHERE user_from_flag = 'can';
UPDATE bb_users SET user_from_flag = '634' WHERE user_from_flag = 'qat';
UPDATE bb_users SET user_from_flag = '404' WHERE user_from_flag = 'ken';
UPDATE bb_users SET user_from_flag = '196' WHERE user_from_flag = 'cyp';
UPDATE bb_users SET user_from_flag = '417' WHERE user_from_flag = 'kgz';
UPDATE bb_users SET user_from_flag = '296' WHERE user_from_flag = 'kir';
UPDATE bb_users SET user_from_flag = '156' WHERE user_from_flag = 'chn';
UPDATE bb_users SET user_from_flag = '166' WHERE user_from_flag = 'cck';
UPDATE bb_users SET user_from_flag = '170' WHERE user_from_flag = 'col';
UPDATE bb_users SET user_from_flag = '174' WHERE user_from_flag = 'com';
UPDATE bb_users SET user_from_flag = '188' WHERE user_from_flag = 'cri';
UPDATE bb_users SET user_from_flag = '384' WHERE user_from_flag = 'civ';
UPDATE bb_users SET user_from_flag = '192' WHERE user_from_flag = 'cub';
UPDATE bb_users SET user_from_flag = '414' WHERE user_from_flag = 'kwt';
UPDATE bb_users SET user_from_flag = '418' WHERE user_from_flag = 'lao';
UPDATE bb_users SET user_from_flag = '428' WHERE user_from_flag = 'lva';
UPDATE bb_users SET user_from_flag = '426' WHERE user_from_flag = 'lso';
UPDATE bb_users SET user_from_flag = '430' WHERE user_from_flag = 'lbr';
UPDATE bb_users SET user_from_flag = '422' WHERE user_from_flag = 'lbn';
UPDATE bb_users SET user_from_flag = '434' WHERE user_from_flag = 'lby';
UPDATE bb_users SET user_from_flag = '440' WHERE user_from_flag = 'ltu';
UPDATE bb_users SET user_from_flag = '438' WHERE user_from_flag = 'lie';
UPDATE bb_users SET user_from_flag = '442' WHERE user_from_flag = 'lux';
UPDATE bb_users SET user_from_flag = '480' WHERE user_from_flag = 'mus';
UPDATE bb_users SET user_from_flag = '478' WHERE user_from_flag = 'mrt';
UPDATE bb_users SET user_from_flag = '450' WHERE user_from_flag = 'mdg';
UPDATE bb_users SET user_from_flag = '175' WHERE user_from_flag = 'myt';
UPDATE bb_users SET user_from_flag = '446' WHERE user_from_flag = 'mac';
UPDATE bb_users SET user_from_flag = '807' WHERE user_from_flag = 'mkd';
UPDATE bb_users SET user_from_flag = '454' WHERE user_from_flag = 'mwi';
UPDATE bb_users SET user_from_flag = '458' WHERE user_from_flag = 'mys';
UPDATE bb_users SET user_from_flag = '466' WHERE user_from_flag = 'mli';
UPDATE bb_users SET user_from_flag = '462' WHERE user_from_flag = 'mdv';
UPDATE bb_users SET user_from_flag = '470' WHERE user_from_flag = 'mlt';
UPDATE bb_users SET user_from_flag = '504' WHERE user_from_flag = 'mar';
UPDATE bb_users SET user_from_flag = '474' WHERE user_from_flag = 'mtq';
UPDATE bb_users SET user_from_flag = '584' WHERE user_from_flag = 'mhl';
UPDATE bb_users SET user_from_flag = '484' WHERE user_from_flag = 'mex';
UPDATE bb_users SET user_from_flag = '508' WHERE user_from_flag = 'moz';
UPDATE bb_users SET user_from_flag = '498' WHERE user_from_flag = 'mda';
UPDATE bb_users SET user_from_flag = '492' WHERE user_from_flag = 'mco';
UPDATE bb_users SET user_from_flag = '496' WHERE user_from_flag = 'mng';
UPDATE bb_users SET user_from_flag = '500' WHERE user_from_flag = 'msr';
UPDATE bb_users SET user_from_flag = '104' WHERE user_from_flag = 'mmr';
UPDATE bb_users SET user_from_flag = '516' WHERE user_from_flag = 'nam';
UPDATE bb_users SET user_from_flag = '520' WHERE user_from_flag = 'nru';
UPDATE bb_users SET user_from_flag = '524' WHERE user_from_flag = 'npl';
UPDATE bb_users SET user_from_flag = '562' WHERE user_from_flag = 'ner';
UPDATE bb_users SET user_from_flag = '566' WHERE user_from_flag = 'nga';
UPDATE bb_users SET user_from_flag = '530' WHERE user_from_flag = 'ant';
UPDATE bb_users SET user_from_flag = '528' WHERE user_from_flag = 'nld';
UPDATE bb_users SET user_from_flag = '558' WHERE user_from_flag = 'nic';
UPDATE bb_users SET user_from_flag = '570' WHERE user_from_flag = 'niu';
UPDATE bb_users SET user_from_flag = '540' WHERE user_from_flag = 'ncl';
UPDATE bb_users SET user_from_flag = '554' WHERE user_from_flag = 'nzl';
UPDATE bb_users SET user_from_flag = '578' WHERE user_from_flag = 'nor';
UPDATE bb_users SET user_from_flag = '784' WHERE user_from_flag = 'are';
UPDATE bb_users SET user_from_flag = '512' WHERE user_from_flag = 'omn';
UPDATE bb_users SET user_from_flag = '162' WHERE user_from_flag = 'cxr';
UPDATE bb_users SET user_from_flag = '184' WHERE user_from_flag = 'cok';
UPDATE bb_users SET user_from_flag = '334' WHERE user_from_flag = 'hmd';
UPDATE bb_users SET user_from_flag = '586' WHERE user_from_flag = 'pak';
UPDATE bb_users SET user_from_flag = '585' WHERE user_from_flag = 'plw';
UPDATE bb_users SET user_from_flag = '275' WHERE user_from_flag = 'pse';
UPDATE bb_users SET user_from_flag = '591' WHERE user_from_flag = 'pan';
UPDATE bb_users SET user_from_flag = '598' WHERE user_from_flag = 'png';
UPDATE bb_users SET user_from_flag = '600' WHERE user_from_flag = 'pry';
UPDATE bb_users SET user_from_flag = '604' WHERE user_from_flag = 'per';
UPDATE bb_users SET user_from_flag = '612' WHERE user_from_flag = 'pcn';
UPDATE bb_users SET user_from_flag = '616' WHERE user_from_flag = 'pol';
UPDATE bb_users SET user_from_flag = '620' WHERE user_from_flag = 'prt';
UPDATE bb_users SET user_from_flag = '630' WHERE user_from_flag = 'pri';
UPDATE bb_users SET user_from_flag = '178' WHERE user_from_flag = 'cog';
UPDATE bb_users SET user_from_flag = '638' WHERE user_from_flag = 'reu';
UPDATE bb_users SET user_from_flag = '643' WHERE user_from_flag = 'rus';
UPDATE bb_users SET user_from_flag = '646' WHERE user_from_flag = 'rwa';
UPDATE bb_users SET user_from_flag = '642' WHERE user_from_flag = 'rou';
UPDATE bb_users SET user_from_flag = '840' WHERE user_from_flag = 'usa';
UPDATE bb_users SET user_from_flag = '222' WHERE user_from_flag = 'slv';
UPDATE bb_users SET user_from_flag = '882' WHERE user_from_flag = 'wsm';
UPDATE bb_users SET user_from_flag = '674' WHERE user_from_flag = 'smr';
UPDATE bb_users SET user_from_flag = '678' WHERE user_from_flag = 'stp';
UPDATE bb_users SET user_from_flag = '682' WHERE user_from_flag = 'sau';
UPDATE bb_users SET user_from_flag = '748' WHERE user_from_flag = 'swz';
UPDATE bb_users SET user_from_flag = '744' WHERE user_from_flag = 'sjm';
UPDATE bb_users SET user_from_flag = '580' WHERE user_from_flag = 'mnp';
UPDATE bb_users SET user_from_flag = '690' WHERE user_from_flag = 'syc';
UPDATE bb_users SET user_from_flag = '686' WHERE user_from_flag = 'sen';
UPDATE bb_users SET user_from_flag = '670' WHERE user_from_flag = 'vct';
UPDATE bb_users SET user_from_flag = '659' WHERE user_from_flag = 'kna';
UPDATE bb_users SET user_from_flag = '662' WHERE user_from_flag = 'lca';
UPDATE bb_users SET user_from_flag = '666' WHERE user_from_flag = 'spm';
UPDATE bb_users SET user_from_flag = '688' WHERE user_from_flag = 'srb';
UPDATE bb_users SET user_from_flag = '891' WHERE user_from_flag = 'scg';
UPDATE bb_users SET user_from_flag = '702' WHERE user_from_flag = 'sgp';
UPDATE bb_users SET user_from_flag = '760' WHERE user_from_flag = 'syr';
UPDATE bb_users SET user_from_flag = '703' WHERE user_from_flag = 'svk';
UPDATE bb_users SET user_from_flag = '705' WHERE user_from_flag = 'svn';
UPDATE bb_users SET user_from_flag = '090' WHERE user_from_flag = 'slb';
UPDATE bb_users SET user_from_flag = '706' WHERE user_from_flag = 'som';
UPDATE bb_users SET user_from_flag = '736' WHERE user_from_flag = 'sdn';
UPDATE bb_users SET user_from_flag = '740' WHERE user_from_flag = 'sur';
UPDATE bb_users SET user_from_flag = '694' WHERE user_from_flag = 'sle';
UPDATE bb_users SET user_from_flag = '810' WHERE user_from_flag = 'sun';
UPDATE bb_users SET user_from_flag = '762' WHERE user_from_flag = 'tjk';
UPDATE bb_users SET user_from_flag = '764' WHERE user_from_flag = 'tha';
UPDATE bb_users SET user_from_flag = '158' WHERE user_from_flag = 'twn';
UPDATE bb_users SET user_from_flag = '834' WHERE user_from_flag = 'tza';
UPDATE bb_users SET user_from_flag = '768' WHERE user_from_flag = 'tgo';
UPDATE bb_users SET user_from_flag = '772' WHERE user_from_flag = 'tkl';
UPDATE bb_users SET user_from_flag = '776' WHERE user_from_flag = 'ton';
UPDATE bb_users SET user_from_flag = '780' WHERE user_from_flag = 'tto';
UPDATE bb_users SET user_from_flag = '798' WHERE user_from_flag = 'tuv';
UPDATE bb_users SET user_from_flag = '788' WHERE user_from_flag = 'tun';
UPDATE bb_users SET user_from_flag = '795' WHERE user_from_flag = 'tkm';
UPDATE bb_users SET user_from_flag = '792' WHERE user_from_flag = 'tur';
UPDATE bb_users SET user_from_flag = '800' WHERE user_from_flag = 'uga';
UPDATE bb_users SET user_from_flag = '860' WHERE user_from_flag = 'uzb';
UPDATE bb_users SET user_from_flag = '804' WHERE user_from_flag = 'ukr';
UPDATE bb_users SET user_from_flag = '858' WHERE user_from_flag = 'ury';
UPDATE bb_users SET user_from_flag = '234' WHERE user_from_flag = 'fro';
UPDATE bb_users SET user_from_flag = '583' WHERE user_from_flag = 'fsm';
UPDATE bb_users SET user_from_flag = '242' WHERE user_from_flag = 'fji';
UPDATE bb_users SET user_from_flag = '608' WHERE user_from_flag = 'phl';
UPDATE bb_users SET user_from_flag = '246' WHERE user_from_flag = 'fin';
UPDATE bb_users SET user_from_flag = '238' WHERE user_from_flag = 'flk';
UPDATE bb_users SET user_from_flag = '250' WHERE user_from_flag = 'fra';
UPDATE bb_users SET user_from_flag = '254' WHERE user_from_flag = 'guf';
UPDATE bb_users SET user_from_flag = '258' WHERE user_from_flag = 'pyf';
UPDATE bb_users SET user_from_flag = '260' WHERE user_from_flag = 'atf';
UPDATE bb_users SET user_from_flag = '191' WHERE user_from_flag = 'hrv';
UPDATE bb_users SET user_from_flag = '140' WHERE user_from_flag = 'caf';
UPDATE bb_users SET user_from_flag = '148' WHERE user_from_flag = 'tcd';
UPDATE bb_users SET user_from_flag = '499' WHERE user_from_flag = 'mne';
UPDATE bb_users SET user_from_flag = '203' WHERE user_from_flag = 'cze';
UPDATE bb_users SET user_from_flag = '152' WHERE user_from_flag = 'chl';
UPDATE bb_users SET user_from_flag = '756' WHERE user_from_flag = 'che';
UPDATE bb_users SET user_from_flag = '752' WHERE user_from_flag = 'swe';
UPDATE bb_users SET user_from_flag = '144' WHERE user_from_flag = 'lka';
UPDATE bb_users SET user_from_flag = '218' WHERE user_from_flag = 'ecu';
UPDATE bb_users SET user_from_flag = '226' WHERE user_from_flag = 'gnq';
UPDATE bb_users SET user_from_flag = '232' WHERE user_from_flag = 'eri';
UPDATE bb_users SET user_from_flag = '233' WHERE user_from_flag = 'est';
UPDATE bb_users SET user_from_flag = '231' WHERE user_from_flag = 'eth';
UPDATE bb_users SET user_from_flag = '710' WHERE user_from_flag = 'zaf';
UPDATE bb_users SET user_from_flag = '410' WHERE user_from_flag = 'kor';
UPDATE bb_users SET user_from_flag = '239' WHERE user_from_flag = 'sgs';
UPDATE bb_users SET user_from_flag = '388' WHERE user_from_flag = 'jam';
UPDATE bb_users SET user_from_flag = '392' WHERE user_from_flag = 'jpn';
UPDATE bb_users SET user_from_flag = '074' WHERE user_from_flag = 'bvt';
UPDATE bb_users SET user_from_flag = '574' WHERE user_from_flag = 'nfk';
UPDATE bb_users SET user_from_flag = '654' WHERE user_from_flag = 'shn';
UPDATE bb_users SET user_from_flag = '796' WHERE user_from_flag = 'tca';

ALTER TABLE `bb_users` CHANGE `user_from_flag` `user_from_flag` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;