-- MySQL dump 10.17  Distrib 10.3.15-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: admin
-- ------------------------------------------------------
-- Server version	10.3.15-MariaDB

/*!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 utf8mb4 */;
/*!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 `address`
--

DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `province_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '省ID',
  `city_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '市ID',
  `region_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '区ID',
  `lat` varchar(15) NOT NULL DEFAULT '' COMMENT '纬度',
  `lng` varchar(15) NOT NULL DEFAULT '' COMMENT '经度',
  `area_info` varchar(50) NOT NULL DEFAULT '' COMMENT '区域信息',
  `address` varchar(30) NOT NULL DEFAULT '' COMMENT '详细地址信息',
  `receive_tel` varchar(11) NOT NULL DEFAULT '' COMMENT '收件电话',
  `receive_name` varchar(10) NOT NULL DEFAULT '' COMMENT '收件人',
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '默认地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='收货地址';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address`
--

LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
INSERT INTO `address` VALUES (1,1,1,32,375,'','','北京市 市辖区 东城区','东门大街402号','15073010917','马大哈',1),(3,1,1,32,375,'','','北京市 市辖区 东城区','东门大街402号','15073010917','马大哈2',0),(4,1,1,32,375,'','','北京市 市辖区 东城区','东门大街402号','15073010917','马大哈3',0);
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `adv`
--

DROP TABLE IF EXISTS `adv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adv` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ap_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '广告位ID',
  `adv_title` varchar(30) NOT NULL DEFAULT '' COMMENT '广告标题',
  `adv_link` varchar(100) NOT NULL DEFAULT '' COMMENT '广告链接',
  `adv_image` varchar(100) NOT NULL DEFAULT '' COMMENT '广告图片链接',
  `adv_start` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '开始时间',
  `adv_end` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '结束时间',
  `adv_sort` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '排序',
  `adv_type` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='广告表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `adv`
--

LOCK TABLES `adv` WRITE;
/*!40000 ALTER TABLE `adv` DISABLE KEYS */;
INSERT INTO `adv` VALUES (5,4,'xxxxx','xxx','http://api.qingwuit.com/Uploads/adv/2019_11_13/15736267124422.png',1481817600,1894291200,0,0),(6,5,'x','/','http://api.qingwuit.com/Uploads/adv/2019_11_13/15736349798484.jpg',1573574400,1902758400,0,0),(7,5,'2','/','http://api.qingwuit.com/Uploads/adv/2019_11_13/15736350111164.jpg',1573574400,1923321600,0,0),(8,5,'3','/','http://api.qingwuit.com/Uploads/adv/2019_11_13/15736350582872.jpg',1573574400,1923926400,0,0),(9,6,'1','/','http://api.qingwuit.com/Uploads/adv/2019_11_13/15736355063668.jpg',1573574400,1923235200,0,0),(10,7,'1','1','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737130049876.jpg',1573660800,1923926400,0,0),(11,7,'2','2','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737130641814.jpg',1573574400,1923840000,0,0),(12,7,'32','','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737130908330.jpg',1573660800,1923840000,0,0),(13,8,'1','','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737142019047.jpg',1573660800,1923753600,0,0),(14,8,'2','','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737142259817.jpg',1573660800,1923753600,0,0),(15,8,'3','','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737142435543.jpg',1573660800,1923753600,0,0),(16,8,'4','','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737142987008.jpg',1573660800,1923667200,0,0),(17,9,'1','','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737156483842.jpg',1573660800,1923753600,0,0),(18,10,'1','','http://api.qingwuit.com/Uploads/adv/2019_11_14/15737177205862.jpg',1573660800,1923753600,0,0),(19,11,'积分','#','http://api.qingwuit.com/Uploads/adv/2020_01_04/15781279029818.jpg',1578067200,1896105600,0,0),(20,12,'团购中心幻灯片','#','http://api.qingwuit.com/Uploads/adv/2020_01_06/15783010576303.jpg',1578240000,2086531200,0,0);
/*!40000 ALTER TABLE `adv` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `adv_position`
--

DROP TABLE IF EXISTS `adv_position`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adv_position` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ap_name` varchar(30) NOT NULL DEFAULT '' COMMENT '广告位名称',
  `ap_isuse` tinyint(3) unsigned NOT NULL DEFAULT 1 COMMENT '是否开启',
  `ap_width` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT '宽度',
  `ap_height` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT '高度',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='广告位表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `adv_position`
--

LOCK TABLES `adv_position` WRITE;
/*!40000 ALTER TABLE `adv_position` DISABLE KEYS */;
INSERT INTO `adv_position` VALUES (4,'PC_首页左导航栏',1,203,96),(5,'PC_首页幻灯片下广告',1,312,160),(6,'PC_首页幻灯片',1,1200,450),(7,'PC_首页商品列表左侧',1,234,614),(8,'PC_首页商品列表底部',1,1200,117),(9,'PC_首页版权底部',1,1200,117),(10,'PC_加入我们幻灯片',1,1200,350),(11,'PC_积分商城首页',1,1200,250),(12,'PC_团购中心幻灯片',1,1200,300);
/*!40000 ALTER TABLE `adv_position` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agreement`
--

DROP TABLE IF EXISTS `agreement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agreement` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '标题',
  `ename` varchar(20) NOT NULL DEFAULT '' COMMENT '英文标题',
  `content` text NOT NULL DEFAULT '' COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='协议表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agreement`
--

LOCK TABLES `agreement` WRITE;
/*!40000 ALTER TABLE `agreement` DISABLE KEYS */;
INSERT INTO `agreement` VALUES (1,'入驻协议','store_join','<div><h2>1.本协议的订立</h2><p>在本网站（<a target=\"_blank\" href=\"http://www.ecmoban.com/\">www.ecmoban.com</a>）依据《商创商城网站用户注册协议》登记注册，且符合本网站 商家入驻标准(详见链接：<a target=\"_blank\" href=\"http://www.ecmoban.com/contact/joinin.aspx\">http://www.ecmoban.com/contact/joinin.aspx</a>）的用户（以下简称\"商 家\"），在同意本协议全部条款后，方有资格使用\"商创商城商家在线入驻系统\"（以 下简称\"入驻系统\"）申请入驻。一经商家点击\"同意以上协议，下一步\"按键， 即意味着商家同意与本网站签订本协议并同意受本协议约束。</p></div><div><h2>2.入驻系统使用说明</h2><p>2.1 商家通过入驻系统提出入驻申请，并按照要求填写商家信息、提供商家资质资料后，由 本网站审核并与有合作意向的商家联系协商合作相关事宜，经双方协商一致线下签订书面《开放平台 供应商合作运营协议》（以下简称\"运营协议\"），且商家按照\"运营协议\"约定 支付相应平台使用费及保证金等必要费用后，商家正式入驻本网站。本网站将为入驻商家开通商家后 台系统，商家可通过商家后台系统在本网站运营 自己的入驻店铺。</p><p>2.2 商家以及本网站通过入驻系统做出的申请、资料提交及确认等各类沟通，仅为双方合作 的意向以及本网站对商家资格审核的必备程序，除遵守本协议各项约定外，对双方不产生法律约束力 。双方间最终合作事宜及运营规则均以\"运营协议\"的约定及商家后台系统公示的各项规则 为准。</p></div><div><h2>3.商家权利义务</h2><p>用户使用\"商创商城商家在线入驻系统\"前请认真阅读并理解本协议内容，本协议 内容中以加粗方式显著标识的条款，请用户着重阅读、慎重考虑。</p></div><div><h2>1.本协议的订立</h2><p>在本网站（<a target=\"_blank\" href=\"http://www.ecmoban.com/\">www.ecmoban.com</a>）依据《商创商城网站用户注册协议》登记注册，且符合本网站 商家入驻标准(详见链接：<a target=\"_blank\" href=\"http://www.ecmoban.com/contact/joinin.aspx\">http://www.ecmoban.com/contact/joinin.aspx</a>）的用户（以下简称\"商 家\"），在同意本协议全部条款后，方有资格使用\"商创商城商家在线入驻系统\"（以 下简称\"入驻系统\"） 申请入驻。一经商家点击\"同意以上协议，下一步\"按键 ，即意味着商家同意与本网站签订本协议并同意受本协议约束。</p></div><div><h2>2.入驻系统使用说明</h2><p>2.1 商家通过入驻系统提出入驻申请，并按照要求填写商家信息、提供商家资质资料后，由 本网站审核并与有合作意向的商家联系协商合作相关事宜，经双方协商一致线下签订书面《开放平台 供应商合作运营协议》（以下简称\"运营协议\"），且商家按照\"运营协议\"约定 支付相应平台使用费及保证金等必要费用后，商家正式入驻本网站。本网站将为入驻商家开通商家后 台系统，商家可通过商家后台系统在本网站运营 自己的入驻店铺。</p><p>2.2 商家以及本网站通过入驻系统做出的申请、资料提交及确认等各类沟通，仅为双方合作 的意向以及本网站对商家资格审核的必备程序，除遵守本协议各项约定外，对双方不产生法律约束力 。双方间最终合作事宜及运营规则均以\"运营协议\"的约定及商家后台系统公示的各项规则 为准。</p></div><div><h2>3.商家权利义务</h2><p>用户使用\"商创商城商家在线入驻系统\"前请认真阅读并理解本协议内容，本协议 内容中以加粗方式显著标识的条款，请用户着重阅读、慎重考虑。</p></div>');
/*!40000 ALTER TABLE `agreement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `area`
--

DROP TABLE IF EXISTS `area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `area` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `area_id` varchar(20) NOT NULL DEFAULT '0' COMMENT '地区标识',
  `pid` varchar(20) NOT NULL DEFAULT '0' COMMENT '父地区',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户',
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '名字',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1645 DEFAULT CHARSET=utf8 COMMENT='全国地区数据';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `area`
--

LOCK TABLES `area` WRITE;
/*!40000 ALTER TABLE `area` DISABLE KEYS */;
INSERT INTO `area` VALUES (1,'110000','0',3,'北京市'),(2,'120000','0',0,'天津市'),(3,'130000','0',0,'河北省'),(4,'140000','0',0,'山西省'),(5,'150000','0',0,'内蒙古自治区'),(6,'210000','0',0,'辽宁省'),(7,'220000','0',0,'吉林省'),(8,'230000','0',0,'黑龙江省'),(9,'310000','0',0,'上海市'),(10,'320000','0',0,'江苏省'),(11,'330000','0',0,'浙江省'),(12,'340000','0',0,'安徽省'),(13,'350000','0',0,'福建省'),(14,'360000','0',0,'江西省'),(15,'370000','0',0,'山东省'),(16,'410000','0',0,'河南省'),(17,'420000','0',0,'湖北省'),(18,'430000','0',0,'湖南省'),(19,'440000','0',0,'广东省'),(20,'450000','0',0,'广西壮族自治区'),(21,'460000','0',0,'海南省'),(22,'500000','0',0,'重庆市'),(23,'510000','0',0,'四川省'),(24,'520000','0',0,'贵州省'),(25,'530000','0',0,'云南省'),(26,'540000','0',0,'西藏自治区'),(27,'610000','0',0,'陕西省'),(28,'620000','0',0,'甘肃省'),(29,'630000','0',0,'青海省'),(30,'640000','0',0,'宁夏回族自治区'),(31,'650000','0',0,'新疆维吾尔自治区'),(32,'110100000000','110000',0,'市辖区'),(33,'120100000000','120000',0,'市辖区'),(34,'130100000000','130000',0,'石家庄市'),(35,'130200000000','130000',0,'唐山市'),(36,'130300000000','130000',0,'秦皇岛市'),(37,'130400000000','130000',0,'邯郸市'),(38,'130500000000','130000',0,'邢台市'),(39,'130600000000','130000',0,'保定市'),(40,'130700000000','130000',0,'张家口市'),(41,'130800000000','130000',0,'承德市'),(42,'130900000000','130000',0,'沧州市'),(43,'131000000000','130000',0,'廊坊市'),(44,'131100000000','130000',0,'衡水市'),(45,'140100000000','140000',0,'太原市'),(46,'140200000000','140000',0,'大同市'),(47,'140300000000','140000',0,'阳泉市'),(48,'140400000000','140000',0,'长治市'),(49,'140500000000','140000',0,'晋城市'),(50,'140600000000','140000',0,'朔州市'),(51,'140700000000','140000',0,'晋中市'),(52,'140800000000','140000',0,'运城市'),(53,'140900000000','140000',0,'忻州市'),(54,'141000000000','140000',0,'临汾市'),(55,'141100000000','140000',0,'吕梁市'),(56,'150100000000','150000',0,'呼和浩特市'),(57,'150200000000','150000',0,'包头市'),(58,'150300000000','150000',0,'乌海市'),(59,'150400000000','150000',0,'赤峰市'),(60,'150500000000','150000',0,'通辽市'),(61,'150600000000','150000',0,'鄂尔多斯市'),(62,'150700000000','150000',0,'呼伦贝尔市'),(63,'150800000000','150000',0,'巴彦淖尔市'),(64,'150900000000','150000',0,'乌兰察布市'),(65,'152200000000','150000',0,'兴安盟'),(66,'152500000000','150000',0,'锡林郭勒盟'),(67,'152900000000','150000',0,'阿拉善盟'),(68,'210100000000','210000',0,'沈阳市'),(69,'210200000000','210000',0,'大连市'),(70,'210300000000','210000',0,'鞍山市'),(71,'210400000000','210000',0,'抚顺市'),(72,'210500000000','210000',0,'本溪市'),(73,'210600000000','210000',0,'丹东市'),(74,'210700000000','210000',0,'锦州市'),(75,'210800000000','210000',0,'营口市'),(76,'210900000000','210000',0,'阜新市'),(77,'211000000000','210000',0,'辽阳市'),(78,'211100000000','210000',0,'盘锦市'),(79,'211200000000','210000',0,'铁岭市'),(80,'211300000000','210000',0,'朝阳市'),(81,'211400000000','210000',0,'葫芦岛市'),(82,'220100000000','220000',0,'长春市'),(83,'220200000000','220000',0,'吉林市'),(84,'220300000000','220000',0,'四平市'),(85,'220400000000','220000',0,'辽源市'),(86,'220500000000','220000',0,'通化市'),(87,'220600000000','220000',0,'白山市'),(88,'220700000000','220000',0,'松原市'),(89,'220800000000','220000',0,'白城市'),(90,'222400000000','220000',0,'延边朝鲜族自治州'),(91,'230100000000','230000',0,'哈尔滨市'),(92,'230200000000','230000',0,'齐齐哈尔市'),(93,'230300000000','230000',0,'鸡西市'),(94,'230400000000','230000',0,'鹤岗市'),(95,'230500000000','230000',0,'双鸭山市'),(96,'230600000000','230000',0,'大庆市'),(97,'230700000000','230000',0,'伊春市'),(98,'230800000000','230000',0,'佳木斯市'),(99,'230900000000','230000',0,'七台河市'),(100,'231000000000','230000',0,'牡丹江市'),(101,'231100000000','230000',0,'黑河市'),(102,'231200000000','230000',0,'绥化市'),(103,'232700000000','230000',0,'大兴安岭地区'),(104,'310100000000','310000',0,'市辖区'),(105,'320100000000','320000',0,'南京市'),(106,'320200000000','320000',0,'无锡市'),(107,'320300000000','320000',0,'徐州市'),(108,'320400000000','320000',0,'常州市'),(109,'320500000000','320000',0,'苏州市'),(110,'320600000000','320000',0,'南通市'),(111,'320700000000','320000',0,'连云港市'),(112,'320800000000','320000',0,'淮安市'),(113,'320900000000','320000',0,'盐城市'),(114,'321000000000','320000',0,'扬州市'),(115,'321100000000','320000',0,'镇江市'),(116,'321200000000','320000',0,'泰州市'),(117,'321300000000','320000',0,'宿迁市'),(118,'330100000000','330000',0,'杭州市'),(119,'330200000000','330000',0,'宁波市'),(120,'330300000000','330000',0,'温州市'),(121,'330400000000','330000',0,'嘉兴市'),(122,'330500000000','330000',0,'湖州市'),(123,'330600000000','330000',0,'绍兴市'),(124,'330700000000','330000',0,'金华市'),(125,'330800000000','330000',0,'衢州市'),(126,'330900000000','330000',0,'舟山市'),(127,'331000000000','330000',0,'台州市'),(128,'331100000000','330000',0,'丽水市'),(129,'340100000000','340000',0,'合肥市'),(130,'340200000000','340000',0,'芜湖市'),(131,'340300000000','340000',0,'蚌埠市'),(132,'340400000000','340000',0,'淮南市'),(133,'340500000000','340000',0,'马鞍山市'),(134,'340600000000','340000',0,'淮北市'),(135,'340700000000','340000',0,'铜陵市'),(136,'340800000000','340000',0,'安庆市'),(137,'341000000000','340000',0,'黄山市'),(138,'341100000000','340000',0,'滁州市'),(139,'341200000000','340000',0,'阜阳市'),(140,'341300000000','340000',0,'宿州市'),(141,'341500000000','340000',0,'六安市'),(142,'341600000000','340000',0,'亳州市'),(143,'341700000000','340000',0,'池州市'),(144,'341800000000','340000',0,'宣城市'),(145,'350100000000','350000',0,'福州市'),(146,'350200000000','350000',0,'厦门市'),(147,'350300000000','350000',0,'莆田市'),(148,'350400000000','350000',0,'三明市'),(149,'350500000000','350000',0,'泉州市'),(150,'350600000000','350000',0,'漳州市'),(151,'350700000000','350000',0,'南平市'),(152,'350800000000','350000',0,'龙岩市'),(153,'350900000000','350000',0,'宁德市'),(154,'360100000000','360000',0,'南昌市'),(155,'360200000000','360000',0,'景德镇市'),(156,'360300000000','360000',0,'萍乡市'),(157,'360400000000','360000',0,'九江市'),(158,'360500000000','360000',0,'新余市'),(159,'360600000000','360000',0,'鹰潭市'),(160,'360700000000','360000',0,'赣州市'),(161,'360800000000','360000',0,'吉安市'),(162,'360900000000','360000',0,'宜春市'),(163,'361000000000','360000',0,'抚州市'),(164,'361100000000','360000',0,'上饶市'),(165,'370100000000','370000',0,'济南市'),(166,'370200000000','370000',0,'青岛市'),(167,'370300000000','370000',0,'淄博市'),(168,'370400000000','370000',0,'枣庄市'),(169,'370500000000','370000',0,'东营市'),(170,'370600000000','370000',0,'烟台市'),(171,'370700000000','370000',0,'潍坊市'),(172,'370800000000','370000',0,'济宁市'),(173,'370900000000','370000',0,'泰安市'),(174,'371000000000','370000',0,'威海市'),(175,'371100000000','370000',0,'日照市'),(176,'371200000000','370000',0,'莱芜市'),(177,'371300000000','370000',0,'临沂市'),(178,'371400000000','370000',0,'德州市'),(179,'371500000000','370000',0,'聊城市'),(180,'371600000000','370000',0,'滨州市'),(181,'371700000000','370000',0,'菏泽市'),(182,'410100000000','410000',0,'郑州市'),(183,'410200000000','410000',0,'开封市'),(184,'410300000000','410000',0,'洛阳市'),(185,'410400000000','410000',0,'平顶山市'),(186,'410500000000','410000',0,'安阳市'),(187,'410600000000','410000',0,'鹤壁市'),(188,'410700000000','410000',0,'新乡市'),(189,'410800000000','410000',0,'焦作市'),(190,'410900000000','410000',0,'濮阳市'),(191,'411000000000','410000',0,'许昌市'),(192,'411100000000','410000',0,'漯河市'),(193,'411200000000','410000',0,'三门峡市'),(194,'411300000000','410000',0,'南阳市'),(195,'411400000000','410000',0,'商丘市'),(196,'411500000000','410000',0,'信阳市'),(197,'411600000000','410000',0,'周口市'),(198,'411700000000','410000',0,'驻马店市'),(199,'419000000000','410000',0,'省直辖县级行政区划'),(200,'420100000000','420000',0,'武汉市'),(201,'420200000000','420000',0,'黄石市'),(202,'420300000000','420000',0,'十堰市'),(203,'420500000000','420000',0,'宜昌市'),(204,'420600000000','420000',0,'襄阳市'),(205,'420700000000','420000',0,'鄂州市'),(206,'420800000000','420000',0,'荆门市'),(207,'420900000000','420000',0,'孝感市'),(208,'421000000000','420000',0,'荆州市'),(209,'421100000000','420000',0,'黄冈市'),(210,'421200000000','420000',0,'咸宁市'),(211,'421300000000','420000',0,'随州市'),(212,'422800000000','420000',0,'恩施土家族苗族自治州'),(213,'429000000000','420000',0,'省直辖县级行政区划'),(214,'430100000000','430000',0,'长沙市'),(215,'430200000000','430000',0,'株洲市'),(216,'430300000000','430000',0,'湘潭市'),(217,'430400000000','430000',0,'衡阳市'),(218,'430500000000','430000',0,'邵阳市'),(219,'430600000000','430000',0,'岳阳市'),(220,'430700000000','430000',0,'常德市'),(221,'430800000000','430000',0,'张家界市'),(222,'430900000000','430000',0,'益阳市'),(223,'431000000000','430000',0,'郴州市'),(224,'431100000000','430000',0,'永州市'),(225,'431200000000','430000',0,'怀化市'),(226,'431300000000','430000',0,'娄底市'),(227,'433100000000','430000',0,'湘西土家族苗族自治州'),(228,'440100000000','440000',0,'广州市'),(229,'440200000000','440000',0,'韶关市'),(230,'440300000000','440000',0,'深圳市'),(231,'440400000000','440000',0,'珠海市'),(232,'440500000000','440000',0,'汕头市'),(233,'440600000000','440000',0,'佛山市'),(234,'440700000000','440000',0,'江门市'),(235,'440800000000','440000',0,'湛江市'),(236,'440900000000','440000',0,'茂名市'),(237,'441200000000','440000',0,'肇庆市'),(238,'441300000000','440000',0,'惠州市'),(239,'441400000000','440000',0,'梅州市'),(240,'441500000000','440000',0,'汕尾市'),(241,'441600000000','440000',0,'河源市'),(242,'441700000000','440000',0,'阳江市'),(243,'441800000000','440000',0,'清远市'),(244,'441900000000','440000',0,'东莞市'),(245,'442000000000','440000',0,'中山市'),(246,'445100000000','440000',0,'潮州市'),(247,'445200000000','440000',0,'揭阳市'),(248,'445300000000','440000',0,'云浮市'),(249,'450100000000','450000',0,'南宁市'),(250,'450200000000','450000',0,'柳州市'),(251,'450300000000','450000',0,'桂林市'),(252,'450400000000','450000',0,'梧州市'),(253,'450500000000','450000',0,'北海市'),(254,'450600000000','450000',0,'防城港市'),(255,'450700000000','450000',0,'钦州市'),(256,'450800000000','450000',0,'贵港市'),(257,'450900000000','450000',0,'玉林市'),(258,'451000000000','450000',0,'百色市'),(259,'451100000000','450000',0,'贺州市'),(260,'451200000000','450000',0,'河池市'),(261,'451300000000','450000',0,'来宾市'),(262,'451400000000','450000',0,'崇左市'),(263,'460100000000','460000',0,'海口市'),(264,'460200000000','460000',0,'三亚市'),(265,'460300000000','460000',0,'三沙市'),(266,'460400000000','460000',0,'儋州市'),(267,'469000000000','460000',0,'省直辖县级行政区划'),(268,'500100000000','500000',0,'市辖区'),(269,'500200000000','500000',0,'县'),(270,'510100000000','510000',0,'成都市'),(271,'510300000000','510000',0,'自贡市'),(272,'510400000000','510000',0,'攀枝花市'),(273,'510500000000','510000',0,'泸州市'),(274,'510600000000','510000',0,'德阳市'),(275,'510700000000','510000',0,'绵阳市'),(276,'510800000000','510000',0,'广元市'),(277,'510900000000','510000',0,'遂宁市'),(278,'511000000000','510000',0,'内江市'),(279,'511100000000','510000',0,'乐山市'),(280,'511300000000','510000',0,'南充市'),(281,'511400000000','510000',0,'眉山市'),(282,'511500000000','510000',0,'宜宾市'),(283,'511600000000','510000',0,'广安市'),(284,'511700000000','510000',0,'达州市'),(285,'511800000000','510000',0,'雅安市'),(286,'511900000000','510000',0,'巴中市'),(287,'512000000000','510000',0,'资阳市'),(288,'513200000000','510000',0,'阿坝藏族羌族自治州'),(289,'513300000000','510000',0,'甘孜藏族自治州'),(290,'513400000000','510000',0,'凉山彝族自治州'),(291,'520100000000','520000',0,'贵阳市'),(292,'520200000000','520000',0,'六盘水市'),(293,'520300000000','520000',0,'遵义市'),(294,'520400000000','520000',0,'安顺市'),(295,'520500000000','520000',0,'毕节市'),(296,'520600000000','520000',0,'铜仁市'),(297,'522300000000','520000',0,'黔西南布依族苗族自治州'),(298,'522600000000','520000',0,'黔东南苗族侗族自治州'),(299,'522700000000','520000',0,'黔南布依族苗族自治州'),(300,'530100000000','530000',0,'昆明市'),(301,'530300000000','530000',0,'曲靖市'),(302,'530400000000','530000',0,'玉溪市'),(303,'530500000000','530000',0,'保山市'),(304,'530600000000','530000',0,'昭通市'),(305,'530700000000','530000',0,'丽江市'),(306,'530800000000','530000',0,'普洱市'),(307,'530900000000','530000',0,'临沧市'),(308,'532300000000','530000',0,'楚雄彝族自治州'),(309,'532500000000','530000',0,'红河哈尼族彝族自治州'),(310,'532600000000','530000',0,'文山壮族苗族自治州'),(311,'532800000000','530000',0,'西双版纳傣族自治州'),(312,'532900000000','530000',0,'大理白族自治州'),(313,'533100000000','530000',0,'德宏傣族景颇族自治州'),(314,'533300000000','530000',0,'怒江傈僳族自治州'),(315,'533400000000','530000',0,'迪庆藏族自治州'),(316,'540100000000','540000',0,'拉萨市'),(317,'540200000000','540000',0,'日喀则市'),(318,'540300000000','540000',0,'昌都市'),(319,'540400000000','540000',0,'林芝市'),(320,'540500000000','540000',0,'山南市'),(321,'540600000000','540000',0,'那曲市'),(322,'542500000000','540000',0,'阿里地区'),(323,'610100000000','610000',0,'西安市'),(324,'610200000000','610000',0,'铜川市'),(325,'610300000000','610000',0,'宝鸡市'),(326,'610400000000','610000',0,'咸阳市'),(327,'610500000000','610000',0,'渭南市'),(328,'610600000000','610000',0,'延安市'),(329,'610700000000','610000',0,'汉中市'),(330,'610800000000','610000',0,'榆林市'),(331,'610900000000','610000',0,'安康市'),(332,'611000000000','610000',0,'商洛市'),(333,'620100000000','620000',0,'兰州市'),(334,'620200000000','620000',0,'嘉峪关市'),(335,'620300000000','620000',0,'金昌市'),(336,'620400000000','620000',0,'白银市'),(337,'620500000000','620000',0,'天水市'),(338,'620600000000','620000',0,'武威市'),(339,'620700000000','620000',0,'张掖市'),(340,'620800000000','620000',0,'平凉市'),(341,'620900000000','620000',0,'酒泉市'),(342,'621000000000','620000',0,'庆阳市'),(343,'621100000000','620000',0,'定西市'),(344,'621200000000','620000',0,'陇南市'),(345,'622900000000','620000',0,'临夏回族自治州'),(346,'623000000000','620000',0,'甘南藏族自治州'),(347,'630100000000','630000',0,'西宁市'),(348,'630200000000','630000',0,'海东市'),(349,'632200000000','630000',0,'海北藏族自治州'),(350,'632300000000','630000',0,'黄南藏族自治州'),(351,'632500000000','630000',0,'海南藏族自治州'),(352,'632600000000','630000',0,'果洛藏族自治州'),(353,'632700000000','630000',0,'玉树藏族自治州'),(354,'632800000000','630000',0,'海西蒙古族藏族自治州'),(355,'640100000000','640000',0,'银川市'),(356,'640200000000','640000',0,'石嘴山市'),(357,'640300000000','640000',0,'吴忠市'),(358,'640400000000','640000',0,'固原市'),(359,'640500000000','640000',0,'中卫市'),(360,'650100000000','650000',0,'乌鲁木齐市'),(361,'650200000000','650000',0,'克拉玛依市'),(362,'650400000000','650000',0,'吐鲁番市'),(363,'650500000000','650000',0,'哈密市'),(364,'652300000000','650000',0,'昌吉回族自治州'),(365,'652700000000','650000',0,'博尔塔拉蒙古自治州'),(366,'652800000000','650000',0,'巴音郭楞蒙古自治州'),(367,'652900000000','650000',0,'阿克苏地区'),(368,'653000000000','650000',0,'克孜勒苏柯尔克孜自治州'),(369,'653100000000','650000',0,'喀什地区'),(370,'653200000000','650000',0,'和田地区'),(371,'654000000000','650000',0,'伊犁哈萨克自治州'),(372,'654200000000','650000',0,'塔城地区'),(373,'654300000000','650000',0,'阿勒泰地区'),(374,'659000000000','650000',0,'自治区直辖县级行政区划'),(375,'110101000000','110100000000',0,'东城区'),(376,'110102000000','110100000000',0,'西城区'),(377,'110105000000','110100000000',0,'朝阳区'),(378,'110106000000','110100000000',0,'丰台区'),(379,'110107000000','110100000000',0,'石景山区'),(380,'110108000000','110100000000',0,'海淀区'),(381,'110109000000','110100000000',0,'门头沟区'),(382,'110111000000','110100000000',0,'房山区'),(383,'110112000000','110100000000',0,'通州区'),(384,'110113000000','110100000000',0,'顺义区'),(385,'110114000000','110100000000',0,'昌平区'),(386,'110115000000','110100000000',0,'大兴区'),(387,'110116000000','110100000000',0,'怀柔区'),(388,'110117000000','110100000000',0,'平谷区'),(389,'110118000000','110100000000',0,'密云区'),(390,'110119000000','110100000000',0,'延庆区'),(391,'120101000000','120100000000',0,'和平区'),(392,'120102000000','120100000000',0,'河东区'),(393,'120103000000','120100000000',0,'河西区'),(394,'120104000000','120100000000',0,'南开区'),(395,'120105000000','120100000000',0,'河北区'),(396,'120106000000','120100000000',0,'红桥区'),(397,'120110000000','120100000000',0,'东丽区'),(398,'120111000000','120100000000',0,'西青区'),(399,'120112000000','120100000000',0,'津南区'),(400,'120113000000','120100000000',0,'北辰区'),(401,'120114000000','120100000000',0,'武清区'),(402,'120115000000','120100000000',0,'宝坻区'),(403,'120116000000','120100000000',0,'滨海新区'),(404,'120117000000','120100000000',0,'宁河区'),(405,'120118000000','120100000000',0,'静海区'),(406,'120119000000','120100000000',0,'蓟州区'),(407,'130101000000','130100000000',0,'市辖区'),(408,'130102000000','130100000000',0,'长安区'),(409,'130104000000','130100000000',0,'桥西区'),(410,'130105000000','130100000000',0,'新华区'),(411,'130107000000','130100000000',0,'井陉矿区'),(412,'130108000000','130100000000',0,'裕华区'),(413,'130109000000','130100000000',0,'藁城区'),(414,'130110000000','130100000000',0,'鹿泉区'),(415,'130111000000','130100000000',0,'栾城区'),(416,'130121000000','130100000000',0,'井陉县'),(417,'130123000000','130100000000',0,'正定县'),(418,'130125000000','130100000000',0,'行唐县'),(419,'130126000000','130100000000',0,'灵寿县'),(420,'130127000000','130100000000',0,'高邑县'),(421,'130128000000','130100000000',0,'深泽县'),(422,'130129000000','130100000000',0,'赞皇县'),(423,'130130000000','130100000000',0,'无极县'),(424,'130131000000','130100000000',0,'平山县'),(425,'130132000000','130100000000',0,'元氏县'),(426,'130133000000','130100000000',0,'赵县'),(427,'130171000000','130100000000',0,'石家庄高新技术产业开发区'),(428,'130172000000','130100000000',0,'石家庄循环化工园区'),(429,'130181000000','130100000000',0,'辛集市'),(430,'130183000000','130100000000',0,'晋州市'),(431,'130184000000','130100000000',0,'新乐市'),(432,'130201000000','130200000000',0,'市辖区'),(433,'130202000000','130200000000',0,'路南区'),(434,'130203000000','130200000000',0,'路北区'),(435,'130204000000','130200000000',0,'古冶区'),(436,'130205000000','130200000000',0,'开平区'),(437,'130207000000','130200000000',0,'丰南区'),(438,'130208000000','130200000000',0,'丰润区'),(439,'130209000000','130200000000',0,'曹妃甸区'),(440,'130224000000','130200000000',0,'滦南县'),(441,'130225000000','130200000000',0,'乐亭县'),(442,'130227000000','130200000000',0,'迁西县'),(443,'130229000000','130200000000',0,'玉田县'),(444,'130271000000','130200000000',0,'唐山市芦台经济技术开发区'),(445,'130272000000','130200000000',0,'唐山市汉沽管理区'),(446,'130273000000','130200000000',0,'唐山高新技术产业开发区'),(447,'130274000000','130200000000',0,'河北唐山海港经济开发区'),(448,'130281000000','130200000000',0,'遵化市'),(449,'130283000000','130200000000',0,'迁安市'),(450,'130284000000','130200000000',0,'滦州市'),(451,'130301000000','130300000000',0,'市辖区'),(452,'130302000000','130300000000',0,'海港区'),(453,'130303000000','130300000000',0,'山海关区'),(454,'130304000000','130300000000',0,'北戴河区'),(455,'130306000000','130300000000',0,'抚宁区'),(456,'130321000000','130300000000',0,'青龙满族自治县'),(457,'130322000000','130300000000',0,'昌黎县'),(458,'130324000000','130300000000',0,'卢龙县'),(459,'130371000000','130300000000',0,'秦皇岛市经济技术开发区'),(460,'130372000000','130300000000',0,'北戴河新区'),(461,'130401000000','130400000000',0,'市辖区'),(462,'130402000000','130400000000',0,'邯山区'),(463,'130403000000','130400000000',0,'丛台区'),(464,'130404000000','130400000000',0,'复兴区'),(465,'130406000000','130400000000',0,'峰峰矿区'),(466,'130407000000','130400000000',0,'肥乡区'),(467,'130408000000','130400000000',0,'永年区'),(468,'130423000000','130400000000',0,'临漳县'),(469,'130424000000','130400000000',0,'成安县'),(470,'130425000000','130400000000',0,'大名县'),(471,'130426000000','130400000000',0,'涉县'),(472,'130427000000','130400000000',0,'磁县'),(473,'130430000000','130400000000',0,'邱县'),(474,'130431000000','130400000000',0,'鸡泽县'),(475,'130432000000','130400000000',0,'广平县'),(476,'130433000000','130400000000',0,'馆陶县'),(477,'130434000000','130400000000',0,'魏县'),(478,'130435000000','130400000000',0,'曲周县'),(479,'130471000000','130400000000',0,'邯郸经济技术开发区'),(480,'130473000000','130400000000',0,'邯郸冀南新区'),(481,'130481000000','130400000000',0,'武安市'),(482,'130501000000','130500000000',0,'市辖区'),(483,'130502000000','130500000000',0,'桥东区'),(484,'130503000000','130500000000',0,'桥西区'),(485,'130521000000','130500000000',0,'邢台县'),(486,'130522000000','130500000000',0,'临城县'),(487,'130523000000','130500000000',0,'内丘县'),(488,'130524000000','130500000000',0,'柏乡县'),(489,'130525000000','130500000000',0,'隆尧县'),(490,'130526000000','130500000000',0,'任县'),(491,'130527000000','130500000000',0,'南和县'),(492,'130528000000','130500000000',0,'宁晋县'),(493,'130529000000','130500000000',0,'巨鹿县'),(494,'130530000000','130500000000',0,'新河县'),(495,'130531000000','130500000000',0,'广宗县'),(496,'130532000000','130500000000',0,'平乡县'),(497,'130533000000','130500000000',0,'威县'),(498,'130534000000','130500000000',0,'清河县'),(499,'130535000000','130500000000',0,'临西县'),(500,'130571000000','130500000000',0,'河北邢台经济开发区'),(501,'130581000000','130500000000',0,'南宫市'),(502,'130582000000','130500000000',0,'沙河市'),(503,'130601000000','130600000000',0,'市辖区'),(504,'130602000000','130600000000',0,'竞秀区'),(505,'130606000000','130600000000',0,'莲池区'),(506,'130607000000','130600000000',0,'满城区'),(507,'130608000000','130600000000',0,'清苑区'),(508,'130609000000','130600000000',0,'徐水区'),(509,'130623000000','130600000000',0,'涞水县'),(510,'130624000000','130600000000',0,'阜平县'),(511,'130626000000','130600000000',0,'定兴县'),(512,'130627000000','130600000000',0,'唐县'),(513,'130628000000','130600000000',0,'高阳县'),(514,'130629000000','130600000000',0,'容城县'),(515,'130630000000','130600000000',0,'涞源县'),(516,'130631000000','130600000000',0,'望都县'),(517,'130632000000','130600000000',0,'安新县'),(518,'130633000000','130600000000',0,'易县'),(519,'130634000000','130600000000',0,'曲阳县'),(520,'130635000000','130600000000',0,'蠡县'),(521,'130636000000','130600000000',0,'顺平县'),(522,'130637000000','130600000000',0,'博野县'),(523,'130638000000','130600000000',0,'雄县'),(524,'130671000000','130600000000',0,'保定高新技术产业开发区'),(525,'130672000000','130600000000',0,'保定白沟新城'),(526,'130681000000','130600000000',0,'涿州市'),(527,'130682000000','130600000000',0,'定州市'),(528,'130683000000','130600000000',0,'安国市'),(529,'130684000000','130600000000',0,'高碑店市'),(530,'130701000000','130700000000',0,'市辖区'),(531,'130702000000','130700000000',0,'桥东区'),(532,'130703000000','130700000000',0,'桥西区'),(533,'130705000000','130700000000',0,'宣化区'),(534,'130706000000','130700000000',0,'下花园区'),(535,'130708000000','130700000000',0,'万全区'),(536,'130709000000','130700000000',0,'崇礼区'),(537,'130722000000','130700000000',0,'张北县'),(538,'130723000000','130700000000',0,'康保县'),(539,'130724000000','130700000000',0,'沽源县'),(540,'130725000000','130700000000',0,'尚义县'),(541,'130726000000','130700000000',0,'蔚县'),(542,'130727000000','130700000000',0,'阳原县'),(543,'130728000000','130700000000',0,'怀安县'),(544,'130730000000','130700000000',0,'怀来县'),(545,'130731000000','130700000000',0,'涿鹿县'),(546,'130732000000','130700000000',0,'赤城县'),(547,'130771000000','130700000000',0,'张家口市高新技术产业开发区'),(548,'130772000000','130700000000',0,'张家口市察北管理区'),(549,'130773000000','130700000000',0,'张家口市塞北管理区'),(550,'130801000000','130800000000',0,'市辖区'),(551,'130802000000','130800000000',0,'双桥区'),(552,'130803000000','130800000000',0,'双滦区'),(553,'130804000000','130800000000',0,'鹰手营子矿区'),(554,'130821000000','130800000000',0,'承德县'),(555,'130822000000','130800000000',0,'兴隆县'),(556,'130824000000','130800000000',0,'滦平县'),(557,'130825000000','130800000000',0,'隆化县'),(558,'130826000000','130800000000',0,'丰宁满族自治县'),(559,'130827000000','130800000000',0,'宽城满族自治县'),(560,'130828000000','130800000000',0,'围场满族蒙古族自治县'),(561,'130871000000','130800000000',0,'承德高新技术产业开发区'),(562,'130881000000','130800000000',0,'平泉市'),(563,'130901000000','130900000000',0,'市辖区'),(564,'130902000000','130900000000',0,'新华区'),(565,'130903000000','130900000000',0,'运河区'),(566,'130921000000','130900000000',0,'沧县'),(567,'130922000000','130900000000',0,'青县'),(568,'130923000000','130900000000',0,'东光县'),(569,'130924000000','130900000000',0,'海兴县'),(570,'130925000000','130900000000',0,'盐山县'),(571,'130926000000','130900000000',0,'肃宁县'),(572,'130927000000','130900000000',0,'南皮县'),(573,'130928000000','130900000000',0,'吴桥县'),(574,'130929000000','130900000000',0,'献县'),(575,'130930000000','130900000000',0,'孟村回族自治县'),(576,'130971000000','130900000000',0,'河北沧州经济开发区'),(577,'130972000000','130900000000',0,'沧州高新技术产业开发区'),(578,'130973000000','130900000000',0,'沧州渤海新区'),(579,'130981000000','130900000000',0,'泊头市'),(580,'130982000000','130900000000',0,'任丘市'),(581,'130983000000','130900000000',0,'黄骅市'),(582,'130984000000','130900000000',0,'河间市'),(583,'131001000000','131000000000',0,'市辖区'),(584,'131002000000','131000000000',0,'安次区'),(585,'131003000000','131000000000',0,'广阳区'),(586,'131022000000','131000000000',0,'固安县'),(587,'131023000000','131000000000',0,'永清县'),(588,'131024000000','131000000000',0,'香河县'),(589,'131025000000','131000000000',0,'大城县'),(590,'131026000000','131000000000',0,'文安县'),(591,'131028000000','131000000000',0,'大厂回族自治县'),(592,'131071000000','131000000000',0,'廊坊经济技术开发区'),(593,'131081000000','131000000000',0,'霸州市'),(594,'131082000000','131000000000',0,'三河市'),(595,'131101000000','131100000000',0,'市辖区'),(596,'131102000000','131100000000',0,'桃城区'),(597,'131103000000','131100000000',0,'冀州区'),(598,'131121000000','131100000000',0,'枣强县'),(599,'131122000000','131100000000',0,'武邑县'),(600,'131123000000','131100000000',0,'武强县'),(601,'131124000000','131100000000',0,'饶阳县'),(602,'131125000000','131100000000',0,'安平县'),(603,'131126000000','131100000000',0,'故城县'),(604,'131127000000','131100000000',0,'景县'),(605,'131128000000','131100000000',0,'阜城县'),(606,'131171000000','131100000000',0,'河北衡水高新技术产业开发区'),(607,'131172000000','131100000000',0,'衡水滨湖新区'),(608,'131182000000','131100000000',0,'深州市'),(609,'140101000000','140100000000',0,'市辖区'),(610,'140105000000','140100000000',0,'小店区'),(611,'140106000000','140100000000',0,'迎泽区'),(612,'140107000000','140100000000',0,'杏花岭区'),(613,'140108000000','140100000000',0,'尖草坪区'),(614,'140109000000','140100000000',0,'万柏林区'),(615,'140110000000','140100000000',0,'晋源区'),(616,'140121000000','140100000000',0,'清徐县'),(617,'140122000000','140100000000',0,'阳曲县'),(618,'140123000000','140100000000',0,'娄烦县'),(619,'140171000000','140100000000',0,'山西转型综合改革示范区'),(620,'140181000000','140100000000',0,'古交市'),(621,'140201000000','140200000000',0,'市辖区'),(622,'140212000000','140200000000',0,'新荣区'),(623,'140213000000','140200000000',0,'平城区'),(624,'140214000000','140200000000',0,'云冈区'),(625,'140215000000','140200000000',0,'云州区'),(626,'140221000000','140200000000',0,'阳高县'),(627,'140222000000','140200000000',0,'天镇县'),(628,'140223000000','140200000000',0,'广灵县'),(629,'140224000000','140200000000',0,'灵丘县'),(630,'140225000000','140200000000',0,'浑源县'),(631,'140226000000','140200000000',0,'左云县'),(632,'140271000000','140200000000',0,'山西大同经济开发区'),(633,'140301000000','140300000000',0,'市辖区'),(634,'140302000000','140300000000',0,'城区'),(635,'140303000000','140300000000',0,'矿区'),(636,'140311000000','140300000000',0,'郊区'),(637,'140321000000','140300000000',0,'平定县'),(638,'140322000000','140300000000',0,'盂县'),(639,'140401000000','140400000000',0,'市辖区'),(640,'140403000000','140400000000',0,'潞州区'),(641,'140404000000','140400000000',0,'上党区'),(642,'140405000000','140400000000',0,'屯留区'),(643,'140406000000','140400000000',0,'潞城区'),(644,'140423000000','140400000000',0,'襄垣县'),(645,'140425000000','140400000000',0,'平顺县'),(646,'140426000000','140400000000',0,'黎城县'),(647,'140427000000','140400000000',0,'壶关县'),(648,'140428000000','140400000000',0,'长子县'),(649,'140429000000','140400000000',0,'武乡县'),(650,'140430000000','140400000000',0,'沁县'),(651,'140431000000','140400000000',0,'沁源县'),(652,'140471000000','140400000000',0,'山西长治高新技术产业园区'),(653,'140501000000','140500000000',0,'市辖区'),(654,'140502000000','140500000000',0,'城区'),(655,'140521000000','140500000000',0,'沁水县'),(656,'140522000000','140500000000',0,'阳城县'),(657,'140524000000','140500000000',0,'陵川县'),(658,'140525000000','140500000000',0,'泽州县'),(659,'140581000000','140500000000',0,'高平市'),(660,'140601000000','140600000000',0,'市辖区'),(661,'140602000000','140600000000',0,'朔城区'),(662,'140603000000','140600000000',0,'平鲁区'),(663,'140621000000','140600000000',0,'山阴县'),(664,'140622000000','140600000000',0,'应县'),(665,'140623000000','140600000000',0,'右玉县'),(666,'140671000000','140600000000',0,'山西朔州经济开发区'),(667,'140681000000','140600000000',0,'怀仁市'),(668,'140701000000','140700000000',0,'市辖区'),(669,'140702000000','140700000000',0,'榆次区'),(670,'140721000000','140700000000',0,'榆社县'),(671,'140722000000','140700000000',0,'左权县'),(672,'140723000000','140700000000',0,'和顺县'),(673,'140724000000','140700000000',0,'昔阳县'),(674,'140725000000','140700000000',0,'寿阳县'),(675,'140726000000','140700000000',0,'太谷县'),(676,'140727000000','140700000000',0,'祁县'),(677,'140728000000','140700000000',0,'平遥县'),(678,'140729000000','140700000000',0,'灵石县'),(679,'140781000000','140700000000',0,'介休市'),(680,'140801000000','140800000000',0,'市辖区'),(681,'140802000000','140800000000',0,'盐湖区'),(682,'140821000000','140800000000',0,'临猗县'),(683,'140822000000','140800000000',0,'万荣县'),(684,'140823000000','140800000000',0,'闻喜县'),(685,'140824000000','140800000000',0,'稷山县'),(686,'140825000000','140800000000',0,'新绛县'),(687,'140826000000','140800000000',0,'绛县'),(688,'140827000000','140800000000',0,'垣曲县'),(689,'140828000000','140800000000',0,'夏县'),(690,'140829000000','140800000000',0,'平陆县'),(691,'140830000000','140800000000',0,'芮城县'),(692,'140881000000','140800000000',0,'永济市'),(693,'140882000000','140800000000',0,'河津市'),(694,'140901000000','140900000000',0,'市辖区'),(695,'140902000000','140900000000',0,'忻府区'),(696,'140921000000','140900000000',0,'定襄县'),(697,'140922000000','140900000000',0,'五台县'),(698,'140923000000','140900000000',0,'代县'),(699,'140924000000','140900000000',0,'繁峙县'),(700,'140925000000','140900000000',0,'宁武县'),(701,'140926000000','140900000000',0,'静乐县'),(702,'140927000000','140900000000',0,'神池县'),(703,'140928000000','140900000000',0,'五寨县'),(704,'140929000000','140900000000',0,'岢岚县'),(705,'140930000000','140900000000',0,'河曲县'),(706,'140931000000','140900000000',0,'保德县'),(707,'140932000000','140900000000',0,'偏关县'),(708,'140971000000','140900000000',0,'五台山风景名胜区'),(709,'140981000000','140900000000',0,'原平市'),(710,'141001000000','141000000000',0,'市辖区'),(711,'141002000000','141000000000',0,'尧都区'),(712,'141021000000','141000000000',0,'曲沃县'),(713,'141022000000','141000000000',0,'翼城县'),(714,'141023000000','141000000000',0,'襄汾县'),(715,'141024000000','141000000000',0,'洪洞县'),(716,'141025000000','141000000000',0,'古县'),(717,'141026000000','141000000000',0,'安泽县'),(718,'141027000000','141000000000',0,'浮山县'),(719,'141028000000','141000000000',0,'吉县'),(720,'141029000000','141000000000',0,'乡宁县'),(721,'141030000000','141000000000',0,'大宁县'),(722,'141031000000','141000000000',0,'隰县'),(723,'141032000000','141000000000',0,'永和县'),(724,'141033000000','141000000000',0,'蒲县'),(725,'141034000000','141000000000',0,'汾西县'),(726,'141081000000','141000000000',0,'侯马市'),(727,'141082000000','141000000000',0,'霍州市'),(728,'141101000000','141100000000',0,'市辖区'),(729,'141102000000','141100000000',0,'离石区'),(730,'141121000000','141100000000',0,'文水县'),(731,'141122000000','141100000000',0,'交城县'),(732,'141123000000','141100000000',0,'兴县'),(733,'141124000000','141100000000',0,'临县'),(734,'141125000000','141100000000',0,'柳林县'),(735,'141126000000','141100000000',0,'石楼县'),(736,'141127000000','141100000000',0,'岚县'),(737,'141128000000','141100000000',0,'方山县'),(738,'141129000000','141100000000',0,'中阳县'),(739,'141130000000','141100000000',0,'交口县'),(740,'141181000000','141100000000',0,'孝义市'),(741,'141182000000','141100000000',0,'汾阳市'),(742,'150101000000','150100000000',0,'市辖区'),(743,'150102000000','150100000000',0,'新城区'),(744,'150103000000','150100000000',0,'回民区'),(745,'150104000000','150100000000',0,'玉泉区'),(746,'150105000000','150100000000',0,'赛罕区'),(747,'150121000000','150100000000',0,'土默特左旗'),(748,'150122000000','150100000000',0,'托克托县'),(749,'150123000000','150100000000',0,'和林格尔县'),(750,'150124000000','150100000000',0,'清水河县'),(751,'150125000000','150100000000',0,'武川县'),(752,'150171000000','150100000000',0,'呼和浩特金海工业园区'),(753,'150172000000','150100000000',0,'呼和浩特经济技术开发区'),(754,'150201000000','150200000000',0,'市辖区'),(755,'150202000000','150200000000',0,'东河区'),(756,'150203000000','150200000000',0,'昆都仑区'),(757,'150204000000','150200000000',0,'青山区'),(758,'150205000000','150200000000',0,'石拐区'),(759,'150206000000','150200000000',0,'白云鄂博矿区'),(760,'150207000000','150200000000',0,'九原区'),(761,'150221000000','150200000000',0,'土默特右旗'),(762,'150222000000','150200000000',0,'固阳县'),(763,'150223000000','150200000000',0,'达尔罕茂明安联合旗'),(764,'150271000000','150200000000',0,'包头稀土高新技术产业开发区'),(765,'150301000000','150300000000',0,'市辖区'),(766,'150302000000','150300000000',0,'海勃湾区'),(767,'150303000000','150300000000',0,'海南区'),(768,'150304000000','150300000000',0,'乌达区'),(769,'150401000000','150400000000',0,'市辖区'),(770,'150402000000','150400000000',0,'红山区'),(771,'150403000000','150400000000',0,'元宝山区'),(772,'150404000000','150400000000',0,'松山区'),(773,'150421000000','150400000000',0,'阿鲁科尔沁旗'),(774,'150422000000','150400000000',0,'巴林左旗'),(775,'150423000000','150400000000',0,'巴林右旗'),(776,'150424000000','150400000000',0,'林西县'),(777,'150425000000','150400000000',0,'克什克腾旗'),(778,'150426000000','150400000000',0,'翁牛特旗'),(779,'150428000000','150400000000',0,'喀喇沁旗'),(780,'150429000000','150400000000',0,'宁城县'),(781,'150430000000','150400000000',0,'敖汉旗'),(782,'150501000000','150500000000',0,'市辖区'),(783,'150502000000','150500000000',0,'科尔沁区'),(784,'150521000000','150500000000',0,'科尔沁左翼中旗'),(785,'150522000000','150500000000',0,'科尔沁左翼后旗'),(786,'150523000000','150500000000',0,'开鲁县'),(787,'150524000000','150500000000',0,'库伦旗'),(788,'150525000000','150500000000',0,'奈曼旗'),(789,'150526000000','150500000000',0,'扎鲁特旗'),(790,'150571000000','150500000000',0,'通辽经济技术开发区'),(791,'150581000000','150500000000',0,'霍林郭勒市'),(792,'150601000000','150600000000',0,'市辖区'),(793,'150602000000','150600000000',0,'东胜区'),(794,'150603000000','150600000000',0,'康巴什区'),(795,'150621000000','150600000000',0,'达拉特旗'),(796,'150622000000','150600000000',0,'准格尔旗'),(797,'150623000000','150600000000',0,'鄂托克前旗'),(798,'150624000000','150600000000',0,'鄂托克旗'),(799,'150625000000','150600000000',0,'杭锦旗'),(800,'150626000000','150600000000',0,'乌审旗'),(801,'150627000000','150600000000',0,'伊金霍洛旗'),(802,'150701000000','150700000000',0,'市辖区'),(803,'150702000000','150700000000',0,'海拉尔区'),(804,'150703000000','150700000000',0,'扎赉诺尔区'),(805,'150721000000','150700000000',0,'阿荣旗'),(806,'150722000000','150700000000',0,'莫力达瓦达斡尔族自治旗'),(807,'150723000000','150700000000',0,'鄂伦春自治旗'),(808,'150724000000','150700000000',0,'鄂温克族自治旗'),(809,'150725000000','150700000000',0,'陈巴尔虎旗'),(810,'150726000000','150700000000',0,'新巴尔虎左旗'),(811,'150727000000','150700000000',0,'新巴尔虎右旗'),(812,'150781000000','150700000000',0,'满洲里市'),(813,'150782000000','150700000000',0,'牙克石市'),(814,'150783000000','150700000000',0,'扎兰屯市'),(815,'150784000000','150700000000',0,'额尔古纳市'),(816,'150785000000','150700000000',0,'根河市'),(817,'150801000000','150800000000',0,'市辖区'),(818,'150802000000','150800000000',0,'临河区'),(819,'150821000000','150800000000',0,'五原县'),(820,'150822000000','150800000000',0,'磴口县'),(821,'150823000000','150800000000',0,'乌拉特前旗'),(822,'150824000000','150800000000',0,'乌拉特中旗'),(823,'150825000000','150800000000',0,'乌拉特后旗'),(824,'150826000000','150800000000',0,'杭锦后旗'),(825,'150901000000','150900000000',0,'市辖区'),(826,'150902000000','150900000000',0,'集宁区'),(827,'150921000000','150900000000',0,'卓资县'),(828,'150922000000','150900000000',0,'化德县'),(829,'150923000000','150900000000',0,'商都县'),(830,'150924000000','150900000000',0,'兴和县'),(831,'150925000000','150900000000',0,'凉城县'),(832,'150926000000','150900000000',0,'察哈尔右翼前旗'),(833,'150927000000','150900000000',0,'察哈尔右翼中旗'),(834,'150928000000','150900000000',0,'察哈尔右翼后旗'),(835,'150929000000','150900000000',0,'四子王旗'),(836,'150981000000','150900000000',0,'丰镇市'),(837,'152201000000','152200000000',0,'乌兰浩特市'),(838,'152202000000','152200000000',0,'阿尔山市'),(839,'152221000000','152200000000',0,'科尔沁右翼前旗'),(840,'152222000000','152200000000',0,'科尔沁右翼中旗'),(841,'152223000000','152200000000',0,'扎赉特旗'),(842,'152224000000','152200000000',0,'突泉县'),(843,'152501000000','152500000000',0,'二连浩特市'),(844,'152502000000','152500000000',0,'锡林浩特市'),(845,'152522000000','152500000000',0,'阿巴嘎旗'),(846,'152523000000','152500000000',0,'苏尼特左旗'),(847,'152524000000','152500000000',0,'苏尼特右旗'),(848,'152525000000','152500000000',0,'东乌珠穆沁旗'),(849,'152526000000','152500000000',0,'西乌珠穆沁旗'),(850,'152527000000','152500000000',0,'太仆寺旗'),(851,'152528000000','152500000000',0,'镶黄旗'),(852,'152529000000','152500000000',0,'正镶白旗'),(853,'152530000000','152500000000',0,'正蓝旗'),(854,'152531000000','152500000000',0,'多伦县'),(855,'152571000000','152500000000',0,'乌拉盖管委会'),(856,'152921000000','152900000000',0,'阿拉善左旗'),(857,'152922000000','152900000000',0,'阿拉善右旗'),(858,'152923000000','152900000000',0,'额济纳旗'),(859,'152971000000','152900000000',0,'内蒙古阿拉善经济开发区'),(860,'210101000000','210100000000',0,'市辖区'),(861,'210102000000','210100000000',0,'和平区'),(862,'210103000000','210100000000',0,'沈河区'),(863,'210104000000','210100000000',0,'大东区'),(864,'210105000000','210100000000',0,'皇姑区'),(865,'210106000000','210100000000',0,'铁西区'),(866,'210111000000','210100000000',0,'苏家屯区'),(867,'210112000000','210100000000',0,'浑南区'),(868,'210113000000','210100000000',0,'沈北新区'),(869,'210114000000','210100000000',0,'于洪区'),(870,'210115000000','210100000000',0,'辽中区'),(871,'210123000000','210100000000',0,'康平县'),(872,'210124000000','210100000000',0,'法库县'),(873,'210181000000','210100000000',0,'新民市'),(874,'210201000000','210200000000',0,'市辖区'),(875,'210202000000','210200000000',0,'中山区'),(876,'210203000000','210200000000',0,'西岗区'),(877,'210204000000','210200000000',0,'沙河口区'),(878,'210211000000','210200000000',0,'甘井子区'),(879,'210212000000','210200000000',0,'旅顺口区'),(880,'210213000000','210200000000',0,'金州区'),(881,'210214000000','210200000000',0,'普兰店区'),(882,'210224000000','210200000000',0,'长海县'),(883,'210281000000','210200000000',0,'瓦房店市'),(884,'210283000000','210200000000',0,'庄河市'),(885,'210301000000','210300000000',0,'市辖区'),(886,'210302000000','210300000000',0,'铁东区'),(887,'210303000000','210300000000',0,'铁西区'),(888,'210304000000','210300000000',0,'立山区'),(889,'210311000000','210300000000',0,'千山区'),(890,'210321000000','210300000000',0,'台安县'),(891,'210323000000','210300000000',0,'岫岩满族自治县'),(892,'210381000000','210300000000',0,'海城市'),(893,'210401000000','210400000000',0,'市辖区'),(894,'210402000000','210400000000',0,'新抚区'),(895,'210403000000','210400000000',0,'东洲区'),(896,'210404000000','210400000000',0,'望花区'),(897,'210411000000','210400000000',0,'顺城区'),(898,'210421000000','210400000000',0,'抚顺县'),(899,'210422000000','210400000000',0,'新宾满族自治县'),(900,'210423000000','210400000000',0,'清原满族自治县'),(901,'210501000000','210500000000',0,'市辖区'),(902,'210502000000','210500000000',0,'平山区'),(903,'210503000000','210500000000',0,'溪湖区'),(904,'210504000000','210500000000',0,'明山区'),(905,'210505000000','210500000000',0,'南芬区'),(906,'210521000000','210500000000',0,'本溪满族自治县'),(907,'210522000000','210500000000',0,'桓仁满族自治县'),(908,'210601000000','210600000000',0,'市辖区'),(909,'210602000000','210600000000',0,'元宝区'),(910,'210603000000','210600000000',0,'振兴区'),(911,'210604000000','210600000000',0,'振安区'),(912,'210624000000','210600000000',0,'宽甸满族自治县'),(913,'210681000000','210600000000',0,'东港市'),(914,'210682000000','210600000000',0,'凤城市'),(915,'210701000000','210700000000',0,'市辖区'),(916,'210702000000','210700000000',0,'古塔区'),(917,'210703000000','210700000000',0,'凌河区'),(918,'210711000000','210700000000',0,'太和区'),(919,'210726000000','210700000000',0,'黑山县'),(920,'210727000000','210700000000',0,'义县'),(921,'210781000000','210700000000',0,'凌海市'),(922,'210782000000','210700000000',0,'北镇市'),(923,'210801000000','210800000000',0,'市辖区'),(924,'210802000000','210800000000',0,'站前区'),(925,'210803000000','210800000000',0,'西市区'),(926,'210804000000','210800000000',0,'鲅鱼圈区'),(927,'210811000000','210800000000',0,'老边区'),(928,'210881000000','210800000000',0,'盖州市'),(929,'210882000000','210800000000',0,'大石桥市'),(930,'210901000000','210900000000',0,'市辖区'),(931,'210902000000','210900000000',0,'海州区'),(932,'210903000000','210900000000',0,'新邱区'),(933,'210904000000','210900000000',0,'太平区'),(934,'210905000000','210900000000',0,'清河门区'),(935,'210911000000','210900000000',0,'细河区'),(936,'210921000000','210900000000',0,'阜新蒙古族自治县'),(937,'210922000000','210900000000',0,'彰武县'),(938,'211001000000','211000000000',0,'市辖区'),(939,'211002000000','211000000000',0,'白塔区'),(940,'211003000000','211000000000',0,'文圣区'),(941,'211004000000','211000000000',0,'宏伟区'),(942,'211005000000','211000000000',0,'弓长岭区'),(943,'211011000000','211000000000',0,'太子河区'),(944,'211021000000','211000000000',0,'辽阳县'),(945,'211081000000','211000000000',0,'灯塔市'),(946,'211101000000','211100000000',0,'市辖区'),(947,'211102000000','211100000000',0,'双台子区'),(948,'211103000000','211100000000',0,'兴隆台区'),(949,'211104000000','211100000000',0,'大洼区'),(950,'211122000000','211100000000',0,'盘山县'),(951,'211201000000','211200000000',0,'市辖区'),(952,'211202000000','211200000000',0,'银州区'),(953,'211204000000','211200000000',0,'清河区'),(954,'211221000000','211200000000',0,'铁岭县'),(955,'211223000000','211200000000',0,'西丰县'),(956,'211224000000','211200000000',0,'昌图县'),(957,'211281000000','211200000000',0,'调兵山市'),(958,'211282000000','211200000000',0,'开原市'),(959,'211301000000','211300000000',0,'市辖区'),(960,'211302000000','211300000000',0,'双塔区'),(961,'211303000000','211300000000',0,'龙城区'),(962,'211321000000','211300000000',0,'朝阳县'),(963,'211322000000','211300000000',0,'建平县'),(964,'211324000000','211300000000',0,'喀喇沁左翼蒙古族自治县'),(965,'211381000000','211300000000',0,'北票市'),(966,'211382000000','211300000000',0,'凌源市'),(967,'211401000000','211400000000',0,'市辖区'),(968,'211402000000','211400000000',0,'连山区'),(969,'211403000000','211400000000',0,'龙港区'),(970,'211404000000','211400000000',0,'南票区'),(971,'211421000000','211400000000',0,'绥中县'),(972,'211422000000','211400000000',0,'建昌县'),(973,'211481000000','211400000000',0,'兴城市'),(974,'220101000000','220100000000',0,'市辖区'),(975,'220102000000','220100000000',0,'南关区'),(976,'220103000000','220100000000',0,'宽城区'),(977,'220104000000','220100000000',0,'朝阳区'),(978,'220105000000','220100000000',0,'二道区'),(979,'220106000000','220100000000',0,'绿园区'),(980,'220112000000','220100000000',0,'双阳区'),(981,'220113000000','220100000000',0,'九台区'),(982,'220122000000','220100000000',0,'农安县'),(983,'220171000000','220100000000',0,'长春经济技术开发区'),(984,'220172000000','220100000000',0,'长春净月高新技术产业开发区'),(985,'220173000000','220100000000',0,'长春高新技术产业开发区'),(986,'220174000000','220100000000',0,'长春汽车经济技术开发区'),(987,'220182000000','220100000000',0,'榆树市'),(988,'220183000000','220100000000',0,'德惠市'),(989,'220201000000','220200000000',0,'市辖区'),(990,'220202000000','220200000000',0,'昌邑区'),(991,'220203000000','220200000000',0,'龙潭区'),(992,'220204000000','220200000000',0,'船营区'),(993,'220211000000','220200000000',0,'丰满区'),(994,'220221000000','220200000000',0,'永吉县'),(995,'220271000000','220200000000',0,'吉林经济开发区'),(996,'220272000000','220200000000',0,'吉林高新技术产业开发区'),(997,'220273000000','220200000000',0,'吉林中国新加坡食品区'),(998,'220281000000','220200000000',0,'蛟河市'),(999,'220282000000','220200000000',0,'桦甸市'),(1000,'220283000000','220200000000',0,'舒兰市'),(1001,'220284000000','220200000000',0,'磐石市'),(1002,'220301000000','220300000000',0,'市辖区'),(1003,'220302000000','220300000000',0,'铁西区'),(1004,'220303000000','220300000000',0,'铁东区'),(1005,'220322000000','220300000000',0,'梨树县'),(1006,'220323000000','220300000000',0,'伊通满族自治县'),(1007,'220381000000','220300000000',0,'公主岭市'),(1008,'220382000000','220300000000',0,'双辽市'),(1009,'220401000000','220400000000',0,'市辖区'),(1010,'220402000000','220400000000',0,'龙山区'),(1011,'220403000000','220400000000',0,'西安区'),(1012,'220421000000','220400000000',0,'东丰县'),(1013,'220422000000','220400000000',0,'东辽县'),(1014,'220501000000','220500000000',0,'市辖区'),(1015,'220502000000','220500000000',0,'东昌区'),(1016,'220503000000','220500000000',0,'二道江区'),(1017,'220521000000','220500000000',0,'通化县'),(1018,'220523000000','220500000000',0,'辉南县'),(1019,'220524000000','220500000000',0,'柳河县'),(1020,'220581000000','220500000000',0,'梅河口市'),(1021,'220582000000','220500000000',0,'集安市'),(1022,'220601000000','220600000000',0,'市辖区'),(1023,'220602000000','220600000000',0,'浑江区'),(1024,'220605000000','220600000000',0,'江源区'),(1025,'220621000000','220600000000',0,'抚松县'),(1026,'220622000000','220600000000',0,'靖宇县'),(1027,'220623000000','220600000000',0,'长白朝鲜族自治县'),(1028,'220681000000','220600000000',0,'临江市'),(1029,'220701000000','220700000000',0,'市辖区'),(1030,'220702000000','220700000000',0,'宁江区'),(1031,'220721000000','220700000000',0,'前郭尔罗斯蒙古族自治县'),(1032,'220722000000','220700000000',0,'长岭县'),(1033,'220723000000','220700000000',0,'乾安县'),(1034,'220771000000','220700000000',0,'吉林松原经济开发区'),(1035,'220781000000','220700000000',0,'扶余市'),(1036,'220801000000','220800000000',0,'市辖区'),(1037,'220802000000','220800000000',0,'洮北区'),(1038,'220821000000','220800000000',0,'镇赉县'),(1039,'220822000000','220800000000',0,'通榆县'),(1040,'220871000000','220800000000',0,'吉林白城经济开发区'),(1041,'220881000000','220800000000',0,'洮南市'),(1042,'220882000000','220800000000',0,'大安市'),(1043,'222401000000','222400000000',0,'延吉市'),(1044,'222402000000','222400000000',0,'图们市'),(1045,'222403000000','222400000000',0,'敦化市'),(1046,'222404000000','222400000000',0,'珲春市'),(1047,'222405000000','222400000000',0,'龙井市'),(1048,'222406000000','222400000000',0,'和龙市'),(1049,'222424000000','222400000000',0,'汪清县'),(1050,'222426000000','222400000000',0,'安图县'),(1051,'230101000000','230100000000',0,'市辖区'),(1052,'230102000000','230100000000',0,'道里区'),(1053,'230103000000','230100000000',0,'南岗区'),(1054,'230104000000','230100000000',0,'道外区'),(1055,'230108000000','230100000000',0,'平房区'),(1056,'230109000000','230100000000',0,'松北区'),(1057,'230110000000','230100000000',0,'香坊区'),(1058,'230111000000','230100000000',0,'呼兰区'),(1059,'230112000000','230100000000',0,'阿城区'),(1060,'230113000000','230100000000',0,'双城区'),(1061,'230123000000','230100000000',0,'依兰县'),(1062,'230124000000','230100000000',0,'方正县'),(1063,'230125000000','230100000000',0,'宾县'),(1064,'230126000000','230100000000',0,'巴彦县'),(1065,'230127000000','230100000000',0,'木兰县'),(1066,'230128000000','230100000000',0,'通河县'),(1067,'230129000000','230100000000',0,'延寿县'),(1068,'230183000000','230100000000',0,'尚志市'),(1069,'230184000000','230100000000',0,'五常市'),(1070,'230201000000','230200000000',0,'市辖区'),(1071,'230202000000','230200000000',0,'龙沙区'),(1072,'230203000000','230200000000',0,'建华区'),(1073,'230204000000','230200000000',0,'铁锋区'),(1074,'230205000000','230200000000',0,'昂昂溪区'),(1075,'230206000000','230200000000',0,'富拉尔基区'),(1076,'230207000000','230200000000',0,'碾子山区'),(1077,'230208000000','230200000000',0,'梅里斯达斡尔族区'),(1078,'230221000000','230200000000',0,'龙江县'),(1079,'230223000000','230200000000',0,'依安县'),(1080,'230224000000','230200000000',0,'泰来县'),(1081,'230225000000','230200000000',0,'甘南县'),(1082,'230227000000','230200000000',0,'富裕县'),(1083,'230229000000','230200000000',0,'克山县'),(1084,'230230000000','230200000000',0,'克东县'),(1085,'230231000000','230200000000',0,'拜泉县'),(1086,'230281000000','230200000000',0,'讷河市'),(1087,'230301000000','230300000000',0,'市辖区'),(1088,'230302000000','230300000000',0,'鸡冠区'),(1089,'230303000000','230300000000',0,'恒山区'),(1090,'230304000000','230300000000',0,'滴道区'),(1091,'230305000000','230300000000',0,'梨树区'),(1092,'230306000000','230300000000',0,'城子河区'),(1093,'230307000000','230300000000',0,'麻山区'),(1094,'230321000000','230300000000',0,'鸡东县'),(1095,'230381000000','230300000000',0,'虎林市'),(1096,'230382000000','230300000000',0,'密山市'),(1097,'230401000000','230400000000',0,'市辖区'),(1098,'230402000000','230400000000',0,'向阳区'),(1099,'230403000000','230400000000',0,'工农区'),(1100,'230404000000','230400000000',0,'南山区'),(1101,'230405000000','230400000000',0,'兴安区'),(1102,'230406000000','230400000000',0,'东山区'),(1103,'230407000000','230400000000',0,'兴山区'),(1104,'230421000000','230400000000',0,'萝北县'),(1105,'230422000000','230400000000',0,'绥滨县'),(1106,'230501000000','230500000000',0,'市辖区'),(1107,'230502000000','230500000000',0,'尖山区'),(1108,'230503000000','230500000000',0,'岭东区'),(1109,'230505000000','230500000000',0,'四方台区'),(1110,'230506000000','230500000000',0,'宝山区'),(1111,'230521000000','230500000000',0,'集贤县'),(1112,'230522000000','230500000000',0,'友谊县'),(1113,'230523000000','230500000000',0,'宝清县'),(1114,'230524000000','230500000000',0,'饶河县'),(1115,'230601000000','230600000000',0,'市辖区'),(1116,'230602000000','230600000000',0,'萨尔图区'),(1117,'230603000000','230600000000',0,'龙凤区'),(1118,'230604000000','230600000000',0,'让胡路区'),(1119,'230605000000','230600000000',0,'红岗区'),(1120,'230606000000','230600000000',0,'大同区'),(1121,'230621000000','230600000000',0,'肇州县'),(1122,'230622000000','230600000000',0,'肇源县'),(1123,'230623000000','230600000000',0,'林甸县'),(1124,'230624000000','230600000000',0,'杜尔伯特蒙古族自治县'),(1125,'230671000000','230600000000',0,'大庆高新技术产业开发区'),(1126,'230701000000','230700000000',0,'市辖区'),(1127,'230702000000','230700000000',0,'伊春区'),(1128,'230703000000','230700000000',0,'南岔区'),(1129,'230704000000','230700000000',0,'友好区'),(1130,'230705000000','230700000000',0,'西林区'),(1131,'230706000000','230700000000',0,'翠峦区'),(1132,'230707000000','230700000000',0,'新青区'),(1133,'230708000000','230700000000',0,'美溪区'),(1134,'230709000000','230700000000',0,'金山屯区'),(1135,'230710000000','230700000000',0,'五营区'),(1136,'230711000000','230700000000',0,'乌马河区'),(1137,'230712000000','230700000000',0,'汤旺河区'),(1138,'230713000000','230700000000',0,'带岭区'),(1139,'230714000000','230700000000',0,'乌伊岭区'),(1140,'230715000000','230700000000',0,'红星区'),(1141,'230716000000','230700000000',0,'上甘岭区'),(1142,'230722000000','230700000000',0,'嘉荫县'),(1143,'230781000000','230700000000',0,'铁力市'),(1144,'230801000000','230800000000',0,'市辖区'),(1145,'230803000000','230800000000',0,'向阳区'),(1146,'230804000000','230800000000',0,'前进区'),(1147,'230805000000','230800000000',0,'东风区'),(1148,'230811000000','230800000000',0,'郊区'),(1149,'230822000000','230800000000',0,'桦南县'),(1150,'230826000000','230800000000',0,'桦川县'),(1151,'230828000000','230800000000',0,'汤原县'),(1152,'230881000000','230800000000',0,'同江市'),(1153,'230882000000','230800000000',0,'富锦市'),(1154,'230883000000','230800000000',0,'抚远市'),(1155,'230901000000','230900000000',0,'市辖区'),(1156,'230902000000','230900000000',0,'新兴区'),(1157,'230903000000','230900000000',0,'桃山区'),(1158,'230904000000','230900000000',0,'茄子河区'),(1159,'230921000000','230900000000',0,'勃利县'),(1160,'231001000000','231000000000',0,'市辖区'),(1161,'231002000000','231000000000',0,'东安区'),(1162,'231003000000','231000000000',0,'阳明区'),(1163,'231004000000','231000000000',0,'爱民区'),(1164,'231005000000','231000000000',0,'西安区'),(1165,'231025000000','231000000000',0,'林口县'),(1166,'231071000000','231000000000',0,'牡丹江经济技术开发区'),(1167,'231081000000','231000000000',0,'绥芬河市'),(1168,'231083000000','231000000000',0,'海林市'),(1169,'231084000000','231000000000',0,'宁安市'),(1170,'231085000000','231000000000',0,'穆棱市'),(1171,'231086000000','231000000000',0,'东宁市'),(1172,'231101000000','231100000000',0,'市辖区'),(1173,'231102000000','231100000000',0,'爱辉区'),(1174,'231121000000','231100000000',0,'嫩江县'),(1175,'231123000000','231100000000',0,'逊克县'),(1176,'231124000000','231100000000',0,'孙吴县'),(1177,'231181000000','231100000000',0,'北安市'),(1178,'231182000000','231100000000',0,'五大连池市'),(1179,'231201000000','231200000000',0,'市辖区'),(1180,'231202000000','231200000000',0,'北林区'),(1181,'231221000000','231200000000',0,'望奎县'),(1182,'231222000000','231200000000',0,'兰西县'),(1183,'231223000000','231200000000',0,'青冈县'),(1184,'231224000000','231200000000',0,'庆安县'),(1185,'231225000000','231200000000',0,'明水县'),(1186,'231226000000','231200000000',0,'绥棱县'),(1187,'231281000000','231200000000',0,'安达市'),(1188,'231282000000','231200000000',0,'肇东市'),(1189,'231283000000','231200000000',0,'海伦市'),(1190,'232701000000','232700000000',0,'漠河市'),(1191,'232721000000','232700000000',0,'呼玛县'),(1192,'232722000000','232700000000',0,'塔河县'),(1193,'232761000000','232700000000',0,'加格达奇区'),(1194,'232762000000','232700000000',0,'松岭区'),(1195,'232763000000','232700000000',0,'新林区'),(1196,'232764000000','232700000000',0,'呼中区'),(1197,'310101000000','310100000000',0,'黄浦区'),(1198,'310104000000','310100000000',0,'徐汇区'),(1199,'310105000000','310100000000',0,'长宁区'),(1200,'310106000000','310100000000',0,'静安区'),(1201,'310107000000','310100000000',0,'普陀区'),(1202,'310109000000','310100000000',0,'虹口区'),(1203,'310110000000','310100000000',0,'杨浦区'),(1204,'310112000000','310100000000',0,'闵行区'),(1205,'310113000000','310100000000',0,'宝山区'),(1206,'310114000000','310100000000',0,'嘉定区'),(1207,'310115000000','310100000000',0,'浦东新区'),(1208,'310116000000','310100000000',0,'金山区'),(1209,'310117000000','310100000000',0,'松江区'),(1210,'310118000000','310100000000',0,'青浦区'),(1211,'310120000000','310100000000',0,'奉贤区'),(1212,'310151000000','310100000000',0,'崇明区'),(1213,'320101000000','320100000000',0,'市辖区'),(1214,'320102000000','320100000000',0,'玄武区'),(1215,'320104000000','320100000000',0,'秦淮区'),(1216,'320105000000','320100000000',0,'建邺区'),(1217,'320106000000','320100000000',0,'鼓楼区'),(1218,'320111000000','320100000000',0,'浦口区'),(1219,'320113000000','320100000000',0,'栖霞区'),(1220,'320114000000','320100000000',0,'雨花台区'),(1221,'320115000000','320100000000',0,'江宁区'),(1222,'320116000000','320100000000',0,'六合区'),(1223,'320117000000','320100000000',0,'溧水区'),(1224,'320118000000','320100000000',0,'高淳区'),(1225,'320201000000','320200000000',0,'市辖区'),(1226,'320205000000','320200000000',0,'锡山区'),(1227,'320206000000','320200000000',0,'惠山区'),(1228,'320211000000','320200000000',0,'滨湖区'),(1229,'320213000000','320200000000',0,'梁溪区'),(1230,'320214000000','320200000000',0,'新吴区'),(1231,'320281000000','320200000000',0,'江阴市'),(1232,'320282000000','320200000000',0,'宜兴市'),(1233,'320301000000','320300000000',0,'市辖区'),(1234,'320302000000','320300000000',0,'鼓楼区'),(1235,'320303000000','320300000000',0,'云龙区'),(1236,'320305000000','320300000000',0,'贾汪区'),(1237,'320311000000','320300000000',0,'泉山区'),(1238,'320312000000','320300000000',0,'铜山区'),(1239,'320321000000','320300000000',0,'丰县'),(1240,'320322000000','320300000000',0,'沛县'),(1241,'320324000000','320300000000',0,'睢宁县'),(1242,'320371000000','320300000000',0,'徐州经济技术开发区'),(1243,'320381000000','320300000000',0,'新沂市'),(1244,'320382000000','320300000000',0,'邳州市'),(1245,'320401000000','320400000000',0,'市辖区'),(1246,'320402000000','320400000000',0,'天宁区'),(1247,'320404000000','320400000000',0,'钟楼区'),(1248,'320411000000','320400000000',0,'新北区'),(1249,'320412000000','320400000000',0,'武进区'),(1250,'320413000000','320400000000',0,'金坛区'),(1251,'320481000000','320400000000',0,'溧阳市'),(1252,'320501000000','320500000000',0,'市辖区'),(1253,'320505000000','320500000000',0,'虎丘区'),(1254,'320506000000','320500000000',0,'吴中区'),(1255,'320507000000','320500000000',0,'相城区'),(1256,'320508000000','320500000000',0,'姑苏区'),(1257,'320509000000','320500000000',0,'吴江区'),(1258,'320571000000','320500000000',0,'苏州工业园区'),(1259,'320581000000','320500000000',0,'常熟市'),(1260,'320582000000','320500000000',0,'张家港市'),(1261,'320583000000','320500000000',0,'昆山市'),(1262,'320585000000','320500000000',0,'太仓市'),(1263,'320601000000','320600000000',0,'市辖区'),(1264,'320602000000','320600000000',0,'崇川区'),(1265,'320611000000','320600000000',0,'港闸区'),(1266,'320612000000','320600000000',0,'通州区'),(1267,'320623000000','320600000000',0,'如东县'),(1268,'320671000000','320600000000',0,'南通经济技术开发区'),(1269,'320681000000','320600000000',0,'启东市'),(1270,'320682000000','320600000000',0,'如皋市'),(1271,'320684000000','320600000000',0,'海门市'),(1272,'320685000000','320600000000',0,'海安市'),(1273,'320701000000','320700000000',0,'市辖区'),(1274,'320703000000','320700000000',0,'连云区'),(1275,'320706000000','320700000000',0,'海州区'),(1276,'320707000000','320700000000',0,'赣榆区'),(1277,'320722000000','320700000000',0,'东海县'),(1278,'320723000000','320700000000',0,'灌云县'),(1279,'320724000000','320700000000',0,'灌南县'),(1280,'320771000000','320700000000',0,'连云港经济技术开发区'),(1281,'320772000000','320700000000',0,'连云港高新技术产业开发区'),(1282,'320801000000','320800000000',0,'市辖区'),(1283,'320803000000','320800000000',0,'淮安区'),(1284,'320804000000','320800000000',0,'淮阴区'),(1285,'320812000000','320800000000',0,'清江浦区'),(1286,'320813000000','320800000000',0,'洪泽区'),(1287,'320826000000','320800000000',0,'涟水县'),(1288,'320830000000','320800000000',0,'盱眙县'),(1289,'320831000000','320800000000',0,'金湖县'),(1290,'320871000000','320800000000',0,'淮安经济技术开发区'),(1291,'320901000000','320900000000',0,'市辖区'),(1292,'320902000000','320900000000',0,'亭湖区'),(1293,'320903000000','320900000000',0,'盐都区'),(1294,'320904000000','320900000000',0,'大丰区'),(1295,'320921000000','320900000000',0,'响水县'),(1296,'320922000000','320900000000',0,'滨海县'),(1297,'320923000000','320900000000',0,'阜宁县'),(1298,'320924000000','320900000000',0,'射阳县'),(1299,'320925000000','320900000000',0,'建湖县'),(1300,'320971000000','320900000000',0,'盐城经济技术开发区'),(1301,'320981000000','320900000000',0,'东台市'),(1302,'321001000000','321000000000',0,'市辖区'),(1303,'321002000000','321000000000',0,'广陵区'),(1304,'321003000000','321000000000',0,'邗江区'),(1305,'321012000000','321000000000',0,'江都区'),(1306,'321023000000','321000000000',0,'宝应县'),(1307,'321071000000','321000000000',0,'扬州经济技术开发区'),(1308,'321081000000','321000000000',0,'仪征市'),(1309,'321084000000','321000000000',0,'高邮市'),(1310,'321101000000','321100000000',0,'市辖区'),(1311,'321102000000','321100000000',0,'京口区'),(1312,'321111000000','321100000000',0,'润州区'),(1313,'321112000000','321100000000',0,'丹徒区'),(1314,'321171000000','321100000000',0,'镇江新区'),(1315,'321181000000','321100000000',0,'丹阳市'),(1316,'321182000000','321100000000',0,'扬中市'),(1317,'321183000000','321100000000',0,'句容市'),(1318,'321201000000','321200000000',0,'市辖区'),(1319,'321202000000','321200000000',0,'海陵区'),(1320,'321203000000','321200000000',0,'高港区'),(1321,'321204000000','321200000000',0,'姜堰区'),(1322,'321271000000','321200000000',0,'泰州医药高新技术产业开发区'),(1323,'321281000000','321200000000',0,'兴化市'),(1324,'321282000000','321200000000',0,'靖江市'),(1325,'321283000000','321200000000',0,'泰兴市'),(1326,'321301000000','321300000000',0,'市辖区'),(1327,'321302000000','321300000000',0,'宿城区'),(1328,'321311000000','321300000000',0,'宿豫区'),(1329,'321322000000','321300000000',0,'沭阳县'),(1330,'321323000000','321300000000',0,'泗阳县'),(1331,'321324000000','321300000000',0,'泗洪县'),(1332,'321371000000','321300000000',0,'宿迁经济技术开发区'),(1333,'330101000000','330100000000',0,'市辖区'),(1334,'330102000000','330100000000',0,'上城区'),(1335,'330103000000','330100000000',0,'下城区'),(1336,'330104000000','330100000000',0,'江干区'),(1337,'330105000000','330100000000',0,'拱墅区'),(1338,'330106000000','330100000000',0,'西湖区'),(1339,'330108000000','330100000000',0,'滨江区'),(1340,'330109000000','330100000000',0,'萧山区'),(1341,'330110000000','330100000000',0,'余杭区'),(1342,'330111000000','330100000000',0,'富阳区'),(1343,'330112000000','330100000000',0,'临安区'),(1344,'330122000000','330100000000',0,'桐庐县'),(1345,'330127000000','330100000000',0,'淳安县'),(1346,'330182000000','330100000000',0,'建德市'),(1347,'330201000000','330200000000',0,'市辖区'),(1348,'330203000000','330200000000',0,'海曙区'),(1349,'330205000000','330200000000',0,'江北区'),(1350,'330206000000','330200000000',0,'北仑区'),(1351,'330211000000','330200000000',0,'镇海区'),(1352,'330212000000','330200000000',0,'鄞州区'),(1353,'330213000000','330200000000',0,'奉化区'),(1354,'330225000000','330200000000',0,'象山县'),(1355,'330226000000','330200000000',0,'宁海县'),(1356,'330281000000','330200000000',0,'余姚市'),(1357,'330282000000','330200000000',0,'慈溪市'),(1358,'330301000000','330300000000',0,'市辖区'),(1359,'330302000000','330300000000',0,'鹿城区'),(1360,'330303000000','330300000000',0,'龙湾区'),(1361,'330304000000','330300000000',0,'瓯海区'),(1362,'330305000000','330300000000',0,'洞头区'),(1363,'330324000000','330300000000',0,'永嘉县'),(1364,'330326000000','330300000000',0,'平阳县'),(1365,'330327000000','330300000000',0,'苍南县'),(1366,'330328000000','330300000000',0,'文成县'),(1367,'330329000000','330300000000',0,'泰顺县'),(1368,'330371000000','330300000000',0,'温州经济技术开发区'),(1369,'330381000000','330300000000',0,'瑞安市'),(1370,'330382000000','330300000000',0,'乐清市'),(1371,'330401000000','330400000000',0,'市辖区'),(1372,'330402000000','330400000000',0,'南湖区'),(1373,'330411000000','330400000000',0,'秀洲区'),(1374,'330421000000','330400000000',0,'嘉善县'),(1375,'330424000000','330400000000',0,'海盐县'),(1376,'330481000000','330400000000',0,'海宁市'),(1377,'330482000000','330400000000',0,'平湖市'),(1378,'330483000000','330400000000',0,'桐乡市'),(1379,'330501000000','330500000000',0,'市辖区'),(1380,'330502000000','330500000000',0,'吴兴区'),(1381,'330503000000','330500000000',0,'南浔区'),(1382,'330521000000','330500000000',0,'德清县'),(1383,'330522000000','330500000000',0,'长兴县'),(1384,'330523000000','330500000000',0,'安吉县'),(1385,'330601000000','330600000000',0,'市辖区'),(1386,'330602000000','330600000000',0,'越城区'),(1387,'330603000000','330600000000',0,'柯桥区'),(1388,'330604000000','330600000000',0,'上虞区'),(1389,'330624000000','330600000000',0,'新昌县'),(1390,'330681000000','330600000000',0,'诸暨市'),(1391,'330683000000','330600000000',0,'嵊州市'),(1392,'330701000000','330700000000',0,'市辖区'),(1393,'330702000000','330700000000',0,'婺城区'),(1394,'330703000000','330700000000',0,'金东区'),(1395,'330723000000','330700000000',0,'武义县'),(1396,'330726000000','330700000000',0,'浦江县'),(1397,'330727000000','330700000000',0,'磐安县'),(1398,'330781000000','330700000000',0,'兰溪市'),(1399,'330782000000','330700000000',0,'义乌市'),(1400,'330783000000','330700000000',0,'东阳市'),(1401,'330784000000','330700000000',0,'永康市'),(1402,'330801000000','330800000000',0,'市辖区'),(1403,'330802000000','330800000000',0,'柯城区'),(1404,'330803000000','330800000000',0,'衢江区'),(1405,'330822000000','330800000000',0,'常山县'),(1406,'330824000000','330800000000',0,'开化县'),(1407,'330825000000','330800000000',0,'龙游县'),(1408,'330881000000','330800000000',0,'江山市'),(1409,'330901000000','330900000000',0,'市辖区'),(1410,'330902000000','330900000000',0,'定海区'),(1411,'330903000000','330900000000',0,'普陀区'),(1412,'330921000000','330900000000',0,'岱山县'),(1413,'330922000000','330900000000',0,'嵊泗县'),(1414,'331001000000','331000000000',0,'市辖区'),(1415,'331002000000','331000000000',0,'椒江区'),(1416,'331003000000','331000000000',0,'黄岩区'),(1417,'331004000000','331000000000',0,'路桥区'),(1418,'331022000000','331000000000',0,'三门县'),(1419,'331023000000','331000000000',0,'天台县'),(1420,'331024000000','331000000000',0,'仙居县'),(1421,'331081000000','331000000000',0,'温岭市'),(1422,'331082000000','331000000000',0,'临海市'),(1423,'331083000000','331000000000',0,'玉环市'),(1424,'331101000000','331100000000',0,'市辖区'),(1425,'331102000000','331100000000',0,'莲都区'),(1426,'331121000000','331100000000',0,'青田县'),(1427,'331122000000','331100000000',0,'缙云县'),(1428,'331123000000','331100000000',0,'遂昌县'),(1429,'331124000000','331100000000',0,'松阳县'),(1430,'331125000000','331100000000',0,'云和县'),(1431,'331126000000','331100000000',0,'庆元县'),(1432,'331127000000','331100000000',0,'景宁畲族自治县'),(1433,'331181000000','331100000000',0,'龙泉市'),(1434,'340101000000','340100000000',0,'市辖区'),(1435,'340102000000','340100000000',0,'瑶海区'),(1436,'340103000000','340100000000',0,'庐阳区'),(1437,'340104000000','340100000000',0,'蜀山区'),(1438,'340111000000','340100000000',0,'包河区'),(1439,'340121000000','340100000000',0,'长丰县'),(1440,'340122000000','340100000000',0,'肥东县'),(1441,'340123000000','340100000000',0,'肥西县'),(1442,'340124000000','340100000000',0,'庐江县'),(1443,'340171000000','340100000000',0,'合肥高新技术产业开发区'),(1444,'340172000000','340100000000',0,'合肥经济技术开发区'),(1445,'340173000000','340100000000',0,'合肥新站高新技术产业开发区'),(1446,'340181000000','340100000000',0,'巢湖市'),(1447,'340201000000','340200000000',0,'市辖区'),(1448,'340202000000','340200000000',0,'镜湖区'),(1449,'340203000000','340200000000',0,'弋江区'),(1450,'340207000000','340200000000',0,'鸠江区'),(1451,'340208000000','340200000000',0,'三山区'),(1452,'340221000000','340200000000',0,'芜湖县'),(1453,'340222000000','340200000000',0,'繁昌县'),(1454,'340223000000','340200000000',0,'南陵县'),(1455,'340225000000','340200000000',0,'无为县'),(1456,'340271000000','340200000000',0,'芜湖经济技术开发区'),(1457,'340272000000','340200000000',0,'安徽芜湖长江大桥经济开发区'),(1458,'340301000000','340300000000',0,'市辖区'),(1459,'340302000000','340300000000',0,'龙子湖区'),(1460,'340303000000','340300000000',0,'蚌山区'),(1461,'340304000000','340300000000',0,'禹会区'),(1462,'340311000000','340300000000',0,'淮上区'),(1463,'340321000000','340300000000',0,'怀远县'),(1464,'340322000000','340300000000',0,'五河县'),(1465,'340323000000','340300000000',0,'固镇县'),(1466,'340371000000','340300000000',0,'蚌埠市高新技术开发区'),(1467,'340372000000','340300000000',0,'蚌埠市经济开发区'),(1468,'340401000000','340400000000',0,'市辖区'),(1469,'340402000000','340400000000',0,'大通区'),(1470,'340403000000','340400000000',0,'田家庵区'),(1471,'340404000000','340400000000',0,'谢家集区'),(1472,'340405000000','340400000000',0,'八公山区'),(1473,'340406000000','340400000000',0,'潘集区'),(1474,'340421000000','340400000000',0,'凤台县'),(1475,'340422000000','340400000000',0,'寿县'),(1476,'340501000000','340500000000',0,'市辖区'),(1477,'340503000000','340500000000',0,'花山区'),(1478,'340504000000','340500000000',0,'雨山区'),(1479,'340506000000','340500000000',0,'博望区'),(1480,'340521000000','340500000000',0,'当涂县'),(1481,'340522000000','340500000000',0,'含山县'),(1482,'340523000000','340500000000',0,'和县'),(1483,'340601000000','340600000000',0,'市辖区'),(1484,'340602000000','340600000000',0,'杜集区'),(1485,'340603000000','340600000000',0,'相山区'),(1486,'340604000000','340600000000',0,'烈山区'),(1487,'340621000000','340600000000',0,'濉溪县'),(1488,'340701000000','340700000000',0,'市辖区'),(1489,'340705000000','340700000000',0,'铜官区'),(1490,'340706000000','340700000000',0,'义安区'),(1491,'340711000000','340700000000',0,'郊区'),(1492,'340722000000','340700000000',0,'枞阳县'),(1493,'340801000000','340800000000',0,'市辖区'),(1494,'340802000000','340800000000',0,'迎江区'),(1495,'340803000000','340800000000',0,'大观区'),(1496,'340811000000','340800000000',0,'宜秀区'),(1497,'340822000000','340800000000',0,'怀宁县'),(1498,'340825000000','340800000000',0,'太湖县'),(1499,'340826000000','340800000000',0,'宿松县'),(1500,'340827000000','340800000000',0,'望江县'),(1501,'340828000000','340800000000',0,'岳西县'),(1502,'340871000000','340800000000',0,'安徽安庆经济开发区'),(1503,'340881000000','340800000000',0,'桐城市'),(1504,'340882000000','340800000000',0,'潜山市'),(1505,'341001000000','341000000000',0,'市辖区'),(1506,'341002000000','341000000000',0,'屯溪区'),(1507,'341003000000','341000000000',0,'黄山区'),(1508,'341004000000','341000000000',0,'徽州区'),(1509,'341021000000','341000000000',0,'歙县'),(1510,'341022000000','341000000000',0,'休宁县'),(1511,'341023000000','341000000000',0,'黟县'),(1512,'341024000000','341000000000',0,'祁门县'),(1513,'341101000000','341100000000',0,'市辖区'),(1514,'341102000000','341100000000',0,'琅琊区'),(1515,'341103000000','341100000000',0,'南谯区'),(1516,'341122000000','341100000000',0,'来安县'),(1517,'341124000000','341100000000',0,'全椒县'),(1518,'341125000000','341100000000',0,'定远县'),(1519,'341126000000','341100000000',0,'凤阳县'),(1520,'341171000000','341100000000',0,'苏滁现代产业园'),(1521,'341172000000','341100000000',0,'滁州经济技术开发区'),(1522,'341181000000','341100000000',0,'天长市'),(1523,'341182000000','341100000000',0,'明光市'),(1524,'341201000000','341200000000',0,'市辖区'),(1525,'341202000000','341200000000',0,'颍州区'),(1526,'341203000000','341200000000',0,'颍东区'),(1527,'341204000000','341200000000',0,'颍泉区'),(1528,'341221000000','341200000000',0,'临泉县'),(1529,'341222000000','341200000000',0,'太和县'),(1530,'341225000000','341200000000',0,'阜南县'),(1531,'341226000000','341200000000',0,'颍上县'),(1532,'341271000000','341200000000',0,'阜阳合肥现代产业园区'),(1533,'341272000000','341200000000',0,'阜阳经济技术开发区'),(1534,'341282000000','341200000000',0,'界首市'),(1535,'341301000000','341300000000',0,'市辖区'),(1536,'341302000000','341300000000',0,'埇桥区'),(1537,'341321000000','341300000000',0,'砀山县'),(1538,'341322000000','341300000000',0,'萧县'),(1539,'341323000000','341300000000',0,'灵璧县'),(1540,'341324000000','341300000000',0,'泗县'),(1541,'341371000000','341300000000',0,'宿州马鞍山现代产业园区'),(1542,'341372000000','341300000000',0,'宿州经济技术开发区'),(1543,'341501000000','341500000000',0,'市辖区'),(1544,'341502000000','341500000000',0,'金安区'),(1545,'341503000000','341500000000',0,'裕安区'),(1546,'341504000000','341500000000',0,'叶集区'),(1547,'341522000000','341500000000',0,'霍邱县'),(1548,'341523000000','341500000000',0,'舒城县'),(1549,'341524000000','341500000000',0,'金寨县'),(1550,'341525000000','341500000000',0,'霍山县'),(1551,'341601000000','341600000000',0,'市辖区'),(1552,'341602000000','341600000000',0,'谯城区'),(1553,'341621000000','341600000000',0,'涡阳县'),(1554,'341622000000','341600000000',0,'蒙城县'),(1555,'341623000000','341600000000',0,'利辛县'),(1556,'341701000000','341700000000',0,'市辖区'),(1557,'341702000000','341700000000',0,'贵池区'),(1558,'341721000000','341700000000',0,'东至县'),(1559,'341722000000','341700000000',0,'石台县'),(1560,'341723000000','341700000000',0,'青阳县'),(1561,'341801000000','341800000000',0,'市辖区'),(1562,'341802000000','341800000000',0,'宣州区'),(1563,'341821000000','341800000000',0,'郎溪县'),(1564,'341822000000','341800000000',0,'广德县'),(1565,'341823000000','341800000000',0,'泾县'),(1566,'341824000000','341800000000',0,'绩溪县'),(1567,'341825000000','341800000000',0,'旌德县'),(1568,'341871000000','341800000000',0,'宣城市经济开发区'),(1569,'341881000000','341800000000',0,'宁国市'),(1570,'350101000000','350100000000',0,'市辖区'),(1571,'350102000000','350100000000',0,'鼓楼区'),(1572,'350103000000','350100000000',0,'台江区'),(1573,'350104000000','350100000000',0,'仓山区'),(1574,'350105000000','350100000000',0,'马尾区'),(1575,'350111000000','350100000000',0,'晋安区'),(1576,'350112000000','350100000000',0,'长乐区'),(1577,'350121000000','350100000000',0,'闽侯县'),(1578,'350122000000','350100000000',0,'连江县'),(1579,'350123000000','350100000000',0,'罗源县'),(1580,'350124000000','350100000000',0,'闽清县'),(1581,'350125000000','350100000000',0,'永泰县'),(1582,'350128000000','350100000000',0,'平潭县'),(1583,'350181000000','350100000000',0,'福清市'),(1584,'350201000000','350200000000',0,'市辖区'),(1585,'350203000000','350200000000',0,'思明区'),(1586,'350205000000','350200000000',0,'海沧区'),(1587,'350206000000','350200000000',0,'湖里区'),(1588,'350211000000','350200000000',0,'集美区'),(1589,'350212000000','350200000000',0,'同安区'),(1590,'350213000000','350200000000',0,'翔安区'),(1591,'350301000000','350300000000',0,'市辖区'),(1592,'350302000000','350300000000',0,'城厢区'),(1593,'350303000000','350300000000',0,'涵江区'),(1594,'350304000000','350300000000',0,'荔城区'),(1595,'350305000000','350300000000',0,'秀屿区'),(1596,'350322000000','350300000000',0,'仙游县'),(1597,'350401000000','350400000000',0,'市辖区'),(1598,'350402000000','350400000000',0,'梅列区'),(1599,'350403000000','350400000000',0,'三元区'),(1600,'350421000000','350400000000',0,'明溪县'),(1601,'350423000000','350400000000',0,'清流县'),(1602,'350424000000','350400000000',0,'宁化县'),(1603,'350425000000','350400000000',0,'大田县'),(1604,'350426000000','350400000000',0,'尤溪县'),(1605,'350427000000','350400000000',0,'沙县'),(1606,'350428000000','350400000000',0,'将乐县'),(1607,'350429000000','350400000000',0,'泰宁县'),(1608,'350430000000','350400000000',0,'建宁县'),(1609,'350481000000','350400000000',0,'永安市'),(1610,'350501000000','350500000000',0,'市辖区'),(1611,'350527000000','350500000000',0,'金门县'),(1612,'350502000000','350500000000',0,'鲤城区'),(1613,'350503000000','350500000000',0,'丰泽区'),(1614,'350504000000','350500000000',0,'洛江区'),(1615,'350505000000','350500000000',0,'泉港区'),(1616,'350521000000','350500000000',0,'惠安县'),(1617,'350524000000','350500000000',0,'安溪县'),(1618,'350525000000','350500000000',0,'永春县'),(1619,'350526000000','350500000000',0,'德化县'),(1620,'350581000000','350500000000',0,'石狮市'),(1621,'350582000000','350500000000',0,'晋江市'),(1622,'350583000000','350500000000',0,'南安市'),(1623,'350601000000','350600000000',0,'市辖区'),(1624,'350602000000','350600000000',0,'芗城区'),(1625,'350603000000','350600000000',0,'龙文区'),(1626,'350622000000','350600000000',0,'云霄县'),(1627,'350623000000','350600000000',0,'漳浦县'),(1628,'350624000000','350600000000',0,'诏安县'),(1629,'350625000000','350600000000',0,'长泰县'),(1630,'350626000000','350600000000',0,'东山县'),(1631,'350627000000','350600000000',0,'南靖县'),(1632,'350628000000','350600000000',0,'平和县'),(1633,'350629000000','350600000000',0,'华安县'),(1634,'350681000000','350600000000',0,'龙海市'),(1635,'350701000000','350700000000',0,'市辖区'),(1636,'350702000000','350700000000',0,'延平区');
/*!40000 ALTER TABLE `area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attr_spec`
--

DROP TABLE IF EXISTS `attr_spec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attr_spec` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `spec_name` varchar(20) NOT NULL DEFAULT '' COMMENT '规格名',
  `attr_name` text NOT NULL DEFAULT '' COMMENT '属性表',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='规格属性表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attr_spec`
--

LOCK TABLES `attr_spec` WRITE;
/*!40000 ALTER TABLE `attr_spec` DISABLE KEYS */;
INSERT INTO `attr_spec` VALUES (1,1,'颜色','黑,白,绿'),(2,1,'大小','大,中,小'),(3,1,'容量','10ML,200ML,300ML');
/*!40000 ALTER TABLE `attr_spec` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cart`
--

DROP TABLE IF EXISTS `cart`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cart` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `spec_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '规格属性ID',
  `goods_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `seller_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家ID',
  `store_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '店铺ID',
  `store_name` varchar(30) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `goods_name` varchar(80) NOT NULL DEFAULT '' COMMENT '商品名',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT '订单图片',
  `goods_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '商品价格',
  `goods_num` int(10) NOT NULL DEFAULT 0 COMMENT '数量',
  `goods_spec` varchar(100) NOT NULL DEFAULT '' COMMENT '规格属性',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='购物车表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cart`
--

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

--
-- Table structure for table `cash_log`
--

DROP TABLE IF EXISTS `cash_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cash_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '昵称',
  `real_name` varchar(30) NOT NULL DEFAULT '' COMMENT '真名',
  `bank` varchar(40) NOT NULL DEFAULT '' COMMENT '银行',
  `card_no` varchar(40) NOT NULL DEFAULT '' COMMENT '银行卡号',
  `money` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '提现金额',
  `rate` decimal(5,2) NOT NULL DEFAULT 0.00 COMMENT '手续费%',
  `rate_money` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '手续实际金额',
  `status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '状态 0 审核 1 提现成功',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='提现日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cash_log`
--

LOCK TABLES `cash_log` WRITE;
/*!40000 ALTER TABLE `cash_log` DISABLE KEYS */;
INSERT INTO `cash_log` VALUES (4,1,'神秘人2','栗色','工商银行','234124',100.00,1.00,1.00,0,1578365316);
/*!40000 ALTER TABLE `cash_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chat_friend`
--

DROP TABLE IF EXISTS `chat_friend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_friend` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `to_user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '好友ID',
  `group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '分组ID',
  `chat_last_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '最后一次聊天时间',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间 加好友时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `to_user_id` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='好友列表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chat_friend`
--

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

--
-- Table structure for table `chat_msg`
--

DROP TABLE IF EXISTS `chat_msg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_msg` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `to_user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '聊天对象',
  `type` varchar(10) NOT NULL DEFAULT 'text' COMMENT '内容类型',
  `content` text CHARACTER set utf8mb4 NOT NULL DEFAULT '' COMMENT '内容',
  `is_read` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '是否查看',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `to_user_id` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='聊天信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chat_msg`
--

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

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL DEFAULT '' COMMENT '配置名',
  `val` text NOT NULL COMMENT '配置内容',
  `content` varchar(30) NOT NULL DEFAULT '' COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='配置中心';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'web_name','青梧商城','站点名称'),(2,'web_url','http://api.qingwuit.com','站点链接'),(3,'keywords','青梧商城1','网站关键字'),(4,'description','青梧商城23','网站描述'),(5,'logo','http://api.qingwuit.com/Uploads/2019_11_14/15737192091385.png','网站logo'),(6,'mobile','15073010917','公司电话'),(7,'email','364825702@qq.com','邮件'),(8,'icp','icpxxxs','备案号'),(9,'web_status','1','站点状态'),(10,'web_close_info','商城暂时关闭','站点关闭原因'),(11,'wxpay_jsapi','{\"appid\":\"xxxx\",\"appsecret\":\"1\",\"mchid\":\"xxxx\",\"key\":\"l73fAeSw6Vy76inufzlSQsudMX6Muejh\",\"notify_url\":\"http:\\/\\/www.qingwuit.com\"}','微信支付_微信游览器'),(12,'wxpay_h5','{\"appid\":\"123\",\"appsecret\":\"1\",\"mchid\":\"2\",\"key\":\"2\"}','微信支付H5'),(13,'wxpay_app','{\"appid\":\"2\",\"appsecret\":\"2\",\"mchid\":\"2\",\"key\":\"2\"}','微信支付APP'),(14,'wxpay_mini','{\"appid\":\"3\",\"appsecret\":\"3\",\"mchid\":\"3\",\"key\":\"3\"}','微信小程序'),(15,'wechat_public','{\"url\":\"1\",\"token\":\"2\",\"name\":\"3\",\"appid\":\"4\",\"secret\":\"5\",\"mini_appid\":null,\"mini_secret\":null}','微信公众号配置'),(16,'alipay_h5','{\"appid\":\"6\",\"public_key\":\"6\",\"private_key\":\"6\"}','支付宝支付'),(17,'alipay_app','{\"appid\":\"7\",\"public_key\":\"7\",\"private_key\":\"7\"}','支付宝APP'),(18,'alisms','{\"key\":\"LTAIAexHTIIuJKYs\",\"secret\":\"xxxx\",\"sign_name\":\"\sxx\"}','阿里Sms'),(19,'alioss','{\"status\":\"0\",\"access_key\":\"LTAI5Uw2Koz8VAYK\",\"secret_access\":\"xxx\",\"bucket\":\"yunk001\",\"endpoint\":\"oss-cn-beijing.aliyuncs.com\"}','阿里Oss'),(20,'baidu_ak','s','百度地图KEY'),(21,'amap_ak','79f3a628c906e1fc7384a6f19d478ae3','高德地图KEY'),(22,'alipay_pc','{\"appid\":\"2016091900544672\",\"public_key\":\"MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA+z64yozEqXS9GvcT7e758dPTt8qJ2+12wcpioEhaBbfqvowcZjUV9BPL1EgtJie5SNK9rFDFO\\/POWVlzj8BVD0viUteNe2amPRhZLxzT3HXn9VJH+dTwOEgZ1MSrDisxOi7\\/NCTF42zQl6\\/w2lK2FQI\\/c1kIoN91ivWlPqX3BbXG54hyngu5T9j2AimEhKWMhq6sL2gVoNILbJDLDN85AOfoGb1DZ59dFSez\\/GtssO0KXGqfc1R1AggmisksQOKAXSiSHejEHvU\\/Zx4lIvpCWEwBXx7qWbOD2MXWmsrn6W41f4AJYoJxQ2QRUkFlKpstAgVfhNMR6A+W1p7bh647GQIDAQAB\",\"private_key\":\"MIIEpQIBAAKCAQEA0RUuZV3hJ\\/7bRKOl0YstVD7yjkSCnavuKvzHHEbwmv5IaIo\\/f2ynGHU8i5C3LfPPcHxpVb5\\/LTp1oNq1qgRgHIh7fD+IYw7+dH+EzyJOmVa+fFxCM5yR1JxfXLWy1Qv2R6KwBJ1pVtalzCai+GvvOioQ4JxSHHcNUEvAoB4WzXhreQHDCBn7nk8+yAetOVYdff5o1vDFE+4RrALpOCMaTtoOyOFcm\\/WQULddXdC9sxGjA338\\/crAM1rU8yzXkJIScoZ0sm1iK\\/euF6j0LgavoMWamihbZvUDQ8Lx3OphGpeOVa9N+w15CX7UAsr6SGUEj02aPkdNfbsajde91zdUhwIDAQABAoIBAFb\\/30xiofvIemi3R5pHtVbm0nsMWuVM00+j2x4TDq8PvAVz8TQOfAEbV1QjpXVDjD+cJSB+oeCqAKQsHYdfRrbYu7lZnmDJrmu\\/W\\/3sopP\\/mkeZBBsBvVSgtLWZDY7E6XepZGCnN1vg+SBXu1xvXR3wvxEXOruJdkrBGqgFnStlfXSNDkLGmMtjF4fXIBO9kGjBp4x1W7OioGdgyJ8P+IXsl8nfXKHxwgo5LFRZIiIawx7S2EPfZ4LkCtoECfpbCVYbdY9Mn\\/fXvLC3BG+QYzGoqD41OmxSWSg4aoiOIP1W1nX+lHcHRIbosnXJuWTQnWQm3JqI9y19TmYz44KW1RECgYEA8Hlv3D\\/zAEkHJGYh8Toc\\/BRmze7gkAPPoQgapdtfuCvhpTHL9nRPxczx+u+Zg6m9ot\\/K7Gfxu7Xgdp9bTDO7Ov73Sdd+FgYeGhi2YswjUhGkdpgKH6H0pqjEzKnrsgAt9IlKwtzm833OEzJftujAI8O4z4XOG6df4yaKxlVzCu0CgYEA3pTnNVuRMnngJ6XR6JR4ftW8oIAdf6XF5U8zftMsQ\\/wOwfXxpXPfDjyyCnRSnX7ySGi8es8KRUyl2rGhQS2XXZIeKZviyADnL2ThgltT7zxLbGDrSlfkNC1UrFWEKUdJcNK10ScqQxk5qv4nV5bmQF9lZWpMJ9g6suSHUqfzysMCgYEAyWV6+KQaOOfwclyTGruH4NqZSuk\\/6301m\\/D0mGmE3fLqVPbCklLRKKC\\/HGEkWa+EIe95vMpFGud06QQHa2d77CnzI0W11G4lMcf2oAHFpwsdiTFGcT2rbxSzVZEN05Lw6fc9xLtLNSvstgkfPknp+UoG8s5mUqS32r7BxN91rPUCgYEAyobSmkpnI3ah73GCPg5aVY5FxATO0ocUOkKGqK+dZ37CLtqKtfFo1JuFpN2TDpuj+R7T4SriPYwwnX1jLNs\\/D3UU3OdqwnGP6h\\/w0ZwoE1bZihPmBA9VJeTZVrW5O5YRzQbtSRJJ8iPRxTTct2YmvAwRRuYhxV+KiZxHRX5s5eECgYEA4YTPQheQx7uGEq4C7k3OfKzTcrNGfXR+LGZo3VI0Y48XJy99kOf832N3w6ZSgc1W9FkfuPjVPKsS2ln4gONb+ZV2w5kl8a5l5DtGfD9MapesC2PnQcntumHJvgKxZkKKftm7budJ+AxYX7FUKKG2m78niOdPB3KUZlQavXCslM4=\",\"notify_url\":\"\\/\",\"return_url\":\"\\/\"}','支付宝PC'),(23,'goods_verify','0','产品审核'),(24,'freight_key','95577090e41c4b5a80d8ff74611f4cc7','阿里云快递 key'),(25,'oauth_config','{\"appid\":\"wxe4f1c489bc591298\",\"app_secret\":\"6667286448b8d3e1c9c245f1e752f94b\"}','OAuth 配置'),(26,'distribution','{\"status\":\"0\",\"distribution\":\"0\",\"distribution_1\":\"0\",\"distribution_2\":\"0\"}','分销配置'),(27,'cash_rate','1','提现手续费百分比'),(28,'task_time','{\"auto_confirm\":\"7\",\"auto_comment\":\"1\"}','定时任务执行时间');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `crontab_day`
--

DROP TABLE IF EXISTS `crontab_day`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crontab_day` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `users` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户',
  `store` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家ID',
  `goods` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品数量',
  `orders` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '订单数量',
  `price` decimal(9,2) unsigned NOT NULL DEFAULT 0.00 COMMENT '销售量',
  `format_time` varchar(20) NOT NULL DEFAULT '' COMMENT '格式化时间',
  `times` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '时间戳 格式化的',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '时间戳',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='定时采集数据 天';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crontab_day`
--

LOCK TABLES `crontab_day` WRITE;
/*!40000 ALTER TABLE `crontab_day` DISABLE KEYS */;
INSERT INTO `crontab_day` VALUES (1,2,1,1,3,10,186.00,'',0,0),(2,2,1,1,3,10,186.00,'',0,0),(3,2,1,1,3,10,186.00,'2020-01-11',0,1578736304);
/*!40000 ALTER TABLE `crontab_day` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `crontab_month`
--

DROP TABLE IF EXISTS `crontab_month`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crontab_month` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `users` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户',
  `store` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家ID',
  `goods` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品数量',
  `orders` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '订单数量',
  `price` decimal(9,2) unsigned NOT NULL DEFAULT 0.00 COMMENT '销售量',
  `format_time` varchar(20) NOT NULL DEFAULT '' COMMENT '格式化时间',
  `times` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '时间戳 格式化的',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '时间戳',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时采集数据 月';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crontab_month`
--

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

--
-- Table structure for table `crontab_week`
--

DROP TABLE IF EXISTS `crontab_week`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crontab_week` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `users` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户',
  `store` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家ID',
  `goods` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品数量',
  `orders` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '订单数量',
  `price` decimal(9,2) unsigned NOT NULL DEFAULT 0.00 COMMENT '销售量',
  `format_time` varchar(20) NOT NULL DEFAULT '' COMMENT '格式化时间',
  `times` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '时间戳 格式化的',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '时间戳',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时采集数据 周';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crontab_week`
--

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

--
-- Table structure for table `favorites`
--

DROP TABLE IF EXISTS `favorites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `favorites` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `mix_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品ID 和 店铺ID',
  `is_type` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '是商品还是店铺',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='店铺收藏和商品收藏';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `favorites`
--

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

--
-- Table structure for table `freight_template`
--

DROP TABLE IF EXISTS `freight_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `freight_template` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '模版名称',
  `price` decimal(6,2) NOT NULL DEFAULT 0.00 COMMENT '默认运费',
  `content` text NOT NULL DEFAULT '' COMMENT '内容JSON',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='运费模版';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `freight_template`
--

LOCK TABLES `freight_template` WRITE;
/*!40000 ALTER TABLE `freight_template` DISABLE KEYS */;
INSERT INTO `freight_template` VALUES (1,1,'测试',1.00,'[{\"content\":[[\"1\",\"32\",\"375\"],[\"1\",\"32\",\"376\"],[\"1\",\"32\",\"377\"],[\"1\",\"32\",\"378\"],[\"1\",\"32\",\"379\"],[\"1\",\"32\",\"380\"],[\"1\",\"32\",\"381\"],[\"1\",\"32\",\"382\"],[\"1\",\"32\",\"383\"],[\"1\",\"32\",\"384\"],[\"1\",\"32\",\"385\"],[\"1\",\"32\",\"386\"],[\"1\",\"32\",\"387\"],[\"1\",\"32\",\"388\"],[\"1\",\"32\",\"389\"],[\"1\",\"32\",\"390\"]],\"price\":\"10\"},{\"content\":[[\"2\",\"33\",\"391\"],[\"2\",\"33\",\"392\"],[\"2\",\"33\",\"393\"],[\"2\",\"33\",\"394\"],[\"2\",\"33\",\"395\"],[\"2\",\"33\",\"396\"],[\"2\",\"33\",\"397\"],[\"2\",\"33\",\"398\"],[\"2\",\"33\",\"399\"],[\"2\",\"33\",\"400\"],[\"2\",\"33\",\"401\"],[\"2\",\"33\",\"402\"],[\"2\",\"33\",\"403\"],[\"2\",\"33\",\"404\"],[\"2\",\"33\",\"405\"],[\"2\",\"33\",\"406\"]],\"price\":\"10\"}]');
/*!40000 ALTER TABLE `freight_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods`
--

DROP TABLE IF EXISTS `goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '栏目ID',
  `bid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '品牌ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `goods_no` varchar(20) NOT NULL DEFAULT '' COMMENT '自定义编号',
  `goods_subname` varchar(80) NOT NULL DEFAULT '' COMMENT '副标题',
  `goods_name` varchar(80) NOT NULL DEFAULT '' COMMENT '商品名',
  `goods_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '商品价格',
  `goods_market_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '市场价格',
  `goods_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '数量',
  `goods_images` varchar(400) NOT NULL DEFAULT '' COMMENT '所有产品图片',
  `goods_master_image` varchar(100) NOT NULL DEFAULT '' COMMENT '主图',
  `goods_freight` decimal(5,2) NOT NULL DEFAULT 0.00 COMMENT '运费',
  `freight_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '物流模版',
  `free_freight` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '满多少包邮',
  `chose_spec_id` varchar(100) NOT NULL DEFAULT '' COMMENT '选择的规格',
  `chose_attr` varchar(100) NOT NULL DEFAULT '' COMMENT '选择的属性',
  `goods_sale_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '销售数量',
  `goods_collect` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '收藏数量',
  `goods_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '商品状态 0 下架 1 上架',
  `goods_verify` tinyint(3) unsigned NOT NULL DEFAULT 1 COMMENT '审核状态 1 通过 0 审核失败 2 审核中',
  `goods_content` text NOT NULL DEFAULT '' COMMENT '商品详情',
  `store_goods_class` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家自定义分类',
  `is_groupbuy` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '参加拼团',
  `groupbuy_num` tinyint(3) unsigned NOT NULL DEFAULT 5 COMMENT '拼团人数',
  `groupbuy_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '拼团价格',
  `is_top` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否置顶',
  `is_index` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否首页显示 总后台控制',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  `edit_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='商品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods`
--

LOCK TABLES `goods` WRITE;
/*!40000 ALTER TABLE `goods` DISABLE KEYS */;
INSERT INTO `goods` VALUES (33,24,0,6,'','智能操控 快速冷暖','Haier/海尔 KFR-33GW/10EBBAL13U1 1.5匹智能壁挂式家用空调挂机 智能操控 快速冷暖 送装一体',6819.00,8999.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789844297080.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789844297080.jpg',0.00,0,0.00,'','',0,0,1,1,'<p><br></p>',0,0,5,0.00,1,1,1578984500,1578984500),(34,42,0,6,'','小米电视4A 55英寸','Xiaomi/小米 小米电视4A 55英寸 4k超高清智能网络电视机 50 60',2300.00,4500.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789845731455.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789845731455.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,1,1,1578984606,1578984606),(35,42,0,6,'','Hisense/海信 wifi彩电','Hisense/海信 LED49EC270W 49吋液晶平板电视机网络wifi彩电50',1800.00,2999.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789847119340.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789847119340.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,1,1,1578984742,1578984742),(36,42,0,6,'','大屏购物 镇店爆款','Konka/康佳 A48F 48英寸高清智能网络平板 LED液晶电视机 50 49 已累计爆售 1万台 大屏购物 镇店爆款',4500.00,6999.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789848102868.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789848102868.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,1,1,1578984824,1578984824),(37,43,0,6,'','自动洗衣机','Haier/海尔 EG10014B39GU1 10公斤kg蓝晶变频滚筒全自动洗衣机',1200.00,1399.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789848981398.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789848981398.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,1,1,1578984918,1578984918),(38,43,0,6,'','变频全自动','Haier/海尔 EG7012B29W 7公斤 变频全自动 滚筒洗衣机 消毒洗',3999.00,4500.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789849782329.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789849782329.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,1,1,1578984991,1578984991),(39,42,0,6,'','4K超高清 人气爆款','Skyworth/创维 55V9E 55吋4K超高清智能网络平板LED液晶电视机 50 25核智能 4K超高清 人气爆款',2199.00,3000.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789850938015.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789850938015.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,1,1,1578985102,1578985102),(40,42,0,6,'','曲面 4K超清','Changhong/长虹 55G6 55吋液晶电视机4k曲面平板电视智能网络wifi 曲面 4K超清 双64位 U-MAX',2599.00,3500.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789851475164.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789851475164.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,1,1,1578985164,1578985164),(41,46,0,6,'','你当像鸟飞往你的山','你当像鸟飞往你的山（比尔·盖茨年度特别推荐，登顶《纽约时报》畅销榜80 周！多一个人读到这个真实故事，就多一个人勇敢做自己！）',45.00,60.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789855695161.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789855695161.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578985572,1578985572),(42,46,0,6,'','生活态度 悲喜自渡','悲喜自渡：季羡林的孤独智慧',25.00,63.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789856514996.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789856514996.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578985666,1578985666),(43,46,0,6,'','季羡林98载了悟生命','凡心所向，素履所往：季羡林的生命智慧',28.00,50.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789857291625.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789857291625.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578985743,1578985743),(44,46,0,6,'','生活明朗 万物可爱','生活明朗 万物可爱：季羡林的豁达智慧',39.00,60.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789857983504.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789857983504.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578985808,1578985808),(45,46,0,6,'','糊涂潇洒','季羡林散文精选集：糊涂一点，潇洒一点',55.00,90.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789858817331.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789858817331.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578985891,1578985891),(46,46,0,6,'','郗士作序推荐','一个人的世界史 解读20世纪',26.00,60.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789859654804.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789859654804.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578985979,1578985979),(47,46,0,6,'','图书榜虚构类连续六周TOP1','人生海海 解密人性的荒唐与高尚',89.00,120.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789860825014.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789860825014.jpg',0.00,0,0.00,'','',0,0,1,1,'<p><br></p>',0,0,5,0.00,0,1,1578986095,1578986095),(48,46,0,6,'','皮囊','直面人生的终极问题，刻在骨头里的故事',18.00,55.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789861497404.jpg','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789861497404.jpg',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578986160,1578986160),(49,47,0,6,'','麒麟810芯片 4800万AI四摄','HUAWEI nova 5z 6GB+64GB 全网通版（幻夜黑）麒麟810芯片 4800万AI四摄 3200万人像超级夜景 创新极点全面屏',2999.00,3000.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789863245959.png','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789863245959.png',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578986339,1578986339),(50,47,0,6,'','荣耀V30系列共享','荣耀V30 PRO 双模5G 麒麟990 5G SOC芯片 突破性相机矩阵 双超级快充 8GB+128GB 冰岛幻境',3899.00,4500.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789864056865.png','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789864056865.png',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578986423,1578986423),(51,47,0,6,'','保时捷超跑基因 臻选皮质','HUAWEI Mate 30 RS 保时捷设计 5G全网通 12GB+512GB（玄黑）',12900.00,14000.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789864711939.png','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789864711939.png',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578986491,1578986491),(52,47,0,6,'','4800万超广角AI四摄 | 3200万AI自拍','荣耀20 4800万超广角AI四摄 3200W美颜自拍 麒麟980全网通版8GB+128GB 蓝水翡翠',3999.00,6850.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789865478371.png','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789865478371.png',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578986571,1578986571),(53,47,0,6,'','手环5篮球版+10000mAh','荣耀20 PRO 荣耀最强拍照手机 4800万全焦段AI四摄 麒麟980全网通版8GB+128GB 冰岛幻境',2699.00,3200.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789867525935.png','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789867525935.png',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578986769,1578986769),(54,47,0,6,'','800万AI四摄 人像超级夜景','HUAWEI nova 5 Pro 4800万AI四摄 人像超级夜景  8GB+128GB 全网通版（绮境森林）',2499.00,2599.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789868452378.png','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789868452378.png',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578986867,1578986867),(55,47,0,6,'','双模5G 麒麟990','荣耀V30 双模5G 麒麟990 突破性相机矩阵 6GB+128GB 曙光之橙',3299.00,4299.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789869295440.png','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789869295440.png',0.00,0,0.00,'','',0,0,1,1,'',0,0,5,0.00,0,1,1578986944,1578986944),(56,47,2,6,'','麒麟990 5G旗舰SoC芯片','HUAWEI Mate 30 5G 全网通 8GB+256GB 麒麟990 4000万超感光徕卡三摄',5499.00,6599.00,1000,'http://api.qingwuit.com/Uploads/goods/2020_01_14/15789870023566.png','http://api.qingwuit.com/Uploads/goods/2020_01_14/15789870023566.png',0.00,0,0.00,'','',0,0,1,1,'',0,1,5,5299.00,0,1,1578987020,1578987438);
/*!40000 ALTER TABLE `goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_brand`
--

DROP TABLE IF EXISTS `goods_brand`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_brand` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '品牌名',
  `thumb` varchar(100) NOT NULL DEFAULT '' COMMENT '品牌图片',
  `is_sort` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='商品品牌';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_brand`
--

LOCK TABLES `goods_brand` WRITE;
/*!40000 ALTER TABLE `goods_brand` DISABLE KEYS */;
INSERT INTO `goods_brand` VALUES (2,'华为','http://api.qingwuit.com/Uploads/goods_class/2019_10_16/15711888897988.png',1);
/*!40000 ALTER TABLE `goods_brand` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_class`
--

DROP TABLE IF EXISTS `goods_class`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_class` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '父ID',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '商品分类名',
  `thumb` varchar(100) NOT NULL DEFAULT '' COMMENT '分类图片',
  `rate` decimal(3,2) NOT NULL DEFAULT 0.00 COMMENT '分佣比例',
  `tags` varchar(100) NOT NULL DEFAULT '' COMMENT '标签',
  `is_sort` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COMMENT='商品分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_class`
--

LOCK TABLES `goods_class` WRITE;
/*!40000 ALTER TABLE `goods_class` DISABLE KEYS */;
INSERT INTO `goods_class` VALUES (13,0,'家用电器','',0.00,'手机,电脑',0),(14,0,'图书 & 音像 & 电子书','',0.00,'图书',1),(15,0,'手机 & 数码 & 通信','',0.00,'手机',2),(16,0,'电脑 & 办公','',0.00,'电脑',3),(17,0,'家居 & 家具 & 家装','',0.00,'家居',4),(18,0,'男装 & 女装 & 内衣','',0.00,'男装',5),(19,13,'大家电','',0.00,'',0),(20,13,'生活电器','',0.00,'',0),(21,20,'电饭煲','',0.00,'',0),(22,13,'节能电器','',0.00,'',0),(23,20,'电视剧','',0.00,'',0),(24,19,'空调','',0.00,'',0),(25,14,'图书','',0.00,'',0),(26,14,'磁带','',0.00,'',0),(27,14,'电子书','',0.00,'',0),(28,15,'手机','',0.00,'',0),(29,15,'相机','',0.00,'',0),(30,15,'摄影机','',0.00,'',0),(31,14,'对讲机','',0.00,'',0),(32,16,'戴尔','',0.00,'',0),(33,16,'神州','',0.00,'',0),(34,16,'方舟子','',0.00,'',0),(35,17,'真皮沙发','',0.00,'',0),(36,17,'日本沙发','',0.00,'',0),(37,17,'美的橱柜','',0.00,'',0),(38,18,'孕妇装','',0.00,'',0),(39,18,'男装','',0.00,'',0),(40,18,'披风大衣','',0.00,'',0),(41,22,'净水器','',0.00,'净水器',0),(42,19,'平板电视','',0.00,'',0),(43,19,'洗衣机','',0.00,'',0),(44,25,'IT科技','',0.00,'',0),(45,25,'育儿教育','',0.00,'',0),(46,25,'小说文学','',0.00,'',0),(47,28,'华为手机','',0.00,'',0),(48,28,'小米手机','',0.00,'',0),(49,28,'锤子手机','',0.00,'',0),(50,32,'平板电脑','',0.00,'',0),(51,32,'笔记本电脑','',0.00,'',0),(52,36,'卧室家具','',0.00,'',0),(53,36,'客厅家具','',0.00,'',0),(54,39,'日韩潮流','',0.00,'',0),(55,39,'哈西文化','',0.00,'',0);
/*!40000 ALTER TABLE `goods_class` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_spec`
--

DROP TABLE IF EXISTS `goods_spec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_spec` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `goods_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '产品ID',
  `spec_name` varchar(80) NOT NULL DEFAULT '' COMMENT '规格名',
  `goods_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '商品价格',
  `goods_market_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '市场价格',
  `goods_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '数量',
  `goods_image` varchar(100) NOT NULL DEFAULT '' COMMENT '规格图',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 COMMENT='商品规格';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_spec`
--

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

--
-- Table structure for table `groupbuy`
--

DROP TABLE IF EXISTS `groupbuy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groupbuy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `goods_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品ID',
  `seller_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家ID',
  `goods_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '团购价格',
  `groupbuy_num` tinyint(3) unsigned NOT NULL DEFAULT 5 COMMENT '拼团总需人数',
  `groupbuy_use` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '拼团下单人数',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='团购';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `groupbuy`
--

LOCK TABLES `groupbuy` WRITE;
/*!40000 ALTER TABLE `groupbuy` DISABLE KEYS */;
INSERT INTO `groupbuy` VALUES (1,32,1,0.00,3,1,1578293409);
/*!40000 ALTER TABLE `groupbuy` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `groupbuy_user`
--

DROP TABLE IF EXISTS `groupbuy_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groupbuy_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gb_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '团购ID',
  `order_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '订单ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `nickname` varchar(60) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `order_no` varchar(40) NOT NULL DEFAULT '' COMMENT '订单号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='团购用户订单信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `groupbuy_user`
--

LOCK TABLES `groupbuy_user` WRITE;
/*!40000 ALTER TABLE `groupbuy_user` DISABLE KEYS */;
INSERT INTO `groupbuy_user` VALUES (1,1,19,1,'神秘人2','202001061450096718');
/*!40000 ALTER TABLE `groupbuy_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hooks`
--

DROP TABLE IF EXISTS `hooks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hooks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '钩子名称',
  `content` varchar(50) NOT NULL DEFAULT '' COMMENT '描述',
  `controller_action` varchar(50) NOT NULL DEFAULT '' COMMENT '控制器和方法',
  `apis` varchar(50) NOT NULL DEFAULT '' COMMENT '接口',
  `is_type` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '后台0 商家1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8 COMMENT='操作指令权限(钩子)';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hooks`
--

LOCK TABLES `hooks` WRITE;
/*!40000 ALTER TABLE `hooks` DISABLE KEYS */;
INSERT INTO `hooks` VALUES (4,'栏目权限','栏目显示权限','\\Admin\\UsersController@get_permission_menus','/users/get_permission_menus',0),(5,'面包屑导航','面包屑导航','\\Admin\\MenusController@get_bread_nav','/menus/get_bread_nav',0),(6,'统计数据','统计数据','\\Admin\\IndexController@get_statistics','/index/get_statistics',0),(7,'后台登录','后台登录','\\Admin\\LoginController@login','/Admin/login',0),(8,'获取用户信息','获取用户信息','\\Admin\\UsersController@get_user_info','/Admin/get_user_info',0),(9,'注销账号','注销账号','\\Admin\\LoginController@logout','/logout',0),(10,'验证是否登录','验证是否登录','\\Admin\\LoginController@check_user_login','/check_user_login',0),(11,'后台菜单列表','后台菜单列表','\\Admin\\MenusController@index','/Admin/menus/index',0),(12,'后台菜单添加','后台菜单添加','\\Admin\\MenusController@add','/Admin/menus/add',0),(13,'后台菜单修改','后台菜单修改','\\Admin\\MenusController@edit','/Admin/menus/edit/{id}',0),(14,'后台菜单删除','后台菜单删除','\\Admin\\MenusController@del','/Admin/menus/del',0),(15,'后台角色列表','后台角色','\\Admin\\RolesController@index','/Admin/roles/index',0),(16,'后台角色添加','后台角色','\\Admin\\RolesController@add','/Admin/roles/add',0),(17,'后台角色编辑','后台角色','\\Admin\\RolesController@edit','/Admin/roles/edit/{id}',0),(18,'后台角色删除','后台角色','\\Admin\\RolesController@del','/Admin/roles/del',0),(19,'接口控制','接口控制','\\Admin\\HooksController@index','/Admin/hooks/index',0),(20,'接口控制添加','接口控制','\\Admin\\HooksController@add','/Admin/hooks/add',0),(21,'接口控制编辑','接口控制','\\Admin\\HooksController@edit','/Admin/hooks/edit/{id}',0),(22,'接口控制删除','接口控制','\\Admin\\HooksController@del','/Admin/hooks/del',0),(23,'后台用户列表','后台用户','\\Admin\\UsersController@index','/Admin/users/index',0),(24,'后台用户添加','后台用户','\\Admin\\UsersController@add','/Admin/users/add',0),(25,'后台用户编辑','后台用户','\\Admin\\UsersController@edit','/Admin/users/edit/{id}',0),(26,'后台用户删除','后台用户','\\Admin\\UsersController@del','/Admin/users/del',0),(27,'获取用户信息','获取用户信息','\\Admin\\UsersController@get_user_info','/Admin/users/get_user_info',0),(28,'修用户资金','修用户资金','\\Admin\\UsersController@change_money','/Admin/users/change_money',0),(29,'网址设置','网址设置','\\Admin\\ConfigController@web_config','/Admin/config/web_config',0),(30,'上传设置','上传设置','\\Admin\\ConfigController@upload_config','/Admin/config/upload_config',0),(31,'地图设置','地图设置','\\Admin\\ConfigController@map_config','/Admin/config/map_config',0),(32,'微信支付H5配置','微信支付H5配置','\\Admin\\ConfigController@wxpay_h5_config','/Admin/config/wxpay_h5_config',0),(33,'微信支付APP配置','微信支付APP配置','\\Admin\\ConfigController@wxpay_app_config','/Admin/config/wxpay_app_config',0),(34,'微信支付JSAPI配置','微信支付JSAPI配置','\\Admin\\ConfigController@wxpay_jsapi_config','/Admin/config/wxpay_jsapi_config',0),(35,'微信支付MINI配置(小程序)','微信支付MINI配置(小程序)','\\Admin\\ConfigController@wxpay_mini_config','/Admin/config/wxpay_mini_config',0),(36,'阿里云物流配置','阿里云物流配置','\\Admin\\ConfigController@freight_config','/Admin/config/freight_config',0),(37,'微信公众号配置','微信公众号配置','\\Admin\\ConfigController@wechat_public_config','/Admin/config/wechat_public_config',0),(38,'微信Oauth 配置 PC','微信Oauth 配置 PC','\\Admin\\ConfigController@oauth_config','/Admin/config/oauth_config',0),(39,'分销配置','分销配置','\\Admin\\ConfigController@distribution_config','/Admin/config/distribution_config',0),(40,'定时任务 自动执行','定时任务 自动执行','\\Admin\\ConfigController@task_time_config','/Admin/config/task_time_config',0),(41,'短信列表','短信列表','\\Admin\\SmsLogController@index','/Admin/sms_log/index',0),(42,'短信列表删除','短信列表','\\Admin\\SmsLogController@del','/Admin/sms_log/del',0),(43,'支付宝支付 H5','支付宝支付 H5','\\Admin\\ConfigController@alipay_h5_config','/Admin/config/alipay_h5_config',0),(44,'支付宝支付 App','支付宝支付 App','\\Admin\\ConfigController@alipay_app_config','/Admin/config/alipay_app_config',0),(45,'支付宝支付PC','支付宝支付PC','\\Admin\\ConfigController@alipay_pc_config','/Admin/config/alipay_pc_config',0),(46,'支付宝短信sms','支付宝短信sms','\\Admin\\ConfigController@alisms_config','/Admin/config/alisms_config',0),(47,'站点设置 Logo上传','站点设置 Logo上传','\\Admin\\ConfigController@logo_upload','/Admin/config/logo_upload',0),(48,'商品分类列表','商品分类','\\Admin\\GoodsClassController@index','/Admin/goods_class/index',0),(49,'商品分类添加','商品分类','\\Admin\\GoodsClassController@add','/Admin/goods_class/add',0),(50,'商品分类编辑','商品分类','\\Admin\\GoodsClassController@edit','/Admin/goods_class/edit/{id}',0),(51,'商品分类删除','商品分类','\\Admin\\GoodsClassController@del','/Admin/goods_class/del',0),(52,'分类图片 上传','分类图片 上传','\\Admin\\GoodsClassController@goods_class_upload','/Admin/goods_class/goods_class_upload',0),(53,'订单管理列表','订单管理','\\Admin\\OrderController@index','/Admin/order/index',0),(54,'订单详情','订单详情','\\Admin\\OrderController@info','/Admin/order/info',0),(55,'品牌分类列表','品牌分类','\\Admin\\GoodsBrandController@index','/Admin/goods_brand/index',0),(56,'品牌分类添加','品牌分类','\\Admin\\GoodsBrandController@add','/Admin/goods_brand/add',0),(57,'品牌分类编辑','品牌分类','\\Admin\\GoodsBrandController@edit','/Admin/goods_brand/edit/{id}',0),(58,'品牌分类删除','品牌分类','\\Admin\\GoodsBrandController@del','/Admin/goods_brand/del',0),(59,'品牌图片 上传','品牌图片 上传','\\Admin\\GoodsBrandController@goods_brand_upload','/Admin/goods_brand/goods_brand_upload',0),(60,'地区管理列表','地区管理','\\Admin\\AreaController@index','/Admin/area/index',0),(61,'地区管理添加','地区管理','\\Admin\\AreaController@add','/Admin/area/add',0),(62,'地区管理编辑','地区管理','\\Admin\\AreaController@edit','/Admin/area/edit/{id}',0),(63,'地区管理删除','地区管理','\\Admin\\AreaController@del','/Admin/area/del',0),(64,'获取地区子地区','获取地区子地区','\\Admin\\AreaController@get_area_children','/Admin/area/get_area_children',0),(65,'获取地区列表2','获取地区列表2','\\Admin\\AreaController@get_area_list','/Admin/area/get_area_list',0),(66,'缓存清空','缓存清空','\\Admin\\AutoController@cache_flush','/Admin/auto/cache_flush',0),(67,'商品管理列表','商品管理','\\Admin\\GoodsController@index','/Admin/goods/index',0),(68,'商品管理审核','商品管理','\\Admin\\GoodsController@goods_verify','/Admin/goods/goods_verify',0),(69,'商品管理审核状态','商品管理','\\Admin\\GoodsController@goods_verify_change','/Admin/goods/goods_verify_change',0),(70,'指定ID 修改上下架','指定ID 修改上下架','\\Admin\\GoodsController@goods_status','/Admin/goods/goods_status',0),(71,'指定ID 修改上下架','指定ID 修改上下架','\\Admin\\GoodsController@goods_index','/Admin/goods/goods_index',0),(72,'广告位列表','广告位','\\Admin\\AdvPositionController@index','/Admin/adv_position/index',0),(73,'广告位添加','广告位','\\Admin\\AdvPositionController@add','/Admin/adv_position/add',0),(74,'广告位编辑','广告位','\\Admin\\AdvPositionController@edit','/Admin/adv_position/edit/{id}',0),(75,'广告位删除','广告位','\\Admin\\AdvPositionController@del','/Admin/adv_position/del',0),(76,'广告列表','广告','\\Admin\\AdvController@index','/Admin/adv/index',0),(77,'广告添加','广告','\\Admin\\AdvController@add','/Admin/adv/add',0),(78,'广告编辑','广告','\\Admin\\AdvController@edit','/Admin/adv/edit/{id}',0),(79,'广告删除','广告','\\Admin\\AdvController@del','/Admin/adv/del',0),(80,'广告图片 上传','广告','\\Admin\\AdvController@adv_upload','/Admin/adv/adv_upload',0),(81,'秒杀活动列表','秒杀活动','\\Admin\\SeckillController@index','/Admin/seckill/index',0),(82,'秒杀活动添加','秒杀活动','\\Admin\\SeckillController@add','/Admin/seckill/add',0),(83,'秒杀活动编辑','秒杀活动','\\Admin\\SeckillController@edit','/Admin/seckill/edit/{id}',0),(84,'免杀活动删除','秒杀活动','\\Admin\\SeckillController@del','/Admin/seckill/del',0),(85,'秒杀活动商品列表','秒杀活动','\\Admin\\SeckillController@get_add_seckill_goods','/Admin/seckill/get_add_seckill_goods',0),(86,'秒杀活动审核','秒杀活动','\\Admin\\SeckillController@change_status','/Admin/seckill/change_status',0),(87,'秒杀活动删除商品','秒杀活动','\\Admin\\SeckillController@del_seckill_goods','/Admin/seckill/del_seckill_goods',0),(88,'站点协议列表','站点协议','\\Admin\\AgreementController@index','/Admin/agreement/index',0),(89,'站点协议添加','站点协议','\\Admin\\AgreementController@add','/Admin/agreement/add',0),(90,'站点协议编辑','站点协议','\\Admin\\AgreementController@edit','/Admin/agreement/edit/{id}',0),(91,'站点协议删除','站点协议','\\Admin\\AgreementController@del','/Admin/agreement/del',0),(92,'店铺列表列表','店铺列表','\\Admin\\StoreController@index','/Admin/store/index',0),(93,'店铺列表删除','店铺列表','\\Admin\\StoreController@del','/Admin/store/del',0),(94,'店铺列表审核','店铺列表','\\Admin\\StoreController@store_pass','/Admin/store/store_pass',0),(95,'积分商品图片 上传','积分商品图片 上传','\\Admin\\IntegralController@integral_upload','/Admin/integral/integral_upload',0),(96,'积分商城列表','积分商城','\\Admin\\IntegralController@index','/Admin/integral/index',0),(97,'积分商城添加','积分商城','\\Admin\\IntegralController@add','/Admin/integral/add',0),(98,'积分商城编辑','积分商城','\\Admin\\IntegralController@edit','/Admin/integral/edit/{id}',0),(99,'积分商城删除','积分商城','\\Admin\\IntegralController@del','/Admin/integral/del',0),(100,'指定ID 修改上下架','积分商城','\\Admin\\IntegralController@goods_status','/Admin/integral/goods_status',0),(101,'指定ID 修改热门推荐','积分商城','\\Admin\\IntegralController@goods_hot','/Admin/integral/goods_hot',0),(102,'积分商城分类列表','积分商城分类','\\Admin\\IntegralClassController@index','/Admin/integral_class/index',0),(103,'积分商城分类添加','积分商城分类','\\Admin\\IntegralClassController@add','/Admin/integral_class/add',0),(104,'积分商城分类编辑','积分商城分类','\\Admin\\IntegralClassController@edit','/Admin/integral_class/edit/{id}',0),(105,'积分商城分类删除','积分商城分类','\\Admin\\IntegralClassController@del','/Admin/integral_class/del',0),(106,'积分订单管理列表','积分订单管理','\\Admin\\IntegralOrderController@index','/Admin/integral_order/index',0),(107,'积分订单管理详情','积分订单管理','\\Admin\\IntegralOrderController@info','/Admin/integral_order/info',0),(108,'积分订单管理填写物流','积分订单管理','\\Admin\\IntegralOrderController@send_delivery','/Admin/integral_order/send_delivery',0),(109,'资金提现列表','资金提现','\\Admin\\CashLogController@index','/Admin/cash/index',0),(110,'资金提现修改状态','资金提现','\\Admin\\CashLogController@change_status','/Admin/cash/change_status',0),(111,'资金提现删除','资金提现','\\Admin\\CashLogController@del','/Admin/cash/del',0),(112,'商家登录','商家登录','\\Seller\\LoginController@login','/Seller/login',1),(113,'商家获取用户信息','商家获取用户信息','\\Seller\\UsersController@get_user_info','/Seller/get_user_info',1),(114,'验证是否登录','验证是否登录','\\Seller\\LoginController@check_user_login','/Seller/check_user_login',1),(115,'商家首页统计数据','首页统计数据','\\Seller\\IndexController@get_statistics','/Seller/index/get_statistics',1),(116,'规格属性列表','规格属性','\\Seller\\AttrSpecController@index','/Seller/attr_spec/index',1),(117,'规格属性添加','规格属性','\\Seller\\AttrSpecController@add','/Seller/attr_spec/add',1),(118,'规格属性编辑','规格属性','\\Seller\\AttrSpecController@edit','/Seller/attr_spec/edit/{id}',1),(119,'规格属性删除','规格属性','\\Seller\\AttrSpecController@del','/Seller/attr_spec/del',1),(120,'商家自定义分类列表','商家自定义分类','\\Seller\\StoreGoodsClassController@index','/Seller/store_goods_class/index',1),(121,'商家自定义分类添加','商家自定义分类','\\Seller\\StoreGoodsClassController@add','/Seller/store_goods_class/add',1),(122,'商家自定义分类编辑','商家自定义分类','\\Seller\\StoreGoodsClassController@edit','/Seller/store_goods_class/edit/{id}',1),(123,'商家自定义分类删除','商家自定义分类','\\Seller\\StoreGoodsClassController@del','/Seller/store_goods_class/del',1),(124,'商品图片 上传','商品','\\Seller\\GoodsController@goods_upload','/Seller/goods/goods/goods_upload',1),(125,'商品列表','商品','\\Seller\\GoodsController@index','/Seller/goods/index',1),(126,'商品添加','商品','\\Seller\\GoodsController@add','/Seller/goods/add',1),(127,'商品编辑','商品','\\Seller\\GoodsController@edit','/Seller/goods/edit/{id}',1),(128,'商品删除','商品','\\Seller\\GoodsController@del','/Seller/goods/del',1),(129,'指定ID 修改上下架','商品','\\Seller\\GoodsController@goods_status','/Seller/goods/goods_status',1),(130,'订单管理列表','订单管理','\\Seller\\OrderController@index','/Seller/order/index',1),(131,'订单管理信息','订单管理','\\Seller\\OrderController@info','/Seller/order/info',1),(132,'订单管理物流添加','订单管理','\\Seller\\OrderController@send_delivery','/Seller/order/send_delivery',1),(133,'订单管理售后','订单管理','\\Seller\\OrderController@refund','/Seller/order/refund',1),(134,'订单管理退款','订单管理','\\Seller\\OrderController@refund_money','/Seller/order/refund_money',1),(135,'拼团订单列表','拼团订单','\\Seller\\GroupbuyController@index','/Seller/groupbuy/index',1),(136,'拼团订单用户','拼团订单','\\Seller\\GroupbuyController@get_groupbuy_user','/Seller/groupbuy/get_groupbuy_user',1),(137,'运费模版列表','运费模版','\\Seller\\FreightTemplateController@index','/Seller/freight_template/index',1),(138,'运费模版添加','运费模版','\\Seller\\FreightTemplateController@add','/Seller/freight_template/add',1),(139,'运费模版编辑','运费模版','\\Seller\\FreightTemplateController@edit','/Seller/freight_template/edit/{id}',1),(140,'运费模版删除','运费模版','\\Seller\\FreightTemplateController@del','/Seller/freight_template/del',1),(141,'添加商品 选择商品分类','商品','\\Seller\\StoreController@get_store_class','/Seller/store/get_store_class',1),(142,'商家店铺信息设置','商家店铺信息设置','\\Seller\\StoreController@setting','/Seller/store/setting',1),(143,'设置包邮','设置包邮','\\Seller\\StoreController@free_freight','/Seller/free_freight/setting',1),(144,'设置售后','设置售后','\\Seller\\StoreController@after_sale_content','/Seller/store/after_sale_content',1),(145,'店铺LOGO上传','店铺LOGO','\\Seller\\StoreController@logo_upload','/Seller/store/logo_upload',1),(146,'秒杀列表','秒杀','\\Seller\\SeckillController@index','/Seller/seckill/index',1),(147,'秒杀添加申请','秒杀','\\Seller\\SeckillController@add','/Seller/seckill/add',1),(148,'秒杀添加商品','秒杀','\\Seller\\SeckillController@add_seckill_goods','/Seller/seckill/add_seckill_goods',1),(149,'秒杀获取申请商品','秒杀','\\Seller\\SeckillController@get_add_seckill_goods','/Seller/seckill/get_add_seckill_goods',1),(150,'秒杀删除商品','秒杀','\\Seller\\SeckillController@del_seckill_goods','/Seller/seckill/del_seckill_goods',1),(151,'获取地区信息  省市区  三级选择框','获取地区信息  省市区  三级选择框','\\Seller\\AreaController@get_area_list','/Seller/area/get_area_list',1),(152,'富文本编辑上传','富文本编辑上传','\\Seller\\AutoController@auto_upload','/Seller/auto/auto_upload',1);
/*!40000 ALTER TABLE `hooks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `integral_class`
--

DROP TABLE IF EXISTS `integral_class`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `integral_class` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(10) NOT NULL DEFAULT '' COMMENT '栏目名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='积分商品分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `integral_class`
--

LOCK TABLES `integral_class` WRITE;
/*!40000 ALTER TABLE `integral_class` DISABLE KEYS */;
INSERT INTO `integral_class` VALUES (2,'积分栏目一');
/*!40000 ALTER TABLE `integral_class` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `integral_goods`
--

DROP TABLE IF EXISTS `integral_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `integral_goods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '分类',
  `goods_name` varchar(80) NOT NULL DEFAULT '',
  `goods_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '积分价格',
  `goods_market_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '市场价',
  `goods_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '库存',
  `goods_images` text NOT NULL DEFAULT '' COMMENT '图片',
  `goods_master_image` varchar(100) NOT NULL DEFAULT '' COMMENT '主图',
  `goods_sale_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '销售数量',
  `goods_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '状态 0 下架 1上架',
  `goods_content` text NOT NULL DEFAULT '' COMMENT '内容',
  `is_hot` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '是否推荐',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='积分商品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `integral_goods`
--

LOCK TABLES `integral_goods` WRITE;
/*!40000 ALTER TABLE `integral_goods` DISABLE KEYS */;
INSERT INTO `integral_goods` VALUES (1,0,'积分测试',1.00,22.00,996,'http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242401532.png,http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242469142.jpg','http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242469142.jpg',0,1,'<p>2</p>',1,1578126562),(3,2,'阿萨',1.00,2.00,3,'http://api.qingwuit.com/Uploads/integral/2020_01_04/15781275612430.png','http://api.qingwuit.com/Uploads/integral/2020_01_04/15781275612430.png',0,1,'<p>4</p>',0,1578127566);
/*!40000 ALTER TABLE `integral_goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `integral_order`
--

DROP TABLE IF EXISTS `integral_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `integral_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_no` varchar(20) NOT NULL DEFAULT '' COMMENT '订单号',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '买家',
  `user_nickname` varchar(20) NOT NULL DEFAULT '' COMMENT '昵称',
  `order_name` varchar(80) NOT NULL DEFAULT '' COMMENT '订单名称',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT '图片',
  `total_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '总价格',
  `delivery_no` varchar(20) NOT NULL DEFAULT '' COMMENT '快递单号',
  `delivery_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '快递状态',
  `province` varchar(20) NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(20) NOT NULL DEFAULT '' COMMENT '城市',
  `region` varchar(20) NOT NULL DEFAULT '' COMMENT '区县',
  `address` varchar(30) NOT NULL DEFAULT '' COMMENT '详细地址',
  `receive_tel` varchar(11) NOT NULL DEFAULT '' COMMENT '收件电话',
  `receive_name` varchar(11) NOT NULL DEFAULT '' COMMENT '收件人',
  `remark` varchar(80) NOT NULL DEFAULT '' COMMENT '备注',
  `order_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '订单状态 0 未完成 1 完成 2 取消订单',
  `pay_type` varchar(12) NOT NULL DEFAULT '' COMMENT '支付类型',
  `pay_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '支付时间',
  `pay_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '支付状态 0 未完成 1 完成',
  `close_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '取消时间',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='积分商品订单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `integral_order`
--

LOCK TABLES `integral_order` WRITE;
/*!40000 ALTER TABLE `integral_order` DISABLE KEYS */;
INSERT INTO `integral_order` VALUES (2,'202001051556595353',1,'神秘人2','积分测试等','http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242469142_200.jpg',1.00,'',0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','测试积分订单',0,'',0,0,0,1578211020),(3,'202001051611212972',1,'神秘人2','积分测试等','http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242469142_200.jpg',1.00,'cccccc',1,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',1,'',1578211881,1,0,1578211881),(6,'202001051657338726',1,'神秘人2','积分测试等','http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242469142_200.jpg',1.00,'',0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0,'',1578214653,1,0,1578214653);
/*!40000 ALTER TABLE `integral_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `integral_order_goods`
--

DROP TABLE IF EXISTS `integral_order_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `integral_order_goods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '订单id',
  `goods_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品ID',
  `goods_name` varchar(80) NOT NULL DEFAULT '' COMMENT '商品名称',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT '商品图片',
  `total_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '总价格',
  `goods_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '商品价格',
  `goods_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='积分订单商品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `integral_order_goods`
--

LOCK TABLES `integral_order_goods` WRITE;
/*!40000 ALTER TABLE `integral_order_goods` DISABLE KEYS */;
INSERT INTO `integral_order_goods` VALUES (1,2,1,'积分测试','http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242469142_200.jpg',1.00,1.00,1),(2,3,1,'积分测试','http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242469142_200.jpg',1.00,1.00,1),(5,6,1,'积分测试','http://api.qingwuit.com/Uploads/integral/2020_01_04/15781242469142_200.jpg',1.00,1.00,1);
/*!40000 ALTER TABLE `integral_order_goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menus`
--

DROP TABLE IF EXISTS `menus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '鐖剁骇ID',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '鑿滃崟鍚?',
  `icon` varchar(15) NOT NULL DEFAULT '' COMMENT '闃块噷ICON鍥炬爣',
  `url` varchar(100) NOT NULL DEFAULT '' COMMENT '鑿滃崟閾炬帴',
  `is_sort` int(10) unsigned NOT NULL DEFAULT 1 COMMENT '鎺掑簭',
  `is_type` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '绫诲瀷 0 鍚庡彴 1 鍟嗗?',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COMMENT='鍚庡彴鑿滃崟';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menus`
--

LOCK TABLES `menus` WRITE;
/*!40000 ALTER TABLE `menus` DISABLE KEYS */;
INSERT INTO `menus` VALUES (6,0,'配置中心','&#xe667;','/',1,0),(7,0,'用户中心','&#xe601;','/',0,0),(8,7,'用户管理','&#xe601;','/Admin/users/index',0,0),(9,7,'菜单管理','/','/Admin/menus/index',0,0),(10,7,'角色管理','/','/Admin/roles/index',0,0),(11,7,'接口管理','/','/Admin/hooks/index',0,0),(12,6,'网站配置','/','/Admin/config/web_config',0,0),(13,6,'上传配置','/','/Admin/config/upload_config',0,0),(14,6,'地图配置','/','/Admin/config/map_config',0,0),(15,6,'支付配置','/','/Admin/config/pay_config',0,0),(16,6,'短信配置','/','/Admin/config/alisms_config',0,0),(17,6,'公众号配置','/','/Admin/config/wechat_public_config',0,0),(18,0,'商品中心','&#xe61d;','/',2,0),(19,18,'商品分类','/','/Admin/goods_class/index',0,0),(20,18,'品牌管理','/','/Admin/goods_brand/index',0,0),(21,18,'商品管理','/','/Admin/goods/index',0,0),(22,0,'店铺中心','&#xe654;','/',3,0),(23,22,'店铺管理','/','/Admin/store/index',0,0),(24,22,'店铺申请','/','/Admin/store/join',0,0),(25,0,'订单中心','&#xe618;','/',4,0),(26,25,'订单管理','/','/Admin/order/index',0,0),(27,25,'售后处理','/','/Admin/refund/index',1,0),(28,0,'积分商城','&#xe629;','/',5,0),(29,28,'积分产品','/','/Admin/integral/index',0,0),(30,28,'积分订单','/','/Admin/integral_order/index',0,0),(31,28,'积分分类','/','/Admin/integral_class/index',0,0),(32,0,'物流中心','&#xe608;','/',6,0),(33,32,'地区管理','/','/Admin/area/index',0,0),(34,0,'营销中心','&#xe653;','/',7,0),(35,34,'秒杀管理','/','/Admin/seckill/index',0,0),(36,0,'广告中心','&#xeb9c;','/',8,0),(37,36,'广告位管理','/','/Admin/adv_position/index',0,0),(38,36,'广告管理','/','/Admin/adv/index',0,0),(39,0,'店铺中心','&#xe654;','/',1,1),(40,39,'店铺设置','/','/Seller/store/setting',0,1),(41,0,'订单中心','&#xe618;','/',3,1),(42,41,'订单列表','/','/Seller/order/index',0,1),(44,0,'物流中心','&#xe608;','/',2,1),(45,0,'售后中心','&#xeba9;','/',4,1),(46,0,'商品中心','&#xe61d;','/',0,1),(47,0,'营销中心','&#xe653;','/',5,1),(48,46,'商品列表','/','/Seller/goods/index',0,1),(49,46,'规格属性','/','/Seller/attr_spec/index',0,1),(50,6,'站点协议','/','/Admin/agreement/index',6,0),(51,22,'申请失败','/','/Admin/store/error',3,0),(52,44,'运费模版','/','/Seller/freight_template/index',0,1),(53,44,'免运费设置','/','/Seller/free_freight/index',0,1),(54,39,'售后配置','/','/Seller/store/after_sale_content',1,1),(56,47,'秒杀商品','/','/Seller/seckill/index',0,1),(58,46,'店铺分类','/','/Seller/store_goods_class/index',0,1),(59,6,'快递配置','/','/Admin/config/freight_config',5,0),(60,45,'售后处理','/','/Seller/refund/index',0,1),(61,6,'OAuth配置','/','/Admin/config/oauth_config',5,0),(62,6,'分销配置','/','/Admin/config/distribution',7,0),(63,41,'团购订单','/','/Seller/groupbuy_order/index',1,1),(64,7,'提现管理','/','/Admin/cash/index',4,0),(65,6,'任务执行','/','/Admin/config/task_time',8,0);
/*!40000 ALTER TABLE `menus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `money_log`
--

DROP TABLE IF EXISTS `money_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `money_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `log_no` varchar(20) NOT NULL DEFAULT '' COMMENT '变更号，订单则订单号',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `nickname` varchar(20) NOT NULL DEFAULT '0' COMMENT '用户昵称',
  `name` varchar(15) NOT NULL DEFAULT '未知变更' COMMENT '名称:支付订单',
  `money` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '资金',
  `frozen_money` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '冻结资金',
  `integral` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '积分',
  `pay_type` varchar(10) NOT NULL DEFAULT '' COMMENT '支付方式',
  `info` varchar(50) NOT NULL DEFAULT '' COMMENT '描述',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='用户资金变更日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `money_log`
--

LOCK TABLES `money_log` WRITE;
/*!40000 ALTER TABLE `money_log` DISABLE KEYS */;
INSERT INTO `money_log` VALUES (30,'202001071242406960',1,'神秘人2','订单支付',-1.00,0.00,0.00,'余额支付','order_no:28',1578372160),(31,'202001071242409232',1,'神秘人2','订单冻结',0.00,1.00,0.00,'余额支付','order_no:28',1578372160),(32,'202001071520146945',1,'神秘人2','售后退款',0.00,-1.00,0.00,'-','order_no:202001071242409656',1578381614),(33,'202001071520149050',1,'神秘人2','售后退款',1.00,0.00,0.00,'-','order_no:202001071242409656',1578381614);
/*!40000 ALTER TABLE `money_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_goods`
--

DROP TABLE IF EXISTS `order_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_goods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '订单ID',
  `spec_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '规格属性ID',
  `goods_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品ID',
  `goods_name` varchar(80) NOT NULL DEFAULT '' COMMENT '商品名',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT '订单图片',
  `total_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '总价格',
  `goods_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '商品价格',
  `goods_num` int(9) NOT NULL DEFAULT 0 COMMENT '数量',
  `goods_spec` varchar(100) NOT NULL DEFAULT '' COMMENT '规格属性',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='订单商品表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_goods`
--

LOCK TABLES `order_goods` WRITE;
/*!40000 ALTER TABLE `order_goods` DISABLE KEYS */;
INSERT INTO `order_goods` VALUES (19,18,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML'),(20,19,0,32,'三星C24F396FH曲面显示器23.5英寸电脑显示器24液晶显示屏幕超22','http://api.qingwuit.com/Uploads/goods/2020_01_06/15782878602527_200.jpg',89.00,100.00,1,''),(21,20,0,32,'三星C24F396FH曲面显示器23.5英寸电脑显示器24液晶显示屏幕超22','http://api.qingwuit.com/Uploads/goods/2020_01_06/15782878602527_200.jpg',89.00,100.00,1,''),(22,21,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML'),(23,22,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML'),(24,23,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML'),(25,24,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML'),(26,25,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML'),(27,26,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML'),(28,28,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML'),(29,29,79,31,'第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,1,'10ML');
/*!40000 ALTER TABLE `order_goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_no` varchar(20) NOT NULL DEFAULT '' COMMENT '订单号',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `user_nickname` varchar(30) NOT NULL DEFAULT '用户昵称',
  `seller_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家ID',
  `store_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '店铺ID',
  `store_name` varchar(30) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `store_logo` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺Logo',
  `order_name` varchar(80) NOT NULL DEFAULT '' COMMENT '订单名称,商品名',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT '订单图片',
  `total_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '总价格',
  `order_price` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '订单价格',
  `freight_money` decimal(6,2) NOT NULL DEFAULT 0.00 COMMENT '运费',
  `delivery_no` varchar(20) NOT NULL DEFAULT '' COMMENT '快递单号',
  `delivery_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '发货状态',
  `delivery_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '发货时间',
  `province` varchar(20) NOT NULL DEFAULT '' COMMENT '收件省份',
  `city` varchar(20) NOT NULL DEFAULT '' COMMENT '收件市',
  `region` varchar(20) NOT NULL DEFAULT '' COMMENT '收件区县',
  `address` varchar(40) NOT NULL DEFAULT '' COMMENT '收件详细地址',
  `receive_tel` varchar(11) NOT NULL DEFAULT '' COMMENT '收件电话',
  `receive_name` varchar(10) NOT NULL DEFAULT '' COMMENT '收件人',
  `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
  `balance` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '余额支付金额',
  `order_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '订单状态 0 未完成 1 完成 2 取消订单',
  `complete_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '订单完成时间',
  `comment_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '评论状态 0 未完成 1 完成',
  `comment_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '评论时间',
  `pay_type` varchar(12) NOT NULL DEFAULT '' COMMENT '支付类型',
  `pay_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '支付时间',
  `pay_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '支付状态 0 未完成 1 完成',
  `refund` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '0 非售后 1 处理中  2 完成',
  `refund_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '售后状态 1 退款 2 退货',
  `refund_step` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '退货步骤 0 等待商家同意 1 等待用户填写快递单 2 等待商家确认 3商家填写快递 4完成 ',
  `refund_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '退款时间',
  `refund_delivery_no` varchar(20) NOT NULL DEFAULT '' COMMENT '退货快递单号',
  `refund_no` varchar(40) NOT NULL DEFAULT '' COMMENT '再次寄出单号',
  `refund_info` varchar(100) NOT NULL DEFAULT '' COMMENT '售后原因',
  `close_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '取消订单时间',
  `is_groupbuy` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '是否拼团订单',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='订单表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (18,'202001061431369198',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,0,1578292296),(19,'202001061450096718',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','三星C24F396FH曲面显示器23.5英寸电脑显示器24液晶显示屏幕超22等','http://api.qingwuit.com/Uploads/goods/2020_01_06/15782878602527_200.jpg',89.00,89.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,1,1578293409),(20,'202001061511346993',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','三星C24F396FH曲面显示器23.5英寸电脑显示器24液晶显示屏幕超22等','http://api.qingwuit.com/Uploads/goods/2020_01_06/15782878602527_200.jpg',89.00,89.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,1,1578294694),(21,'202001071215136783',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,0,1578370513),(22,'202001071215526125',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,0,1578370552),(23,'202001071216118253',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,0,1578370571),(24,'202001071221322459',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,0,1578370892),(25,'202001071228553583',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,0,1578371335),(26,'202001071229192908',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,0,1578371359),(28,'202001071242409656',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'xxxxxx',1,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',1.00,2,0,0,0,'money_pay',1578372160,1,1,1,4,1578381614,'xxxxxxxxxxx','','就是退款',0,0,1578372160),(29,'202001141051043312',1,'神秘人2',1,6,'青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','第三个商品等','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339_200.jpg',1.00,1.00,0.00,'',0,0,'北京市','市辖区','东城区','东门大街402号','15073010917','马大哈','',0.00,0,0,0,0,'',0,0,0,0,0,0,'','','',0,0,1578970264);
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_link_hook`
--

DROP TABLE IF EXISTS `role_link_hook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_link_hook` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '鐢ㄦ埛ID',
  `hook_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '閽╁瓙ID',
  `commands` tinyint(4) NOT NULL DEFAULT 1 COMMENT '鎸囦护锛?0 鍏抽棴 1 寮?鍚?',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8 COMMENT='瑙掕壊鍏宠仈閽╁瓙';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_link_hook`
--

LOCK TABLES `role_link_hook` WRITE;
/*!40000 ALTER TABLE `role_link_hook` DISABLE KEYS */;
INSERT INTO `role_link_hook` VALUES (4,1,4,1),(5,1,6,1),(6,1,5,1),(7,1,7,1),(8,1,8,1),(9,1,10,1),(10,1,12,1),(11,1,9,1),(12,1,11,1),(13,1,13,1),(14,1,14,1),(15,1,15,1),(16,1,16,1),(17,1,17,1),(18,1,19,1),(19,1,18,1),(20,1,20,1),(21,1,22,1),(22,1,21,1),(23,1,23,1),(24,1,25,1),(25,1,24,1),(26,1,26,1),(27,1,27,1),(28,1,28,1),(29,1,29,1),(30,1,31,1),(31,1,33,1),(32,1,35,1),(33,1,37,1),(34,1,41,1),(35,1,39,1),(36,1,43,1),(37,1,45,1),(38,1,47,1),(39,1,49,1),(40,1,51,1),(41,1,53,1),(42,1,55,1),(43,1,57,1),(44,1,59,1),(45,1,61,1),(46,1,63,1),(47,1,65,1),(48,1,67,1),(49,1,69,1),(50,1,71,1),(51,1,73,1),(52,1,75,1),(53,1,77,1),(54,1,79,1),(55,1,81,1),(56,1,83,1),(57,1,85,1),(58,1,87,1),(59,1,89,1),(60,1,91,1),(61,1,93,1),(62,1,95,1),(63,1,97,1),(64,1,99,1),(65,1,101,1),(66,1,103,1),(67,1,105,1),(68,1,107,1),(69,1,108,1),(70,1,110,1),(71,1,106,1),(72,1,104,1),(73,1,102,1),(74,1,100,1),(75,1,98,1),(76,1,96,1),(77,1,94,1),(78,1,92,1),(79,1,90,1),(80,1,88,1),(81,1,86,1),(82,1,84,1),(83,1,82,1),(84,1,80,1),(85,1,78,1),(86,1,76,1),(87,1,74,1),(88,1,72,1),(89,1,70,1),(90,1,68,1),(91,1,66,1),(92,1,64,1),(93,1,62,1),(94,1,60,1),(95,1,58,1),(96,1,56,1),(97,1,54,1),(98,1,52,1),(99,1,50,1),(100,1,48,1),(101,1,46,1),(102,1,44,1),(103,1,42,1),(104,1,40,1),(105,1,38,1),(106,1,36,1),(107,1,34,1),(108,1,32,1),(109,1,30,1),(110,1,111,1),(111,1,109,1),(112,1,152,1),(113,30,114,1),(114,30,112,1),(115,30,116,1),(116,30,118,1),(117,30,120,1),(118,30,122,1),(119,30,124,1),(120,30,126,1),(121,30,128,1),(122,30,130,1),(123,30,132,1),(124,30,134,1),(125,30,136,1),(126,30,138,1),(127,30,140,1),(128,30,142,1),(129,30,144,1),(130,30,146,1),(131,30,148,1),(132,30,150,1),(133,30,152,1),(134,30,151,1),(135,30,149,1),(136,30,147,1),(137,30,145,1),(138,30,143,1),(139,30,141,1),(140,30,139,1),(141,30,137,1),(142,30,135,1),(143,30,133,1),(144,30,131,1),(145,30,129,1),(146,30,127,1),(147,30,125,1),(148,30,123,1),(149,30,121,1),(150,30,119,1),(151,30,117,1),(152,30,115,1),(153,30,113,1),(154,30,4,1),(155,30,5,1),(156,30,8,1),(157,30,10,1),(158,1,112,1),(159,1,113,1),(160,1,115,1),(161,1,114,1),(162,1,116,1),(163,1,117,1),(164,1,119,1),(165,1,118,1),(166,1,120,1),(167,1,121,1),(168,1,123,1),(169,1,122,1),(170,1,124,1),(171,1,125,1),(172,1,127,1),(173,1,126,1),(174,1,128,1),(175,1,129,1),(176,1,131,1),(177,1,133,1),(178,1,132,1),(179,1,130,1),(180,1,134,1),(181,1,135,1),(182,1,136,1),(183,1,138,1),(184,1,140,1),(185,1,142,1),(186,1,144,1),(187,1,146,1),(188,1,148,1),(189,1,150,1),(190,1,149,1),(191,1,151,1),(192,1,147,1),(193,1,145,1),(194,1,143,1),(195,1,141,1),(196,1,139,1),(197,1,137,1),(198,30,81,1);
/*!40000 ALTER TABLE `role_link_hook` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_link_menu`
--

DROP TABLE IF EXISTS `role_link_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_link_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '鐢ㄦ埛ID',
  `menu_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '瑙掕壊ID',
  `commands` varchar(30) NOT NULL DEFAULT 'all' COMMENT '鎸囦护锛歛ll 鍏ㄩ儴 index,add,del,edit',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 COMMENT='瑙掕壊鍏宠仈鑿滃崟';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_link_menu`
--

LOCK TABLES `role_link_menu` WRITE;
/*!40000 ALTER TABLE `role_link_menu` DISABLE KEYS */;
INSERT INTO `role_link_menu` VALUES (10,1,6,'all'),(11,1,7,'all'),(12,1,8,'all'),(13,1,9,'all'),(14,1,10,'all'),(15,1,11,'all'),(16,1,12,'all'),(17,1,13,'all'),(18,1,14,'all'),(19,1,15,'all'),(20,1,16,'all'),(21,1,17,'all'),(22,1,18,'all'),(23,1,19,'all'),(24,1,20,'all'),(25,1,21,'all'),(26,1,22,'all'),(27,1,23,'all'),(28,1,24,'all'),(29,1,25,'all'),(30,1,26,'all'),(31,1,27,'all'),(32,1,28,'all'),(33,1,29,'all'),(34,1,30,'all'),(35,1,31,'all'),(36,1,32,'all'),(37,1,33,'all'),(38,1,34,'all'),(39,1,35,'all'),(40,1,36,'all'),(41,1,37,'all'),(42,1,38,'all'),(43,1,39,'all'),(44,1,40,'all'),(45,1,41,'all'),(46,1,42,'all'),(47,1,44,'all'),(48,1,45,'all'),(49,1,46,'all'),(50,1,47,'all'),(51,1,48,'all'),(52,1,49,'all'),(53,1,50,'all'),(54,1,51,'all'),(55,30,39,'all'),(56,30,40,'all'),(57,30,41,'all'),(58,30,42,'all'),(59,30,44,'all'),(60,30,45,'all'),(61,30,46,'all'),(62,30,48,'all'),(63,30,49,'all'),(64,30,47,'all'),(65,1,52,'all'),(66,1,53,'all'),(67,1,54,'all'),(69,30,56,'all'),(71,30,52,'all'),(72,30,53,'all'),(73,30,54,'all'),(74,1,56,'all'),(76,1,58,'all'),(77,30,58,'all'),(78,1,59,'all'),(79,30,60,'all'),(80,1,60,'all'),(81,1,61,'all'),(82,1,62,'all'),(83,1,63,'all'),(84,30,63,'all'),(85,1,64,'all'),(86,1,65,'all');
/*!40000 ALTER TABLE `role_link_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '瑙掕壊鍚嶇О',
  `content` varchar(80) NOT NULL DEFAULT '' COMMENT '角色描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='鐢ㄦ埛琛?';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'超级管理员','管理一切'),(30,'商家','商家后台权限');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seckill`
--

DROP TABLE IF EXISTS `seckill`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seckill` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '名称',
  `start_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '开始时间',
  `end_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '结束时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='秒杀';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seckill`
--

LOCK TABLES `seckill` WRITE;
/*!40000 ALTER TABLE `seckill` DISABLE KEYS */;
INSERT INTO `seckill` VALUES (1,'12:00 场',1574179200,1640880000),(2,'16:00 场',1578585600,1578672000);
/*!40000 ALTER TABLE `seckill` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seckill_goods`
--

DROP TABLE IF EXISTS `seckill_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seckill_goods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '秒杀ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '参加用户',
  `goods_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品ID',
  `status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '是否允许',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='秒杀商品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seckill_goods`
--

LOCK TABLES `seckill_goods` WRITE;
/*!40000 ALTER TABLE `seckill_goods` DISABLE KEYS */;
INSERT INTO `seckill_goods` VALUES (8,1,6,53,1),(9,1,6,49,1),(10,1,6,52,1),(11,1,6,54,1);
/*!40000 ALTER TABLE `seckill_goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sms_log`
--

DROP TABLE IF EXISTS `sms_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sms_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(30) NOT NULL DEFAULT '' COMMENT '手机号码',
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT '验证码',
  `is_type` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '短信类型',
  `name` varchar(10) NOT NULL DEFAULT '' COMMENT '类型名称',
  `status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '发送成功',
  `is_use` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '是否使用过',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='短信日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms_log`
--

LOCK TABLES `sms_log` WRITE;
/*!40000 ALTER TABLE `sms_log` DISABLE KEYS */;
INSERT INTO `sms_log` VALUES (2,'asd','',0,'',0,0,0),(3,'15073019017','{\"code\":83884}',2,'注册',1,0,1572505357),(4,'15073010917','{\"code\":70259}',2,'注册',1,1,1572505424),(5,'17369417688','{\"code\":48695}',3,'注册',1,0,1575707693),(6,'17369417688','{\"code\":44482}',3,'注册',1,0,1575707745),(7,'17369417688','{\"code\":88514}',3,'注册',1,0,1575707816),(8,'15073010917','{\"code\":57924}',3,'注册',1,0,1575707881),(9,'17369417688','{\"code\":11020}',3,'注册',1,0,1575707919),(10,'17369417688','{\"code\":10403}',3,'注册',1,0,1575708042),(11,'15073010917','{\"code\":10224}',3,'注册',1,0,1575708525),(12,'364825702@qq.com','{\"code\":39339}',4,'邮件认证',0,0,1575794850),(13,'364825702@qq.com','{\"code\":29958}',4,'邮件认证',0,0,1575794919),(14,'364825702@qq.com','{\"code\":97449}',4,'邮件认证',0,1,1575795085);
/*!40000 ALTER TABLE `sms_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store`
--

DROP TABLE IF EXISTS `store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `store` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `store_name` varchar(20) NOT NULL DEFAULT '' COMMENT '店铺名',
  `store_logo` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺logo',
  `store_face_image` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺门面',
  `store_mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '店铺联系电话',
  `store_description` text NOT NULL DEFAULT '' COMMENT '店铺描述',
  `store_collect` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '店铺收藏',
  `store_slide` varchar(300) NOT NULL DEFAULT '' COMMENT '店铺PC幻灯片',
  `store_mobile_slide` varchar(300) NOT NULL DEFAULT '' COMMENT '店铺手机端幻灯片',
  `store_company_name` varchar(30) NOT NULL DEFAULT '' COMMENT '公司名称',
  `province_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '省ID',
  `city_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '市ID',
  `region_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '区ID',
  `lat` varchar(15) NOT NULL DEFAULT '' COMMENT '纬度',
  `lng` varchar(15) NOT NULL DEFAULT '' COMMENT '经度',
  `area_info` varchar(50) NOT NULL DEFAULT '' COMMENT '区域信息',
  `store_address` varchar(30) NOT NULL DEFAULT '' COMMENT '详细地址信息',
  `free_freight` decimal(9,2) NOT NULL DEFAULT 0.00 COMMENT '满多少包邮',
  `after_sale_content` text NOT NULL DEFAULT '' COMMENT '售后详情',
  `store_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '0 关闭 1 开启',
  `store_close_info` varchar(40) NOT NULL DEFAULT '店铺已经关闭！' COMMENT '关闭原因',
  `business_license` varchar(100) NOT NULL DEFAULT '' COMMENT '营业执照',
  `business_license_no` varchar(40) NOT NULL DEFAULT '' COMMENT '营业执照号码',
  `legal_person` varchar(20) NOT NULL DEFAULT '' COMMENT '法人',
  `id_card` varchar(200) NOT NULL DEFAULT '' COMMENT '身份证',
  `id_card_no` varchar(40) NOT NULL DEFAULT '' COMMENT '身份证号码',
  `emergency_contact` varchar(10) NOT NULL DEFAULT '' COMMENT '紧急联系人',
  `emergency_contact_phone` varchar(11) NOT NULL DEFAULT '' COMMENT '紧急联系人电话',
  `store_verify` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '0 审核中 1 通过 2 失败',
  `store_score` decimal(5,1) unsigned NOT NULL DEFAULT 5.0 COMMENT '综合评分',
  `store_agree` decimal(5,1) unsigned NOT NULL DEFAULT 5.0 COMMENT '商品相符',
  `store_service` decimal(5,1) unsigned NOT NULL DEFAULT 5.0 COMMENT '服务评分',
  `store_speed` decimal(5,1) unsigned NOT NULL DEFAULT 5.0 COMMENT '物流速度',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='商家表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store`
--

LOCK TABLES `store` WRITE;
/*!40000 ALTER TABLE `store` DISABLE KEYS */;
INSERT INTO `store` VALUES (6,1,'神秘人','青梧商城','http://api.qingwuit.com/Uploads/store/1/2019_11_14/15737192374823.png','','17369417688','任意买卖，无手续费',0,'','','青梧信息科技',1,32,375,'','','北京市 市辖区 东城区','xxxxx',0.00,'<p>测试</p>',1,'店铺已经关闭！','http://api.qingwuit.com/Uploads/store_join/2019_11_14/15737187818652.png','11221','李三','http://api.qingwuit.com/Uploads/store_join/2019_11_14/15737187793372.png','45566','xxx','17369417688',1,5.0,5.0,5.0,5.0,1573718799),(9,6,'15073010917_6973','日韩潮牌','','','0730-8174813','',0,'','','青梧信息科技',1,32,375,'','','北京市 市辖区 东城区','天心小区 四季春天 2087',0.00,'',1,'店铺已经关闭！','http://api.qingwuit.com/Uploads/store_join/2020_01_14/15789835919014.png','xxx','xxx','http://api.qingwuit.com/Uploads/store_join/2020_01_14/15789835887226.png','44444','1736941768','17369417688',1,5.0,5.0,5.0,5.0,1578984230);
/*!40000 ALTER TABLE `store` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store_class`
--

DROP TABLE IF EXISTS `store_class`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `store_class` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '店铺ID',
  `class_1` text NOT NULL DEFAULT '' COMMENT '一级栏目',
  `class_2` text NOT NULL DEFAULT '' COMMENT '二级栏目',
  `class_3` text NOT NULL DEFAULT '' COMMENT '三级栏目',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='店铺申请栏目';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store_class`
--

LOCK TABLES `store_class` WRITE;
/*!40000 ALTER TABLE `store_class` DISABLE KEYS */;
INSERT INTO `store_class` VALUES (6,6,'13,13,13,13','19,20,20,22','24,21,23,41'),(7,9,'13,13,13,14,14,14,15,15,15,16,16,17,17,18,18','19,19,19,25,25,25,28,28,28,32,32,36,36,39,39','43,42,24,44,45,46,49,48,47,51,50,53,52,55,54');
/*!40000 ALTER TABLE `store_class` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store_comment`
--

DROP TABLE IF EXISTS `store_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `store_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '父ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '评论人',
  `avatar` varchar(100) NOT NULL DEFAULT '' COMMENT '用户头像',
  `store_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '店铺ID',
  `goods_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商品ID',
  `seller_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '卖家ID',
  `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名',
  `goods_name` varchar(200) NOT NULL DEFAULT '' COMMENT '商品名',
  `goods_image` varchar(100) NOT NULL DEFAULT '' COMMENT '商品图片',
  `content` text NOT NULL DEFAULT '' COMMENT '内容',
  `comment_images` text NOT NULL DEFAULT '' COMMENT '评论图片',
  `score` decimal(3,1) NOT NULL DEFAULT 5.0 COMMENT '平均',
  `agree` tinyint(3) unsigned NOT NULL DEFAULT 5 COMMENT '产品相符',
  `service` tinyint(3) unsigned NOT NULL DEFAULT 5 COMMENT '服务态度',
  `speed` tinyint(3) unsigned NOT NULL DEFAULT 5 COMMENT '发货速度',
  `is_type` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '评论类型 0 商品 1 店铺',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '评论时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='店铺评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store_comment`
--

LOCK TABLES `store_comment` WRITE;
/*!40000 ALTER TABLE `store_comment` DISABLE KEYS */;
INSERT INTO `store_comment` VALUES (2,0,1,'神秘人2','',6,31,1,'青梧商城','第三个商品','http://api.qingwuit.com/Uploads/goods/2019_11_21/15743049996339.jpg','非常不错！','http://api.qingwuit.com/Uploads/comment/2019_12_28/15775243513381.png',5.0,5,5,5,0,1577524829);
/*!40000 ALTER TABLE `store_comment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store_goods_class`
--

DROP TABLE IF EXISTS `store_goods_class`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `store_goods_class` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '商家ID',
  `name` varchar(10) NOT NULL DEFAULT '' COMMENT '栏目名',
  `is_sort` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='商家自定义分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store_goods_class`
--

LOCK TABLES `store_goods_class` WRITE;
/*!40000 ALTER TABLE `store_goods_class` DISABLE KEYS */;
INSERT INTO `store_goods_class` VALUES (1,1,'商家自定义',1),(3,1,'紫阳阁',0),(4,1,'白烟山',0);
/*!40000 ALTER TABLE `store_goods_class` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_check`
--

DROP TABLE IF EXISTS `user_check`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_check` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `real_name` varchar(12) NOT NULL DEFAULT '' COMMENT '真名',
  `card_no` varchar(40) NOT NULL DEFAULT '' COMMENT '身份证号码',
  `card_top` varchar(100) NOT NULL DEFAULT '' COMMENT '身份证上',
  `card_bottom` varchar(100) NOT NULL DEFAULT '' COMMENT '身份证下',
  `bank_card` varchar(40) NOT NULL DEFAULT '' COMMENT '银行卡号',
  `bank_name` varchar(15) NOT NULL DEFAULT '' COMMENT '开户银行',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='认证信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_check`
--

LOCK TABLES `user_check` WRITE;
/*!40000 ALTER TABLE `user_check` DISABLE KEYS */;
INSERT INTO `user_check` VALUES (1,1,'栗色','4452111','http://api.qingwuit.com/Uploads/user_check/2019_12_07/15757105037269.jpg','http://api.qingwuit.com/Uploads/user_check/2019_12_07/15757105063455.jpg','234124','工商银行');
/*!40000 ALTER TABLE `user_check` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_link_role`
--

DROP TABLE IF EXISTS `user_link_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_link_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '鐢ㄦ埛ID',
  `role_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '瑙掕壊ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='鐢ㄦ埛鍏宠仈瑙掕壊';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_link_role`
--

LOCK TABLES `user_link_role` WRITE;
/*!40000 ALTER TABLE `user_link_role` DISABLE KEYS */;
INSERT INTO `user_link_role` VALUES (10,1,1),(15,6,30);
/*!40000 ALTER TABLE `user_link_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(200) NOT NULL DEFAULT '' COMMENT '密码',
  `pay_password` char(6) NOT NULL DEFAULT '' COMMENT '支付密码',
  `nickname` varchar(30) NOT NULL DEFAULT '神秘人' COMMENT '昵称',
  `avatar` varchar(100) NOT NULL DEFAULT '' COMMENT '头像',
  `gender` tinyint(3) unsigned NOT NULL DEFAULT 1 COMMENT '性别',
  `phone` char(11) NOT NULL DEFAULT '' COMMENT '手机号码',
  `email` varchar(30) NOT NULL DEFAULT '' COMMENT '邮箱',
  `money` decimal(9,2) unsigned NOT NULL DEFAULT 0.00 COMMENT '余额',
  `frozen_money` decimal(9,2) unsigned NOT NULL DEFAULT 0.00 COMMENT '冻结余额',
  `integral` decimal(9,2) unsigned NOT NULL DEFAULT 0.00 COMMENT '积分',
  `inviter_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '注册邀请人',
  `login_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '登录时间',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '上次登录时间',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '注册时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','$2y$10$zqrgwbK/MI1Gju41lCUfOOAeWruTGciU6h2ytnGe1v70yW930M.ya','123456','神秘人2','http://api.qingwuit.com/Uploads/avatar/2020_01_05/15782074168008.jpg',1,'18888888888','364825702@qq.com',10.00,0.00,20.00,0,1578970254,1578884237,0),(6,'15073010917_6322','$2y$10$QClUmq27DT5eILipqlALy.x4B/.crA9h2vW8m2YTTsBAC7lLhDrmO','','15073010917_6973','',1,'15073010917','',0.00,0.00,0.00,0,1578985333,1578983514,1572506016);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wechat_users`
--

DROP TABLE IF EXISTS `wechat_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wechat_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID',
  `nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '昵称',
  `avatar` varchar(200) NOT NULL DEFAULT '' COMMENT '头像',
  `sex` tinyint(4) NOT NULL DEFAULT 1 COMMENT '性别',
  `openid` varchar(80) NOT NULL DEFAULT '' COMMENT '指定平台唯一ID',
  `unionid` varchar(80) NOT NULL DEFAULT '' COMMENT '平台唯一ID',
  `add_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信用户信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wechat_users`
--

LOCK TABLES `wechat_users` WRITE;
/*!40000 ALTER TABLE `wechat_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `wechat_users` 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 2020-01-14 15:40:36