|
1
|
ALTER TABLE `lottery_agent_info`
|
|
2
|
ADD COLUMN `PUBLIC_KEY` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '代理标识' AFTER `UPDATE_TIME`;
|
|
3
|
ALTER TABLE `lottery_agent_info`
|
|
4
|
ADD COLUMN `AREA` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '地区' AFTER `PUBLIC_KEY`;
|
|
5
|
-- 环境1
|
|
6
|
update lottery_agent_info set AGENT_ID = 'ID000001' where id =1;
|
|
7
|
update lottery_agent_info set AGENT_ID = 'ID000002' where id =3;
|
|
8
|
update lottery_agent_info set AGENT_ID = 'ID000003' where id =9;
|
|
9
|
update lottery_agent_info set AGENT_ID = 'ID000004' where id =10;
|
|
10
|
update lottery_agent_info set AGENT_ID = 'ID000005' where id =11;
|
|
11
|
update lottery_agent_info set AGENT_ID = 'ID000006' where id =12;
|
|
12
|
update lottery_agent_info set AGENT_ID = 'ID000007' where id =13;
|
|
13
|
update lottery_agent_info set AGENT_ID = 'ID000008' where id =14;
|
|
14
|
update lottery_agent_info set AGENT_ID = 'ID000009' where id =15;
|
|
15
|
update lottery_agent_info set AGENT_ID = 'ID000010' where id =16;
|
|
16
|
update lottery_agent_info set AGENT_ID = 'ID000011' where id =17;
|
|
17
|
update lottery_agent_info set AGENT_ID = 'ID000012' where id =18;
|
|
18
|
update lottery_agent_info set AGENT_ID = 'ID000013' where id =19;
|
|
19
|
update lottery_agent_info set AGENT_ID = 'ID000014' where id =20;
|
|
20
|
update lottery_agent_info set AGENT_ID = 'ID000015' where id =21;
|
|
21
|
update lottery_agent_info set AGENT_ID = 'ID000016' where id =22;
|
|
22
|
update lottery_agent_info set AGENT_ID = 'ID000017' where id =23;
|
|
23
|
update lottery_agent_info set AGENT_ID = 'ID000018' where id =24;
|
|
24
|
update lottery_agent_info set AGENT_ID = 'ID000019' where id =25;
|
|
25
|
update lottery_agent_info set AGENT_ID = 'ID000020' where id =26;
|
|
26
|
update lottery_agent_info set AGENT_ID = 'ID000021' where id =27;
|
|
27
|
update lottery_agent_info set AGENT_ID = 'ID000022' where id =28;
|
|
28
|
update lottery_agent_info set AGENT_ID = 'ID000023' where id =29;
|
|
29
|
update lottery_agent_info set AGENT_ID = 'ID000024' where id =30;
|
|
30
|
update lottery_agent_info set AGENT_ID = 'ID000025' where id =31;
|
|
31
|
update lottery_agent_info set AGENT_ID = 'ID000026' where id =32;
|
|
32
|
update lottery_agent_info set AGENT_ID = 'ID000027' where id =33;
|
|
33
|
update lottery_agent_info set AGENT_ID = 'ID000028' where id =34;
|
|
34
|
update lottery_agent_info set AGENT_ID = 'ID000029' where id =35;
|
|
35
|
update lottery_agent_info set AGENT_ID = 'ID000030' where id =36;
|
|
36
|
update lottery_agent_info set AGENT_ID = 'ID000031' where id =37;
|
|
37
|
update lottery_agent_info set AGENT_ID = 'ID000032' where id =38;
|
|
38
|
update lottery_agent_info set AGENT_ID = 'ID000033' where id =39;
|
|
39
|
update lottery_agent_info set AGENT_ID = 'ID000034' where id =40;
|
|
40
|
update lottery_agent_info set AGENT_ID = 'ID000035' where id =41;
|
|
41
|
update lottery_agent_info set AGENT_ID = 'ID000036' where id =42;
|
|
42
|
update lottery_agent_info set AGENT_ID = 'ID000037' where id =43;
|
|
43
|
update lottery_agent_info set AGENT_ID = 'ID000038' where id =44;
|
|
44
|
update lottery_agent_info set AGENT_ID = 'ID000039' where id =45;
|
|
45
|
update lottery_agent_info set AGENT_ID = 'ID000040' where id =46;
|
|
46
|
update lottery_agent_info set AGENT_ID = 'ID000041' where id =47;
|
|
47
|
update lottery_agent_info set AGENT_ID = 'ID000042' where id =48;
|
|
48
|
update lottery_agent_info set AGENT_ID = 'ID000043' where id =49;
|
|
49
|
update lottery_agent_info set AGENT_ID = 'ID000044' where id =50;
|
|
50
|
update lottery_agent_info set AGENT_ID = 'ID000045' where id =51;
|
|
51
|
update lottery_agent_info set AGENT_ID = 'ID000046' where id =52;
|
|
52
|
update lottery_agent_info set AGENT_ID = 'ID000047' where id =53;
|
|
53
|
update lottery_agent_info set AGENT_ID = 'ID000048' where id =54;
|
|
54
|
update lottery_agent_info set AGENT_ID = 'ID000049' where id =55;
|
|
55
|
update lottery_agent_info set AGENT_ID = 'ID000050' where id =56;
|
|
56
|
update lottery_agent_info set AGENT_ID = 'ID000051' where id =57;
|
|
57
|
update lottery_agent_info set AGENT_ID = 'ID000052' where id =58;
|
|
58
|
update lottery_agent_info set AGENT_ID = 'ID000053' where id =59;
|
|
59
|
update lottery_agent_info set AGENT_ID = 'ID000054' where id =60;
|
|
60
|
update lottery_agent_info set AGENT_ID = 'ID000055' where id =61;
|
|
61
|
update lottery_agent_info set AGENT_ID = 'ID000056' where id =62;
|
|
62
|
update lottery_agent_info set AGENT_ID = 'ID000057' where id =63;
|
|
63
|
update lottery_agent_info set AGENT_ID = 'ID000058' where id =64;
|
|
64
|
update lottery_agent_info set AGENT_ID = 'ID000059' where id =65;
|
|
65
|
update lottery_agent_info set AGENT_ID = 'ID000060' where id =66;
|
|
66
|
update lottery_agent_info set AGENT_ID = 'ID000061' where id =67;
|
|
67
|
update lottery_agent_info set AGENT_ID = 'ID000062' where id =68;
|
|
68
|
update lottery_agent_info set AGENT_ID = 'ID000063' where id =69;
|
|
69
|
update lottery_agent_info set AGENT_ID = 'ID000064' where id =70;
|
|
70
|
update lottery_agent_info set AGENT_ID = 'ID000065' where id =71;
|
|
71
|
update lottery_agent_info set AGENT_ID = 'ID000066' where id =72;
|
|
72
|
update lottery_agent_info set AGENT_ID = 'ID000067' where id =73;
|
|
73
|
update lottery_agent_info set AGENT_ID = 'ID000068' where id =74;
|
|
74
|
update lottery_agent_info set AGENT_ID = 'ID000069' where id =40005;
|
|
75
|
update lottery_agent_info set AGENT_ID = 'ID000070' where id =150078;
|
|
76
|
update lottery_agent_info set AGENT_ID = 'ID000071' where id =210079;
|
|
77
|
|
|
78
|
-- 环境2
|
|
79
|
update lottery_agent_info set AGENT_ID = 'SID000001' where id =10000;
|
|
80
|
update lottery_agent_info set AGENT_ID = 'SID000002' where id =10011;
|
|
81
|
update lottery_agent_info set AGENT_ID = 'SID000003' where id =10012;
|
|
82
|
update lottery_agent_info set AGENT_ID = 'SID000004' where id =10013;
|
|
83
|
update lottery_agent_info set AGENT_ID = 'SID000005' where id =10014;
|
|
84
|
update lottery_agent_info set AGENT_ID = 'SID000006' where id =10015;
|
|
85
|
update lottery_agent_info set AGENT_ID = 'SID000007' where id =10016;
|
|
86
|
update lottery_agent_info set AGENT_ID = 'SID000008' where id =10017;
|
|
87
|
update lottery_agent_info set AGENT_ID = 'SID000009' where id =10018;
|
|
88
|
update lottery_agent_info set AGENT_ID = 'SID000010' where id =10019;
|
|
89
|
update lottery_agent_info set AGENT_ID = 'SID000011' where id =10020;
|
|
90
|
update lottery_agent_info set AGENT_ID = 'SID000042' where id =10023;
|
|
91
|
update lottery_agent_info set AGENT_ID = 'SID000043' where id =10024;
|
|
92
|
update lottery_agent_info set AGENT_ID = 'SID000044' where id =10025;
|
|
93
|
update lottery_agent_info set AGENT_ID = 'SID000045' where id =10026;
|
|
94
|
update lottery_agent_info set AGENT_ID = 'SID000046' where id =10027;
|
|
95
|
update lottery_agent_info set AGENT_ID = 'SID000047' where id =10028;
|
|
96
|
update lottery_agent_info set AGENT_ID = 'SID000048' where id =10029;
|
|
97
|
update lottery_agent_info set AGENT_ID = 'SID000049' where id =10030;
|
|
98
|
update lottery_agent_info set AGENT_ID = 'SID000050' where id =10031;
|
|
99
|
update lottery_agent_info set AGENT_ID = 'SID000051' where id =10032;
|
|
100
|
update lottery_agent_info set AGENT_ID = 'SID000052' where id =10033;
|
|
101
|
update lottery_agent_info set AGENT_ID = 'SID000053' where id =10034;
|
|
102
|
update lottery_agent_info set AGENT_ID = 'SID000054' where id =10035;
|
|
103
|
update lottery_agent_info set AGENT_ID = 'SID000055' where id =10036;
|
|
104
|
update lottery_agent_info set AGENT_ID = 'SID000056' where id =10037;
|
|
105
|
update lottery_agent_info set AGENT_ID = 'SID000057' where id =10038;
|
|
106
|
update lottery_agent_info set AGENT_ID = 'SID000058' where id =10039;
|
|
107
|
update lottery_agent_info set AGENT_ID = 'SID000059' where id =10040;
|
|
108
|
update lottery_agent_info set AGENT_ID = 'SID000060' where id =10041;
|
|
109
|
update lottery_agent_info set AGENT_ID = 'SID000061' where id =10042;
|
|
110
|
update lottery_agent_info set AGENT_ID = 'SID000062' where id =10043;
|
|
111
|
update lottery_agent_info set AGENT_ID = 'SID000063' where id =10044;
|
|
112
|
update lottery_agent_info set AGENT_ID = 'SID000012' where id =40002;
|
|
113
|
update lottery_agent_info set AGENT_ID = 'SID000013' where id =40003;
|
|
114
|
update lottery_agent_info set AGENT_ID = 'SID000014' where id =40004;
|
|
115
|
update lottery_agent_info set AGENT_ID = 'SID000015' where id =40005;
|
|
116
|
update lottery_agent_info set AGENT_ID = 'SID000016' where id =40006;
|
|
117
|
update lottery_agent_info set AGENT_ID = 'SID000017' where id =40007;
|
|
118
|
update lottery_agent_info set AGENT_ID = 'SID000018' where id =40008;
|
|
119
|
update lottery_agent_info set AGENT_ID = 'SID000019' where id =40009;
|
|
120
|
update lottery_agent_info set AGENT_ID = 'SID000020' where id =40010;
|
|
121
|
update lottery_agent_info set AGENT_ID = 'SID000021' where id =40011;
|
|
122
|
update lottery_agent_info set AGENT_ID = 'SID000022' where id =40012;
|
|
123
|
update lottery_agent_info set AGENT_ID = 'SID000023' where id =40013;
|
|
124
|
update lottery_agent_info set AGENT_ID = 'SID000024' where id =40014;
|
|
125
|
update lottery_agent_info set AGENT_ID = 'SID000025' where id =40015;
|
|
126
|
update lottery_agent_info set AGENT_ID = 'SID000026' where id =40016;
|
|
127
|
update lottery_agent_info set AGENT_ID = 'SID000027' where id =40017;
|
|
128
|
update lottery_agent_info set AGENT_ID = 'SID000028' where id =40018;
|
|
129
|
update lottery_agent_info set AGENT_ID = 'SID000029' where id =40019;
|
|
130
|
update lottery_agent_info set AGENT_ID = 'SID000030' where id =40020;
|
|
131
|
update lottery_agent_info set AGENT_ID = 'SID000031' where id =40021;
|
|
132
|
update lottery_agent_info set AGENT_ID = 'SID000032' where id =40022;
|
|
133
|
update lottery_agent_info set AGENT_ID = 'SID000033' where id =40023;
|
|
134
|
update lottery_agent_info set AGENT_ID = 'SID000034' where id =40024;
|
|
135
|
update lottery_agent_info set AGENT_ID = 'SID000035' where id =40025;
|
|
136
|
update lottery_agent_info set AGENT_ID = 'SID000036' where id =40026;
|
|
137
|
update lottery_agent_info set AGENT_ID = 'SID000037' where id =40027;
|
|
138
|
update lottery_agent_info set AGENT_ID = 'SID000038' where id =40028;
|
|
139
|
update lottery_agent_info set AGENT_ID = 'SID000039' where id =40029;
|
|
140
|
update lottery_agent_info set AGENT_ID = 'SID000040' where id =40030;
|
|
141
|
update lottery_agent_info set AGENT_ID = 'SID000041' where id =40031;
|
|
142
|
update lottery_agent_info set AGENT_ID = 'SID000064' where id =70000;
|
|
143
|
update lottery_agent_info set AGENT_ID = 'SID000065' where id =70001;
|
|
144
|
update lottery_agent_info set AGENT_ID = 'SID000066' where id =70002;
|
|
145
|
update lottery_agent_info set AGENT_ID = 'SID000067' where id =70003;
|
|
146
|
update lottery_agent_info set AGENT_ID = 'SID000068' where id =70004;
|
|
147
|
update lottery_agent_info set AGENT_ID = 'SID000069' where id =100000;
|
|
148
|
update lottery_agent_info set AGENT_ID = 'SID000070' where id =100001;
|
|
149
|
update lottery_agent_info set AGENT_ID = 'SID000071' where id =130000;
|
|
150
|
update lottery_agent_info set AGENT_ID = 'SID000072' where id =130001;
|
|
151
|
update lottery_agent_info set AGENT_ID = 'SID000073' where id =160000;
|
|
152
|
update lottery_agent_info set AGENT_ID = 'SID000074' where id =280000;
|
|
153
|
update lottery_agent_info set AGENT_ID = 'SID000075' where id =310000;
|
|
154
|
update lottery_agent_info set AGENT_ID = 'SID000076' where id =340000;
|
|
155
|
update lottery_agent_info set AGENT_ID = 'SID000077' where id =370000;
|
|
156
|
update lottery_agent_info set AGENT_ID = 'SID000078' where id =400000;
|
|
157
|
update lottery_agent_info set AGENT_ID = 'SID000079' where id =400001;
|
|
158
|
update lottery_agent_info set AGENT_ID = 'SID000080' where id =400002;
|
|
159
|
update lottery_agent_info set AGENT_ID = 'SID000081' where id =400003;
|
|
160
|
update lottery_agent_info set AGENT_ID = 'SID000082' where id =430000;
|
|
161
|
update lottery_agent_info set AGENT_ID = 'SID000083' where id =430001;
|