text: -- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
  --
  -- Host: localhost    Database: kerkr
  -- ------------------------------------------------------
  -- Server version	5.7.18-log
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `ke_citys`
  --
  
  DROP TABLE IF EXISTS `ke_citys`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `ke_citys` (
    `pid` int(11) DEFAULT NULL,
    `id` int(11) DEFAULT NULL,
    `name` text
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `ke_citys`
  --
  
  LOCK TABLES `ke_citys` WRITE;
  /*!40000 ALTER TABLE `ke_citys` DISABLE KEYS */;
  INSERT INTO `ke_citys` VALUES (0,1,'北京市'),(1,10,'北京'),(0,2,'上海市'),(2,21,'上海'),(0,3,'天津市'),(3,22,'天津'),(0,4,'重庆市'),(4,23,'重庆'),(4,230,'涪陵市'),(4,231,'万州市'),(4,232,'黔江市'),(0,5,'河北省'),(5,311,'石家庄'),(5,313,'张家口'),(5,314,'承德'),(5,335,'秦皇岛'),(5,315,'唐山'),(5,316,'廊坊'),(5,312,'保定'),(5,317,'沧州'),(5,318,'衡水'),(5,319,'邢台'),(5,310,'邯郸'),(0,6,'山西省'),(6,351,'太原'),(6,352,'大同'),(6,349,'朔州'),(6,353,'阳泉'),(6,355,'长治'),(6,356,'晋城'),(6,350,'忻州'),(6,358,'离石'),(6,354,'晋中'),(6,354,'榆次'),(6,357,'临汾'),(6,359,'运城'),(6,242,'吕梁'),(0,7,'内蒙古自治区'),(7,471,'呼和浩特'),(7,472,'包头'),(7,473,'乌海'),(7,476,'赤峰'),(7,470,'海拉尔'),(7,482,'乌兰浩特'),(7,475,'通辽'),(7,479,'锡林浩特'),(7,474,'集宁'),(7,477,'东胜'),(7,478,'临河'),(7,483,'阿拉善左旗'),(7,480,'巴彦淖尔'),(7,489,'鄂尔多斯'),(7,481,'呼伦贝尔'),(7,484,'乌兰察布'),(7,485,'锡林郭勒盟'),(7,486,'兴安盟'),(0,8,'辽宁省'),(8,24,'沈阳'),(8,421,'朝阳'),(8,418,'阜新'),(8,410,'铁岭'),(8,413,'抚顺'),(8,414,'本溪'),(8,419,'辽阳'),(8,412,'鞍山'),(8,415,'丹东'),(8,411,'大连'),(8,417,'营口'),(8,427,'盘锦'),(8,416,'锦州'),(8,429,'葫芦岛'),(0,9,'吉林省'),(9,431,'长春'),(9,436,'白城'),(9,438,'松原'),(9,432,'吉林'),(9,434,'四平'),(9,437,'辽源'),(9,435,'通化'),(9,439,'白山'),(9,433,'延吉'),(9,247,'延边州'),(0,10,'黑龙江省'),(10,451,'哈尔滨'),(10,452,'齐齐哈尔'),(10,456,'黑河'),(10,459,'大庆'),(10,458,'伊春'),(10,468,'鹤岗'),(10,454,'佳木斯'),(10,469,'双鸭山'),(10,464,'七台河'),(10,467,'鸡西'),(10,453,'牡丹江'),(10,455,'绥化'),(10,457,'加格达奇'),(10,285,'大兴安岭地区'),(0,11,'江苏省'),(11,25,'南京'),(11,512,'苏州'),(11,516,'徐州'),(11,518,'连云港'),(11,527,'宿迁'),(11,517,'淮安'),(11,515,'盐城'),(11,514,'扬州'),(11,523,'泰州'),(11,513,'南通'),(11,511,'镇江'),(11,519,'常州'),(11,510,'无锡'),(0,12,'浙江省'),(12,571,'杭州'),(12,572,'湖州'),(12,573,'嘉兴'),(12,580,'舟山'),(12,574,'宁波'),(12,575,'绍兴'),(12,579,'金华'),(12,576,'台州'),(12,577,'温州'),(12,578,'丽水'),(12,570,'衢州'),(0,13,'安徽省'),(13,551,'合肥'),(13,557,'宿州'),(13,561,'淮北'),(13,558,'阜阳'),(13,552,'蚌埠'),(13,554,'淮南'),(13,550,'滁州'),(13,555,'马鞍山'),(13,553,'芜湖'),(13,562,'铜陵'),(13,556,'安庆'),(13,559,'黄山'),(13,564,'六安'),(13,565,'巢湖'),(13,566,'贵池'),(13,563,'宣城'),(13,5581,'亳州'),(0,14,'福建省'),(14,591,'福州'),(14,599,'南平'),(14,598,'三明'),(14,594,'莆田'),(14,595,'泉州'),(14,592,'厦门'),(14,596,'漳州'),(14,597,'龙岩'),(14,593,'宁德'),(14,5930,'福安'),(14,5990,'邵武'),(14,5950,'石狮'),(14,5980,'永安'),(14,5991,'武夷山'),(14,5995,'福清'),(0,15,'江西省'),(15,791,'南昌'),(15,792,'九江'),(15,798,'景德镇'),(15,701,'鹰潭'),(15,790,'新余'),(15,799,'萍乡'),(15,797,'赣州'),(15,793,'上饶'),(15,794,'临川'),(15,795,'宜春'),(15,796,'吉安'),(15,7940,'抚州'),(0,16,'山东省'),(16,531,'济南'),(16,635,'聊城'),(16,534,'德州'),(16,546,'东营'),(16,533,'淄博'),(16,536,'潍坊'),(16,535,'烟台'),(16,631,'威海'),(16,532,'青岛'),(16,633,'日照'),(16,539,'临沂'),(16,632,'枣庄'),(16,537,'济宁'),(16,538,'泰安'),(16,634,'莱芜'),(16,543,'滨州'),(16,530,'菏泽'),(0,17,'河南省'),(17,371,'郑州'),(17,398,'三门峡'),(17,379,'洛阳'),(17,391,'焦作'),(17,373,'新乡'),(17,392,'鹤壁'),(17,372,'安阳'),(17,393,'濮阳'),(17,378,'开封'),(17,370,'商丘'),(17,374,'许昌'),(17,395,'漯河'),(17,375,'平顶山'),(17,377,'南阳'),(17,376,'信阳'),(17,3910,'济源'),(17,394,'周口'),(17,396,'驻马店'),(0,18,'湖北省'),(18,27,'武汉'),(18,719,'十堰'),(18,710,'襄樊'),(18,724,'荆门'),(18,712,'孝感'),(18,713,'黄冈'),(18,711,'鄂州'),(18,714,'黄石'),(18,715,'咸宁'),(18,716,'荆州'),(18,717,'宜昌'),(18,718,'恩施'),(18,722,'随州'),(18,728,'仙桃'),(18,7281,'潜江'),(18,7282,'天门'),(18,7221,'广水'),(0,19,'湖南省'),(19,731,'长沙'),(19,744,'张家界'),(19,736,'常德'),(19,730,'岳阳'),(19,733,'株洲'),(19,732,'湘潭'),(19,734,'衡阳'),(19,735,'郴州'),(19,746,'永州'),(19,739,'邵阳'),(19,745,'怀化'),(19,738,'娄底'),(19,743,'吉首'),(19,737,'益阳'),(0,20,'广东省'),(20,20,'广州'),(20,755,'深圳'),(20,763,'清远'),(20,751,'韶关'),(20,762,'河源'),(20,753,'梅州'),(20,768,'潮州'),(20,754,'汕头'),(20,663,'揭阳'),(20,660,'汕尾'),(20,752,'惠州'),(20,769,'东莞'),(20,756,'珠海'),(20,760,'中山'),(20,750,'江门'),(20,757,'佛山'),(20,668,'茂名'),(20,759,'湛江'),(20,662,'阳江'),(20,766,'云浮'),(20,758,'肇庆'),(0,21,'广西自治区'),(21,771,'南宁'),(21,773,'桂林'),(21,772,'柳州'),(21,774,'贺州'),(21,775,'玉林'),(21,777,'钦州'),(21,779,'北海'),(21,770,'防城港'),(21,776,'百色'),(21,778,'河池'),(21,7750,'贵港'),(21,7740,'梧州'),(21,7711,'崇左市'),(21,284,'来宾市'),(0,22,'海南省'),(22,898,'海口'),(22,899,'三亚'),(22,890,'儋州'),(22,8901,'琼海'),(22,8902,'文昌'),(22,8903,'万宁'),(22,8904,'五指山'),(22,8905,'东方'),(0,23,'四川省'),(23,28,'成都'),(23,839,'广元'),(23,816,'绵阳'),(23,838,'德阳'),(23,817,'南充'),(23,826,'广安'),(23,825,'遂宁'),(23,832,'内江'),(23,833,'乐山'),(23,813,'自贡'),(23,830,'泸州'),(23,831,'宜宾'),(23,812,'攀枝花'),(23,827,'巴中'),(23,818,'达州'),(23,8320,'资阳'),(23,835,'雅安'),(23,834,'西昌'),(23,837,'阿坝州'),(23,828,'眉山市'),(23,281,'凉山州'),(23,282,'甘孜州'),(0,24,'贵州省'),(24,851,'贵阳'),(24,858,'六盘水'),(24,852,'遵义'),(24,857,'毕节'),(24,856,'铜仁'),(24,853,'安顺'),(24,855,'凯里'),(24,854,'都匀'),(24,859,'兴义'),(24,243,'黔东南州'),(24,244,'黔南州'),(24,245,'黔西南州'),(0,25,'云南省'),(25,871,'昆明'),(25,874,'曲靖'),(25,877,'玉溪'),(25,888,'丽江'),(25,870,'昭通'),(25,879,'思茅'),(25,883,'临沧'),(25,875,'保山'),(25,692,'潞西'),(25,886,'泸水'),(25,887,'中甸'),(25,872,'大理'),(25,878,'楚雄'),(25,873,'个旧'),(25,876,'文山'),(25,691,'景洪'),(25,8730,'红河'),(25,286,'德宏州'),(25,287,'迪庆州'),(25,288,'西双版纳州'),(25,289,'怒江州'),(0,26,'西藏自治区'),(26,891,'拉萨'),(26,896,'那曲'),(26,895,'昌都'),(26,894,'林芝'),(26,893,'乃东'),(26,892,'日喀则'),(26,897,'噶尔'),(26,8971,'阿里地区'),(26,900,'山南地区'),(26,800,'樟木口岸'),(0,27,'陕西省'),(27,29,'西安'),(27,911,'延安'),(27,919,'铜川'),(27,913,'渭南'),(27,910,'咸阳'),(27,917,'宝鸡'),(27,916,'汉中'),(27,912,'榆林'),(27,914,'商洛'),(27,915,'安康'),(0,28,'甘肃省'),(28,931,'兰州'),(28,937,'嘉峪关'),(28,943,'白银'),(28,938,'天水'),(28,9370,'酒泉'),(28,936,'张掖'),(28,935,'金昌'),(28,934,'西峰'),(28,933,'平凉'),(28,932,'定西'),(28,939,'陇南'),(28,930,'临夏'),(28,9350,'武威'),(28,941,'甘南藏族'),(0,29,'宁夏自治区'),(29,951,'银川市'),(29,952,'石嘴山市'),(29,953,'吴忠市'),(29,954,'固原市'),(29,248,'中卫市'),(0,30,'青海省'),(30,971,'西宁'),(30,972,'平安'),(30,970,'海晏'),(30,974,'共和'),(30,973,'同仁'),(30,975,'玛沁'),(30,976,'玉树'),(30,977,'德令哈'),(30,236,'果洛藏族自治州'),(30,237,'海北藏族自治州'),(30,238,'海东地区'),(30,239,'海南藏族自治州'),(30,240,'海西蒙古族藏族自治州'),(30,241,'黄南藏族自治州'),(0,31,'新疆自治区'),(31,991,'乌鲁木齐'),(31,990,'克拉玛依'),(31,993,'石河子'),(31,998,'喀什'),(31,997,'阿克苏'),(31,903,'和田'),(31,995,'吐鲁番'),(31,902,'哈密'),(31,908,'阿图什'),(31,909,'博乐'),(31,994,'昌吉'),(31,996,'库尔勒'),(31,999,'伊犁'),(31,992,'奎屯'),(31,901,'塔城'),(31,906,'阿勒泰'),(31,904,'巴音郭楞蒙古自治州'),(31,905,'博尔塔拉蒙古自治州'),(31,907,'克孜勒苏柯尔克孜自治州'),(31,989,'伊犁哈萨克自治州'),(0,32,'香港'),(32,8520,'香港'),(0,33,'台湾'),(33,2,'台北');
  /*!40000 ALTER TABLE `ke_citys` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2018-08-17 11:52:08
  