ALTER TABLE `lottery_agent_info` 
ADD COLUMN `PUBLIC_KEY` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '代理标识' AFTER `UPDATE_TIME`;
ALTER TABLE `lottery_agent_info` 
ADD COLUMN `AREA` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '地区' AFTER `PUBLIC_KEY`;
-- 环境1
update lottery_agent_info set AGENT_ID = 'ID000001' where id =1;
update lottery_agent_info set AGENT_ID = 'ID000002' where id =3;
update lottery_agent_info set AGENT_ID = 'ID000003' where id =9;
update lottery_agent_info set AGENT_ID = 'ID000004' where id =10;
update lottery_agent_info set AGENT_ID = 'ID000005' where id =11;
update lottery_agent_info set AGENT_ID = 'ID000006' where id =12;
update lottery_agent_info set AGENT_ID = 'ID000007' where id =13;
update lottery_agent_info set AGENT_ID = 'ID000008' where id =14;
update lottery_agent_info set AGENT_ID = 'ID000009' where id =15;
update lottery_agent_info set AGENT_ID = 'ID000010' where id =16;
update lottery_agent_info set AGENT_ID = 'ID000011' where id =17;
update lottery_agent_info set AGENT_ID = 'ID000012' where id =18;
update lottery_agent_info set AGENT_ID = 'ID000013' where id =19;
update lottery_agent_info set AGENT_ID = 'ID000014' where id =20;
update lottery_agent_info set AGENT_ID = 'ID000015' where id =21;
update lottery_agent_info set AGENT_ID = 'ID000016' where id =22;
update lottery_agent_info set AGENT_ID = 'ID000017' where id =23;
update lottery_agent_info set AGENT_ID = 'ID000018' where id =24;
update lottery_agent_info set AGENT_ID = 'ID000019' where id =25;
update lottery_agent_info set AGENT_ID = 'ID000020' where id =26;
update lottery_agent_info set AGENT_ID = 'ID000021' where id =27;
update lottery_agent_info set AGENT_ID = 'ID000022' where id =28;
update lottery_agent_info set AGENT_ID = 'ID000023' where id =29;
update lottery_agent_info set AGENT_ID = 'ID000024' where id =30;
update lottery_agent_info set AGENT_ID = 'ID000025' where id =31;
update lottery_agent_info set AGENT_ID = 'ID000026' where id =32;
update lottery_agent_info set AGENT_ID = 'ID000027' where id =33;
update lottery_agent_info set AGENT_ID = 'ID000028' where id =34;
update lottery_agent_info set AGENT_ID = 'ID000029' where id =35;
update lottery_agent_info set AGENT_ID = 'ID000030' where id =36;
update lottery_agent_info set AGENT_ID = 'ID000031' where id =37;
update lottery_agent_info set AGENT_ID = 'ID000032' where id =38;
update lottery_agent_info set AGENT_ID = 'ID000033' where id =39;
update lottery_agent_info set AGENT_ID = 'ID000034' where id =40;
update lottery_agent_info set AGENT_ID = 'ID000035' where id =41;
update lottery_agent_info set AGENT_ID = 'ID000036' where id =42;
update lottery_agent_info set AGENT_ID = 'ID000037' where id =43;
update lottery_agent_info set AGENT_ID = 'ID000038' where id =44;
update lottery_agent_info set AGENT_ID = 'ID000039' where id =45;
update lottery_agent_info set AGENT_ID = 'ID000040' where id =46;
update lottery_agent_info set AGENT_ID = 'ID000041' where id =47;
update lottery_agent_info set AGENT_ID = 'ID000042' where id =48;
update lottery_agent_info set AGENT_ID = 'ID000043' where id =49;
update lottery_agent_info set AGENT_ID = 'ID000044' where id =50;
update lottery_agent_info set AGENT_ID = 'ID000045' where id =51;
update lottery_agent_info set AGENT_ID = 'ID000046' where id =52;
update lottery_agent_info set AGENT_ID = 'ID000047' where id =53;
update lottery_agent_info set AGENT_ID = 'ID000048' where id =54;
update lottery_agent_info set AGENT_ID = 'ID000049' where id =55;
update lottery_agent_info set AGENT_ID = 'ID000050' where id =56;
update lottery_agent_info set AGENT_ID = 'ID000051' where id =57;
update lottery_agent_info set AGENT_ID = 'ID000052' where id =58;
update lottery_agent_info set AGENT_ID = 'ID000053' where id =59;
update lottery_agent_info set AGENT_ID = 'ID000054' where id =60;
update lottery_agent_info set AGENT_ID = 'ID000055' where id =61;
update lottery_agent_info set AGENT_ID = 'ID000056' where id =62;
update lottery_agent_info set AGENT_ID = 'ID000057' where id =63;
update lottery_agent_info set AGENT_ID = 'ID000058' where id =64;
update lottery_agent_info set AGENT_ID = 'ID000059' where id =65;
update lottery_agent_info set AGENT_ID = 'ID000060' where id =66;
update lottery_agent_info set AGENT_ID = 'ID000061' where id =67;
update lottery_agent_info set AGENT_ID = 'ID000062' where id =68;
update lottery_agent_info set AGENT_ID = 'ID000063' where id =69;
update lottery_agent_info set AGENT_ID = 'ID000064' where id =70;
update lottery_agent_info set AGENT_ID = 'ID000065' where id =71;
update lottery_agent_info set AGENT_ID = 'ID000066' where id =72;
update lottery_agent_info set AGENT_ID = 'ID000067' where id =73;
update lottery_agent_info set AGENT_ID = 'ID000068' where id =74;
update lottery_agent_info set AGENT_ID = 'ID000069' where id =40005;
update lottery_agent_info set AGENT_ID = 'ID000070' where id =150078;
update lottery_agent_info set AGENT_ID = 'ID000071' where id =210079;

