CHANGES

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.