-- MySQL dump 10.13 Distrib 5.7.19, for Linux (x86_64)
--
-- Host: localhost Database: db_address
-- ------------------------------------------------------
-- Server version 5.7.19
/*!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 `city`
--
DROP TABLE IF EXISTS `city`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`province_code` char(12) NOT NULL,
`city_code` char(12) NOT NULL,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_city_code` (`city_code`)
) ENGINE=InnoDB AUTO_INCREMENT=345 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `city`
--
LOCK TABLES `city` WRITE;
/*!40000 ALTER TABLE `city` DISABLE KEYS */;
INSERT INTO `city` VALUES (1,'110000000000','110100000000','市辖区'),(2,'120000000000','120100000000','市辖区'),(3,'130000000000','130100000000','石家庄市'),(4,'130000000000','130200000000','唐山市'),(5,'130000000000','130300000000','秦皇岛市'),(6,'130000000000','130400000000','邯郸市'),(7,'130000000000','130500000000','邢台市'),(8,'130000000000','130600000000','保定市'),(9,'130000000000','130700000000','张家口市'),(10,'130000000000','130800000000','承德市'),(11,'130000000000','130900000000','沧州市'),(12,'130000000000','131000000000','廊坊市'),(13,'130000000000','131100000000','衡水市'),(14,'130000000000','139000000000','省直辖县级行政区划'),(15,'140000000000','140100000000','太原市'),(16,'140000000000','140200000000','大同市'),(17,'140000000000','140300000000','阳泉市'),(18,'140000000000','140400000000','长治市'),(19,'140000000000','140500000000','晋城市'),(20,'140000000000','140600000000','朔州市'),(21,'140000000000','140700000000','晋中市'),(22,'140000000000','140800000000','运城市'),(23,'140000000000','140900000000','忻州市'),(24,'140000000000','141000000000','临汾市'),(25,'140000000000','141100000000','吕梁市'),(26,'150000000000','150100000000','呼和浩特市'),(27,'150000000000','150200000000','包头市'),(28,'150000000000','150300000000','乌海市'),(29,'150000000000','150400000000','赤峰市'),(30,'150000000000','150500000000','通辽市'),(31,'150000000000','150600000000','鄂尔多斯市'),(32,'150000000000','150700000000','呼伦贝尔市'),(33,'150000000000','150800000000','巴彦淖尔市'),(34,'150000000000','150900000000','乌兰察布市'),(35,'150000000000','152200000000','兴安盟'),(36,'150000000000','152500000000','锡林郭勒盟'),(37,'150000000000','152900000000','阿拉善盟'),(38,'210000000000','210100000000','沈阳市'),(39,'210000000000','210200000000','大连市'),(40,'210000000000','210300000000','鞍山市'),(41,'210000000000','210400000000','抚顺市'),(42,'210000000000','210500000000','本溪市'),(43,'210000000000','210600000000','丹东市'),(44,'210000000000','210700000000','锦州市'),(45,'210000000000','210800000000','营口市'),(46,'210000000000','210900000000','阜新市'),(47,'210000000000','211000000000','辽阳市'),(48,'210000000000','211100000000','盘锦市'),(49,'210000000000','211200000000','铁岭市'),(50,'210000000000','211300000000','朝阳市'),(51,'210000000000','211400000000','葫芦岛市'),(52,'220000000000','220100000000','长春市'),(53,'220000000000','220200000000','吉林市'),(54,'220000000000','220300000000','四平市'),(55,'220000000000','220400000000','辽源市'),(56,'220000000000','220500000000','通化市'),(57,'220000000000','220600000000','白山市'),(58,'220000000000','220700000000','松原市'),(59,'220000000000','220800000000','白城市'),(60,'220000000000','222400000000','延边朝鲜族自治州'),(61,'230000000000','230100000000','哈尔滨市'),(62,'230000000000','230200000000','齐齐哈尔市'),(63,'230000000000','230300000000','鸡西市'),(64,'230000000000','230400000000','鹤岗市'),(65,'230000000000','230500000000','双鸭山市'),(66,'230000000000','230600000000','大庆市'),(67,'230000000000','230700000000','伊春市'),(68,'230000000000','230800000000','佳木斯市'),(69,'230000000000','230900000000','七台河市'),(70,'230000000000','231000000000','牡丹江市'),(71,'230000000000','231100000000','黑河市'),(72,'230000000000','231200000000','绥化市'),(73,'230000000000','232700000000','大兴安岭地区'),(74,'310000000000','310100000000','市辖区'),(75,'320000000000','320100000000','南京市'),(76,'320000000000','320200000000','无锡市'),(77,'320000000000','320300000000','徐州市'),(78,'320000000000','320400000000','常州市'),(79,'320000000000','320500000000','苏州市'),(80,'320000000000','320600000000','南通市'),(81,'320000000000','320700000000','连云港市'),(82,'320000000000','320800000000','淮安市'),(83,'320000000000','320900000000','盐城市'),(84,'320000000000','321000000000','扬州市'),(85,'320000000000','321100000000','镇江市'),(86,'320000000000','321200000000','泰州市'),(87,'320000000000','321300000000','宿迁市'),(88,'330000000000','330100000000','杭州市'),(89,'330000000000','330200000000','宁波市'),(90,'330000000000','330300000000','温州市'),(91,'330000000000','330400000000','嘉兴市'),(92,'330000000000','330500000000','湖州市'),(93,'330000000000','330600000000','绍兴市'),(94,'330000000000','330700000000','金华市'),(95,'330000000000','330800000000','衢州市'),(96,'330000000000','330900000000','舟山市'),(97,'330000000000','331000000000','台州市'),(98,'330000000000','331100000000','丽水市'),(99,'340000000000','340100000000','合肥市'),(100,'340000000000','340200000000','芜湖市'),(101,'340000000000','340300000000','蚌埠市'),(102,'340000000000','340400000000','淮南市'),(103,'340000000000','340500000000','马鞍山市'),(104,'340000000000','340600000000','淮北市'),(105,'340000000000','340700000000','铜陵市'),(106,'340000000000','340800000000','安庆市'),(107,'340000000000','341000000000','黄山市'),(108,'340000000000','341100000000','滁州市'),(109,'340000000000','341200000000','阜阳市'),(110,'340000000000','341300000000','宿州市'),(111,'340000000000','341500000000','六安市'),(112,'340000000000','341600000000','亳州市'),(113,'340000000000','341700000000','池州市'),(114,'340000000000','341800000000','宣城市'),(115,'350000000000','350100000000','福州市'),(116,'350000000000','350200000000','厦门市'),(117,'350000000000','350300000000','莆田市'),(118,'350000000000','350400000000','三明市'),(119,'350000000000','350500000000','泉州市'),(120,'350000000000','350600000000','漳州市'),(121,'350000000000','350700000000','南平市'),(122,'350000000000','350800000000','龙岩市'),(123,'350000000000','350900000000','宁德市'),(124,'360000000000','360100000000','南昌市'),(125,'360000000000','360200000000','景德镇市'),(126,'360000000000','360300000000','萍乡市'),(127,'360000000000','360400000000','九江市'),(128,'360000000000','360500000000','新余市'),(129,'360000000000','360600000000','鹰潭市'),(130,'360000000000','360700000000','赣州市'),(131,'360000000000','360800000000','吉安市'),(132,'360000000000','360900000000','宜春市'),(133,'360000000000','361000000000','抚州市'),(134,'360000000000','361100000000','上饶市'),(135,'370000000000','370100000000','济南市'),(136,'370000000000','370200000000','青岛市'),(137,'370000000000