-- 环境2
update lottery_agent_info set AGENT_ID = 'SID000001' where id =10000;
update lottery_agent_info set AGENT_ID = 'SID000002' where id =10011;
update lottery_agent_info set AGENT_ID = 'SID000003' where id =10012;
update lottery_agent_info set AGENT_ID = 'SID000004' where id =10013;
update lottery_agent_info set AGENT_ID = 'SID000005' where id =10014;
update lottery_agent_info set AGENT_ID = 'SID000006' where id =10015;
update lottery_agent_info set AGENT_ID = 'SID000007' where id =10016;
update lottery_agent_info set AGENT_ID = 'SID000008' where id =10017;
update lottery_agent_info set AGENT_ID = 'SID000009' where id =10018;
update lottery_agent_info set AGENT_ID = 'SID000010' where id =10019;
update lottery_agent_info set AGENT_ID = 'SID000011' where id =10020;
update lottery_agent_info set AGENT_ID = 'SID000042' where id =10023;
update lottery_agent_info set AGENT_ID = 'SID000043' where id =10024;
update lottery_agent_info set AGENT_ID = 'SID000044' where id =10025;
update lottery_agent_info set AGENT_ID = 'SID000045' where id =10026;
update lottery_agent_info set AGENT_ID = 'SID000046' where id =10027;
update lottery_agent_info set AGENT_ID = 'SID000047' where id =10028;
update lottery_agent_info set AGENT_ID = 'SID000048' where id =10029;
update lottery_agent_info set AGENT_ID = 'SID000049' where id =10030;
update lottery_agent_info set AGENT_ID = 'SID000050' where id =10031;
update lottery_agent_info set AGENT_ID = 'SID000051' where id =10032;
update lottery_agent_info set AGENT_ID = 'SID000052' where id =10033;
update lottery_agent_info set AGENT_ID = 'SID000053' where id =10034;
update lottery_agent_info set AGENT_ID = 'SID000054' where id =10035;
update lottery_agent_info set AGENT_ID = 'SID000055' where id =10036;
update lottery_agent_info set AGENT_ID = 'SID000056' where id =10037;
update lottery_agent_info set AGENT_ID = 'SID000057' where id =10038;
update lottery_agent_info set AGENT_ID = 'SID000058' where id =10039;
update lottery_agent_info set AGENT_ID = 'SID000059' where id =10040;
update lottery_agent_info set AGENT_ID = 'SID000060' where id =10041;
update lottery_agent_info set AGENT_ID = 'SID000061' where id =10042;
update lottery_agent_info set AGENT_ID = 'SID000062' where id =10043;
update lottery_agent_info set AGENT_ID = 'SID000063' where id =10044;
update lottery_agent_info set AGENT_ID = 'SID000012' where id =40002;
update lottery_agent_info set AGENT_ID = 'SID000013' where id =40003;
update lottery_agent_info set AGENT_ID = 'SID000014' where id =40004;
update lottery_agent_info set AGENT_ID = 'SID000015' where id =40005;
update lottery_agent_info set AGENT_ID = 'SID000016' where id =40006;
update lottery_agent_info set AGENT_ID = 'SID000017' where id =40007;
update lottery_agent_info set AGENT_ID = 'SID000018' where id =40008;
update lottery_agent_info set AGENT_ID = 'SID000019' where id =40009;
update lottery_agent_info set AGENT_ID = 'SID000020' where id =40010;
update lottery_agent_info set AGENT_ID = 'SID000021' where id =40011;
update lottery_agent_info set AGENT_ID = 'SID000022' where id =40012;
update lottery_agent_info set AGENT_ID = 'SID000023' where id =40013;
update lottery_agent_info set AGENT_ID = 'SID000024' where id =40014;
update lottery_agent_info set AGENT_ID = 'SID000025' where id =40015;
update lottery_agent_info set AGENT_ID = 'SID000026' where id =40016;
update lottery_agent_info set AGENT_ID = 'SID000027' where id =40017;
update lottery_agent_info set AGENT_ID = 'SID000028' where id =40018;
update lottery_agent_info set AGENT_ID = 'SID000029' where id =40019;
update lottery_agent_info set AGENT_ID = 'SID000030' where id =40020;
update lottery_agent_info set AGENT_ID = 'SID000031' where id =40021;
update lottery_agent_info set AGENT_ID = 'SID000032' where id =40022;
update lottery_agent_info set AGENT_ID = 'SID000033' where id =40023;
update lottery_agent_info set AGENT_ID = 'SID000034' where id =40024;
update lottery_agent_info set AGENT_ID = 'SID000035' where id =40025;
update lottery_agent_info set AGENT_ID = 'SID000036' where id =40026;
update lottery_agent_info set AGENT_ID = 'SID000037' where id =40027;
update lottery_agent_info set AGENT_ID = 'SID000038' where id =40028;
update lottery_agent_info set AGENT_ID = 'SID000039' where id =40029;
update lottery_agent_info set AGENT_ID = 'SID000040' where id =40030;
update lottery_agent_info set AGENT_ID = 'SID000041' where id =40031;
update lottery_agent_info set AGENT_ID = 'SID000064' where id =70000;
update lottery_agent_info set AGENT_ID = 'SID000065' where id =70001;
update lottery_agent_info set AGENT_ID = 'SID000066' where id =70002;
update lottery_agent_info set AGENT_ID = 'SID000067' where id =70003;
update lottery_agent_info set AGENT_ID = 'SID000068' where id =70004;
update lottery_agent_info set AGENT_ID = 'SID000069' where id =100000;
update lottery_agent_info set AGENT_ID = 'SID000070' where id =100001;
update lottery_agent_info set AGENT_ID = 'SID000071' where id =130000;
update lottery_agent_info set AGENT_ID = 'SID000072' where id =130001;
update lottery_agent_info set AGENT_ID = 'SID000073' where id =160000;
update lottery_agent_info set AGENT_ID = 'SID000074' where id =280000;
update lottery_agent_info set AGENT_ID = 'SID000075' where id =310000;
update lottery_agent_info set AGENT_ID = 'SID000076' where id =340000;
update lottery_agent_info set AGENT_ID = 'SID000077' where id =370000;
update lottery_agent_info set AGENT_ID = 'SID000078' where id =400000;
update lottery_agent_info set AGENT_ID = 'SID000079' where id =400001;
update lottery_agent_info set AGENT_ID = 'SID000080' where id =400002;
update lottery_agent_info set AGENT_ID = 'SID000081' where id =400003;
update lottery_agent_info set AGENT_ID = 'SID000082' where id =430000;
update lottery_agent_info set AGENT_ID = 'SID000083' where id =430001;