forked from eduosi/district
-
Notifications
You must be signed in to change notification settings - Fork 1
/
CHANGES
528 lines (480 loc) · 31.3 KB
/
CHANGES
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
Changes 18.0
28 Apr 2020
更新数据详见：
http://xzqh.mca.gov.cn/description?dcpid=2019
http://www.mca.gov.cn/article/sj/xzqh/2020/2020/202003061536.html
Changes 17.0
01 Sep 2019
更新数据详见：
http://xzqh.mca.gov.cn/description?dcpid=2016
http://xzqh.mca.gov.cn/description?dcpid=2017
http://xzqh.mca.gov.cn/description?dcpid=2018
Changes 16.0
25 Jan 2019
*) 纠正”长子“的拼音
*) 那曲地区改名那曲市
*) 那曲地区那曲县改名那曲市色尼区
*) 修改那曲市所属区县行政编码及其排序
更新脚本：
UPDATE `district` SET `initial` = 'z' ,`initials` = 'zz' ,`pinyin` = 'zhangzi' WHERE `id` = '739';
UPDATE `district` SET `suffix` = '市' ,`code` = '540600' WHERE `id` = '425';
UPDATE `district` SET `name` = '色尼' ,`initial` = 's' ,`initials` = 'sn' ,`pinyin` = 'seni' ,`suffix` = '区' ,`code` = '540602' ,`order` = '1' WHERE `id` = '2895';
UPDATE `district` SET `code` = '540621' ,`order` = '2' WHERE `id` = '2896';
UPDATE `district` SET `code` = '540622' ,`order` = '3' WHERE `id` = '2897';
UPDATE `district` SET `code` = '540623' ,`order` = '4' WHERE `id` = '2898';
UPDATE `district` SET `code` = '540624' ,`order` = '5' WHERE `id` = '2899';
UPDATE `district` SET `code` = '540625' ,`order` = '6' WHERE `id` = '2900';
UPDATE `district` SET `code` = '540626' ,`order` = '7' WHERE `id` = '2901';
UPDATE `district` SET `code` = '540627' ,`order` = '8' WHERE `id` = '2902';
UPDATE `district` SET `code` = '540628' ,`order` = '9' WHERE `id` = '2903';
UPDATE `district` SET `code` = '540629' ,`order` = '10' WHERE `id` = '2904';
UPDATE `district` SET `code` = '540630' ,`order` = '11' WHERE `id` = '2894';
Changes 15.0
24 Jan 2019
*) 纠正”长“的拼音
更新脚本：
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cn' ,`pinyin` = 'changning' WHERE `id` = '72';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cs', `pinyin` = 'changshou' WHERE `id` = '101';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzhi' WHERE `id` = '139';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cc' ,`pinyin` = 'changchun' WHERE `id` = '173';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cs' ,`pinyin` = 'changsha' WHERE `id` = '307';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ca' ,`pinyin` = 'changan' WHERE `id` = '533';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzhi' WHERE `id` = '733';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzi' WHERE `id` = '739';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ch' ,`pinyin` = 'changhai' WHERE `id` = '944';
UPDATE `district` SET `initials` = 'gcl' ,`pinyin` = 'gongchangling' WHERE `id` = '997';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cb' ,`pinyin` = 'changbai' WHERE `id` = '1065';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cl' ,`pinyin` = 'changling' WHERE `id` = '1069';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cx' ,`pinyin` = 'changxing' WHERE `id` = '1362';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cf' ,`pinyin` = 'changfeng' WHERE `id` = '1411';
UPDATE `district` SET `initials` = 'tc' ,`pinyin` = 'tianchang' WHERE `id` = '1475';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cl' ,`pinyin` = 'changle' WHERE `id` = '1524';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ct' ,`pinyin` = 'changtai' WHERE `id` = '1565';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ct' ,`pinyin` = 'changting' WHERE `id` = '1582';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cq' ,`pinyin` = 'changqing' WHERE `id` = '1702';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cd' ,`pinyin` = 'changdao' WHERE `id` = '1740';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cy' ,`pinyin` = 'changyuan' WHERE `id` = '1905';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cg' ,`pinyin` = 'changge' WHERE `id` = '1929';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cy' ,`pinyin` = 'changyang' WHERE `id` = '2028';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cs' ,`pinyin` = 'changsha' WHERE `id` = '2097';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzhou' WHERE `id` = '2375';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cn' ,`pinyin` = 'changning' WHERE `id` = '2546';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cs' ,`pinyin` = 'changshun' WHERE `id` = '2712';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ca' ,`pinyin` = 'changan' WHERE `id` = '2927';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cw' ,`pinyin` = 'changwu' WHERE `id` = '2957';
UPDATE `district` SET `initials` = 'yc' ,`pinyin` = 'yanchang' WHERE `id` = '2974';
UPDATE `district` SET `initials` = 'zc' ,`pinyin` = 'zichang' WHERE `id` = '2976';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cc' ,`pinyin` = 'changcheng' WHERE `id` = '3035';
UPDATE `district` SET `initials` = 'yc' ,`pinyin` = 'yuanchang' WHERE `id` = '3487';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzhi' WHERE `id` = '3514';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cb' ,`pinyin` = 'changbin' WHERE `id` = '3549';
Changes 14.0
22 Jan 2019
*) 山东莱芜整体并入济南
更新脚本：
UPDATE `district` SET `name` = '莱芜' WHERE `id` = '1786';
UPDATE `district` SET `parent_id` = '255', `initials` = 'lw', `pinyin` = 'laiwu' WHERE `id` = '1786';
UPDATE `district` SET `parent_id` = '255' WHERE `id` = '1787';
DELETE FROM `district` WHERE `id` = '266';
Changes 13.0
17 Dec 2018
*) 漠河县更改为漠河市和行政代码
*）纠正“蚌埠”拼音
更新脚本：
UPDATE `district` SET `suffix` = '市' ,`code` = '232701' WHERE `id` = '1216';
UPDATE `district` SET `pinyin` = 'bengbu' WHERE `id` = '221';
Changes 12.0
16 Oct 2018
*）济南市济阳县更名为济阳区
*）纠正吕梁拼音
*）福州市长乐县更新为长乐区，并更新行政代码
*）更新哈密市巴里坤哈萨克自治县行政代码
*）更新厦门市错误拼音
*）删除北京市宣武区、崇文区
更新脚本：
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1704';
UPDATE `district` SET `pinyin` = 'lvliang' WHERE `id` = '146';
UPDATE `district` SET `suffix` = '区', `code` = 350112, `order` = 6 WHERE `id` = '1524';
UPDATE `district` SET `order` = '7' WHERE `id` = '1517';
UPDATE `district` SET `order` = '8' WHERE `id` = '1518';
UPDATE `district` SET `order` = '9' WHERE `id` = '1519';
UPDATE `district` SET `order` = '10' WHERE `id` = '1520';
UPDATE `district` SET `order` = '11' WHERE `id` = '1521';
UPDATE `district` SET `order` = '12' WHERE `id` = '1522';
UPDATE `district` SET `order` = '13' WHERE `id` = '1523';
UPDATE `district` SET `code` = '650521' WHERE `id` = '3198';
UPDATE `district` SET `initial` = 'x' ,`initials` = 'xm' ,`pinyin` = 'xiamen' WHERE `id` = '236';
DELETE FROM `district` WHERE `id` = '38';
DELETE FROM `district` WHERE `id` = '39';
Changes 11.0
*）纠正“都”拼音
Changes 10.0
01 Mar 2017
*) 更新若干城市数据
Changes 9.0
28 Apr 2015
*) 杭州市富阳市更名为杭州市富阳区
*) 更新杭州市下级行政区域排序
*) 西安市高陵县更名为西安市高陵区，行政代码更新为 610117
*) 更新西安市下级行政区域排序
*) 龙岩市永定县更名为龙岩市永定区，行政代码更新为 350803
*) 更新龙岩市下级行政区域排序，行政代码更新为 520403
*) 迪庆市香格里拉县更名为迪庆市香格里拉市
*) 南宁市武鸣县更名为南宁市武鸣区
*) 海东市平安县更名为海东市平安区
*) 更新海东市平乐都区行政代码为 630202
*) 三门峡市陕县更名为三门峡市陕州区
*) 更新三门峡市下级行政区域排序
*) 甘孜州康定县更名为甘孜州康定市，行政代码更新为 513301
*) 海南市县级市儋州市升级为地级市，行政代码更新为 460400
*) 吐鲁番地区更名为吐鲁番市
*) 吐鲁番地区吐鲁番市更名为吐鲁番市高昌区
*) 新疆维吾尔自治区设立直辖县级市可克达拉市
*) 林芝地区更名为林芝市
*) 林芝地区林芝市更名为林芝市巴宜区
*) 上饶市广丰县更名为上饶市广丰区
*) 更新上饶市下级行政区域排序
更新脚本：
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1328';
UPDATE `district` SET `order` = '10' WHERE `id` = '1328';
UPDATE `district` SET `order` = '11' WHERE `id` = '1326';
UPDATE `district` SET `order` = '12' WHERE `id` = '1327';
UPDATE `district` SET `suffix` = '区', `code` = '610117' WHERE `id` = '2931';
UPDATE `district` SET `order` = '10' WHERE `id` = '2931';
UPDATE `district` SET `order` = '11' WHERE `id` = '2928';
UPDATE `district` SET `order` = '12' WHERE `id` = '2929';
UPDATE `district` SET `order` = '13' WHERE `id` = '2930';
UPDATE `district` SET `suffix` = '区', `code` = '350803' WHERE `id` = '1583';
UPDATE `district` SET `order` = '2' WHERE `id` = '1583';
UPDATE `district` SET `order` = '3' WHERE `id` = '1582';
UPDATE `district` SET `suffix` = '区', `code` = '520403' WHERE `id` = '2657';
UPDATE `district` SET `suffix` = '市' WHERE `id` = '2837';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2340';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '3123';
UPDATE `district` SET `code` = '630202' WHERE `id` = '3122';
UPDATE `district` SET `name` = '陕州' ,`initials` = 'sz' ,`pinyin` = 'shanzhou' ,`suffix` = '区' WHERE `id` = '1937';
UPDATE `district` SET `order` = '3' WHERE `id` = '1936';
UPDATE `district` SET `order` = '2' WHERE `id` = '1937';
UPDATE `district` SET `suffix` = '市', `code` = '513301' WHERE `id` = '2593';
UPDATE `district` SET `code` = '460400' WHERE `id` = '361';
UPDATE `district` SET `suffix` = '市' WHERE `id` = '467';
UPDATE `district` SET `name` = '高昌' ,`initial` = 'g' ,`initials` = 'gc' ,`pinyin` = 'gaochang' ,`suffix` = '区' WHERE `id` = '3194';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `extra`, `suffix`, `code`, `area_code`, `order`) VALUES ('可克达拉', '31', 'k', 'kdkl', 'kedakela', '', '市', '659008', '0999', '22');
UPDATE `district` SET `suffix` = '市' ,`code` = '540400' WHERE `id` = '427';
UPDATE `district` SET `name` = '巴宜' ,`initial` = 'b' ,`initials` = 'by' ,`pinyin` = 'bayi' ,`code` = '540402' WHERE `id` = '2912';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1687';
UPDATE `district` SET `order` = '3' WHERE `id` = '1686';
UPDATE `district` SET `order` = '2' WHERE `id` = '1687';
Changes 8.0
13 Dec 2014
*) 撤销昌都地区，设立昌都市
*) 撤销原昌都地区昌都县，设立昌都市卡若区
*) 长春市九台市更名为九台区，行政代码更新为 220113
*) 更新长春市下级行政区域排序
*) 阳江市阳东县更名为阳东区
*) 眉山市彭山县更名为彭山区
*) 德州市陵县更名为陵城区，行政代码更新为 371403
*) 撤销石家庄市桥东区
*) 石家庄市藁城市更名为藁城县，更新行政代码为 130109
*) 石家庄市鹿泉市更名为鹿泉区，更新行政代码为 130110
*) 石家庄栾城县更名为栾城区，更新行政代码为 130111
*) 重排石家庄市下级行政区域顺序
*) 撤销开封市金明区
*) 重排开封市下级行政区域顺序
*) 更新云浮市云安区行政代码为 445302
*) 重排云浮市下级行政区域顺序
*) 十堰市郧县更名为郧阳区，行政代码更新为 420304
*) 重庆市璧山区行政代码更新为 500120
*) 重庆市铜梁区行政代码更新为 500151
*) 重排重庆市下级行政区域顺序
*) 南平市建阳区行政代码更新为 350703
*) 重排南平市下级行政区域顺序
*) 威海市文登区行政代码更新为 371003
*) 茂名市电白区行政代码更新为 440904
*) 广州市从化区行政代码更新为 440117
*) 广州市增城区行政代码更新为 440118
*) 重排广州市下级行政区域顺序
--- 以下感谢 @黄盛 同学纠正错误和提供信息
*) 修正福绵错误拼音和，增加行政代码
*) 吉林市蛟河市行政代码更新为 220281
*) 更新那曲地区双湖县行政代码为 542431
*) 更新嘉峪关市镜铁区行政代码为 620201
*) 更新白城市通榆县行政代码为 220822
*) 重排白城市下级行政区域排序
更新脚本：
UPDATE `district` SET `suffix` = '市' WHERE `id` = '422';
UPDATE `district` SET `name` = '卡若' , `initial` = 'k' , `initials` = 'kr' , `pinyin` = 'karuo' , `suffix` = '区' WHERE `id` = '2853';
UPDATE `district` SET `suffix` = '区' , `code` = '220113' , `order` = '7' WHERE `id` = '1032';
UPDATE `district` SET `order` = '8' WHERE `id` = '1031';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2311';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2538';
UPDATE `district` SET `name` = '陵城' , `initials` = 'lc' , `pinyin` = 'lingcheng' , `suffix` = '区' , `code` = '371403' WHERE `id` = '1801';
DELETE FROM `district` WHERE `id` = '534';
UPDATE `district` SET `suffix` = '区' , `code` = '130109' WHERE `id` = '552';
UPDATE `district` SET `suffix` = '区' , `code` = '130110' WHERE `id` = '555';
UPDATE `district` SET `suffix` = '区' , `code` = '130111' WHERE `id` = '541';
UPDATE `district` SET `order` = '2' WHERE `id` = '535';
UPDATE `district` SET `order` = '3' WHERE `id` = '536';
UPDATE `district` SET `order` = '4' WHERE `id` = '537';
UPDATE `district` SET `order` = '5' WHERE `id` = '538';
UPDATE `district` SET `order` = '6' WHERE `id` = '552';
UPDATE `district` SET `order` = '7' WHERE `id` = '555';
UPDATE `district` SET `order` = '8' WHERE `id` = '541';
UPDATE `district` SET `order` = '9' WHERE `id` = '539';
UPDATE `district` SET `order` = '10' WHERE `id` = '540';
UPDATE `district` SET `order` = '11' WHERE `id` = '542';
UPDATE `district` SET `order` = '12' WHERE `id` = '543';
UPDATE `district` SET `order` = '13' WHERE `id` = '544';
UPDATE `district` SET `order` = '14' WHERE `id` = '545';
UPDATE `district` SET `order` = '15' WHERE `id` = '546';
UPDATE `district` SET `order` = '16' WHERE `id` = '547';
UPDATE `district` SET `order` = '17' WHERE `id` = '548';
UPDATE `district` SET `order` = '18' WHERE `id` = '549';
UPDATE `district` SET `order` = '19' WHERE `id` = '550';
UPDATE `district` SET `order` = '20' WHERE `id` = '551';
UPDATE `district` SET `order` = '21' WHERE `id` = '553';
UPDATE `district` SET `order` = '22' WHERE `id` = '554';
DELETE FROM `district` WHERE `id` = '1851';
UPDATE `district` SET `order` = '5' WHERE `id` = '1855';
UPDATE `district` SET `order` = '6' WHERE `id` = '1852';
UPDATE `district` SET `order` = '7' WHERE `id` = '1853';
UPDATE `district` SET `order` = '8' WHERE `id` = '1854';
UPDATE `district` SET `order` = '9' WHERE `id` = '1856';
UPDATE `district` SET `code` = '445302' WHERE `id` = '2332';
UPDATE `district` SET `order` = '2' WHERE `id` = '2332';
UPDATE `district` SET `order` = '3' WHERE `id` = '2330';
UPDATE `district` SET `order` = '4' WHERE `id` = '2331';
UPDATE `district` SET `name` = '郧阳' , `initials` = 'yy' , `pinyin` = 'yunyang' , `suffix` = '区' , `code` = '420304' WHERE `id` = '2014';
UPDATE `district` SET `code` = '500120' WHERE `id` = '109';
UPDATE `district` SET `code` = '500151' WHERE `id` = '107';
UPDATE `district` SET `order` = '20' WHERE `id` = '109';
UPDATE `district` SET `order` = '22' WHERE `id` = '106';
UPDATE `district` SET `order` = '23' WHERE `id` = '108';
UPDATE `district` SET `code` = '350703' WHERE `id` = '1580';
UPDATE `district` SET `order` = '2' WHERE `id` = '1580';
UPDATE `district` SET `order` = '3' WHERE `id` = '1572';
UPDATE `district` SET `order` = '4' WHERE `id` = '1573';
UPDATE `district` SET `order` = '5' WHERE `id` = '1574';
UPDATE `district` SET `order` = '6' WHERE `id` = '1575';
UPDATE `district` SET `order` = '7' WHERE `id` = '1576';
UPDATE `district` SET `order` = '8' WHERE `id` = '1577';
UPDATE `district` SET `order` = '9' WHERE `id` = '1578';
UPDATE `district` SET `order` = '10' WHERE `id` = '1579';
UPDATE `district` SET `code` = '371003' WHERE `id` = '1779';
UPDATE `district` SET `code` = '440904' WHERE `id` = '2274';
UPDATE `district` SET `code` = '440117' WHERE `id` = '2224';
UPDATE `district` SET `code` = '440118' WHERE `id` = '2223';
UPDATE `district` SET `order` = '11' WHERE `id` = '2224';
UPDATE `district` SET `order` = '12' WHERE `id` = '2223';
UPDATE `district` SET `initials` = 'fm' , `pinyin` = 'fumian' , `code` = '450903' WHERE `id` = '3584';
UPDATE `district` SET `code` = '220281' WHERE `id` = '1040';
UPDATE `district` SET `code` = '542431' WHERE `id` = '2894';
UPDATE `district` SET `code` = '620201' WHERE `id` = '3034';
UPDATE `district` SET `code` = '220822' WHERE `id` = '1076';
UPDATE `district` SET `order` = '3' WHERE `id` = '1076';
UPDATE `district` SET `order` = '4' WHERE `id` = '1074';
UPDATE `district` SET `order` = '5' WHERE `id` = '1075';
Changes 7.0
14 Oct 2014
*) 删除河南省开封市开封县
*) 新增河南省开封市祥符区
*) 河南省开封市下级行政区重新排序
*) 云浮市云安县更名为云安区
*) 滨州市沾化县更名为沾化区
更新脚本：
UPDATE `district` SET `initial` = 'x' , `initials` = 'xf' , `suffix` = '区' , `code` = '410212' WHERE `id` = '1855';
UPDATE `district` SET `order` = '6' WHERE `id` = '1855';
UPDATE `district` SET `order` = '7' WHERE `id` = '1852';
UPDATE `district` SET `order` = '8' WHERE `id` = '1853';
UPDATE `district` SET `order` = '9' WHERE `id` = '1854';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2332';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1823';
Changes 6.0
24 Sep 2014
*) 删除石家庄市河东区
*) 石家庄市下级行政区重新排序
更新脚本：
DELETE FROM `district` WHERE `id` = '534';
UPDATE `district` SET `order` = `order` - 1 WHERE `parentid` = 125 AND `order` > 1;
Changes 5.1
15 Sep 2014
*) 修正错误的内蒙古行政区级别为：自治区
*) 修正错误的辽宁行政区级别为：省
更新脚本：
UPDATE `district` SET `suffix` = '自治区' WHERE `id` = '7';
UPDATE `district` SET `suffix` = '省' WHERE `id` = '8';
感谢：@wwb-dev( https://github.com/wwb-dev ) 对错误数据的纠正
Changes 5.0
11 Sep 2014
*) 更新三亚市下级行政区排序
*) 删除更新脚本中 SQL 中的库名
*) STANDARD 版和 SIMPLE 版保留行政代码
更新脚本：
UPDATE `district` SET `order` = '1' WHERE `id` = '3578';
UPDATE `district` SET `order` = '2' WHERE `id` = '3579';
UPDATE `district` SET `order` = '3' WHERE `id` = '3580';
UPDATE `district` SET `order` = '4' WHERE `id` = '3581';
Changes 4.0
09 Sep 2014
*) 临沂市苍山县更名为临沂市兰陵县
*) 山东省撤销县级文登市，设立威海市文登区
*) 新疆维吾尔族自治区新增县级双河市
*) 更新阿克苏区号
*) 更新新疆维吾尔族自治区北屯市行政代码
*) 更新新疆维吾尔族自治区铁门关市行政代码和区号
*) 更新新疆维吾尔族自治区数据
*) 修改喀什拼音 kashen 为 kashi
*) 删除茂名市茂港区
*) 茂名市电白县更新为茂名市电白区
*) 更新茂名市下辖行政区排序
*) 三亚市新增海棠、吉阳、天涯、崖州四区
*) 哈尔滨市双城市更名为双城区
*) 删除连云港市新浦区
*) 更新连云港市下辖行政区排序
*) 连云港市赣榆县更名为连云港市赣榆区
*) 南平市建阳市更名为南平市建阳区
*) 重庆市璧山县更名为重庆市璧山区
*) 重庆市铜梁县更名为重庆市铜梁区
*) 沈阳市东陵区更名为沈阳市浑南区
*) 日喀则地区更名日喀则市
*) 原日喀则地区日喀则市更名为日喀则市桑珠孜区
*) 伊犁哈萨克自治州新增县级市霍尔果斯市
*) 更新伊犁哈萨克自治州下级行政区域排序
*) 桂林市临桂县更名为临桂区
*) 广安市新增前锋区
*) 更新广安市区号
*) 更新广安市下辖行政区区号和排序
*) 达州市达县更名为达州市大川区
*) 潮州市潮安县更名为潮州市潮安区
*) 玉林市新增福绵区
*) 更新玉林市下辖行政区排序
*) 删除绍兴市绍兴县，新增绍兴市柯桥区
*) 绍兴市上虞市更名为上虞区，同时更新行政代码
*) 更新绍兴市下辖行政区排序
*) 删除潮州市梅县，新增梅州市梅县区
*) 赣州市南康市更名为赣州市南康区
*) 删除济宁市市中区
*) 删除济宁市兖州市，新增济宁市兖州区
*) 更新济宁市下辖区排序
*) 修正巴音郭楞蒙古自治州博湖县行政代码
更新脚本：
UPDATE `district` SET `name` = '兰陵' , `initial` = 'l' , `initials` = 'll' , `pinyin` = 'lanling' WHERE `id` = '1794';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1779';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `code`, `area_code`, `order`) VALUES ('双河', '31', 's', 'sh', 'shuanghe', '市', '659007', '0909', '21');
UPDATE `district` SET `area_code` = '0997' WHERE `id` = '474';
UPDATE `district` SET `code` = '659005' WHERE `id` = '466';
UPDATE `district` SET `code` = '659006' , `area_code` = '0996' WHERE `id` = '465';
UPDATE `district` SET `name` = '乌鲁木齐', `initial` = 'w', `initials` = 'wlmq', `pinyin` = 'wulumuqi', `code` = '650100', `code` = '0996 0991' WHERE `id` = '465';
UPDATE `district` SET `parentid` = 465 WHERE `parentid` = 467;
UPDATE `district` SET `name` = '克拉玛依', `initial` = 'k', `initials` = 'klmy', `pinyin` = 'kelamayi', `code` = '650200', `area_code` = '0990' WHERE `id` = '466';
UPDATE `district` SET `parentid` = 466 WHERE `parentid` = 468;
UPDATE `district` SET `name` = '吐鲁番', initial` = 't', `initials` = 'tlf', `pinyin` = 'tulufan', `suffix` = '地区', `code` = '652100', `area_code` = '0995' WHERE `id` = '467';
UPDATE `district` SET `parentid` = 467 WHERE `parentid` = 469;
UPDATE `district` SET `name` = '哈密', `initial` = 'h', `initials` = 'hm', `pinyin` = 'hami', `extra` = '回族', `suffix` = '地区', `code` = '652200', `area_code` = '0902' WHERE `id` = '468';
UPDATE `district` SET `parentid` = 468 WHERE `parentid` = 470;
UPDATE `district` SET `name` = '昌吉', `initial` = 'c', `initials` = 'cj', `pinyin` = 'changji', `suffix` = '自治州', `code` = '652300', `area_code` = '0994' WHERE `id` = '469';
UPDATE `district` SET `parentid` = 469 WHERE `parentid` = 471;
UPDATE `district` SET `name` = '博尔塔拉', `initial` = 'b', initials` = 'betl', `pinyin` = 'boertala', `extra` = '蒙古', `suffix` = '自治州', `code` = '652700', `area_code` = '0909' WHERE `id` = '470';
UPDATE `district` SET `parentid` = 470 WHERE `parentid` = 472;
UPDATE `district` SET `name` = '巴音郭楞', `initial` = 'b', `initials` = 'bygl', `pinyin` = 'bayinguoleng', `extra` = '蒙古', `suffix` = '自治州', `code` = '652800', `area_code` = '0996' WHERE `id` = '471';
UPDATE `district` SET `parentid` = 471 WHERE `parentid` = 473;
UPDATE `district` SET `name` = '阿克苏', `initial` = 'a', `initials` = 'aks', `pinyin` = 'akesu', `extra` = '柯尔克孜', `suffix` = '地区', `code` = '652900', `area_code` = '0997' WHERE `id` = '472';
UPDATE `district` SET `parentid` = 472 WHERE `parentid` = 474;
UPDATE `district` SET `name` = '克孜勒苏', `initial` = 'k', `initials` = 'kzls', `pinyin` = 'kezilesu', `suffix` = '自治州', `code` = '653000', `area_code` = '0908' WHERE `id` = '473';
UPDATE `district` SET `parentid` = 473 WHERE `parentid` = 475;
UPDATE `district` SET `name` = '喀什', `initial` = 'k', `initials` = 'ks', `pinyin` = 'kashi', `suffix` = '地区', `code` = '653100', `area_code` = '0998' WHERE `id` = '474';
UPDATE `district` SET `parentid` = 474 WHERE `parentid` = 476;
UPDATE `district` SET `name` = '和田', initial` = 'h', `initials` = 'ht', `pinyin` = 'hetian', `extra` = '哈萨克', `suffix` = '地区', `code` = '653200', `area_code` = '0903' WHERE `id` = '475';
UPDATE `district` SET `parentid` = 475 WHERE `parentid` = 477;
UPDATE `district` SET `name` = '伊犁', `initial` = 'y', `initials` = 'yl', `pinyin` = 'yili', `suffix` = '自治州', `code` = '654000', `area_code` = '0999' WHERE `id` = '476';
UPDATE `district` SET `parentid` = 476 WHERE `parentid` = 478;
UPDATE `district` SET `name` = '塔城', `initial` = 't', `initials` = 'tc', `pinyin` = 'tacheng', `suffix` = '地区', `code` = '654200', `area_code` = '0901' WHERE `id` = '477';
UPDATE `district` SET `parentid` = 477 WHERE `parentid` = 479;
UPDATE `district` SET `name` = '阿勒泰', `initial` = 'a', `initials` = 'alt', `pinyin` = 'aletai', `suffix` = '地区', `code` = '654300', `area_code` = '0906' WHERE `id` = '478';
UPDATE `district` SET `parentid` = 478 WHERE `parentid` = 480;
UPDATE `district` SET `name` = '石河子', `initial` = 's', `initials` = 'shz', `pinyin` = 'shihezi', `suffix` = '市', `code` = '659001', `area_code` = '0993' WHERE `id` = '479';
UPDATE `district` SET `name` = '阿拉尔', `initial` = 'a', `initials` = 'ale', `pinyin` = 'alaer', `suffix` = '市', `code` = '659002', `area_code` = '0997' WHERE `id` = '480';
UPDATE `district` SET `name` = '图木舒克', `initial` = 't', `initials` = 'tmsk', `pinyin` = 'tumushuke', `suffix` = '市', `code` = '659003', `area_code` = '0998' WHERE `id` = '481';
UPDATE `district` SET `name` = '五家渠', `initial` = 'w', `initials` = 'wjq', `pinyin` = 'wujiaqu', `suffix` = '市', `code` = '659004', `area_code` = '0994' WHERE `id` = '482';
UPDATE `district` SET `name` = '北屯', `initial` = 'b', `initials` = 'bt', `pinyin` = 'beitun', `suffix` = '市', `code` = '659005', `area_code` = '0906' WHERE `id` = '483';
UPDATE `district` SET `name` = '铁门关', `initial` = 't', `initials` = 'tmg', `pinyin` = 'tiemenguan', `suffix` = '市', `code` = '659006', `area_code` = '0996' WHERE `id` = '484';
DELETE FROM `district` WHERE `id` = '2273';
UPDATE `district` SET `suffix` = '区', `order` = '2' WHERE `id` = '2274';
UPDATE `district` SET `order` = '3' WHERE `id` = '2275';
UPDATE `district` SET `order` = '4' WHERE `id` = '2276';
UPDATE `district` SET `order` = '5' WHERE `id` = '2277';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`) VALUES ('海棠', '357', 'h', 'ht', 'haitang', '区', '0898');
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`) VALUES ('吉阳', '357', 'j', 'jy', 'jiyang', '区', '0898');
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`) VALUES ('天涯', '357', 't', 'ty', 'tianya', '区', '0898');
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`) VALUES ('崖州', '357', 'y', 'yz', 'yazhou', '区', '0898');
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1100';
DELETE FROM `district` WHERE `id` = '1271';
UPDATE `district` SET `order` = '2' WHERE `id` = '1272';
UPDATE `district` SET `order` = '3' WHERE `id` = '1273';
UPDATE `district` SET `order` = '4' WHERE `id` = '1274';
UPDATE `district` SET `order` = '5' WHERE `id` = '1275';
UPDATE `district` SET `order` = '6' WHERE `id` = '1276';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1273';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1580';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '109';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '107';
UPDATE `district` SET `name` = '浑南' , `initial` = 'h' , `initials` = 'hn' , `pinyin` = 'hunnan' WHERE `id` = '931';
UPDATE `district` SET `suffix` = '市' WHERE `id` = '424';
UPDATE `district` SET `name` = '桑珠孜' , `initial` = 's' , `initials` = 'szz' , `pinyin` = 'sangzhuzi' , `suffix` = '区' WHERE `id` = '2876';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `code`, `area_code`, `order`) VALUES ('霍尔果斯', '476', 'h', 'hegs', 'huoerguosi', '市', '654004', '0999', 3);
UPDATE `district` SET `order` = '4' WHERE `id` = '3255';
UPDATE `district` SET `order` = '5' WHERE `id` = '3256';
UPDATE `district` SET `order` = '6' WHERE `id` = '3257';
UPDATE `district` SET `order` = '7' WHERE `id` = '3258';
UPDATE `district` SET `order` = '8' WHERE `id` = '3259';
UPDATE `district` SET `order` = '9' WHERE `id` = '3260';
UPDATE `district` SET `order` = '10' WHERE `id` = '3261';
UPDATE `district` SET `order` = '11' WHERE `id` = '3262';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2362';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`, `order`) VALUES ('前锋', '388', 'q', 'qf', 'qianfeng', '区', '0826', '2');
UPDATE `district` SET `area_code` = '0826' WHERE `id` = '388';
UPDATE `district` SET `area_code` = '0826' WHERE `id` = '2552';
UPDATE `district` SET `area_code` = '0826' , `order` = '3' WHERE `id` = '2553';
UPDATE `district` SET `area_code` = '0826' , `order` = '4' WHERE `id` = '2554';
UPDATE `district` SET `area_code` = '0826' , `order` = '5' WHERE `id` = '2555';
UPDATE `district` SET `area_code` = '0826' , `order` = '6' WHERE `id` = '2556';
UPDATE `district` SET `name` = '达川' , `initials` = 'dc' , `pinyin` = 'dachuan' , `suffix` = '区' WHERE `id` = '2558';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2322';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `order`) VALUES ('福绵', '350', 'f', 'fj', 'fujin', '区', 2);
UPDATE `district` SET `order` = '3' WHERE `id` = '2398';
UPDATE `district` SET `order` = '4' WHERE `id` = '2399';
UPDATE `district` SET `order` = '5' WHERE `id` = '2400';
UPDATE `district` SET `order` = '6' WHERE `id` = '2401';
UPDATE `district` SET `order` = '7' WHERE `id` = '2402';
UPDATE `district` SET `name` = '柯桥' , `initial` = 'k' , `initials` = 'kq' , `pinyin` = 'keqiao' , `suffix` = '区' , `code` = '330603' WHERE `id` = '1365';
UPDATE `district` SET `suffix` = '区' , `code` = '330604' , `order` = '3' WHERE `id` = '1368';
UPDATE `district` SET `order` = '4' WHERE `id` = '1366';
UPDATE `district` SET `order` = '5' WHERE `id` = '1367';
UPDATE `district` SET `suffix` = '区' , `code` = '441403' WHERE `id` = '2292';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1650';
DELETE FROM `district` WHERE `id` = '1760';
UPDATE `district` SET `suffix` = '区' , `code` = '370812', `order` = 2 WHERE `id` = '1770';
UPDATE `district` SET `order` = '1' WHERE `id` = '1761';
UPDATE `district` SET `order` = '3' WHERE `id` = '1762';
UPDATE `district` SET `order` = '4' WHERE `id` = '1763';
UPDATE `district` SET `order` = '5' WHERE `id` = '1764';
UPDATE `district` SET `order` = '6' WHERE `id` = '1765';
UPDATE `district` SET `order` = '7' WHERE `id` = '1766';
UPDATE `district` SET `order` = '8' WHERE `id` = '1767';
UPDATE `district` SET `order` = '9' WHERE `id` = '1768';
UPDATE `district` SET `order` = '10' WHERE `id` = '1769';
UPDATE `district` SET `order` = '11' WHERE `id` = '1771';
UPDATE `district` SET `code` = '652829' WHERE `id` = '3219';
Changes 3.0
13 Feb 2014
*) 删除广州市萝岗区
*) 广州市从化市更名为广州市从化区
*) 广州市增城市更名为广州市增城区
更新脚本：
DELETE FROM `district` WHERE `id`='2222';
UPDATE `district` SET `suffix`='区' WHERE `id`='2223';
UPDATE `district` SET `suffix`='区' WHERE `id`='2224';
Changes 2.0.
*)
Changes 1.0
*) The first public version.