fix_contact_address_owner.sql

国外的一套开源CRM

update address set address_owner_type = 'Contact' where address_id = 10040;
update address set address_owner_type = 'Contact' where address_id = 10051;
update address set address_owner_type = 'Contact' where address_id = 10052;
update address set address_owner_type = 'Contact' where address_id = 10057;
update address set address_owner_type = 'Contact' where address_id = 10059;
update address set address_owner_type = 'Contact' where address_id = 10094;
update address set address_owner_type = 'Contact' where address_id = 10100;
update address set address_owner_type = 'Contact' where address_id = 10123;
update address set address_owner_type = 'Contact' where address_id = 10125;
update address set address_owner_type = 'Contact' where address_id = 10130;
update address set address_owner_type = 'Contact' where address_id = 10151;
update address set address_owner_type = 'Contact' where address_id = 10152;
update address set address_owner_type = 'Contact' where address_id = 10162;
update address set address_owner_type = 'Contact' where address_id = 10163;
update address set address_owner_type = 'Contact' where address_id = 10170;
update address set address_owner_type = 'Contact' where address_id = 10180;
update address set address_owner_type = 'Contact' where address_id = 10182;
update address set address_owner_type = 'Contact' where address_id = 10183;
update address set address_owner_type = 'Contact' where address_id = 10184;
update address set address_owner_type = 'Contact' where address_id = 10185;
update address set address_owner_type = 'Contact' where address_id = 10187;
update address set address_owner_type = 'Contact' where address_id = 10188;
update address set address_owner_type = 'Contact' where address_id = 10189;
update address set address_owner_type = 'Contact' where address_id = 10196;
update address set address_owner_type = 'Contact' where address_id = 10197;
update address set address_owner_type = 'Contact' where address_id = 10198;
update address set address_owner_type = 'Contact' where address_id = 10202;
update address set address_owner_type = 'Contact' where address_id = 10203;
update address set address_owner_type = 'Contact' where address_id = 10204;
update address set address_owner_type = 'Contact' where address_id = 10210;
update address set address_owner_type = 'Contact' where address_id = 10212;
update address set address_owner_type = 'Contact' where address_id = 10213;
update address set address_owner_type = 'Contact' where address_id = 10229;
update address set address_owner_type = 'Contact' where address_id = 10231;
update address set address_owner_type = 'Contact' where address_id = 10235;
update address set address_owner_type = 'Contact' where address_id = 10240;
update address set address_owner_type = 'Contact' where address_id = 10250;
update address set address_owner_type = 'Contact' where address_id = 10262;
update address set address_owner_type = 'Contact' where address_id = 10271;
update address set address_owner_type = 'Contact' where address_id = 10272;
update address set address_owner_type = 'Contact' where address_id = 10273;
update address set address_owner_type = 'Contact' where address_id = 10277;
update address set address_owner_type = 'Contact' where address_id = 10281;
update address set address_owner_type = 'Contact' where address_id = 10284;
update address set address_owner_type = 'Contact' where address_id = 10285;
update address set address_owner_type = 'Contact' where address_id = 10286;
update address set address_owner_type = 'Contact' where address_id = 11178;
update address set address_owner_type = 'Contact' where address_id = 10323;
update address set address_owner_type = 'Contact' where address_id = 10334;
update address set address_owner_type = 'Contact' where address_id = 10347;
update address set address_owner_type = 'Contact' where address_id = 10376;
update address set address_owner_type = 'Contact' where address_id = 10387;
update address set address_owner_type = 'Contact' where address_id = 10395;
update address set address_owner_type = 'Contact' where address_id = 10411;
update address set address_owner_type = 'Contact' where address_id = 10415;
update address set address_owner_type = 'Contact' where address_id = 10472;
update address set address_owner_type = 'Contact' where address_id = 10485;
update address set address_owner_type = 'Contact' where address_id = 10490;
update address set address_owner_type = 'Contact' where address_id = 10495;
update address set address_owner_type = 'Contact' where address_id = 10504;
update address set address_owner_type = 'Contact' where address_id = 10508;
update address set address_owner_type = 'Contact' where address_id = 10511;
update address set address_owner_type = 'Contact' where address_id = 10513;
update address set address_owner_type = 'Contact' where address_id = 10520;
update address set address_owner_type = 'Contact' where address_id = 10538;
update address set address_owner_type = 'Contact' where address_id = 10544;
update address set address_owner_type = 'Contact' where address_id = 10545;
update address set address_owner_type = 'Contact' where address_id = 10561;
update address set address_owner_type = 'Contact' where address_id = 10562;
update address set address_owner_type = 'Contact' where address_id = 10574;
update address set address_owner_type = 'Contact' where address_id = 10577;
update address set address_owner_type = 'Contact' where address_id = 10605;
update address set address_owner_type = 'Contact' where address_id = 10606;
update address set address_owner_type = 'Contact' where address_id = 10607;
update address set address_owner_type = 'Contact' where address_id = 10611;
update address set address_owner_type = 'Contact' where address_id = 10632;
update address set address_owner_type = 'Contact' where address_id = 10634;
update address set address_owner_type = 'Contact' where address_id = 10636;
update address set address_owner_type = 'Contact' where address_id = 10652;
update address set address_owner_type = 'Contact' where address_id = 10657;
update address set address_owner_type = 'Contact' where address_id = 10664;
update address set address_owner_type = 'Contact' where address_id = 10666;
update address set address_owner_type = 'Contact' where address_id = 10667;
update address set address_owner_type = 'Contact' where address_id = 10668;
update address set address_owner_type = 'Contact' where address_id = 10671;
update address set address_owner_type = 'Contact' where address_id = 10674;
update address set address_owner_type = 'Contact' where address_id = 10676;
update address set address_owner_type = 'Contact' where address_id = 10677;
update address set address_owner_type = 'Contact' where address_id = 10679;
update address set address_owner_type = 'Contact' where address_id = 10684;
update address set address_owner_type = 'Contact' where address_id = 10686;
update address set address_owner_type = 'Contact' where address_id = 10688;
update address set address_owner_type = 'Contact' where address_id = 10690;
update address set address_owner_type = 'Contact' where address_id = 10693;
update address set address_owner_type = 'Contact' where address_id = 10694;
update address set address_owner_type = 'Contact' where address_id = 10696;
update address set address_owner_type = 'Contact' where address_id = 10697;
update address set address_owner_type = 'Contact' where address_id = 10699;
update address set address_owner_type = 'Contact' where address_id = 10701;
update address set address_owner_type = 'Contact' where address_id = 10702;
update address set address_owner_type = 'Contact' where address_id = 10706;
update address set address_owner_type = 'Contact' where address_id = 10709;
update address set address_owner_type = 'Contact' where address_id = 10711;
update address set address_owner_type = 'Contact' where address_id = 10716;
update address set address_owner_type = 'Contact' where address_id = 10720;
update address set address_owner_type = 'Contact' where address_id = 10725;
update address set address_owner_type = 'Contact' where address_id = 10726;
update address set address_owner_type = 'Contact' where address_id = 10731;
update address set address_owner_type = 'Contact' where address_id = 10734;
update address set address_owner_type = 'Contact' where address_id = 10737;
update address set address_owner_type = 'Contact' where address_id = 10739;
update address set address_owner_type = 'Contact' where address_id = 10743;
update address set address_owner_type = 'Contact' where address_id = 10748;
update address set address_owner_type = 'Contact' where address_id = 10751;
update address set address_owner_type = 'Contact' where address_id = 10752;
update address set address_owner_type = 'Contact' where address_id = 10767;
update address set address_owner_type = 'Contact' where address_id = 10775;
update address set address_owner_type = 'Contact' where address_id = 10780;
update address set address_owner_type = 'Contact' where address_id = 10781;
update address set address_owner_type = 'Contact' where address_id = 10783;
update address set address_owner_type = 'Contact' where address_id = 10788;
update address set address_owner_type = 'Contact' where address_id = 10790;
update address set address_owner_type = 'Contact' where address_id = 10791;
update address set address_owner_type = 'Contact' where address_id = 10792;
update address set address_owner_type = 'Contact' where address_id = 10795;
update address set address_owner_type = 'Contact' where address_id = 10796;
update address set address_owner_type = 'Contact' where address_id = 10804;
update address set address_owner_type = 'Contact' where address_id = 11023;
update address set address_owner_type = 'Contact' where address_id = 10836;
update address set address_owner_type = 'Contact' where address_id = 10842;
update address set address_owner_type = 'Contact' where address_id = 10843;
update address set address_owner_type = 'Contact' where address_id = 10861;
update address set address_owner_type = 'Contact' where address_id = 10864;
update address set address_owner_type = 'Contact' where address_id = 10871;
update address set address_owner_type = 'Contact' where address_id = 10873;
update address set address_owner_type = 'Contact' where address_id = 10878;
update address set address_owner_type = 'Contact' where address_id = 10886;
update address set address_owner_type = 'Contact' where address_id = 10889;
update address set address_owner_type = 'Contact' where address_id = 10890;
update address set address_owner_type = 'Contact' where address_id = 10891;
update address set address_owner_type = 'Contact' where address_id = 10895;
update address set address_owner_type = 'Contact' where address_id = 10897;
update address set address_owner_type = 'Contact' where address_id = 10899;
update address set address_owner_type = 'Contact' where address_id = 10900;
update address set address_owner_type = 'Contact' where address_id = 10901;
update address set address_owner_type = 'Contact' where address_id = 10911;
update address set address_owner_type = 'Contact' where address_id = 10912;
update address set address_owner_type = 'Contact' where address_id = 10915;
update address set address_owner_type = 'Contact' where address_id = 10920;
update address set address_owner_type = 'Contact' where address_id = 10921;
update address set address_owner_type = 'Contact' where address_id = 10923;
update address set address_owner_type = 'Contact' where address_id = 10926;
update address set address_owner_type = 'Contact' where address_id = 10929;
update address set address_owner_type = 'Contact' where address_id = 10930;