CREATE TABLE `a_place` (
`place_id` int(11) NOT NULL AUTO_INCREMENT,
`place_level` tinyint(1) NOT NULL COMMENT '地点等级：\n\n1： 国家\n\n2： 省/州\n\n3： 城市/区',
`country` varchar(50) NOT NULL,
`state` varchar(50) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`region` varchar(50) DEFAULT NULL,
`place_code` varchar(10) NOT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`place_id`),
UNIQUE KEY `place_id_UNIQUE` (`place_id`),
KEY `place_level_index` (`place_level`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='地址表';
INSERT INTO a_place (place_level, country, state, city, region, place_code) VALUES (1,"中国","","","","1"),(1,"阿尔巴尼亚","","","","ALB"),(1,"阿尔及利亚","","","","DZA"),(1,"阿富汗","","","","AFG"),(1,"阿根廷","","","","ARG"),(1,"阿拉伯联合酋长国","","","","ARE"),(1,"阿鲁巴","","","","ABW"),(1,"阿曼","","","","OMN"),(1,"阿塞拜疆","","","","AZE"),(1,"阿森松岛","","","","ASC"),(1,"埃及","","","","EGY"),(1,"埃塞俄比亚","","","","ETH"),(1,"爱尔兰","","","","IRL"),(1,"爱沙尼亚","","","","EST"),(1,"安道尔","","","","AND"),(1,"安哥拉","","","","AGO"),(1,"安圭拉","","","","AIA"),(1,"安提瓜岛和巴布达","","","","ATG"),(1,"澳大利亚","","","","AUS"),(1,"奥地利","","","","AUT"),(1,"奥兰群岛","","","","ALA"),(1,"巴巴多斯岛","","","","BRB"),(1,"巴布亚新几内亚","","","","PNG"),(1,"巴哈马","","","","BHS"),(1,"巴基斯坦","","","","PAK"),(1,"巴拉圭","","","","PRY"),(1,"巴勒斯坦","","","","PSE"),(1,"巴林","","","","BHR"),(1,"巴拿马","","","","PAN"),(1,"巴西","","","","BRA"),(1,"白俄罗斯","","","","BLR"),(1,"百慕大","","","","BMU"),(1,"保加利亚","","","","BGR"),(1,"北马里亚纳群岛","","","","MNP"),(1,"贝宁","","","","BEN"),(1,"比利时","","","","BEL"),(1,"冰岛","","","","ISL"),(1,"波多黎各","","","","PRI"),(1,"波兰","","","","POL"),(1,"玻利维亚","","","","BOL"),(1,"波斯尼亚和黑塞哥维那","","","","BIH"),(1,"博茨瓦纳","","","","BWA"),(1,"伯利兹","","","","BLZ"),(1,"不丹","","","","BTN"),(1,"布基纳法索","","","","BFA"),(1,"布隆迪","","","","BDI"),(1,"布韦岛","","","","BVT"),(1,"朝鲜","","","","PRK"),(1,"丹麦","","","","DNK"),(1,"德国","","","","DEU"),(1,"东帝汶","","","","TLS"),(1,"多哥","","","","TGO"),(1,"多米尼加","","","","DMA"),(1,"多米尼加共和国","","","","DOM"),(1,"俄罗斯","","","","RUS"),(1,"厄瓜多尔","","","","ECU"),(1,"厄立特里亚","","","","ERI"),(1,"法国","","","","FRA"),(1,"法罗群岛","","","","FRO"),(1,"法属波利尼西亚","","","","PYF"),(1,"法属圭亚那","","","","GUF"),(1,"法属南部领地","","","","ATF"),(1,"梵蒂冈","","","","VAT"),(1,"菲律宾","","","","PHL"),(1,"斐济","","","","FJI"),(1,"芬兰","","","","FIN"),(1,"佛得角","","","","CPV"),(1,"弗兰克群岛","","","","FLK"),(1,"冈比亚","","","","GMB"),(1,"刚果","","","","COG"),(1,"刚果民主共和国","","","","COD"),(1,"哥伦比亚","","","","COL"),(1,"哥斯达黎加","","","","CRI"),(1,"格恩西岛","","","","GGY"),(1,"格林纳达","","","","GRD"),(1,"格陵兰","","","","GRL"),(1,"古巴","","","","CUB"),(1,"瓜德罗普","","","","GLP"),(1,"关岛","","","","GUM"),(1,"圭亚那","","","","GUY"),(1,"哈萨克斯坦","","","","KAZ"),(1,"海地","","","","HTI"),(1,"韩国","","","","KOR"),(1,"荷兰","","","","NLD"),(1,"荷属安地列斯","","","","ANT"),(1,"赫德和麦克唐纳群岛","","","","HMD"),(1,"洪都拉斯","","","","HND"),(1,"基里巴斯","","","","KIR"),(1,"吉布提","","","","DJI"),(1,"吉尔吉斯斯坦","","","","KGZ"),(1,"几内亚","","","","GIN"),(1,"几内亚比绍","","","","GNB"),(1,"加拿大","","","","CAN"),(1,"加纳","","","","GHA"),(1,"加蓬","","","","GAB"),(1,"柬埔寨","","","","KHM"),(1,"捷克共和国","","","","CZE"),(1,"津巴布韦","","","","ZWE"),(1,"喀麦隆","","","","CMR"),(1,"卡塔尔","","","","QAT"),(1,"开曼群岛","","","","CYM"),(1,"科科斯群岛","","","","CCK"),(1,"科摩罗","","","","COM"),(1,"科特迪瓦","","","","CIV"),(1,"科威特","","","","KWT"),(1,"克罗地亚","","","","HRV"),(1,"肯尼亚","","","","KEN"),(1,"库克群岛","","","","COK"),(1,"拉脱维亚","","","","LVA"),(1,"莱索托","","","","LSO"),(1,"老挝","","","","LAO"),(1,"黎巴嫩","","","","LBN"),(1,"利比里亚","","","","LBR"),(1,"利比亚","","","","LBY"),(1,"立陶宛","","","","LTU"),(1,"列支敦士登","","","","LIE"),(1,"留尼旺岛","","","","REU"),(1,"卢森堡","","","","LUX"),(1,"卢旺达","","","","RWA"),(1,"罗马尼亚","","","","ROU"),(1,"马达加斯加","","","","MDG"),(1,"马尔代夫","","","","MDV"),(1,"马耳他","","","","MLT"),(1,"马拉维","","","","MWI"),(1,"马来西亚","","","","MYS"),(1,"马里","","","","MLI"),(1,"马其顿","","","","MKD"),(1,"马绍尔群岛","","","","MHL"),(1,"马提尼克","","","","MTQ"),(1,"马约特岛","","","","MYT"),(1,"曼岛","","","","IMN"),(1,"毛里求斯","","","","MUS"),(1,"毛里塔尼亚","","","","MRT"),(1,"美国","","","","USA"),(1,"美属萨摩亚","","","","ASM"),(1,"美属外岛","","","","UMI"),(1,"蒙古","","","","MNG"),(1,"蒙特塞拉特","","","","MSR"),(1,"孟加拉","","","","BGD"),(1,"密克罗尼西亚","","","","FSM"),(1,"秘鲁","","","","PER"),(1,"缅甸","","","","MMR"),(1,"摩尔多瓦","","","","MDA"),(1,"摩洛哥","","","","MAR"),(1,"摩纳哥","","","","MCO"),(1,"莫桑比克","","","","MOZ"),(1,"墨西哥","","","","MEX"),(1,"纳米比亚","","","","NAM"),(1,"南非","","","","ZAF"),(1,"南极洲","","","","ATA"),(1,"南乔治亚和南桑德威奇群岛","","","","SGS"),(1,"瑙鲁","","","","NRU"),(1,"尼泊尔","","","","NPL"),(1,"尼加拉瓜","","","","NIC"),(1,"尼日尔","","","","NER"),(1,"尼日利亚","","","","NGA"),(1,"纽埃","","","","NIU"),(1,"挪威","","","","NOR"),(1,"诺福克","","","","NFK"),(1,"帕劳群岛","","","","PLW"),(1,"皮特凯恩","","","","PCN"),(1,"葡萄牙","","","","PRT"),(1,"乔治亚","","","","GEO"),(1,"日本","","","","JPN"),(1,"瑞典","","","","SWE"),(1,"瑞士","","","","CHE"),(1,"萨尔瓦多","","","","SLV"),(1,"萨摩亚","","","","WSM"),(1,"塞尔维亚,黑山","","","","SCG"),(1,"塞拉利昂","","","","SLE"),(1,"塞内加尔","","","","SEN"),(1,"塞浦路斯","","","","CYP"),(1,"塞舌尔","","","","SYC"),(1,"沙特阿拉伯","","","","SAU"),(1,"圣诞岛","","","","CXR"),(1,"圣多美和普林西比","","","","STP"),(1,"圣赫勒拿","","","","SHN"),(1,"圣基茨和尼维斯","","","","KNA"),(1,"圣卢西亚","","","","LCA"),(1,"圣马力诺","","","","SMR"),(1,"圣皮埃尔和米克隆群岛","","","","SPM"),(1,"圣文森特和格林纳丁斯","","","","VCT"),(1,"斯里兰卡","","","","LKA"),(1,"斯洛伐克","","","","SVK"),(1,"斯洛文尼亚","","","","SVN"),(1,"斯瓦尔巴和扬马廷","","","","SJM"),(1,"斯威士兰","","","","SWZ"),(1,"苏丹","","","","SDN"),(1,"苏里南","","","","SUR"),(1,"所罗门群岛","","","","SLB"),(1,"索马里","","","","SOM"),(1,"塔吉克斯坦","","","","TJK"),(1,"泰国","","","","THA"),(1,"坦桑尼亚","","","","TZA"),(1,"汤加","","","","TON"),(1,"特克斯和凯克特斯群岛","","","","TCA"),(1,"特里斯坦达昆哈","","","","TAA"),(1,"特立尼达和多巴哥","","","","TTO"),(1,"突尼斯","","","","TUN"),(1,"图瓦卢","","","","TUV"),(1,"土耳其","","","","TUR"),(1,"土库曼斯坦","","","","TKM"),(1,"托克劳","","","","TKL"),(1,"瓦利斯和福图纳","","","","WLF"),(1,"瓦努阿图","","","","VUT"),(1,"危地马拉","","","","GTM"),(1,"维尔京群岛，美属","","","","VIR"),(1,"维尔京群岛，英属","","","","VGB"),(1,"委内瑞拉","","","","VEN"),(1,"文莱","","","","BRN"),(1,"乌干达","","","","UGA"),(1,"乌克兰","","","","UKR"),(1,"乌拉圭","","","","URY"),(1,"乌兹别克斯坦","","","","UZ
