YES8

-- 环境1

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000001' WHERE agent_id = 1 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000002' WHERE agent_id = 3 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000004' WHERE agent_id = 9 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000005' WHERE agent_id = 10 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000006' WHERE agent_id = 11 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000007' WHERE agent_id = 12 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000008' WHERE agent_id = 13 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000009' WHERE agent_id = 14 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000010' WHERE agent_id = 15 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000011' WHERE agent_id = 16 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000012' WHERE agent_id = 17 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000013' WHERE agent_id = 18 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000014' WHERE agent_id = 19 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000015' WHERE agent_id = 20 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000016' WHERE agent_id = 21 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000017' WHERE agent_id = 22 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000018' WHERE agent_id = 23 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000019' WHERE agent_id = 24 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000020' WHERE agent_id = 25 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000021' WHERE agent_id = 26 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000022' WHERE agent_id = 27 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000023' WHERE agent_id = 28 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000024' WHERE agent_id = 29 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000025' WHERE agent_id = 30 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000026' WHERE agent_id = 31 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000027' WHERE agent_id = 32 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000028' WHERE agent_id = 33 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000029' WHERE agent_id = 34 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000030' WHERE agent_id = 35 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000031' WHERE agent_id = 36 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000032' WHERE agent_id = 37 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000033' WHERE agent_id = 38 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000034' WHERE agent_id = 39 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000035' WHERE agent_id = 40 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000036' WHERE agent_id = 41 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000037' WHERE agent_id = 42 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000038' WHERE agent_id = 43 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000039' WHERE agent_id = 44 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000040' WHERE agent_id = 45 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000041' WHERE agent_id = 46 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000042' WHERE agent_id = 47 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000043' WHERE agent_id = 48 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000044' WHERE agent_id = 49 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000045' WHERE agent_id = 50 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000046' WHERE agent_id = 51 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000047' WHERE agent_id = 52 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000048' WHERE agent_id = 53 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000049' WHERE agent_id = 54 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000050' WHERE agent_id = 55 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000051' WHERE agent_id = 56 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000052' WHERE agent_id = 57 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000053' WHERE agent_id = 58 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000054' WHERE agent_id = 59 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000055' WHERE agent_id = 60 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000056' WHERE agent_id = 61 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000057' WHERE agent_id = 62 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000058' WHERE agent_id = 63 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000059' WHERE agent_id = 64 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000060' WHERE agent_id = 65 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000061' WHERE agent_id = 66 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000062' WHERE agent_id = 67 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000063' WHERE agent_id = 68 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000064' WHERE agent_id = 69 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000065' WHERE agent_id = 70 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000066' WHERE agent_id = 71 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000067' WHERE agent_id = 72 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000068' WHERE agent_id = 73 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000069' WHERE agent_id = 74 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000070' WHERE agent_id = 150078 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'ID000071' WHERE agent_id = 210079 ;

-- 环境2

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000001' WHERE agent_id = 10000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000002' WHERE agent_id = 10011;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000003' WHERE agent_id = 10012;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000004' WHERE agent_id = 10013;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000005' WHERE agent_id = 10014;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000006' WHERE agent_id = 10015 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000007' WHERE agent_id = 10016 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000008' WHERE agent_id = 10017 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000009' WHERE agent_id = 10018 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000010' WHERE agent_id = 10019 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000011' WHERE agent_id = 10020 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000042' WHERE agent_id = 10023 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000043' WHERE agent_id = 10024 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000044' WHERE agent_id = 10025 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000045' WHERE agent_id = 10026 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000046' WHERE agent_id = 10027 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000047' WHERE agent_id = 10028 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000048' WHERE agent_id = 10029 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000049' WHERE agent_id = 10030 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000050' WHERE agent_id = 10031 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000051' WHERE agent_id = 10032 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000052' WHERE agent_id = 10033 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000053' WHERE agent_id = 10034 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000054' WHERE agent_id = 10035 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000055' WHERE agent_id = 10036 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000056' WHERE agent_id = 10037 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000057' WHERE agent_id = 10038 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000058' WHERE agent_id = 10039 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000059' WHERE agent_id = 10040 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000060' WHERE agent_id = 10041 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000061' WHERE agent_id = 10042 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000062' WHERE agent_id = 10043 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000063' WHERE agent_id = 10044 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000012' WHERE agent_id = 40002 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000013' WHERE agent_id = 40003 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000014' WHERE agent_id = 40004 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000015' WHERE agent_id = 40005 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000016' WHERE agent_id = 40006 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000017' WHERE agent_id = 40007 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000018' WHERE agent_id = 40008 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000019' WHERE agent_id = 40009 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000020' WHERE agent_id = 40010 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000021' WHERE agent_id = 40011 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000022' WHERE agent_id = 40012 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000023' WHERE agent_id = 40013 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000024' WHERE agent_id = 40014 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000025' WHERE agent_id = 40015 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000026' WHERE agent_id = 40016 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000027' WHERE agent_id = 40017 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000028' WHERE agent_id = 40018 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000029' WHERE agent_id = 40019 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000030' WHERE agent_id = 40020 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000031' WHERE agent_id = 40021 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000032' WHERE agent_id = 40022 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000033' WHERE agent_id = 40023 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000034' WHERE agent_id = 40024 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000035' WHERE agent_id = 40025 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000036' WHERE agent_id = 40026 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000037' WHERE agent_id = 40027 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000038' WHERE agent_id = 40028 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000039' WHERE agent_id = 40029 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000040' WHERE agent_id = 40030 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000041' WHERE agent_id = 40031 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000064' WHERE agent_id = 70000 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000065' WHERE agent_id = 70001 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000066' WHERE agent_id = 70002 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000067' WHERE agent_id = 70003 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000068' WHERE agent_id = 70004 ;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000069' WHERE agent_id = 100000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000070' WHERE agent_id = 100001;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000071' WHERE agent_id = 130000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000072' WHERE agent_id = 130001;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000073' WHERE agent_id = 160000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000074' WHERE agent_id = 280000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000075' WHERE agent_id = 310000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000076' WHERE agent_id = 340000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000077' WHERE agent_id = 370000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000078' WHERE agent_id = 400000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000079' WHERE agent_id = 400001;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000080' WHERE agent_id = 400002;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000081' WHERE agent_id = 400003;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000082' WHERE agent_id = 430000;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000083' WHERE agent_id = 430001;

UPDATE `tbl-master-referral-bonus` SET agent_name = 'SID000084' WHERE agent_id = 460000;