DRF实战1 - 环境搭建

1 - 项目环境搭建

1、前端代码的运行

进入meiduo_mall_admin文件目录下，执行如下指令

npm run dev

出现如下图所示，表示运行成功：

2、后端代码的运行

1、导入虚拟环境文件

pip install -r requeriments.txt
# requirements.txt 可以通过pip freeze来生成

2、进入数据库创建meiduo数据库

mysql -uroot -p 

create database meiduo charset=utf8;

3、导入数据

 mysql -uroot -p meiduo < dump.sql
 # dump.sql文件如下图说示，可以复制粘贴到dump.txt文件，然后改成sql后缀

-- MySQL dump 10.13  Distrib 5.7.25, for macos10.14 (x86_64)
--
-- Host: localhost    Database: meiduo
-- ------------------------------------------------------
-- Server version	5.7.25

/*!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 `auth_group`
--

DROP TABLE IF EXISTS `auth_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_group`
--

LOCK TABLES `auth_group` WRITE;
/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
INSERT INTO `auth_group` VALUES (4,'会员'),(6,'匿名用户'),(5,'普通会员'),(3,'管理员');
/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth_group_permissions`
--

DROP TABLE IF EXISTS `auth_group_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_group_permissions`
--

LOCK TABLES `auth_group_permissions` WRITE;
/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
INSERT INTO `auth_group_permissions` VALUES (5,3,1),(6,6,6),(7,6,22);
/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth_permission`
--

DROP TABLE IF EXISTS `auth_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_permission`
--

LOCK TABLES `auth_permission` WRITE;
/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can add permission',2,'add_permission'),(5,'Can change permission',2,'change_permission'),(6,'Can delete permission',2,'delete_permission'),(7,'Can add group',3,'add_group'),(8,'Can change group',3,'change_group'),(9,'Can delete group',3,'delete_group'),(10,'Can add content type',4,'add_contenttype'),(11,'Can change content type',4,'change_contenttype'),(12,'Can delete content type',4,'delete_contenttype'),(13,'Can add session',5,'add_session'),(14,'Can change session',5,'change_session'),(15,'Can delete session',5,'delete_session'),(16,'Can add user',6,'add_user'),(17,'Can change user',6,'change_user'),(18,'Can delete user',6,'delete_user'),(19,'Can add address',7,'add_address'),(20,'Can change address',7,'change_address'),(21,'Can delete address',7,'delete_address'),(22,'Can add 广告内容',8,'add_content'),(23,'Can change 广告内容',8,'change_content'),(24,'Can delete 广告内容',8,'delete_content'),(25,'Can add 广告内容类别',9,'add_contentcategory'),(26,'Can change 广告内容类别',9,'change_contentcategory'),(27,'Can delete 广告内容类别',9,'delete_contentcategory'),(28,'Can add QQ登录用户数据',10,'add_oauthqquser'),(29,'Can change QQ登录用户数据',10,'change_oauthqquser'),(30,'Can delete QQ登录用户数据',10,'delete_oauthqquser'),(31,'Can add area',11,'add_area'),(32,'Can change area',11,'change_area'),(33,'Can delete area',11,'delete_area'),(34,'Can add 品牌',12,'add_brand'),(35,'Can change 品牌',12,'change_brand'),(36,'Can delete 品牌',12,'delete_brand'),(37,'Can add 商品类别',13,'add_goodscategory'),(38,'Can change 商品类别',13,'change_goodscategory'),(39,'Can delete 商品类别',13,'delete_goodscategory'),(40,'Can add 商品频道',14,'add_goodschannel'),(41,'Can change 商品频道',14,'change_goodschannel'),(42,'Can delete 商品频道',14,'delete_goodschannel'),(43,'Can add 商品频道组',15,'add_goodschannelgroup'),(44,'Can change 商品频道组',15,'change_goodschannelgroup'),(45,'Can delete 商品频道组',15,'delete_goodschannelgroup'),(46,'Can add 商品SKU',16,'add_sku'),(47,'Can change 商品SKU',16,'change_sku'),(48,'Can delete 商品SKU',16,'delete_sku'),(49,'Can add SKU图片',17,'add_skuimage'),(50,'Can change SKU图片',17,'change_skuimage'),(51,'Can delete SKU图片',17,'delete_skuimage'),(52,'Can add SKU规格',18,'add_skuspecification'),(53,'Can change SKU规格',18,'change_skuspecification'),(54,'Can delete SKU规格',18,'delete_skuspecification'),(55,'Can add 规格选项',19,'add_specificationoption'),(56,'Can change 规格选项',19,'change_specificationoption'),(57,'Can delete 规格选项',19,'delete_specificationoption'),(58,'Can add 商品SPU',20,'add_spu'),(59,'Can change 商品SPU',20,'change_spu'),(60,'Can delete 商品SPU',20,'delete_spu'),(61,'Can add 商品SPU规格',21,'add_spuspecification'),(62,'Can change 商品SPU规格',21,'change_spuspecification'),(63,'Can delete 商品SPU规格',21,'delete_spuspecification'),(64,'Can add 统计分类商品访问量',22,'add_goodsvisitcount'),(65,'Can change 统计分类商品访问量',22,'change_goodsvisitcount'),(66,'Can delete 统计分类商品访问量',22,'delete_goodsvisitcount'),(67,'Can add 订单商品',23,'add_ordergoods'),(68,'Can change 订单商品',23,'change_ordergoods'),(69,'Can delete 订单商品',23,'delete_ordergoods'),(70,'Can add 订单基本信息',24,'add_orderinfo'),(71,'Can change 订单基本信息',24,'change_orderinfo'),(72,'Can delete 订单基本信息',24,'delete_orderinfo'),(73,'Can add 支付信息',25,'add_payment'),(74,'Can change 支付信息',25,'change_payment'),(75,'Can delete 支付信息',25,'delete_payment'),(76,'add 商品',20,'add_good');
/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_admin_log`
--

DROP TABLE IF EXISTS `django_admin_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_users_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_admin_log`
--

LOCK TABLES `django_admin_log` WRITE;
/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_content_type`
--

DROP TABLE IF EXISTS `django_content_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_content_type`
--

LOCK TABLES `django_content_type` WRITE;
/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(11,'areas','area'),(3,'auth','group'),(2,'auth','permission'),(8,'contents','content'),(9,'contents','contentcategory'),(4,'contenttypes','contenttype'),(12,'goods','brand'),(13,'goods','goodscategory'),(14,'goods','goodschannel'),(15,'goods','goodschannelgroup'),(22,'goods','goodsvisitcount'),(16,'goods','sku'),(17,'goods','skuimage'),(18,'goods','skuspecification'),(19,'goods','specificationoption'),(20,'goods','spu'),(21,'goods','spuspecification'),(10,'oauth','oauthqquser'),(23,'orders','ordergoods'),(24,'orders','orderinfo'),(25,'payments','payment'),(5,'sessions','session'),(7,'users','address'),(6,'users','user');
/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_migrations`
--

DROP TABLE IF EXISTS `django_migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_migrations`
--

LOCK TABLES `django_migrations` WRITE;
/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2019-04-06 11:38:11.517142'),(2,'contenttypes','0002_remove_content_type_name','2019-04-06 11:38:11.567693'),(3,'auth','0001_initial','2019-04-06 11:38:11.694113'),(4,'auth','0002_alter_permission_name_max_length','2019-04-06 11:38:11.724901'),(5,'auth','0003_alter_user_email_max_length','2019-04-06 11:38:11.731991'),(6,'auth','0004_alter_user_username_opts','2019-04-06 11:38:11.746795'),(7,'auth','0005_alter_user_last_login_null','2019-04-06 11:38:11.757953'),(8,'auth','0006_require_contenttypes_0002','2019-04-06 11:38:11.760667'),(9,'auth','0007_alter_validators_add_error_messages','2019-04-06 11:38:11.769652'),(10,'auth','0008_alter_user_username_max_length','2019-04-06 11:38:11.775247'),(11,'users','0001_initial','2019-04-06 11:38:11.917175'),(12,'admin','0001_initial','2019-04-06 11:38:11.976149'),(13,'admin','0002_logentry_remove_auto_add','2019-04-06 11:38:11.996889'),(14,'areas','0001_initial','2019-04-06 11:38:12.030922'),(15,'contents','0001_initial','2019-04-06 11:38:12.115485'),(16,'goods','0001_initial','2019-04-06 11:38:12.709076'),(17,'goods','0002_auto_20190327_0415','2019-04-06 11:38:12.853612'),(18,'oauth','0001_initial','2019-04-06 11:38:12.915762'),(19,'users','0002_user_email_active','2019-04-06 11:38:12.958620'),(20,'users','0003_auto_20190322_0204','2019-04-06 11:38:13.118972'),(21,'users','0004_address_title','2019-04-06 11:38:13.157362'),(22,'users','0005_address_is_delete','2019-04-06 11:38:13.196418'),(23,'orders','0001_initial','2019-04-06 11:38:13.384174'),(24,'orders','0002_auto_20190403_0121','2019-04-06 11:38:13.449250'),(25,'payments','0001_initial','2019-04-06 11:38:13.515386'),(26,'sessions','0001_initial','2019-04-06 11:38:13.551099');
/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_session`
--

DROP TABLE IF EXISTS `django_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_session`
--

LOCK TABLES `django_session` WRITE;
/*!40000 ALTER TABLE `django_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_addresses`
--

DROP TABLE IF EXISTS `tb_addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_addresses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `receiver` varchar(10) NOT NULL,
  `detail_address` varchar(100) NOT NULL,
  `mobile` varchar(11) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `city_id` int(11) NOT NULL,
  `district_id` int(11) NOT NULL,
  `province_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(10) DEFAULT NULL,
  `is_delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tb_addresses_city_id_e2af65db_fk_tb_areas_id` (`city_id`),
  KEY `tb_addresses_district_id_bbca7378_fk_tb_areas_id` (`district_id`),
  KEY `tb_addresses_province_id_5d351f50_fk_tb_areas_id` (`province_id`),
  KEY `tb_addresses_user_id_dc7b4119_fk_users_user_id` (`user_id`),
  CONSTRAINT `tb_addresses_city_id_e2af65db_fk_tb_areas_id` FOREIGN KEY (`city_id`) REFERENCES `tb_areas` (`id`),
  CONSTRAINT `tb_addresses_district_id_bbca7378_fk_tb_areas_id` FOREIGN KEY (`district_id`) REFERENCES `tb_areas` (`id`),
  CONSTRAINT `tb_addresses_province_id_5d351f50_fk_tb_areas_id` FOREIGN KEY (`province_id`) REFERENCES `tb_areas` (`id`),
  CONSTRAINT `tb_addresses_user_id_dc7b4119_fk_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_addresses`
--

LOCK TABLES `tb_addresses` WRITE;
/*!40000 ALTER TABLE `tb_addresses` DISABLE KEYS */;
INSERT INTO `tb_addresses` VALUES (1,'2019-04-06 12:25:15.770778','2019-04-06 12:25:15.770924','python','asdasd','13711111111','','',140400,140423,140000,1,'python',0);
/*!40000 ALTER TABLE `tb_addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_areas`
--

DROP TABLE IF EXISTS `tb_areas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_areas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tb_areas_parent_id_bae67575_fk_tb_areas_id` (`parent_id`),
  CONSTRAINT `tb_areas_parent_id_bae67575_fk_tb_areas_id` FOREIGN KEY (`parent_id`) REFERENCES `tb_areas` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=820001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_areas`
--

LOCK TABLES `tb_areas` WRITE;
/*!40000 ALTER TABLE `tb_areas` DISABLE KEYS */;
INSERT INTO `tb_areas` VALUES (110000,'北京市',NULL),(110100,'北京市',110000),(110101,'东城区',110100),(110102,'西城区',110100),(110105,'朝阳区',110100),(110106,'丰台区',110100),(110107,'石景山区',110100),(110108,'海淀区',110100),(110109,'门头沟区',110100),(110111,'房山区',110100),(110112,'通州区',110100),(110113,'顺义区',110100),(110114,'昌平区',110100),(110115,'大兴区',110100),(110116,'怀柔区',110100),(110117,'平谷区',110100),(110118,'密云区',110100),(110119,'延庆区',110100),(120000,'天津市',NULL),(120100,'天津市',120000),(120101,'和平区',120100),(120102,'河东区',120100),(120103,'河西区',120100),(120104,'南开区',120100),(120105,'河北区',120100),(120106,'红桥区',120100),(120110,'东丽区',120100),(120111,'西青区',120100),(120112,'津南区',120100),(120113,'北辰区',120100),(120114,'武清区',120100),(120115,'宝坻区',120100),(120116,'滨海新区',120100),(120117,'宁河区',120100),(120118,'静海区',120100),(120119,'蓟州区',120100),(130000,'河北省',NULL),(130100,'石家庄市',130000),(130102,'长安区',130100),(130104,'桥西区',130100),(130105,'新华区',130100),(130107,'井陉矿区',130100),(130108,'裕华区',130100),(130109,'藁城区',130100),(130110,'鹿泉区',130100),(130111,'栾城区',130100),(130121,'井陉县',130100),(130123,'正定县',130100),(130125,'行唐县',130100),(130126,'灵寿县',130100),(130127,'高邑县',130100),(130128,'深泽县',130100),(130129,'赞皇县',130100),(130130,'无极县',130100),(130131,'平山县',130100),(130132,'元氏县',130100),(130133,'赵县',130100),(130183,'晋州市',130100),(130184,'新乐市',130100),(130200,'唐山市',130000),(130202,'路南区',130200),(130203,'路北区',130200),(130204,'古冶区',130200),(130205,'开平区',130200),(130207,'丰南区',130200),(130208,'丰润区',130200),(130209,'曹妃甸区',130200),(130223,'滦县',130200),(130224,'滦南县',130200),(130225,'乐亭县',130200),(130227,'迁西县',130200),(130229,'玉田县',130200),(130281,'遵化市',130200),(130283,'迁安市',130200),(130300,'秦皇岛市',130000),(130302,'海港区',130300),(130303,'山海关区',130300),(130304,'北戴河区',130300),(130306,'抚宁区',130300),(130321,'青龙满族自治县',130300),(130322,'昌黎县',130300),(130324,'卢龙县',130300),(130400,'邯郸市',130000),(130402,'邯山区',130400),(130403,'丛台区',130400),(130404,'复兴区',130400),(130406,'峰峰矿区',130400),(130421,'邯郸县',130400),(130423,'临漳县',130400),(130424,'成安县',130400),(130425,'大名县',130400),(130426,'涉县',130400),(130427,'磁县',130400),(130428,'肥乡县',130400),(130429,'永年县',130400),(130430,'邱县',130400),(130431,'鸡泽县',130400),(130432,'广平县',130400),(130433,'馆陶县',130400),(130434,'魏县',130400),(130435,'曲周县',130400),(130481,'武安市',130400),(130500,'邢台市',130000),(130502,'桥东区',130500),(130503,'桥西区',130500),(130521,'邢台县',130500),(130522,'临城县',130500),(130523,'内丘县',130500),(130524,'柏乡县',130500),(130525,'隆尧县',130500),(130526,'任县',130500),(130527,'南和县',130500),(130528,'宁晋县',130500),(130529,'巨鹿县',130500),(130530,'新河县',130500),(130531,'广宗县',130500),(130532,'平乡县',130500),(130533,'威县',130500),(130534,'清河县',130500),(130535,'临西县',130500),(130581,'南宫市',130500),(130582,'沙河市',130500),(130600,'保定市',130000),(130602,'竞秀区',130600),(130606,'莲池区',130600),(130607,'满城区',130600),(130608,'清苑区',130600),(130609,'徐水区',130600),(130623,'涞水县',130600),(130624,'阜平县',130600),(130626,'定兴县',130600),(130627,'唐县',130600),(130628,'高阳县',130600),(130629,'容城县',130600),(130630,'涞源县',130600),(130631,'望都县',130600),(130632,'安新县',130600),(130633,'易县',130600),(130634,'曲阳县',130600),(130635,'蠡县',130600),(130636,'顺平县',130600),(130637,'博野县',130600),(130638,'雄县',130600),(130681,'涿州市',130600),(130683,'安国市',130600),(130684,'高碑店市',130600),(130700,'张家口市',130000),(130702,'桥东区',130700),(130703,'桥西区',130700),(130705,'宣化区',130700),(130706,'下花园区',130700),(130708,'万全区',130700),(130709,'崇礼区',130700),(130722,'张北县',130700),(130723,'康保县',130700),(130724,'沽源县',130700),(130725,'尚义县',130700),(130726,'蔚县',130700),(130727,'阳原县',130700),(130728,'怀安县',130700),(130730,'怀来县',130700),(130731,'涿鹿县',130700),(130732,'赤城县',130700),(130800,'承德市',130000),(130802,'双桥区',130800),(130803,'双滦区',130800),(130804,'鹰手营子矿区',130800),(130821,'承德县',130800),(130822,'兴隆县',130800),(130823,'平泉县',130800),(130824,'滦平县',130800),(130825,'隆化县',130800),(130826,'丰宁满族自治县',130800),(130827,'宽城满族自治县',130800),(130828,'围场满族蒙古族自治县',130800),(130900,'沧州市',130000),(130902,'新华区',130900),(130903,'运河区',130900),(130921,'沧县',130900),(130922,'青县',130900),(130923,'东光县',130900),(130924,'海兴县',130900),(130925,'盐山县',130900),(130926,'肃宁县',130900),(130927,'南皮县',130900),(130928,'吴桥县',130900),(130929,'献县',130900),(130930,'孟村回族自治县',130900),(130981,'泊头市',130900),(130982,'任丘市',130900),(130983,'黄骅市',130900),(130984,'河间市',130900),(131000,'廊坊市',130000),(131002,'安次区',131000),(131003,'广阳区',131000),(131022,'固安县',131000),(131023,'永清县',131000),(131024,'香河县',131000),(131025,'大城县',131000),(131026,'文安县',131000),(131028,'大厂回族自治县',131000),(131081,'霸州市',131000),(131082,'三河市',131000),(131100,'衡水市',130000),(131102,'桃城区',131100),(131103,'冀州区',131100),(131121,'枣强县',131100),(131122,'武邑县',131100),(131123,'武强县',131100),(131124,'饶阳县',131100),(131125,'安平县',131100),(131126,'故城县',131100),(131127,'景县',131100),(131128,'阜城县',131100),(131182,'深州市',131100),(139000,'省直辖县级行政区划',130000),(139001,'定州市',139000),(139002,'辛集市',139000),(140000,'山西省',NULL),(140100,'太原市',140000),(140105,'小店区',140100),(140106,'迎泽区',140100),(140107,'杏花岭区',140100),(140108,'尖草坪区',140100),(140109,'万柏林区',140100),(140110,'晋源区',140100),(140121,'清徐县',140100),(140122,'阳曲县',140100),(140123,'娄烦县',140100),(140181,'古交市',140100),(140200,'大同市',140000),(140202,'城区',140200),(140203,'矿区',140200),(140211,'南郊区',140200),(140212,'新荣区',140200),(140221,'阳高县',140200),(140222,'天镇县',140200),(140223,'广灵县',140200),(140224,'灵丘县',140200),(140225,'浑源县',140200),(140226,'左云县',140200),(140227,'大同县',140200),(140300,'阳泉市',140000),(140302,'城区',140300),(140303,'矿区',140300),(140311,'郊区',140300),(140321,'平定县',140300),(140322,'盂县',140300),(140400,'长治市',140000),(140402,'城区',140400),(140411,'郊区',140400),(140421,'长治县',140400),(140423,'襄垣县',140400),(140424,'屯留县',140400),(140425,'平顺县',140400),(140426,'黎城县',140400),(140427,'壶关县',140400),(140428,'长子县',140400),(140429,'武乡县',140400),(140430,'沁县',140400),(140431,'沁源县',140400),(140481,'潞城市',140400),(140500,'晋城市',140000),(140502,'城区',140500),(140521,'沁水县',140500),(140522,'阳城县',140500),(140524,'陵川县',140500),(140525,'泽州县',140500),(140581,'高平市',140500),(140600,'朔州市',140000),(140602,'朔城区',140600),(140603,'平鲁区',140600),(140621,'山阴县',140600),(140622,'应县',140600),(140623,'右玉县',140600),(140624,'怀仁县',140600),(140700,'晋中市',140000),(140702,'榆次区',140700),(140721,'榆社县',140700),(140722,'左权县',140700),(140723,'和顺县',140700),(140724,'昔阳县',140700),(140725,'寿阳县',140700),(140726,'太谷县',140700),(140727,'祁县',140700),(140728,'平遥县',140700),(140729,'灵石县',140700),(140781,'介休市',140700),(140800,'运城市',140000),(140802,'盐湖区',140800),(140821,'临猗县',140800),(140822,'万荣县',140800),(140823,'闻喜县',140800),(140824,'稷山县',140800),(140825,'新绛县',140800),(140826,'绛县',140800),(140827,'垣曲县',140800),(140828,'夏县',140800),(140829,'平陆县',140800),(140830,'芮城县',140800),(140881,'永济市',140800),(140882,'河津市',140800),(140900,'忻州市',140000),(140902,'忻府区',140900),(140921,'定襄县',140900),(140922,'五台县',140900),(140923,'代县',140900),(140924,'繁峙县',140900),(140925,'宁武县',140900),(140926,'静乐县',140900),(140927,'神池县',140900),(140928,'五寨县',140900),(140929,'岢岚县',140900),(140930,'河曲县',140900),(140931,'保德县',140900),(140932,'偏关县',140900),(140981,'原平市',140900),(141000,'临汾市',140000),(141002,'尧都区',141000),(141021,'曲沃县',141000),(141022,'翼城县',141000),(141023,'襄汾县',141000),(141024,'洪洞县',141000),(141025,'古县',141000),(141026,'安泽县',141000),(141027,'浮山县',141000),(141028,'吉县',141000),(141029,'乡宁县',141000),(141030,'大宁县',141000),(141031,'隰县',141000),(141032,'永和县',141000),(141033,'蒲县',141000),(141034,'汾西县',141000),(141081,'侯马市',141000),(141082,'霍州市',141000),(141100,'吕梁市',140000),(141102,'离石区',141100),(141121,'文水县',141100),(141122,'交城县',141100),(141123,'兴县',141100),(141124,'临县',141100),(141125,'柳林县',141100),(141126,'石楼县',141100),(141127,'岚县',141100),(141128,'方山县',141100),(141129,'中阳县',141100),(141130,'交口县',141100),(141181,'孝义市',141100),(141182,'汾阳市',141100),(150000,'内蒙古自治区',NULL),(150100,'呼和浩特市',150000),(150102,'新城区',150100),(150103,'回民区',150100),(150104,'玉泉区',150100),(150105,'赛罕区',150100),(150121,'土默特左旗',150100),(150122,'托克托县',150100),(150123,'和林格尔县',150100),(150124,'清水河县',150100),(150125,'武川县',150100),(150200,'包头市',150000),(150202,'东河区',150200),(150203,'昆都仑区',150200),(150204,'青山区',150200),(150205,'石拐区',150200),(150206,'白云鄂博矿区',150200),(150207,'九原区',150200),(150221,'土默特右旗',150200),(150222,'固阳县',150200),(150223,'达尔罕茂明安联合旗',150200),(150300,'乌海市',150000),(150302,'海勃湾区',150300),(150303,'海南区',150300),(150304,'乌达区',150300),(150400,'赤峰市',150000),(150402,'红山区',150400),(150403,'元宝山区',150400),(150404,'松山区',150400),(150421,'阿鲁科尔沁旗',150400),(150422,'巴林左旗',150400),(150423,'巴林右旗',150400),(150424,'林西县',150400),(150425,'克什克腾旗',150400),(150426,'翁牛特旗',150400),(150428,'喀喇沁旗',150400),(150429,'宁城县',150400),(150430,'敖汉旗',150400),(150500,'通辽市',150000),(150502,'科尔沁区',150500),(150521,'科尔沁左翼中旗',150500),(150522,'科尔沁左翼后旗',150500),(150523,'开鲁县',150500),(150524,'库伦旗',150500),(150525,'奈曼旗',150500),(150526,'扎鲁特旗',150500),(150581,'霍林郭勒市',150500),(150600,'鄂尔多斯市',150000),(150602,'东胜区',150600),(150603,'康巴什区',150600),(150621,'达拉特旗',150600),(150622,'准格尔旗',150600),(150623,'鄂托克前旗',150600),(150624,'鄂托克旗',150600),(150625,'杭锦旗',150600),(150626,'乌审旗',150600),(150627,'伊金霍洛旗',150600),(150700,'呼伦贝尔市',150000),(150702,'海拉尔区',150700),(150703,'扎赉诺尔区',150700),(150721,'阿荣旗',150700),(150722,'莫力达瓦达斡尔族自治旗',150700),(150723,'鄂伦春自治旗',150700),(150724,'鄂温克族自治旗',150700),(150725,'陈巴尔虎旗',150700),(150726,'新巴尔虎左旗',150700),(150727,'新巴尔虎右旗',150700),(150781,'满洲里市',150700),(150782,'牙克石市',150700),(150783,'扎兰屯市',150700),(150784,'额尔古纳市',150700),(150785,'根河市',150700),(150800,'巴彦淖尔市',150000),(150802,'临河区',150800),(150821,'五原县',150800),(150822,'磴口县',150800),(150823,'乌拉特前旗',150800),(150824,'乌拉特中旗',150800),(150825,'乌拉特后旗',150800),(150826,'杭锦后旗',150800),(150900,'乌兰察布市',150000),(150902,'集宁区',150900),(150921,'卓资县',150900),(150922,'化德县',150900),(150923,'商都县',150900),(150924,'兴和县',150900),(150925,'凉城县',150900),(150926,'察哈尔右翼前旗',150900),(150927,'察哈尔右翼中旗',150900),(150928,'察哈尔右翼后旗',150900),(150929,'四子王旗',150900),(150981,'丰镇市',150900),(152200,'兴安盟',150000),(152201,'乌兰浩特市',152200),(152202,'阿尔山市',152200),(152221,'科尔沁右翼前旗',152200),(152222,'科尔沁右翼中旗',152200),(152223,'扎赉特旗',152200),(152224,'突泉县',152200),(152500,'锡林郭勒盟',150000),(152501,'二连浩特市',152500),(152502,'锡林浩特市',152500),(152522,'阿巴嘎旗',152500),(152523,'苏尼特左旗',152500),(152524,'苏尼特右旗',152500),(152525,'东乌珠穆沁旗',152500),(152526,'西乌珠穆沁旗',152500),(152527,'太仆寺旗',152500),(152528,'镶黄旗',152500),(152529,'正镶白旗',152500),(152530,'正蓝旗',152500),(152531,'多伦县',152500),(152900,'阿拉善盟',150000),(152921,'阿拉善左旗',152900),(152922,'阿拉善右旗',152900),(152923,'额济纳旗',152900),(210000,'辽宁省',NULL),(210100,'沈阳市',210000),(210102,'和平区',210100),(210103,'沈河区',210100),(210104,'大东区',210100),(210105,'皇姑区',210100),(210106,'铁西区',210100),(210111,'苏家屯区',210100),(210112,'浑南区',210100),(210113,'沈北新区',210100),(210114,'于洪区',210100),(210115,'辽中区',210100),(210123,'康平县',210100),(210124,'法库县',210100),(210181,'新民市',210100),(210200,'大连市',210000),(210202,'中山区',210200),(210203,'西岗区',210200),(210204,'沙河口区',210200),(210211,'甘井子区',210200),(210212,'旅顺口区',210200),(210213,'金州区',210200),(210214,'普兰店区',210200),(210224,'长海县',210200),(210281,'瓦房店市',210200),(210283,'庄河市',210200),(210300,'鞍山市',210000),(210302,'铁东区',210300),(210303,'铁西区',210300),(210304,'立山区',210300),(210311,'千山区',210300),(210321,'台安县',210300),(210323,'岫岩满族自治县',210300),(210381,'海城市',210300),(210400,'抚顺市',210000),(210402,'新抚区',210400),(210403,'东洲区',210400),(210404,'望花区',210400),(210411,'顺城区',210400),(210421,'抚顺县',210400),(210422,'新宾满族自治县',210400),(210423,'清原满族自治县',210400),(210500,'本溪市',210000),(210502,'平山区',210500),(210503,'溪湖区',210500),(210504,'明山区',210500),(210505,'南芬区',210500),(210521,'本溪满族自治县',210500),(210522,'桓仁满族自治县',210500),(210600,'丹东市',210000),(210602,'元宝区',210600),(210603,'振兴区',210600),(210604,'振安区',210600),(210624,'宽甸满族自治县',210600),(210681,'东港市',210600),(210682,'凤城市',210600),(210700,'锦州市',210000),(210702,'古塔区',210700),(210703,'凌河区',210700),(210711,'太和区',210700),(210726,'黑山县',210700),(210727,'义县',210700),(210781,'凌海市',210700),(210782,'北镇市',210700),(210800,'营口市',210000),(210802,'站前区',210800),(210803,'西市区',210800),(210804,'鲅鱼圈区',210800),(210811,'老边区',210800),(210881,'盖州市',210800),(210882,'大石桥市',210800),(210900,'阜新市',210000),(210902,'海州区',210900),(210903,'新邱区',210900),(210904,'太平区',210900),(210905,'清河门区',210900),(210911,'细河区',210900),(210921,'阜新蒙古族自治县',210900),(210922,'彰武县',210900),(211000,'辽阳市',210000),(211002,'白塔区',211000),(211003,'文圣区',211000),(211004,'宏伟区',211000),(211005,'弓长岭区',211000),(211011,'太子河区',211000),(211021,'辽阳县',211000),(211081,'灯塔市',211000),(211100,'盘锦市',210000),(211102,'双台子区',211100),(211103,'兴隆台区',211100),(211104,'大洼区',211100),(211122,'盘山县',211100),(211200,'铁岭市',210000),(211202,'银州区',211200),(211204,'清河区',211200),(211221,'铁岭县',211200),(211223,'西丰县',211200),(211224,'昌图县',211200),(211281,'调兵山市',211200),(211282,'开原市',211200),(211300,'朝阳市',210000),(211302,'双塔区',211300),(211303,'龙城区',211300),(211321,'朝阳县',211300),(211322,'建平县',211300),(211324,'喀喇沁左翼蒙古族自治县',211300),(211381,'北票市',211300),(211382,'凌源市',211300),(211400,'葫芦岛市',210000),(211402,'连山区',211400),(211403,'龙港区',211400),(211404,'南票区',211400),(211421,'绥中县',211400),(211422,'建昌县',211400),(211481,'兴城市',211400),(220000,'吉林省',NULL),(220100,'长春市',220000),(220102,'南关区',220100),(220103,'宽城区',220100),(220104,'朝阳区',220100),(220105,'二道区',220100),(220106,'绿园区',220100),(220112,'双阳区',220100),(220113,'九台区',220100),(220122,'农安县',220100),(220182,'榆树市',220100),(220183,'德惠市',220100),(220200,'吉林市',220000),(220202,'昌邑区',220200),(220203,'龙潭区',220200),(220204,'船营区',220200),(220211,'丰满区',220200),(220221,'永吉县',220200),(220281,'蛟河市',220200),(220282,'桦甸市',220200),(220283,'舒兰市',220200),(220284,'磐石市',220200),(220300,'四平市',220000),(220302,'铁西区',220300),(220303,'铁东区',220300),(220322,'梨树县',220300),(220323,'伊通满族自治县',220300),(220381,'公主岭市',220300),(220382,'双辽市',220300),(220400,'辽源市',220000),(220402,'龙山区',220400),(220403,'西安区',220400),(220421,'东丰县',220400),(220422,'东辽县',220400),(220500,'通化市',220000),(220502,'东昌区',220500),(220503,'二道江区',220500),(220521,'通化县',220500),(220523,'辉南县',220500),(220524,'柳河县',220500),(220581,'梅河口市',220500),(220582,'集安市',220500),(220600,'白山市',220000),(220602,'浑江区',220600),(220605,'江源区',220600),(220621,'抚松县',220600),(220622,'靖宇县',220600),(220623,'长白朝鲜族自治县',220600),(220681,'临江市',220600),(220700,'松原市',220000),(220702,'宁江区',220700),(220721,'前郭尔罗斯蒙古族自治县',220700),(220722,'长岭县',220700),(220723,'乾安县',220700),(220781,'扶余市',220700),(220800,'白城市',220000),(220802,'洮北区',220800),(220821,'镇赉县',220800),(220822,'通榆县',220800),(220881,'洮南市',220800),(220882,'大安市',220800),(222400,'延边朝鲜族自治州',220000),(222401,'延吉市',222400),(222402,'图们市',222400),(222403,'敦化市',222400),(222404,'珲春市',222400),(222405,'龙井市',222400),(222406,'和龙市',222400),(222424,'汪清县',222400),(222426,'安图县',222400),(230000,'黑龙江省',NULL),(230100,'哈尔滨市',230000),(230102,'道里区',230100),(230103,'南岗区',230100),(230104,'道外区',230100),(230108,'平房区',230100),(230109,'松北区',230100),(230110,'香坊区',230100),(230111,'呼兰区',230100),(230112,'阿城区',230100),(230113,'双城区',230100),(230123,'依兰县',230100),(230124,'方正县',230100),(230125,'宾县',230100),(230126,'巴彦县',230100),(230127,'木兰县',230100),(230128,'通河县',230100),(230129,'延寿县',230100),(230183,'尚志市',230100),(230184,'五常市',230100),(230200,'齐齐哈尔市',230000),(230202,'龙沙区',230200),(230203,'建华区',230200),(230204,'铁锋区',230200),(230205,'昂昂溪区',230200),(230206,'富拉尔基区',230200),(230207,'碾子山区',230200),(230208,'梅里斯达斡尔族区',230200),(230221,'龙江县',230200),(230223,'依安县',230200),(230224,'泰来县',230200),(230225,'甘南县',230200),(230227,'富裕县',230200),(230229,'克山县',230200),(230230,'克东县',230200),(230231,'拜泉县',230200),(230281,'讷河市',230200),(230300,'鸡西市',230000),(230302,'鸡冠区',230300),(230303,'恒山区',230300),(230304,'滴道区',230300),(230305,'梨树区',230300),(230306,'城子河区',230300),(230307,'麻山区',230300),(230321,'鸡东县',230300),(230381,'虎林市',230300),(230382,'密山市',230300),(230400,'鹤岗市',230000),(230402,'向阳区',230400),(230403,'工农区',230400),(230404,'南山区',230400),(230405,'兴安区',230400),(230406,'东山区',230400),(230407,'兴山区',230400),(230421,'萝北县',230400),(230422,'绥滨县',230400),(230500,'双鸭山市',230000),(230502,'尖山区',230500),(230503,'岭东区',230500),(230505,'四方台区',230500),(230506,'宝山区',230500),(230521,'集贤县',230500),(230522,'友谊县',230500),(230523,'宝清县',230500),(230524,'饶河县',230500),(230600,'大庆市',230000),(230602,'萨尔图区',230600),(230603,'龙凤区',230600),(230604,'让胡路区',230600),(230605,'红岗区',230600),(230606,'大同区',230600),(230621,'肇州县',230600),(230622,'肇源县',230600),(230623,'林甸县',230600),(230624,'杜尔伯特蒙古族自治县',230600),(230700,'伊春市',230000),(230702,'伊春区',230700),(230703,'南岔区',230700),(230704,'友好区',230700),(230705,'西林区',230700),(230706,'翠峦区',230700),(230707,'新青区',230700),(230708,'美溪区',230700),(230709,'金山屯区',230700),(230710,'五营区',230700),(230711,'乌马河区',230700),(230712,'汤旺河区',230700),(230713,'带岭区',230700),(230714,'乌伊岭区',230700),(230715,'红星区',230700),(230716,'上甘岭区',230700),(230722,'嘉荫县',230700),(230781,'铁力市',230700),(230800,'佳木斯市',230000),(230803,'向阳区',230800),(230804,'前进区',230800),(230805,'东风区',230800),(230811,'郊区',230800),(230822,'桦南县',230800),(230826,'桦川县',230800),(230828,'汤原县',230800),(230881,'同江市',230800),(230882,'富锦市',230800),(230883,'抚远市',230800),(230900,'七台河市',230000),(230902,'新兴区',230900),(230903,'桃山区',230900),(230904,'茄子河区',230900),(230921,'勃利县',230900),(231000,'牡丹江市',230000),(231002,'东安区',231000),(231003,'阳明区',231000),(231004,'爱民区',231000),(231005,'西安区',231000),(231025,'林口县',231000),(231081,'绥芬河市',231000),(231083,'海林市',231000),(231084,'宁安市',231000),(231085,'穆棱市',231000),(231086,'东宁市',231000),(231100,'黑河市',230000),(231102,'爱辉区',231100),(231121,'嫩江县',231100),(231123,'逊克县',231100),(231124,'孙吴县',231100),(231181,'北安市',231100),(231182,'五大连池市',231100),(231200,'绥化市',230000),(231202,'北林区',231200),(231221,'望奎县',231200),(231222,'兰西县',231200),(231223,'青冈县',231200),(231224,'庆安县',231200),(231225,'明水县',231200),(231226,'绥棱县',231200),(231281,'安达市',231200),(231282,'肇东市',231200),(231283,'海伦市',231200),(232700,'大兴安岭地区',230000),(232721,'呼玛县',232700),(232722,'塔河县',232700),(232723,'漠河县',232700),(310000,'上海市',NULL),(310100,'上海市',310000),(310101,'黄浦区',310100),(310104,'徐汇区',310100),(310105,'长宁区',310100),(310106,'静安区',310100),(310107,'普陀区',310100),(310109,'虹口区',310100),(310110,'杨浦区',310100),(310112,'闵行区',310100),(310113,'宝山区',310100),(310114,'嘉定区',310100),(310115,'浦东新区',310100),(310116,'金山区',310100),(310117,'松江区',310100),(310118,'青浦区',310100),(310120,'奉贤区',310100),(310151,'崇明区',310100),(320000,'江苏省',NULL),(320100,