Project

General

Profile

功能 #756 » 折扣表修改.txt

伟航 林, 11/01/2024 01:58 AM

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