ssm.sql

/*
SQLyog 企业版 - MySQL GUI v8.14 
MySQL - 5.5.25a : Database - ssm
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`ssm` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `ssm`;

/*Table structure for table `affiche` */

DROP TABLE IF EXISTS `affiche`;

CREATE TABLE `affiche` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告表',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `affiche` */

/*Table structure for table `bulletin` */

DROP TABLE IF EXISTS `bulletin`;

CREATE TABLE `bulletin` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告表',
  `title` varchar(1000) DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `top` tinyint(1) DEFAULT '0' COMMENT '是否置顶 0 否 1 是',
  `invisible` tinyint(1) DEFAULT '0' COMMENT '是否删除 0 否 1 是',
  `type` int(11) DEFAULT NULL COMMENT '公告类型',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `bulletin` */

insert  into `bulletin`(`id`,`title`,`content`,`top`,`invisible`,`type`,`create_time`) values (1,'test','<p>test</p>',0,1,2,'2016-10-20 11:28:27'),(2,'维护公告','<p>维护中<img src=\"http://localhost:8099/ssm/temp/1476934150840_S.png\" title=\"\" alt=\"\"/></p>',0,1,1,'2016-10-20 11:29:12'),(3,'优惠','<p>问题汕头市啊</p>',0,0,2,'2016-10-20 11:29:29'),(4,'通知','<p>访问我而去</p>',0,0,3,'2016-10-20 11:30:05'),(5,'eqeqrerq','<p>ewqfqefq<img src=\"http://img.baidu.com/hi/jx2/j_0026.gif\"/></p>',0,1,3,'2016-10-20 12:54:34');

/*Table structure for table `bulletin_type` */

DROP TABLE IF EXISTS `bulletin_type`;

CREATE TABLE `bulletin_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告类型表',
  `name` varchar(100) DEFAULT NULL COMMENT '类型名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `bulletin_type` */

insert  into `bulletin_type`(`id`,`name`) values (1,'系统公告'),(2,'活动公告'),(3,'普通公告');

/*Table structure for table `cart` */

DROP TABLE IF EXISTS `cart`;

CREATE TABLE `cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '购物车',
  `mid` int(11) DEFAULT NULL COMMENT '用户ID',
  `pid` int(11) DEFAULT NULL COMMENT '商品ID',
  `quantity` int(11) DEFAULT NULL COMMENT '数量',
  `create_time` datetime DEFAULT NULL COMMENT '创计时间',
  PRIMARY KEY (`id`),
  KEY `FK_Reference_19` (`pid`),
  KEY `FK_Reference_20` (`mid`)
) ENGINE=InnoDB AUTO_INCREMENT=453 DEFAULT CHARSET=utf8;

/*Data for the table `cart` */

insert  into `cart`(`id`,`mid`,`pid`,`quantity`,`create_time`) values (3,5,2,9,'2016-08-25 12:21:21'),(4,5,3,2,'2016-08-25 12:21:22'),(5,5,6,4,'2016-08-25 12:21:24'),(20,5,1,23,'2016-08-29 15:10:39'),(21,7,1,10,'2016-08-30 10:58:04'),(22,8,1,1,'2016-08-30 11:41:13'),(25,3,1,7,'2016-08-30 12:11:41'),(168,3,7,1,'2016-09-08 14:19:03'),(169,3,5,1,'2016-09-08 14:19:08'),(170,7,8,1,'2016-09-08 14:55:48'),(175,8,26,2,'2016-09-12 10:58:38'),(218,3,26,3,'2016-09-12 18:42:56'),(219,3,27,1,'2016-09-12 18:43:08'),(223,6,175,1,'2016-09-12 19:41:49'),(452,18,38,1,'2016-09-28 10:15:11');

/*Table structure for table `city` */

DROP TABLE IF EXISTS `city`;

CREATE TABLE `city` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '城市表',
  `provinceId` int(11) DEFAULT NULL COMMENT '省份ID',
  `name` varchar(255) DEFAULT NULL COMMENT '城市名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8;

/*Data for the table `city` */

insert  into `city`(`id`,`provinceId`,`name`) values (1,1,'北京市'),(2,1,'天津市'),(3,3,'石家庄市'),(4,3,'唐山市'),(5,3,'秦皇岛市'),(6,3,'邯郸市'),(7,3,'邢台市'),(8,3,'保定市'),(9,3,'张家口市'),(10,3,'承德市'),(11,3,'沧州市'),(12,3,'廊坊市'),(13,3,'衡水市'),(14,4,'太原市'),(15,4,'大同市'),(16,4,'阳泉市'),(17,4,'长治市'),(18,4,'晋城市'),(19,4,'朔州市'),(20,4,'晋中市'),(21,4,'运城市'),(22,4,'忻州市'),(23,4,'临汾市'),(24,4,'吕梁市'),(25,5,'呼和浩特市'),(26,5,'包头市'),(27,5,'乌海市'),(28,5,'赤峰市'),(29,5,'通辽市'),(30,5,'鄂尔多斯市'),(31,5,'呼伦贝尔市'),(32,5,'巴彦淖尔市'),(33,5,'乌兰察布市'),(34,5,'兴安盟'),(35,5,'锡林郭勒盟'),(36,5,'阿拉善盟'),(37,6,'沈阳市'),(38,6,'大连市'),(39,6,'鞍山市'),(40,6,'抚顺市'),(41,6,'本溪市'),(42,6,'丹东市'),(43,6,'锦州市'),(44,6,'营口市'),(45,6,'阜新市'),(46,6,'辽阳市'),(47,6,'盘锦市'),(48,6,'铁岭市'),(49,6,'朝阳市'),(50,6,'葫芦岛市'),(51,7,'长春市'),(52,7,'吉林市'),(53,7,'四平市'),(54,7,'辽源市'),(55,7,'通化市'),(56,7,'白山市'),(57,7,'松原市'),(58,7,'白城市'),(59,7,'延边朝鲜族自治州'),(60,8,'哈尔滨市'),(61,8,'齐齐哈尔市'),(62,8,'鸡西市'),(63,8,'鹤岗市'),(64,8,'双鸭山市'),(65,8,'大庆市'),(66,8,'伊春市'),(67,8,'佳木斯市'),(68,8,'七台河市'),(69,8,'牡丹江市'),(70,8,'黑河市'),(71,8,'绥化市'),(72,8,'大兴安岭地区'),(73,1,'上海市'),(74,10,'南京市'),(75,10,'无锡市'),(76,10,'徐州市'),(77,10,'常州市'),(78,10,'苏州市'),(79,10,'南通市'),(80,10,'连云港市'),(81,10,'淮安市'),(82,10,'盐城市'),(83,10,'扬州市'),(84,10,'镇江市'),(85,10,'泰州市'),(86,10,'宿迁市'),(87,11,'杭州市'),(88,11,'宁波市'),(89,11,'温州市'),(90,11,'嘉兴市'),(91,11,'湖州市'),(92,11,'绍兴市'),(93,11,'金华市'),(94,11,'衢州市'),(95,11,'舟山市'),(96,11,'台州市'),(97,11,'丽水市'),(98,12,'合肥市'),(99,12,'芜湖市'),(100,12,'蚌埠市'),(101,12,'淮南市'),(102,12,'马鞍山市'),(103,12,'淮北市'),(104,12,'铜陵市'),(105,12,'安庆市'),(106,12,'黄山市'),(107,12,'滁州市'),(108,12,'阜阳市'),(109,12,'宿州市'),(110,12,'巢湖市'),(111,12,'六安市'),(112,12,'亳州市'),(113,12,'池州市'),(114,12,'宣城市'),(115,13,'福州市'),(116,13,'厦门市'),(117,13,'莆田市'),(118,13,'三明市'),(119,13,'泉州市'),(120,13,'漳州市'),(121,13,'南平市'),(122,13,'龙岩市'),(123,13,'宁德市'),(124,14,'南昌市'),(125,14,'景德镇市'),(126,14,'萍乡市'),(127,14,'九江市'),(128,14,'新余市'),(129,14,'鹰潭市'),(130,14,'赣州市'),(131,14,'吉安市'),(132,14,'宜春市'),(133,14,'抚州市'),(134,14,'上饶市'),(135,15,'济南市'),(136,15,'青岛市'),(137,15,'淄博市'),(138,15,'枣庄市'),(139,15,'东营市'),(140,15,'烟台市'),(141,15,'潍坊市'),(142,15,'济宁市'),(143,15,'泰安市'),(144,15,'威海市'),(145,15,'日照市'),(146,15,'莱芜市'),(147,15,'临沂市'),(148,15,'德州市'),(149,15,'聊城市'),(150,15,'滨州市'),(151,15,'荷泽市'),(152,16,'郑州市'),(153,16,'开封市'),(154,16,'洛阳市'),(155,16,'平顶山市'),(156,16,'安阳市'),(157,16,'鹤壁市'),(158,16,'新乡市'),(159,16,'焦作市'),(160,16,'濮阳市'),(161,16,'许昌市'),(162,16,'漯河市'),(163,16,'三门峡市'),(164,16,'南阳市'),(165,16,'商丘市'),(166,16,'信阳市'),(167,16,'周口市'),(168,16,'驻马店市'),(169,17,'武汉市'),(170,17,'黄石市'),(171,17,'十堰市'),(172,17,'宜昌市'),(173,17,'襄樊市'),(174,17,'鄂州市'),(175,17,'荆门市'),(176,17,'孝感市'),(177,17,'荆州市'),(178,17,'黄冈市'),(179,17,'咸宁市'),(180,17,'随州市'),(181,17,'恩施土家族苗族自治州'),(182,17,'神农架'),(183,18,'长沙市'),(184,18,'株洲市'),(185,18,'湘潭市'),(186,18,'衡阳市'),(187,18,'邵阳市'),(188,18,'岳阳市'),(189,18,'常德市'),(190,18,'张家界市'),(191,18,'益阳市'),(192,18,'郴州市'),(193,18,'永州市'),(194,18,'怀化市'),(195,18,'娄底市'),(196,18,'湘西土家族苗族自治州'),(197,19,'广州市'),(198,19,'韶关市'),(199,19,'深圳市'),(200,19,'珠海市'),(201,19,'汕头市'),(202,19,'佛山市'),(203,19,'江门市'),(204,19,'湛江市'),(205,19,'茂名市'),(206,19,'肇庆市'),(207,19,'惠州市'),(208,19,'梅州市'),(209,19,'汕尾市'),(210,19,'河源市'),(211,19,'阳江市'),(212,19,'清远市'),(213,19,'东莞市'),(214,19,'中山市'),(215,19,'潮州市'),(216,19,'揭阳市'),(217,19,'云浮市'),(218,20,'南宁市'),(219,20,'柳州市'),(220,20,'桂林市'),(221,20,'梧州市'),(222,20,'北海市'),(223,20,'防城港市'),(224,20,'钦州市'),(225,20,'贵港市'),(226,20,'玉林市'),(227,20,'百色市'),(228,20,'贺州市'),(229,20,'河池市'),(230,20,'来宾市'),(231,20,'崇左市'),(232,21,'海口市'),(233,21,'三亚市'),(234,1,'重庆市'),(235,23,'成都市'),(236,23,'自贡市'),(237,23,'攀枝花市'),(238,23,'泸州市'),(239,23,'德阳市'),(240,23,'绵阳市'),(241,23,'广元市'),(242,23,'遂宁市'),(243,23,'内江市'),(244,23,'乐山市'),(245,23,'南充市'),(246,23,'眉山市'),(247,23,'宜宾市'),(248,23,'广安市'),(249,23,'达州市'),(250,23,'雅安市'),(251,23,'巴中市'),(252,23,'资阳市'),(253,23,'阿坝藏族羌族自治州'),(254,23,'甘孜藏族自治州'),(255,23,'凉山彝族自治州'),(256,24,'贵阳市'),(257,24,'六盘水市'),(258,24,'遵义市'),(259,24,'安顺市'),(260,24,'铜仁地区'),(261,24,'黔西南布依族苗族自治州'),(262,24,'毕节地区'),(263,24,'黔东南苗族侗族自治州'),(264,24,'黔南布依族苗族自治州'),(265,25,'昆明市'),(266,25,'曲靖市'),(267,25,'玉溪市'),(268,25,'保山市'),(269,25,'昭通市'),(270,25,'丽江市'),(271,25,'思茅市'),(272,25,'临沧市'),(273,25,'楚雄彝族自治州'),(274,25,'红河哈尼族彝族自治州'),(275,25,'文山壮族苗族自治州'),(276,25,'西双版纳傣族自治州'),(277,25,'大理白族自治州'),(278,25,'德宏傣族景颇族自治州'),(279,25,'怒江傈僳族自治州'),(280,25,'迪庆藏族自治州'),(281,26,'拉萨市'),(282,26,'昌都地区'),(283,26,'山南地区'),(284,26,'日喀则地区'),(285,26,'那曲地区'),(286,26,'阿里地区'),(287,26,'林芝地区'),(288,27,'西安市'),(289,27,'铜川市'),(290,27,'宝鸡市'),(291,27,'咸阳市'),(292,27,'渭南市'),(293,27,'延安市'),(294,27,'汉中市'),(295,27,'榆林市'),(296,27,'安康市'),(297,27,'商洛市'),(298,28,'兰州市'),(299,28,'嘉峪关市'),(300,28,'金昌市'),(301,28,'白银市'),(302,28,'天水市'),(303,28,'武威市'),(304,28,'张掖市'),(305,28,'平凉市'),(306,28,'酒泉市'),(307,28,'庆阳市'),(308,28,'定西市'),(309,28,'陇南市'),(310,28,'临夏回族自治州'),(311,28,'甘南藏族自治州'),(312,29,'西宁市'),(313,29,'海东地区'),(314,29,'海北藏族自治州'),(315,29,'黄南藏族自治州'),(316,29,'海南藏族自治州'),(317,29,'果洛藏族自治州'),(318,29,'玉树藏族自治州'),(319,29,'海西蒙古族藏族自治州'),(320,30,'银川市'),(321,30,'石嘴山市'),(322,30,'吴忠市'),(323,30,'固原市'),(324,30,'中卫市'),(325,31,'乌鲁木齐市'),(326,31,'克拉玛依市'),(327,31,'吐鲁番地区'),(328,31,'哈密地区'),(329,31,'昌吉回族自治州'),(330,31,'博尔塔拉蒙古自治州'),(331,31,'巴音郭楞蒙古自治州'),(332,31,'阿克苏地区'),(333,31,'克孜勒苏柯尔克孜自治州'),(334,31,'喀什地区'),(335,31,'和田地区'),(336,31,'伊犁哈萨克自治州'),(337,31,'塔城地区'),(338,31,'阿勒泰地区'),(339,31,'石河子市'),(340,31,'阿拉尔市'),(341,31,'图木舒克市'),(342,31,'五家渠市'),(343,32,'香港特别行政区'),(344,33,'澳门特别行政区'),(345,34,'台湾省');

/*Table structure for table `coupon` */

DROP TABLE IF EXISTS `coupon`;

CREATE TABLE `coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `currency` int(11) DEFAULT '1' COMMENT '1,澳门元；2，人民币',
  `quantity` int(11) DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `minimum_charge` decimal(8,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

/*Data for the table `coupon` */

insert  into `coupon`(`id`,`name`,`description`,`amount`,`currency`,`quantity`,`start_time`,`end_time`,`minimum_charge`) values (1,'金秋代金券','满100减10块','10.00',1,1000,'2016-08-24 00:46:14','2016-09-10 00:46:19','100.00');

/*Table structure for table `coupon_category` */

DROP TABLE IF EXISTS `coupon_category`;

CREATE TABLE `coupon_category` (
  `coupon_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  KEY `FK_Reference_21` (`coupon_id`),
  KEY `FK_Reference_22` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `coupon_category` */

insert  into `coupon_category`(`coupon_id`,`category_id`) values (7,5),(8,5),(9,4),(10,3),(11,4),(12,3),(13,3),(14,3),(15,5),(16,4),(17,4),(18,22),(19,22),(20,22),(21,22),(22,22),(23,18),(24,19),(25,20),(26,20);

/*Table structure for table `delivery_time` */

DROP TABLE IF EXISTS `delivery_time`;

CREATE TABLE `delivery_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '配送时间表',
  `time` datetime DEFAULT NULL COMMENT '配送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `delivery_time` */

/*Table structure for table `member` */

DROP TABLE IF EXISTS `member`;

CREATE TABLE `member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT NULL COMMENT '账号',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `status` int(1) DEFAULT '-1' COMMENT '登录状态 -2 等待发送验证码 -1 验证码已发送 0 等待登录 1 登录成功 2 登录失败',
  `balance` decimal(8,2) DEFAULT '0.00' COMMENT '余额',
  `login_num` int(11) DEFAULT '0' COMMENT '登录次数',
  `message` text COMMENT '留言',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*Data for the table `member` */

insert  into `member`(`id`,`username`,`password`,`status`,`balance`,`login_num`,`message`,`create_time`) values (1,'18380426135','131',2,'70.00',108,'2016-10-18 17:57:40,2016-10-19 10:24:33,2016-10-19 10:27:06,2016-10-19 10:49:05,2016-10-19 10:49:38,2016-10-19 10:58:14,2016-10-19 11:07:38,2016-10-19 11:07:50,2016-10-19 11:08:46,2016-10-19 11:08:51,2016-10-19 11:12:17,2016-10-19 11:14:06,2016-10-19 11:14:11,2016-10-19 11:16:46,2016-10-19 11:33:53,2016-10-19 11:34:50,2016-10-19 11:46:14,2016-10-19 11:46:24,2016-10-19 11:47:11,2016-10-19 11:47:33,2016-10-19 12:24:24,2016-10-19 12:26:27,2016-10-19 12:27:19,2016-10-19 12:29:13,2016-10-19 12:31:44,2016-10-19 12:36:58,2016-10-19 12:38:16,2016-10-19 13:35:31,2016-10-19 13:54:03,2016-10-19 14:06:43,2016-10-19 14:07:14,2016-10-19 14:09:49,2016-10-19 14:10:07,2016-10-19 14:10:20,2016-10-19 14:11:47,2016-10-19 14:15:47,2016-10-19 14:17:19,2016-10-19 14:17:24,2016-10-19 14:18:38,2016-10-19 14:19:39,2016-10-19 14:19:49,2016-10-19 14:31:22,2016-10-19 14:32:25,2016-10-19 14:40:56,2016-10-19 14:41:09,2016-10-19 14:42:46,2016-10-19 14:42:49,2016-10-19 14:42:49,2016-10-19 14:51:16,2016-10-19 15:01:02,2016-10-19 15:01:21,2016-10-19 15:37:33,2016-10-19 15:43:17,2016-10-19 15:45:31,2016-10-19 15:46:16,2016-10-19 15:47:46,2016-10-19 15:48:20,2016-10-19 15:50:30,2016-10-19 15:54:43,2016-10-19 15:54:59,2016-10-19 15:57:27,2016-10-19 15:58:15,2016-10-19 16:00:21,2016-10-19 16:06:11,2016-10-19 16:09:41,2016-10-19 16:11:08,2016-10-19 16:12:36,2016-10-19 16:13:50,2016-10-19 16:14:11,2016-10-19 16:15:26,2016-10-19 16:16:42,2016-10-19 16:18:44,2016-10-19 16:20:29,2016-10-19 16:21:28,2016-10-19 16:24:06,2016-10-19 16:39:17,2016-10-19 16:45:12,2016-10-19 16:46:47,2016-10-19 16:49:13,2016-10-19 17:02:00,2016-10-19 17:26:27,2016-10-19 17:40:35,2016-10-19 17:40:45,2016-10-19 17:42:27,2016-10-19 17:45:31,2016-10-19 17:46:28,2016-10-19 17:47:27,2016-10-19 18:28:58,2016-10-19 18:29:27,2016-10-19 18:31:01,2016-10-19 18:32:55,2016-10-20 09:58:43,2016-10-20 15:16:27,2016-10-20 15:35:28,2016-10-20 15:49:40,2016-10-20 15:50:04,2016-10-20 15:52:45,2016-10-20 15:53:20,2016-10-20 15:55:03,2016-10-20 15:57:36,2016-10-20 15:57:46,2016-10-20 15:58:34,2016-10-20 16:06:28,2016-10-20 16:06:46,2016-10-20 16:08:01,2016-10-20 16:09:16,2016-10-20 16:26:46,2016-10-20 16:26:57','2016-10-18 17:57:40'),(2,'18380426133','123',2,'33.00',11,'2016-10-19 12:36:15,2016-10-19 14:14:40,2016-10-19 14:48:56,2016-10-19 14:48:58,2016-10-19 15:44:54,2016-10-19 15:48:56,2016-10-19 16:18:11,2016-10-19 16:18:18,2016-10-19 16:19:01,2016-10-19 17:43:26,2016-10-19 17:44:20','2016-10-19 12:36:15'),(3,'18380426144',NULL,-1,NULL,NULL,NULL,'2016-10-20 15:17:13'),(4,'18380426139',NULL,-1,NULL,NULL,NULL,'2016-10-20 15:56:59'),(5,'18380426138',NULL,-1,NULL,NULL,NULL,'2016-10-20 15:59:11'),(6,'18380426131','124241',2,'0.00',4,'null,2016-10-20 16:03:13,2016-10-20 16:03:30,2016-10-20 16:09:34,2016-10-20 16:10:14','2016-10-20 16:02:42');

/*Table structure for table `member_address` */

DROP TABLE IF EXISTS `member_address`;

CREATE TABLE `member_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `region` int(11) DEFAULT NULL COMMENT '地区',
  `landmark` int(11) DEFAULT NULL COMMENT '地标',
  `address` varchar(30) DEFAULT NULL,
  `full_address` varchar(50) DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT '0',
  `remark` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Reference_1` (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `member_address` */

insert  into `member_address`(`id`,`member_id`,`name`,`phone`,`region`,`landmark`,`address`,`full_address`,`is_default`,`remark`) values (4,2,'lc','110',1,7,'在','澳門望廈、螺絲山、馬交石山在',1,'备注');

/*Table structure for table `member_copy` */

DROP TABLE IF EXISTS `member_copy`;

CREATE TABLE `member_copy` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户表',
  `name` varchar(10) DEFAULT NULL COMMENT '昵称',
  `username` varchar(20) DEFAULT NULL COMMENT '账号',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号',
  `status` int(1) DEFAULT '0' COMMENT '是否封号 0 否 1 是',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `balance` decimal(8,2) DEFAULT '0.00' COMMENT '余额',
  `head` varchar(255) DEFAULT NULL COMMENT '头像',
  `province` int(11) DEFAULT NULL COMMENT '省份ID',
  `city` int(11) DEFAULT NULL COMMENT '城市ID',
  `street` int(11) DEFAULT NULL COMMENT '区县ID',
  `address` varchar(30) DEFAULT NULL COMMENT '具体地址',
  `full_address` varchar(50) DEFAULT NULL COMMENT '地址全称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `member_copy` */

insert  into `member_copy`(`id`,`name`,`username`,`password`,`phone`,`status`,`create_time`,`balance`,`head`,`province`,`city`,`street`,`address`,`full_address`) values (1,'张三','18380426135','$2a$10$TeKfUiYucql6FBOkAtqLDuGylsEXX1tCExHMi/T81htqHXS7Qg.dS','15982157701',0,'2016-08-08 23:39:52','0.00',NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `member_coupon` */

DROP TABLE IF EXISTS `member_coupon`;

CREATE TABLE `member_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `is_used` tinyint(1) DEFAULT '0' COMMENT '0,δʹÓã»1£¬ÒÑʹÓã»',
  `used_time` datetime DEFAULT NULL,
  `invisible` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_Reference_10` (`member_id`),
  KEY `FK_Reference_11` (`coupon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `member_coupon` */

/*Table structure for table `orders` */

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单表',
  `sn` varchar(20) DEFAULT NULL COMMENT '订单编号',
  `express` varchar(100) DEFAULT NULL COMMENT '快递单号',
  `mid` int(11) DEFAULT NULL COMMENT '用户ID',
  `amount_paid` decimal(8,2) DEFAULT NULL COMMENT '订单实付金额',
  `amount` decimal(8,2) DEFAULT NULL COMMENT '订单总金额',
  `discount` decimal(8,2) DEFAULT NULL COMMENT '折扣金额',
  `receiver` varchar(20) DEFAULT NULL COMMENT '收货人姓名',
  `phone` varchar(20) DEFAULT NULL COMMENT '收货人电话',
  `address` varchar(50) DEFAULT NULL COMMENT '收货人地址',
  `deliver_type` int(1) DEFAULT '0' COMMENT '收货方式 0 快递 1 自提',
  `status` int(1) DEFAULT '0' COMMENT '0，待支付(下单)；1，待理货(已支付)；2，待发货(已理货)；3，待收货(已发货)；4，待评价(已收货)；5，完成(已评价)；6，取消(过期)；',
  `freight` decimal(8,2) DEFAULT '0.00' COMMENT '运费',
  `invisible` tinyint(1) DEFAULT '0' COMMENT '是否删除 0 否 1 是',
  `message` varchar(200) DEFAULT NULL COMMENT '买家留言',
  `postcode` varchar(20) DEFAULT NULL COMMENT '邮编',
  `payment_type` varchar(100) DEFAULT NULL COMMENT '支付方式',
  `delivery_time` datetime DEFAULT NULL COMMENT '配送时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `I_O_sn_unique` (`sn`),
  KEY `FK_Reference_2` (`mid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `orders` */

insert  into `orders`(`id`,`sn`,`express`,`mid`,`amount_paid`,`amount`,`discount`,`receiver`,`phone`,`address`,`deliver_type`,`status`,`freight`,`invisible`,`message`,`postcode`,`payment_type`,`delivery_time`,`create_time`) values (6,'161018356952923','123456',1,'54.00','54.00',NULL,'杨涛','18380426135','河北省石家庄市长安区天府软件园C区',0,5,'10.00',1,'test',NULL,'余额支付','2016-10-18 15:42:41','2016-10-18 14:13:02'),(7,'161019083274162','fwefwefw',1,'13665.00','13665.00',NULL,'份饭','18380426135','河北省石家庄市长安区123124',0,5,'12.00',0,'曲儿曲儿',NULL,'余额支付','2016-10-19 17:28:00','2016-10-19 16:24:57'),(8,'161019996417212','ewfwefwerwq',1,'54.00','54.00',NULL,'驱蚊器','18380426135','河北省石家庄市长安区千万人千万人企鹅',0,3,'10.00',0,'134314123',NULL,'余额支付','2016-10-19 17:03:38','2016-10-19 17:02:33');

/*Table structure for table `orders_item` */

DROP TABLE IF EXISTS `orders_item`;

CREATE TABLE `orders_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单条目表',
  `oid` int(11) DEFAULT NULL COMMENT '订单ID',
  `pid` int(11) DEFAULT NULL COMMENT '商品ID',
  `name` varchar(20) DEFAULT NULL COMMENT '商品名称',
  `quantity` int(11) DEFAULT NULL COMMENT '购买数量',
  `price` decimal(8,2) DEFAULT NULL COMMENT '商品单价',
  `image` varchar(255) DEFAULT NULL COMMENT '商品图片',
  `category` varchar(255) DEFAULT NULL COMMENT '商品分类',
  PRIMARY KEY (`id`),
  KEY `FK_Reference_13` (`oid`),
  KEY `FK_Reference_14` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*Data for the table `orders_item` */

insert  into `orders_item`(`id`,`oid`,`pid`,`name`,`quantity`,`price`,`image`,`category`) values (4,6,2,'黑人牙膏q',2,'22.00','Ms\\Qz\\1476417883813.jpg','话费Q币'),(5,7,4,'遥控赛车',123,'111.00','X1\\Yq\\1476417929895.jpg','电子产品'),(6,8,2,'黑人牙膏q',2,'22.00','Ms\\Qz\\1476417883813.jpg','话费Q币');

/*Table structure for table `orders_log` */

DROP TABLE IF EXISTS `orders_log`;

CREATE TABLE `orders_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单日志表',
  `oid` int(11) DEFAULT NULL COMMENT '订单ID',
  `status` int(1) DEFAULT NULL COMMENT '订单状态',
  `content` varchar(200) DEFAULT NULL COMMENT '日志信息',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `FK_Reference_15` (`oid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table `orders_log` */

insert  into `orders_log`(`id`,`oid`,`status`,`content`,`create_time`) values (3,6,2,'用户完成下单','2016-10-18 14:13:02'),(4,7,2,'用户完成下单','2016-10-19 16:24:57'),(5,8,2,'用户完成下单','2016-10-19 17:02:33'),(6,7,3,'订单已发货','2016-10-19 17:28:00'),(7,7,4,'用户已确认收货','2016-10-19 17:28:16'),(8,7,5,'用户对商品进行了评价； <br/> 评分：null <br/> 评论：null','2016-10-19 18:24:19'),(9,7,5,'用户对商品进行了评价； <br/> 评分：null <br/> 评论：null','2016-10-19 18:26:38'),(10,7,5,'用户对商品进行了评价；  评分：5 评论：qwe','2016-10-19 18:31:20');

/*Table structure for table `payment_type` */

DROP TABLE IF EXISTS `payment_type`;

CREATE TABLE `payment_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '支付方式表',
  `type` varchar(100) DEFAULT NULL COMMENT '支付方式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `payment_type` */

insert  into `payment_type`(`id`,`type`) values (1,'余额支付');

/*Table structure for table `persistent_logins` */

DROP TABLE IF EXISTS `persistent_logins`;

CREATE TABLE `persistent_logins` (
  `username` varchar(64) NOT NULL COMMENT '自动登录表',
  `series` varchar(64) NOT NULL,
  `token` varchar(64) NOT NULL,
  `last_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`series`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `persistent_logins` */

/*Table structure for table `position` */

DROP TABLE IF EXISTS `position`;

CREATE TABLE `position` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '区县表',
  `c_id` int(11) DEFAULT NULL COMMENT '城市ID',
  `name` varchar(20) DEFAULT NULL COMMENT '区县名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2863 DEFAULT CHARSET=utf8;

/*Data for the table `position` */

insert  into `position`(`id`,`c_id`,`name`) values (1,1,'东城区'),(2,1,'西城区'),(3,1,'崇文区'),(4,1,'宣武区'),(5,1,'朝阳区'),(6,1,'丰台区'),(7,1,'石景山区'),(8,1,'海淀区'),(9,1,'门头沟区'),(10,1,'房山区'),(11,1,'通州区'),(12,1,'顺义区'),(13,1,'昌平区'),(14,1,'大兴区'),(15,1,'怀柔区'),(16,1,'平谷区'),(17,1,'密云县'),(18,1,'延庆县'),(19,2,'和平区'),(20,2,'河东区'),(21,2,'河西区'),(22,2,'南开区'),(23,2,'河北区'),(24,2,'红桥区'),(25,2,'塘沽区'),(26,2,'汉沽区'),(27,2,'大港区'),(28,2,'东丽区'),(29,2,'西青区'),(30,2,'津南区'),(31,2,'北辰区'),(32,2,'武清区'),(33,2,'宝坻区'),(34,2,'宁河县'),(35,2,'静海县'),(36,2,'蓟县'),(37,3,'长安区'),(38,3,'桥东区'),(39,3,'桥西区'),(40,3,'新华区'),(41,3,'井陉矿区'),(42,3,'裕华区'),(43,3,'井陉县'),(44,3,'正定县'),(45,3,'栾城县'),(46,3,'行唐县'),(47,3,'灵寿县'),(48,3,'高邑县'),(49,3,'深泽县'),(50,3,'赞皇县'),(51,3,'无极县'),(52,3,'平山县'),(53,3,'元氏县'),(54,3,'赵县'),(55,3,'辛集市'),(56,3,'藁城市'),(57,3,'晋州市'),(58,3,'新乐市'),(59,3,'鹿泉市'),(60,4,'路南区'),(61,4,'路北区'),(62,4,'古冶区'),(63,4,'开平区'),(64,4,'丰南区'),(65,4,'丰润区'),(66,4,'滦县'),(67,4,'滦南县'),(68,4,'乐亭县'),(69,4,'迁西县'),(70,4,'玉田县'),(71,4,'唐海县'),(72,4,'遵化市'),(73,4,'迁安市'),(74,5,'海港区'),(75,5,'山海关区'),(76,5,'北戴河区'),(77,5,'青龙满族自治县'),(78,5,'昌黎县'),(79,5,'抚宁县'),(80,5,'卢龙县'),(81,6,'邯山区'),(82,6,'丛台区'),(83,6,'复兴区'),(84,6,'峰峰矿区'),(85,6,'邯郸县'),(86,6,'临漳县'),(87,6,'成安县'),(88,6,'大名县'),(89,6,'涉县'),(90,6,'磁县'),(91,6,'肥乡县'),(92,6,'永年县'),(93,6,'邱县'),(94,6,'鸡泽县'),(95,6,'广平县'),(96,6,'馆陶县'),(97,6,'魏县'),(98,6,'曲周县'),(99,6,'武安市'),(100,7,'桥东区'),(101,7,'桥西区'),(102,7,'邢台县'),(103,7,'临城县'),(104,7,'内丘县'),(105,7,'柏乡县'),(106,7,'隆尧县'),(107,7,'任县'),(108,7,'南和县'),(109,7,'宁晋县'),(110,7,'巨鹿县'),(111,7,'新河县'),(112,7,'广宗县'),(113,7,'平乡县'),(114,7,'威县'),(115,7,'清河县'),(116,7,'临西县'),(117,7,'南宫市'),(118,7,'沙河市'),(119,8,'新市区'),(120,8,'北市区'),(121,8,'南市区'),(122,8,'满城县'),(123,8,'清苑县'),(124,8,'涞水县'),(125,8,'阜平县'),(126,8,'徐水县'),(127,8,'定兴县'),(128,8,'唐县'),(129,8,'高阳县'),(130,8,'容城县'),(131,8,'涞源县'),(132,8,'望都县'),(133,8,'安新县'),(134,8,'易县'),(135,8,'曲阳县'),(136,8,'蠡县'),(137,8,'顺平县'),(138,8,'博野县'),(139,8,'雄县'),(140,8,'涿州市'),(141,8,'定州市'),(142,8,'安国市'),(143,8,'高碑店市'),(144,9,'桥东区'),(145,9,'桥西区'),(146,9,'宣化区'),(147,9,'下花园区'),(148,9,'宣化县'),(149,9,'张北县'),(150,9,'康保县'),(151,9,'沽源县'),(152,9,'尚义县'),(153,9,'蔚县'),(154,9,'阳原县'),(155,9,'怀安县'),(156,9,'万全县'),(157,9,'怀来县'),(158,9,'涿鹿县'),(159,9,'赤城县'),(160,9,'崇礼县'),(161,10,'双桥区'),(162,10,'双滦区'),(163,10,'鹰手营子矿区'),(164,10,'承德县'),(165,10,'兴隆县'),(166,10,'平泉县'),(167,10,'滦平县'),(168,10,'隆化县'),(169,10,'丰宁满族自治县'),(170,10,'宽城满族自治县'),(171,10,'围场满族蒙古族自治县'),(172,11,'新华区'),(173,11,'运河区'),(174,11,'沧县'),(175,11,'青县'),(176,11,'东光县'),(177,11,'海兴县'),(178,11,'盐山县'),(179,11,'肃宁县'),(180,11,'南皮县'),(181,11,'吴桥县'),(182,11,'献县'),(183,11,'孟村回族自治县'),(184,11,'泊头市'),(185,11,'任丘市'),(186,11,'黄骅市'),(187,11,'河间市'),(188,12,'安次区'),(189,12,'广阳区'),(190,12,'固安县'),(191,12,'永清县'),(192,12,'香河县'),(193,12,'大城县'),(194,12,'文安县'),(195,12,'大厂回族自治县'),(196,12,'霸州市'),(197,12,'三河市'),(198,13,'桃城区'),(199,13,'枣强县'),(200,13,'武邑县'),(201,13,'武强县'),(202,13,'饶阳县'),(203,13,'安平县'),(204,13,'故城县'),(205,13,'景县'),(206,13,'阜城县'),(207,13,'冀州市'),(208,13,'深州市'),(209,14,'小店区'),(210,14,'迎泽区'),(211,14,'杏花岭区'),(212,14,'尖草坪区'),(213,14,'万柏林区'),(214,14,'晋源区'),(215,14,'清徐县'),(216,14,'阳曲县'),(217,14,'娄烦县'),(218,14,'古交市'),(219,15,'城区'),(220,15,'矿区'),(221,15,'南郊区'),(222,15,'新荣区'),(223,15,'阳高县'),(224,15,'天镇县'),(225,15,'广灵县'),(226,15,'灵丘县'),(227,15,'浑源县'),(228,15,'左云县'),(229,15,'大同县'),(230,16,'城区'),(231,16,'矿区'),(232,16,'郊区'),(233,16,'平定县'),(234,16,'盂县'),(235,17,'城区'),(236,17,'郊区'),(237,17,'长治县'),(238,17,'襄垣县'),(239,17,'屯留县'),(240,17,'平顺县'),(241,17,'黎城县'),(242,17,'壶关县'),(243,17,'长子县'),(244,17,'武乡县'),(245,17,'沁县'),(246,17,'沁源县'),(247,17,'潞城市'),(248,18,'城区'),(249,18,'沁水县'),(250,18,'阳城县'),(251,18,'陵川县'),(252,18,'泽州县'),(253,18,'高平市'),(254,19,'朔城区'),(255,19,'平鲁区'),(256,19,'山阴县'),(257,19,'应县'),(258,19,'右玉县'),(259,19,'怀仁县'),(260,20,'榆次区'),(261,20,'榆社县'),(262,20,'左权县'),(263,20,'和顺县'),(264,20,'昔阳县'),(265,20,'寿阳县'),(266,20,'太谷县'),(267,20,'祁县'),(268,20,'平遥县'),(269,20,'灵石县'),(270,20,'介休市'),(271,21,'盐湖区'),(272,21,'临猗县'),(273,21,'万荣县'),(274,21,'闻喜县'),(275,21,'稷山县'),(276,21,'新绛县'),(277,21,'绛县'),(278,21,'垣曲县'),(279,21,'夏县'),(280,21,'平陆县'),(281,21,'芮城县'),(282,21,'永济市'),(283,21,'河津市'),(284,22,'忻府区'),(285,22,'定襄县'),(286,22,'五台县'),(287,22,'代县'),(288,22,'繁峙县'),(289,22,'宁武县'),(290,22,'静乐县'),(291,22,'神池县'),(292,22,'五寨县'),(293,22,'岢岚县'),(294,22,'河曲县'),(295,22,'保德县'),(296,22,'偏关县'),(297,22,'原平市'),(298,23,'尧都区'),(299,23,'曲沃县'),(300,23,'翼城县'),(301,23,'襄汾县'),(302,23,'洪洞县'),(303,23,'古县'),(304,23,'安泽县'),(305,23,'浮山县'),(306,23,'吉县'),(307,23,'乡宁县'),(308,23,'大宁县'),(309,23,'隰县'),(310,23,'永和县'),(311,23,'蒲县'),(312,23,'汾西县'),(313,23,'侯马市'),(314,23,'霍州市'),(315,24,'离石区'),(316,24,'文水县'),(317,24,'交城县'),(318,24,'兴县'),(319,24,'临县'),(320,24,'柳林县'),(321,24,'石楼县'),(322,24,'岚县'),(323,24,'方山县'),(324,24,'中阳县'),(325,24,'交口县'),(326,24,'孝义市'),(327,24,'汾阳市'),(328,25,'新城区'),(329,25,'回民区'),(330,25,'玉泉区'),(331,25,'赛罕区'),(332,25,'土默特左旗'),(333,25,'托克托县'),(334,25,'和林格尔县'),(335,25,'清水河县'),(336,25,'武川县'),(337,26,'东河区'),(338,26,'昆都仑区'),(339,26,'青山区'),(340,26,'石拐区'),(341,26,'白云矿区'),(342,26,'九原区'),(343,26,'土默特右旗'),(344,26,'固阳县'),(345,26,'达尔罕茂明安联合旗'),(346,27,'海勃湾区'),(347,27,'海南区'),(348,27,'乌达区'),(349,28,'红山区'),(350,28,'元宝山区'),(351,28,'松山区'),(352,28,'阿鲁科尔沁旗'),(353,28,'巴林左旗'),(354,28,'巴林右旗'),(355,28,'林西县'),(356,28,'克什克腾旗'),(357,28,'翁牛特旗'),(358,28,'喀喇沁旗'),(359,28,'宁城县'),(360,28,'敖汉旗'),(361,29,'科尔沁区'),(362,29,'科尔沁左翼中旗'),(363,29,'科尔沁左翼后旗'),(364,29,'开鲁县'),(365,29,'库伦旗'),(366,29,'奈曼旗'),(367,29,'扎鲁特旗'),(368,29,'霍林郭勒市'),(369,30,'东胜区'),(370,30,'达拉特旗'),(371,30,'准格尔旗'),(372,30,'鄂托克前旗'),(373,30,'鄂托克旗'),(374,30,'杭锦旗'),(375,30,'乌审旗'),(376,30,'伊金霍洛旗'),(377,31,'海拉尔区'),(378,31,'阿荣旗'),(379,31,'莫力达瓦达斡尔族自治旗'),(380,31,'鄂伦春自治旗'),(381,31,'鄂温克族自治旗'),(382,31,'陈巴尔虎旗'),(383,31,'新巴尔虎左旗'),(384,31,'新巴尔虎右旗'),(385,31,'满洲里市'),(386,31,'牙克石市'),(387,31,'扎兰屯市'),(388,31,'额尔古纳市'),(389,31,'根河市'),(390,32,'临河区'),(391,32,'五原县'),(392,32,'磴口县'),(393,32,'乌拉特前旗'),(394,32,'乌拉特中旗'),(395,32,'乌拉特后旗'),(396,32,'杭锦后旗'),(397,33,'集宁区'),(398,33,'卓资县'),(399,33,'化德县'),(400,33,'商都县'),(401,33,'兴和县'),(402,33,'凉城县'),(403,33,'察哈尔右翼前旗'),(404,33,'察哈尔右翼中旗'),(405,33,'察哈尔右翼后旗'),(406,33,'四子王旗'),(407,33,'丰镇市'),(408,34,'乌兰浩特市'),(409,34,'阿尔山市'),(410,34,'科尔沁右翼前旗'),(411,34,'科尔沁右翼中旗'),(412,34,'扎赉特旗'),(413,34,'突泉县'),(414,35,'二连浩特市'),(415,35,'锡林浩特市'),(416,35,'阿巴嘎旗'),(417,35,'苏尼特左旗'),(418,35,'苏尼特右旗'),(419,35,'东乌珠穆沁旗'),(420,35,'西乌珠穆沁旗'),(421,35,'太仆寺旗'),(422,35,'镶黄旗'),(423,35,'正镶白旗'),(424,35,'正蓝旗'),(425,35,'多伦县'),(426,36,'阿拉善左旗'),(427,36,'阿拉善右旗'),(428,36,'额济纳旗'),(429,37,'和平区'),(430,37,'沈河区'),(431,37,'大东区'),(432,37,'皇姑区'),(433,37,'铁西区'),(434,37,'苏家屯区'),(435,37,'东陵区'),(436,37,'新城子区'),(437,37,'于洪区'),(438,37,'辽中县'),(439,37,'康平县'),(440,37,'法库县'),(441,37,'新民市'),(442,38,'中山区'),(443,38,'西岗区'),(444,38,'沙河口区'),(445,38,'甘井子区'),(446,38,'旅顺口区'),(447,38,'金州区'),(448,38,'长海县'),(449,38,'瓦房店市'),(450,38,'普兰店市'),(451,38,'庄河市'),(452,39,'铁东区'),(453,39,'铁西区'),(454,39,'立山区'),(455,39,'千山区'),(456,39,'台安县'),(457,39,'岫岩满族自治县'),(458,39,'海城市'),(459,40,'新抚区'),(460,40,'东洲区'),(461,40,'望花区'),(462,40,'顺城区'),(463,40,'抚顺县'),(464,40,'新宾满族自治县'),(465,40,'清原满族自治县'),(466,41,'平山区'),(467,41,'溪湖区'),(468,41,'明山区'),(469,41,'南芬区'),(470,41,'本溪满族自治县'),(471,41,'桓仁满族自治县'),(472,42,'元宝区'),(473,42,'振兴区'),(474,42,'振安区'),(475,42,'宽甸满族自治县'),(476,42,'东港市'),(477,42,'凤城市'),(478,43,'古塔区'),(479,43,'凌河区'),(480,43,'太和区'),(481,43,'黑山县'),(482,43,'义县'),(483,43,'凌海市'),(484,43,'北宁市'),(485,44,'站前区'),(486,44,'西市区'),(487,44,'鲅鱼圈区'),(488,44,'老边区'),(489,44,'盖州市'),(490,44,'大石桥市'),(491,45,'海州区'),(492,45,'新邱区'),(493,45,'太平区'),(494,45,'清河门区'),(495,45,'细河区'),(496,45,'阜新蒙古族自治县'),(497,45,'彰武县'),(498,46,'白塔区'),(499,46,'文圣区'),(500,46,'宏伟区'),(501,46,'弓长岭区'),(502,46,'太子河区'),(503,46,'辽阳县'),(504,46,'灯塔市'),(505,47,'双台子区'),(506,47,'兴隆台区'),(507,47,'大洼县'),(508,47,'盘山县'),(509,48,'银州区'),(510,48,'清河区'),(511,48,'铁岭县'),(512,48,'西丰县'),(513,48,'昌图县'),(514,48,'调兵山市'),(515,48,'开原市'),(516,49,'双塔区'),(517,49,'龙城区'),(518,49,'朝阳县'),(519,49,'建平县'),(520,49,'喀喇沁左翼蒙古族自治县'),(521,49,'北票市'),(522,49,'凌源市'),(523,50,'连山区'),(524,50,'龙港区'),(525,50,'南票区'),(526,50,'绥中县'),(527,50,'建昌县'),(528,50,'兴城市'),(529,51,'南关区'),(530,51,'宽城区'),(531,51,'朝阳区'),(532,51,'二道区'),(533,51,'绿园区'),(534,51,'双阳区'),(535,51,'农安县'),(536,51,'九台市'),(537,51,'榆树市'),(538,51,'德惠市'),(539,52,'昌邑区'),(540,52,'龙潭区'),(541,52,'船营区'),(542,52,'丰满区'),(543,52,'永吉县'),(544,52,'蛟河市'),(545,52,'桦甸市'),(546,52,'舒兰市'),(547,52,'磐石市'),(548,53,'铁西区'),(549,53,'铁东区'),(550,53,'梨树县'),(551,53,'伊通满族自治县'),(552,53,'公主岭市'),(553,53,'双辽市'),(554,54,'龙山区'),(555,54,'西安区'),(556,54,'东丰县'),(557,54,'东辽县'),(558,55,'东昌区'),(559,55,'二道江区'),(560,55,'通化县'),(561,55,'辉南县'),(562,55,'柳河县'),(563,55,'梅河口市'),(564,55,'集安市'),(565,56,'八道江区'),(566,56,'抚松县'),(567,56,'靖宇县'),(568,56,'长白朝鲜族自治县'),(569,56,'江源县'),(570,56,'临江市'),(571,57,'宁江区'),(572,57,'前郭尔罗斯蒙古族自治县'),(573,57,'长岭县'),(574,57,'乾安县'),(575,57,'扶余县'),(576,58,'洮北区'),(577,58,'镇赉县'),(578,58,'通榆县'),(579,58,'洮南市'),(580,58,'大安市'),(581,59,'延吉市'),(582,59,'图们市'),(583,59,'敦化市'),(584,59,'珲春市'),(585,59,'龙井市'),(586,59,'和龙市'),(587,59,'汪清县'),(588,59,'安图县'),(589,60,'道里区'),(590,60,'南岗区'),(591,60,'道外区'),(592,60,'香坊区'),(593,60,'动力区'),(594,60,'平房区'),(595,60,'松北区'),(596,60,'呼兰区'),(597,60,'依兰县'),(598,60,'方正县'),(599,60,'宾县'),(600,60,'巴彦县'),(601,60,'木兰县'),(602,60,'通河县'),(603,60,'延寿县'),(604,60,'阿城市'),(605,60,'双城市'),(606,60,'尚志市'),(607,60,'五常市'),(608,61,'龙沙区'),(609,61,'建华区'),(610,61,'铁锋区'),(611,61,'昂昂溪区'),(612,61,'富拉尔基区'),(613,61,'碾子山区'),(614,61,'梅里斯达斡尔族区'),(615,61,'龙江县'),(616,61,'依安县'),(617,61,'泰来县'),(618,61,'甘南县'),(619,61,'富裕县'),(620,61,'克山县'),(621,61,'克东县'),(622,61,'拜泉县'),(623,61,'讷河市'),(624,62,'鸡冠区'),(625,62,'恒山区'),(626,62,'滴道区'),(627,62,'梨树区'),(628,62,'城子河区'),(629,62,'麻山区'),(630,62,'鸡东县'),(631,62,'虎林市'),(632,62,'密山市'),(633,63,'向阳区'),(634,63,'工农区'),(635,63,'南山区'),(636,63,'兴安区'),(637,63,'东山区'),(638,63,'兴山区'),(639,63,'萝北县'),(640,63,'绥滨县'),(641,64,'尖山区'),(642,64,'岭东区'),(643,64,'四方台区'),(644,64,'宝山区'),(645,64,'集贤县'),(646,64,'友谊县'),(647,64,'宝清县'),(648,64,'饶河县'),(649,65,'萨尔图区'),(650,65,'龙凤区'),(651,65,'让胡路区'),(652,65,'红岗区'),(653,65,'大同区'),(654,65,'肇州县'),(655,65,'肇源县'),(656,65,'林甸县'),(657,65,'杜尔伯特蒙古族自治县'),(658,66,'伊春区'),(659,66,'南岔区'),(660,66,'友好区'),(661,66,'西林区'),(662,66,'翠峦区'),(663,66,'新青区'),(664,66,'美溪区'),(665,66,'金山屯区'),(666,66,'五营区'),(667,66,'乌马河区'),(668,66,'汤旺河区'),(669,66,'带岭区'),(670,66,'乌伊岭区'),(671,66,'红星区'),(672,66,'上甘岭区'),(673,66,'嘉荫县'),(674,66,'铁力市'),(675,67,'永红区'),(676,67,'向阳区'),(677,67,'前进区'),(678,67,'东风区'),(679,67,'郊区'),(680,67,'桦南县'),(681,67,'桦川县'),(682,67,'汤原县'),(683,67,'抚远县'),(684,67,'同江市'),(685,67,'富锦市'),(686,68,'新兴区'),(687,68,'桃山区'),(688,68,'茄子河区'),(689,68,'勃利县'),(690,69,'东安区'),(691,69,'阳明区'),(692,69,'爱民区'),(693,69,'西安区'),(694,69,'东宁县'),(695,69,'林口县'),(696,69,'绥芬河市'),(697,69,'海林市'),(698,69,'宁安市'),(699,69,'穆棱市'),(700,70,'爱辉区'),(701,70,'嫩江县'),(702,70,'逊克县'),(703,70,'孙吴县'),(704,70,'北安市'),(705,70,'五大连池市'),(706,71,'北林区'),(707,71,'望奎县'),(708,71,'兰西县'),(709,71,'青冈县'),(710,71,'庆安县'),(711,71,'明水县'),(712,71,'绥棱县'),(713,71,'安达市'),(714,71,'肇东市'),(715,71,'海伦市'),(716,72,'呼玛县'),(717,72,'塔河县'),(718,72,'漠河县'),(719,73,'黄浦区'),(720,73,'卢湾区'),(721,73,'徐汇区'),(722,73,'长宁区'),(723,73,'静安区'),(724,73,'普陀区'),(725,73,'闸北区'),(726,73,'虹口区'),(727,73,'杨浦区'),(728,73,'闵行区'),(729,73,'宝山区'),(730,73,'嘉定区'),(731,73,'浦东新区'),(732,73,'金山区'),(733,73,'松江区'),(734,73,'青浦区'),(735,73,'南汇区'),(736,73,'奉贤区'),(737,73,'崇明县'),(738,74,'玄武区'),(739,74,'白下区'),(740,74,'秦淮区'),(741,74,'建邺区'),(742,74,'鼓楼区'),(743,74,'下关区'),(744,74,'浦口区'),(745,74,'栖霞区'),(746,74,'雨花台区'),(747,74,'江宁区'),(748,74,'六合区'),(749,74,'溧水县'),(750,74,'高淳县'),(751,75,'崇安区'),(752,75,'南长区'),(753,75,'北塘区'),(754,75,'锡山区'),(755,75,'惠山区'),(756,75,'滨湖区'),(757,75,'江阴市'),(758,75,'宜兴市'),(759,76,'鼓楼区'),(760,76,'云龙区'),(761,76,'九里区'),(762,76,'贾汪区'),(763,76,'泉山区'),(764,76,'丰县'),(765,76,'沛县'),(766,76,'铜山县'),(767,76,'睢宁县'),(768,76,'新沂市'),(769,76,'邳州市'),(770,77,'天宁区'),(771,77,'钟楼区'),(772,77,'戚墅堰区'),(773,77,'新北区'),(774,77,'武进区'),(775,77,'溧阳市'),(776,77,'金坛市'),(777,78,'沧浪区'),(778,78,'平江区'),(779,78,'金阊区'),(780,78,'虎丘区'),(781,78,'吴中区'),(782,78,'相城区'),(783,78,'常熟市'),(784,78,'张家港市'),(785,78,'昆山市'),(786,78,'吴江市'),(787,78,'太仓市'),(788,79,'崇川区'),(789,79,'港闸区'),(790,79,'海安县'),(791,79,'如东县'),(792,79,'启东市'),(793,79,'如皋市'),(794,79,'通州市'),(795,79,'海门市'),(796,80,'连云区'),(797,80,'新浦区'),(798,80,'海州区'),(799,80,'赣榆县'),(800,80,'东海县'),(801,80,'灌云县'),(802,80,'灌南县'),(803,81,'清河区'),(804,81,'楚州区'),(805,81,'淮阴区'),(806,81,'清浦区'),(807,81,'涟水县'),(808,81,'洪泽县'),(809,81,'盱眙县'),(810,81,'金湖县'),(811,82,'亭湖区'),(812,82,'盐都区'),(813,82,'响水县'),(814,82,'滨海县'),(815,82,'阜宁县'),(816,82,'射阳县'),(817,82,'建湖县'),(818,82,'东台市'),(819,82,'大丰市'),(820,83,'广陵区'),(821,83,'邗江区'),(822,83,'维扬区'),(823,83,'宝应县'),(824,83,'仪征市'),(825,83,'高邮市'),(826,83,'江都市'),(827,84,'京口区'),(828,84,'润州区'),(829,84,'丹徒区'),(830,84,'丹阳市'),(831,84,'扬中市'),(832,84,'句容市'),(833,85,'海陵区'),(834,85,'高港区'),(835,85,'兴化市'),(836,85,'靖江市'),(837,85,'泰兴市'),(838,85,'姜堰市'),(839,86,'宿城区'),(840,86,'宿豫区'),(841,86,'沭阳县'),(842,86,'泗阳县'),(843,86,'泗洪县'),(844,87,'上城区'),(845,87,'下城区'),(846,87,'江干区'),(847,87,'拱墅区'),(848,87,'西湖区'),(849,87,'滨江区'),(850,87,'萧山区'),(851,87,'余杭区'),(852,87,'桐庐县'),(853,87,'淳安县'),(854,87,'建德市'),(855,87,'富阳市'),(856,87,'临安市'),(857,88,'海曙区'),(858,88,'江东区'),(859,88,'江北区'),(860,88,'北仑区'),(861,88,'镇海区'),(862,88,'鄞州区'),(863,88,'象山县'),(864,88,'宁海县'),(865,88,'余姚市'),(866,88,'慈溪市'),(867,88,'奉化市'),(868,89,'鹿城区'),(869,89,'龙湾区'),(870,89,'瓯海区'),(871,89,'洞头县'),(872,89,'永嘉县'),(873,89,'平阳县'),(874,89,'苍南县'),(875,89,'文成县'),(876,89,'泰顺县'),(877,89,'瑞安市'),(878,89,'乐清市'),(879,90,'秀城区'),(880,90,'秀洲区'),(881,90,'嘉善县'),(882,90,'海盐县'),(883,90,'海宁市'),(884,90,'平湖市'),(885,90,'桐乡市'),(886,91,'吴兴区'),(887,91,'南浔区'),(888,91,'德清县'),(889,91,'长兴县'),(890,91,'安吉县'),(891,92,'越城区'),(892,92,'绍兴县'),(893,92,'新昌县'),(894,92,'诸暨市'),(895,92,'上虞市'),(896,92,'嵊州市'),(897,93,'婺城区'),(898,93,'金东区'),(899,93,'武义县'),(900,93,'浦江县'),(901,93,'磐安县'),(902,93,'兰溪市'),(903,93,'义乌市'),(904,93,'东阳市'),(905,93,'永康市'),(906,94,'柯城区'),(907,94,'衢江区'),(908,94,'常山县'),(909,94,'开化县'),(910,94,'龙游县'),(911,94,'江山市'),(912,95,'定海区'),(913,95,'普陀区'),(914,95,'岱山县'),(915,95,'嵊泗县'),(916,96,'椒江区'),(917,96,'黄岩区'),(918,96,'路桥区'),(919,96,'玉环县'),(920,96,'三门县'),(921,96,'天台县'),(922,96,'仙居县'),(923,96,'温岭市'),(924,96,'临海市'),(925,97,'莲都区'),(926,97,'青田县'),(927,97,'缙云县'),(928,97,'遂昌县'),(929,97,'松阳县'),(930,97,'云和县'),(931,97,'庆元县'),(932,97,'景宁畲族自治县'),(933,97,'龙泉市'),(934,98,'瑶海区'),(935,98,'庐阳区'),(936,98,'蜀山区'),(937,98,'包河区'),(938,98,'长丰县'),(939,98,'肥东县'),(940,98,'肥西县'),(941,99,'镜湖区'),(942,99,'马塘区'),(943,99,'新芜区'),(944,99,'鸠江区'),(945,99,'芜湖县'),(946,99,'繁昌县'),(947,99,'南陵县'),(948,100,'龙子湖区'),(949,100,'蚌山区'),(950,100,'禹会区'),(951,100,'淮上区'),(952,100,'怀远县'),(953,100,'五河县'),(954,100,'固镇县'),(955,101,'大通区'),(956,101,'田家庵区'),(957,101,'谢家集区'),(958,101,'八公山区'),(959,101,'潘集区'),(960,101,'凤台县'),(961,102,'金家庄区'),(962,102,'花山区'),(963,102,'雨山区'),(964,102,'当涂县'),(965,103,'杜集区'),(966,103,'相山区'),(967,103,'烈山区'),(968,103,'濉溪县'),(969,104,'铜官山区'),(970,104,'狮子山区'),(971,104,'郊区'),(972,104,'铜陵县'),(973,105,'迎江区'),(974,105,'大观区'),(975,105,'郊区'),(976,105,'怀宁县'),(977,105,'枞阳县'),(978,105,'潜山县'),(979,105,'太湖县'),(980,105,'宿松县'),(981,105,'望江县'),(982,105,'岳西县'),(983,105,'桐城市'),(984,106,'屯溪区'),(985,106,'黄山区'),(986,106,'徽州区'),(987,106,'歙县'),(988,106,'休宁县'),(989,106,'黟县'),(990,106,'祁门县'),(991,107,'琅琊区'),(992,107,'南谯区'),(993,107,'来安县'),(994,107,'全椒县'),(995,107,'定远县'),(996,107,'凤阳县'),(997,107,'天长市'),(998,107,'明光市'),(999,108,'颍州区'),(1000,108,'颍东区'),(1001,108,'颍泉区'),(1002,108,'临泉县'),(1003,108,'太和县'),(1004,108,'阜南县'),(1005,108,'颍上县'),(1006,108,'界首市'),(1007,109,'埇桥区'),(1008,109,'砀山县'),(1009,109,'萧县'),(1010,109,'灵璧县'),(1011,109,'泗县'),(1012,110,'居巢区'),(1013,110,'庐江县'),(1014,110,'无为县'),(1015,110,'含山县'),(1016,110,'和县'),(1017,111,'金安区'),(1018,111,'裕安区'),(1019,111,'寿县'),(1020,111,'霍邱县'),(1021,111,'舒城县'),(1022,111,'金寨县'),(1023,111,'霍山县'),(1024,112,'谯城区'),(1025,112,'涡阳县'),(1026,112,'蒙城县'),(1027,112,'利辛县'),(1028,113,'贵池区'),(1029,113,'东至县'),(1030,113,'石台县'),(1031,113,'青阳县'),(1032,114,'宣州区'),(1033,114,'郎溪县'),(1034,114,'广德县'),(1035,114,'泾县'),(1036,114,'绩溪县'),(1037,114,'旌德县'),(1038,114,'宁国市'),(1039,115,'鼓楼区'),(1040,115,'台江区'),(1041,115,'仓山区'),(1042,115,'马尾区'),(1043,115,'晋安区'),(1044,115,'闽侯县'),(1045,115,'连江县'),(1046,115,'罗源县'),(1047,115,'闽清县'),(1048,115,'永泰县'),(1049,115,'平潭县'),(1050,115,'福清市'),(1051,115,'长乐市'),(1052,116,'思明区'),(1053,116,'海沧区'),(1054,116,'湖里区'),(1055,116,'集美区'),(1056,116,'同安区'),(1057,116,'翔安区'),(1058,117,'城厢区'),(1059,117,'涵江区'),(1060,117,'荔城区'),(1061,117,'秀屿区'),(1062,117,'仙游县'),(1063,118,'梅列区'),(1064,118,'三元区'),(1065,118,'明溪县'),(1066,118,'清流县'),(1067,118,'宁化县'),(1068,118,'大田县'),(1069,118,'尤溪县'),(1070,118,'沙县'),(1071,118,'将乐县'),(1072,118,'泰宁县'),(1073,118,'建宁县'),(1074,118,'永安市'),(1075,119,'鲤城区'),(1076,119,'丰泽区'),(1077,119,'洛江区'),(1078,119,'泉港区'),(1079,119,'惠安县'),(1080,119,'安溪县'),(1081,119,'永春县'),(1082,119,'德化县'),(1083,119,'金门县'),(1084,119,'石狮市'),(1085,119,'晋江市'),(1086,119,'南安市'),(1087,120,'芗城区'),(1088,120,'龙文区'),(1089,120,'云霄县'),(1090,120,'漳浦县'),(1091,120,'诏安县'),(1092,120,'长泰县'),(1093,120,'东山县'),(1094,120,'南靖县'),(1095,120,'平和县'),(1096,120,'华安县'),(1097,120,'龙海市'),(1098,121,'延平区'),(1099,121,'顺昌县'),(1100,121,'浦城县'),(1101,121,'光泽县'),(1102,121,'松溪县'),(1103,121,'政和县'),(1104,121,'邵武市'),(1105,121,'武夷山市'),(1106,121,'建瓯市'),(1107,121,'建阳市'),(1108,122,'新罗区'),(1109,122,'长汀县'),(1110,122,'永定县'),(1111,122,'上杭县'),(1112,122,'武平县'),(1113,122,'连城县'),(1114,122,'漳平市'),(1115,123,'蕉城区'),(1116,123,'霞浦县'),(1117,123,'古田县'),(1118,123,'屏南县'),(1119,123,'寿宁县'),(1120,123,'周宁县'),(1121,123,'柘荣县'),(1122,123,'福安市'),(1123,123,'福鼎市'),(1124,124,'东湖区'),(1125,124,'西湖区'),(1126,124,'青云谱区'),(1127,124,'湾里区'),(1128,124,'青山湖区'),(1129,124,'南昌县'),(1130,124,'新建县'),(1131,124,'安义县'),(1132,124,'进贤县'),(1133,125,'昌江区'),(1134,125,'珠山区'),(1135,125,'浮梁县'),(1136,125,'乐平市'),(1137,126,'安源区'),(1138,126,'湘东区'),(1139,126,'莲花县'),(1140,126,'上栗县'),(1141,126,'芦溪县'),(1142,127,'庐山区'),(1143,127,'浔阳区'),(1144,127,'九江县'),(1145,127,'武宁县'),(1146,127,'修水县'),(1147,127,'永修县'),(1148,127,'德安县'),(1149,127,'星子县'),(1150,127,'都昌县'),(1151,127,'湖口县'),(1152,127,'彭泽县'),(1153,127,'瑞昌市'),(1154,128,'渝水区'),(1155,128,'分宜县'),(1156,129,'月湖区'),(1157,129,'余江县'),(1158,129,'贵溪市'),(1159,130,'章贡区'),(1160,130,'赣县'),(1161,130,'信丰县'),(1162,130,'大余县'),(1163,130,'上犹县'),(1164,130,'崇义县'),(1165,130,'安远县'),(1166,130,'龙南县'),(1167,130,'定南县'),(1168,130,'全南县'),(1169,130,'宁都县'),(1170,130,'于都县'),(1171,130,'兴国县'),(1172,130,'会昌县'),(1173,130,'寻乌县'),(1174,130,'石城县'),(1175,130,'瑞金市'),(1176,130,'南康市'),(1177,131,'吉州区'),(1178,131,'青原区'),(1179,131,'吉安县'),(1180,131,'吉水县'),(1181,131,'峡江县'),(1182,131,'新干县'),(1183,131,'永丰县'),(1184,131,'泰和县'),(1185,131,'遂川县'),(1186,131,'万安县'),(1187,131,'安福县'),(1188,131,'永新县'),(1189,131,'井冈山市'),(1190,132,'袁州区'),(1191,132,'奉新县'),(1192,132,'万载县'),(1193,132,'上高县'),(1194,132,'宜丰县'),(1195,132,'靖安县'),(1196,132,'铜鼓县'),(1197,132,'丰城市'),(1198,132,'樟树市'),(1199,132,'高安市'),(1200,133,'临川区'),(1201,133,'南城县'),(1202,133,'黎川县'),(1203,133,'南丰县'),(1204,133,'崇仁县'),(1205,133,'乐安县'),(1206,133,'宜黄县'),(1207,133,'金溪县'),(1208,133,'资溪县'),(1209,133,'东乡县'),(1210,133,'广昌县'),(1211,134,'信州区'),(1212,134,'上饶县'),(1213,134,'广丰县'),(1214,134,'玉山县'),(1215,134,'铅山县'),(1216,134,'横峰县'),(1217,134,'弋阳县'),(1218,134,'余干县'),(1219,134,'鄱阳县'),(1220,134,'万年县'),(1221,134,'婺源县'),(1222,134,'德兴市'),(1223,135,'历下区'),(1224,135,'市中区'),(1225,135,'槐荫区'),(1226,135,'天桥区'),(1227,135,'历城区'),(1228,135,'长清区'),(1229,135,'平阴县'),(1230,135,'济阳县'),(1231,135,'商河县'),(1232,135,'章丘市'),(1233,136,'市南区'),(1234,136,'市北区'),(1235,136,'四方区'),(1236,136,'黄岛区'),(1237,136,'崂山区'),(1238,136,'李沧区'),(1239,136,'城阳区'),(1240,136,'胶州市'),(1241,136,'即墨市'),(1242,136,'平度市'),(1243,136,'胶南市'),(1244,136,'莱西市'),(1245,137,'淄川区'),(1246,137,'张店区'),(1247,137,'博山区'),(1248,137,'临淄区'),(1249,137,'周村区'),(1250,137,'桓台县'),(1251,137,'高青县'),(1252,137,'沂源县'),(1253,138,'市中区'),(1254,138,'薛城区'),(1255,138,'峄城区'),(1256,138,'台儿庄区'),(1257,138,'山亭区'),(1258,138,'滕州市'),(1259,139,'东营区'),(1260,139,'河口区'),(1261,139,'垦利县'),(1262,139,'利津县'),(1263,139,'广饶县'),(1264,140,'芝罘区'),(1265,140,'福山区'),(1266,140,'牟平区'),(1267,140,'莱山区'),(1268,140,'长岛县'),(1269,140,'龙口市'),(1270,140,'莱阳市'),(1271,140,'莱州市'),(1272,140,'蓬莱市'),(1273,140,'招远市'),(1274,140,'栖霞市'),(1275,140,'海阳市'),(1276,141,'潍城区'),(1277,141,'寒亭区'),(1278,141,'坊子区'),(1279,141,'奎文区'),(1280,141,'临朐县'),(1281,141,'昌乐县'),(1282,141,'青州市'),(1283,141,'诸城市'),(1284,141,'寿光市'),(1285,141,'安丘市'),(1286,141,'高密市'),(1287,141,'昌邑市'),(1288,142,'市中区'),(1289,142,'任城区'),(1290,142,'微山县'),(1291,142,'鱼台县'),(1292,142,'金乡县'),(1293,142,'嘉祥县'),(1294,142,'汶上县'),(1295,142,'泗水县'),(1296,142,'梁山县'),(1297,142,'曲阜市'),(1298,142,'兖州市'),(1299,142,'邹城市'),(1300,143,'泰山区'),(1301,143,'岱岳区'),(1302,143,'宁阳县'),(1303,143,'东平县'),(1304,143,'新泰市'),(1305,143,'肥城市'),(1306,144,'环翠区'),(1307,144,'文登市'),(1308,144,'荣成市'),(1309,144,'乳山市'),(1310,145,'东港区'),(1311,145,'岚山区'),(1312,145,'五莲县'),(1313,145,'莒县'),(1314,146,'莱城区'),(1315,146,'钢城区'),(1316,147,'兰山区'),(1317,147,'罗庄区'),(1318,147,'河东区'),(1319,147,'沂南县'),(1320,147,'郯城县'),(1321,147,'沂水县'),(1322,147,'苍山县'),(1323,147,'费县'),(1324,147,'平邑县'),(1325,147,'莒南县'),(1326,147,'蒙阴县'),(1327,147,'临沭县'),(1328,148,'德城区'),(1329,148,'陵县'),(1330,148,'宁津县'),(1331,148,'庆云县'),(1332,148,'临邑县'),(1333,148,'齐河县'),(1334,148,'平原县'),(1335,148,'夏津县'),(1336,148,'武城县'),(1337,148,'乐陵市'),(1338,148,'禹城市'),(1339,149,'东昌府区'),(1340,149,'阳谷县'),(1341,149,'莘县'),(1342,149,'茌平县'),(1343,149,'东阿县'),(1344,149,'冠县'),(1345,149,'高唐县'),(1346,149,'临清市'),(1347,150,'滨城区'),(1348,150,'惠民县'),(1349,150,'阳信县'),(1350,150,'无棣县'),(1351,150,'沾化县'),(1352,150,'博兴县'),(1353,150,'邹平县'),(1354,151,'牡丹区'),(1355,151,'曹县'),(1356,151,'单县'),(1357,151,'成武县'),(1358,151,'巨野县'),(1359,151,'郓城县'),(1360,151,'鄄城县'),(1361,151,'定陶县'),(1362,151,'东明县'),(1363,152,'中原区'),(1364,152,'二七区'),(1365,152,'管城回族区'),(1366,152,'金水区'),(1367,152,'上街区'),(1368,152,'惠济区'),(1369,152,'中牟县'),(1370,152,'巩义市'),(1371,152,'荥阳市'),(1372,152,'新密市'),(1373,152,'新郑市'),(1374,152,'登封市'),(1375,153,'龙亭区'),(1376,153,'顺河回族区'),(1377,153,'鼓楼区'),(1378,153,'南关区'),(1379,153,'郊区'),(1380,153,'杞县'),(1381,153,'通许县'),(1382,153,'尉氏县'),(1383,153,'开封县'),(1384,153,'兰考县'),(1385,154,'老城区'),(1386,154,'西工区'),(1387,154,'廛河回族区'),(1388,154,'涧西区'),(1389,154,'吉利区'),(1390,154,'洛龙区'),(1391,154,'孟津县'),(1392,154,'新安县'),(1393,154,'栾川县'),(1394,154,'嵩县'),(1395,154,'汝阳县'),(1396,154,'宜阳县'),(1397,154,'洛宁县'),(1398,154,'伊川县'),(1399,154,'偃师市'),(1400,155,'新华区'),(1401,155,'卫东区'),(1402,155,'石龙区'),(1403,155,'湛河区'),(1404,155,'宝丰县'),(1405,155,'叶县'),(1406,155,'鲁山县'),(1407,155,'郏县'),(1408,155,'舞钢市'),(1409,155,'汝州市'),(1410,156,'文峰区'),(1411,156,'北关区'),(1412,156,'殷都区'),(1413,156,'龙安区'),(1414,156,'安阳县'),(1415,156,'汤阴县'),(1416,156,'滑县'),(1417,156,'内黄县'),(1418,156,'林州市'),(1419,157,'鹤山区'),(1420,157,'山城区'),(1421,157,'淇滨区'),(1422,157,'浚县'),(1423,157,'淇县'),(1424,158,'红旗区'),(1425,158,'卫滨区'),(1426,158,'凤泉区'),(1427,158,'牧野区'),(1428,158,'新乡县'),(1429,158,'获嘉县'),(1430,158,'原阳县'),(1431,158,'延津县'),(1432,158,'封丘县'),(1433,158,'长垣县'),(1434,158,'卫辉市'),(1435,158,'辉县市'),(1436,159,'解放区'),(1437,159,'中站区'),(1438,159,'马村区'),(1439,159,'山阳区'),(1440,159,'修武县'),(1441,159,'博爱县'),(1442,159,'武陟县'),(1443,159,'温县'),(1444,159,'济源市'),(1445,159,'沁阳市'),(1446,159,'孟州市'),(1447,160,'华龙区'),(1448,160,'清丰县'),(1449,160,'南乐县'),(1450,160,'范县'),(1451,160,'台前县'),(1452,160,'濮阳县'),(1453,161,'魏都区'),(1454,161,'许昌县'),(1455,161,'鄢陵县'),(1456,161,'襄城县'),(1457,161,'禹州市'),(1458,161,'长葛市'),(1459,162,'源汇区'),(1460,162,'郾城区'),(1461,162,'召陵区'),(1462,162,'舞阳县'),(1463,162,'临颍县'),(1464,163,'市辖区'),(1465,163,'湖滨区'),(1466,163,'渑池县'),(1467,163,'陕县'),(1468,163,'卢氏县'),(1469,163,'义马市'),(1470,163,'灵宝市'),(1471,164,'宛城区'),(1472,164,'卧龙区'),(1473,164,'南召县'),(1474,164,'方城县'),(1475,164,'西峡县'),(1476,164,'镇平县'),(1477,164,'内乡县'),(1478,164,'淅川县'),(1479,164,'社旗县'),(1480,164,'唐河县'),(1481,164,'新野县'),(1482,164,'桐柏县'),(1483,164,'邓州市'),(1484,165,'梁园区'),(1485,165,'睢阳区'),(1486,165,'民权县'),(1487,165,'睢县'),(1488,165,'宁陵县'),(1489,165,'柘城县'),(1490,165,'虞城县'),(1491,165,'夏邑县'),(1492,165,'永城市'),(1493,166,'浉河区'),(1494,166,'平桥区'),(1495,166,'罗山县'),(1496,166,'光山县'),(1497,166,'新县'),(1498,166,'商城县'),(1499,166,'固始县'),(1500,166,'潢川县'),(1501,166,'淮滨县'),(1502,166,'息县'),(1503,167,'川汇区'),(1504,167,'扶沟县'),(1505,167,'西华县'),(1506,167,'商水县'),(1507,167,'沈丘县'),(1508,167,'郸城县'),(1509,167,'淮阳县'),(1510,167,'太康县'),(1511,167,'鹿邑县'),(1512,167,'项城市'),(1513,168,'驿城区'),(1514,168,'西平县'),(1515,168,'上蔡县'),(1516,168,'平舆县'),(1517,168,'正阳县'),(1518,168,'确山县'),(1519,168,'泌阳县'),(1520,168,'汝南县'),(1521,168,'遂平县'),(1522,168,'新蔡县'),(1523,169,'江岸区'),(1524,169,'江汉区'),(1525,169,'硚口区'),(1526,169,'汉阳区'),(1527,169,'武昌区'),(1528,169,'青山区'),(1529,169,'洪山区'),(1530,169,'东西湖区'),(1531,169,'汉南区'),(1532,169,'蔡甸区'),(1533,169,'江夏区'),(1534,169,'黄陂区'),(1535,169,'新洲区'),(1536,170,'黄石港区'),(1537,170,'西塞山区'),(1538,170,'下陆区'),(1539,170,'铁山区'),(1540,170,'阳新县'),(1541,170,'大冶市'),(1542,171,'茅箭区'),(1543,171,'张湾区'),(1544,171,'郧县'),(1545,171,'郧西县'),(1546,171,'竹山县'),(1547,171,'竹溪县'),(1548,171,'房县'),(1549,171,'丹江口市'),(1550,172,'西陵区'),(1551,172,'伍家岗区'),(1552,172,'点军区'),(1553,172,'猇亭区'),(1554,172,'夷陵区'),(1555,172,'远安县'),(1556,172,'兴山县'),(1557,172,'秭归县'),(1558,172,'长阳土家族自治县'),(1559,172,'五峰土家族自治县'),(1560,172,'宜都市'),(1561,172,'当阳市'),(1562,172,'枝江市'),(1563,173,'襄城区'),(1564,173,'樊城区'),(1565,173,'襄阳区'),(1566,173,'南漳县'),(1567,173,'谷城县'),(1568,173,'保康县'),(1569,173,'老河口市'),(1570,173,'枣阳市'),(1571,173,'宜城市'),(1572,174,'梁子湖区'),(1573,174,'华容区'),(1574,174,'鄂城区'),(1575,175,'东宝区'),(1576,175,'掇刀区'),(1577,175,'京山县'),(1578,175,'沙洋县'),(1579,175,'钟祥市'),(1580,176,'孝南区'),(1581,176,'孝昌县'),(1582,176,'大悟县'),(1583,176,'云梦县'),(1584,176,'应城市'),(1585,176,'安陆市'),(1586,176,'汉川市'),(1587,177,'沙市区'),(1588,177,'荆州区'),(1589,177,'公安县'),(1590,177,'监利县'),(1591,177,'江陵县'),(1592,177,'石首市'),(1593,177,'洪湖市'),(1594,177,'松滋市'),(1595,178,'黄州区'),(1596,178,'团风县'),(1597,178,'红安县'),(1598,178,'罗田县'),(1599,178,'英山县'),(1600,178,'浠水县'),(1601,178,'蕲春县'),(1602,178,'黄梅县'),(1603,178,'麻城市'),(1604,178,'武穴市'),(1605,179,'咸安区'),(1606,179,'嘉鱼县'),(1607,179,'通城县'),(1608,179,'崇阳县'),(1609,179,'通山县'),(1610,179,'赤壁市'),(1611,180,'曾都区'),(1612,180,'广水市'),(1613,181,'恩施市'),(1614,181,'利川市'),(1615,181,'建始县'),(1616,181,'巴东县'),(1617,181,'宣恩县'),(1618,181,'咸丰县'),(1619,181,'来凤县'),(1620,181,'鹤峰县'),(1621,182,'仙桃市'),(1622,182,'潜江市'),(1623,182,'天门市'),(1624,182,'神农架林区'),(1625,183,'芙蓉区'),(1626,183,'天心区'),(1627,183,'岳麓区'),(1628,183,'开福区'),(1629,183,'雨花区'),(1630,183,'长沙县'),(1631,183,'望城县'),(1632,183,'宁乡县'),(1633,183,'浏阳市'),(1634,184,'荷塘区'),(1635,184,'芦淞区'),(1636,184,'石峰区'),(1637,184,'天元区'),(1638,184,'株洲县'),(1639,184,'攸县'),(1640,184,'茶陵县'),(1641,184,'炎陵县'),(1642,184,'醴陵市'),(1643,185,'雨湖区'),(1644,185,'岳塘区'),(1645,185,'湘潭县'),(1646,185,'湘乡市'),(1647,185,'韶山市'),(1648,186,'珠晖区'),(1649,186,'雁峰区'),(1650,186,'石鼓区'),(1651,186,'蒸湘区'),(1652,186,'南岳区'),(1653,186,'衡阳县'),(1654,186,'衡南县'),(1655,186,'衡山县'),(1656,186,'衡东县'),(1657,186,'祁东县'),(1658,186,'耒阳市'),(1659,186,'常宁市'),(1660,187,'双清区'),(1661,187,'大祥区'),(1662,187,'北塔区'),(1663,187,'邵东县'),(1664,187,'新邵县'),(1665,187,'邵阳县'),(1666,187,'隆回县'),(1667,187,'洞口县'),(1668,187,'绥宁县'),(1669,187,'新宁县'),(1670,187,'城步苗族自治县'),(1671,187,'武冈市'),(1672,188,'岳阳楼区'),(1673,188,'云溪区'),(1674,188,'君山区'),(1675,188,'岳阳县'),(1676,188,'华容县'),(1677,188,'湘阴县'),(1678,188,'平江县'),(1679,188,'汨罗市'),(1680,188,'临湘市'),(1681,189,'武陵区'),(1682,189,'鼎城区'),(1683,189,'安乡县'),(1684,189,'汉寿县'),(1685,189,'澧县'),(1686,189,'临澧县'),(1687,189,'桃源县'),(1688,189,'石门县'),(1689,189,'津市市'),(1690,190,'永定区'),(1691,190,'武陵源区'),(1692,190,'慈利县'),(1693,190,'桑植县'),(1694,191,'资阳区'),(1695,191,'赫山区'),(1696,191,'南县'),(1697,191,'桃江县'),(1698,191,'安化县'),(1699,191,'沅江市'),(1700,192,'北湖区'),(1701,192,'苏仙区'),(1702,192,'桂阳县'),(1703,192,'宜章县'),(1704,192,'永兴县'),(1705,192,'嘉禾县'),(1706,192,'临武县'),(1707,192,'汝城县'),(1708,192,'桂东县'),(1709,192,'安仁县'),(1710,192,'资兴市'),(1711,193,'芝山区'),(1712,193,'冷水滩区'),(1713,193,'祁阳县'),(1714,193,'东安县'),(1715,193,'双牌县'),(1716,193,'道县'),(1717,193,'江永县'),(1718,193,'宁远县'),(1719,193,'蓝山县'),(1720,193,'新田县'),(1721,193,'江华瑶族自治县'),(1722,194,'鹤城区'),(1723,194,'中方县'),(1724,194,'沅陵县'),(1725,194,'辰溪县'),(1726,194,'溆浦县'),(1727,194,'会同县'),(1728,194,'麻阳苗族自治县'),(1729,194,'新晃侗族自治县'),(1730,194,'芷江侗族自治县'),(1731,194,'靖州苗族侗族自治县'),(1732,194,'通道侗族自治县'),(1733,194,'洪江市'),(1734,195,'娄星区'),(1735,195,'双峰县'),(1736,195,'新化县'),(1737,195,'冷水江市'),(1738,195,'涟源市'),(1739,196,'吉首市'),(1740,196,'泸溪县'),(1741,196,'凤凰县'),(1742,196,'花垣县'),(1743,196,'保靖县'),(1744,196,'古丈县'),(1745,196,'永顺县'),(1746,196,'龙山县'),(1747,197,'东山区'),(1748,197,'荔湾区'),(1749,197,'越秀区'),(1750,197,'海珠区'),(1751,197,'天河区'),(1752,197,'芳村区'),(1753,197,'白云区'),(1754,197,'黄埔区'),(1755,197,'番禺区'),(1756,197,'花都区'),(1757,197,'增城市'),(1758,197,'从化市'),(1759,198,'武江区'),(1760,198,'浈江区'),(1761,198,'曲江区'),(1762,198,'始兴县'),(1763,198,'仁化县'),(1764,198,'翁源县'),(1765,198,'乳源瑶族自治县'),(1766,198,'新丰县'),(1767,198,'乐昌市'),(1768,198,'南雄市'),(1769,199,'罗湖区'),(1770,199,'福田区'),(1771,199,'南山区'),(1772,199,'宝安区'),(1773,199,'龙岗区'),(1774,199,'盐田区'),(1775,200,'香洲区'),(1776,200,'斗门区'),(1777,200,'金湾区'),(1778,201,'龙湖区'),(1779,201,'金平区'),(1780,201,'濠江区'),(1781,201,'潮阳区'),(1782,201,'潮南区'),(1783,201,'澄海区'),(1784,201,'南澳县'),(1785,202,'禅城区'),(1786,202,'南海区'),(1787,202,'顺德区'),(1788,202,'三水区'),(1789,202,'高明区'),(1790,203,'蓬江区'),(1791,203,'江海区'),(1792,203,'新会区'),(1793,203,'台山市'),(1794,203,'开平市'),(1795,203,'鹤山市'),(1796,203,'恩平市'),(1797,204,'赤坎区'),(1798,204,'霞山区'),(1799,204,'坡头区'),(1800,204,'麻章区'),(1801,204,'遂溪县'),(1802,204,'徐闻县'),(1803,204,'廉江市'),(1804,204,'雷州市'),(1805,204,'吴川市'),(1806,205,'茂南区'),(1807,205,'茂港区'),(1808,205,'电白县'),(1809,205,'高州市'),(1810,205,'化州市'),(1811,205,'信宜市'),(1812,206,'端州区'),(1813,206,'鼎湖区'),(1814,206,'广宁县'),(1815,206,'怀集县'),(1816,206,'封开县'),(1817,206,'德庆县'),(1818,206,'高要市'),(1819,206,'四会市'),(1820,207,'惠城区'),(1821,207,'惠阳区'),(1822,207,'博罗县'),(1823,207,'惠东县'),(1824,207,'龙门县'),(1825,208,'梅江区'),(1826,208,'梅县'),(1827,208,'大埔县'),(1828,208,'丰顺县'),(1829,208,'五华县'),(1830,208,'平远县'),(1831,208,'蕉岭县'),(1832,208,'兴宁市'),(1833,209,'城区'),(1834,209,'海丰县'),(1835,209,'陆河县'),(1836,209,'陆丰市'),(1837,210,'源城区'),(1838,210,'紫金县'),(1839,210,'龙川县'),(1840,210,'连平县'),(1841,210,'和平县'),(1842,210,'东源县'),(1843,211,'江城区'),(1844,211,'阳西县'),(1845,211,'阳东县'),(1846,211,'阳春市'),(1847,212,'清城区'),(1848,212,'佛冈县'),(1849,212,'阳山县'),(1850,212,'连山壮族瑶族自治县'),(1851,212,'连南瑶族自治县'),(1852,212,'清新县'),(1853,212,'英德市'),(1854,212,'连州市'),(1855,215,'湘桥区'),(1856,215,'潮安县'),(1857,215,'饶平县'),(1858,216,'榕城区'),(1859,216,'揭东县'),(1860,216,'揭西县'),(1861,216,'惠来县'),(1862,216,'普宁市'),(1863,217,'云城区'),(1864,217,'新兴县'),(1865,217,'郁南县'),(1866,217,'云安县'),(1867,217,'罗定市'),(1868,218,'兴宁区'),(1869,218,'青秀区'),(1870,218,'江南区'),(1871,218,'西乡塘区'),(1872,218,'良庆区'),(1873,218,'邕宁区'),(1874,218,'武鸣县'),(1875,218,'隆安县'),(1876,218,'马山县'),(1877,218,'上林县'),(1878,218,'宾阳县'),(1879,218,'横县'),(1880,219,'城中区'),(1881,219,'鱼峰区'),(1882,219,'柳南区'),(1883,219,'柳北区'),(1884,219,'柳江县'),(1885,219,'柳城县'),(1886,219,'鹿寨县'),(1887,219,'融安县'),(1888,219,'融水苗族自治县'),(1889,219,'三江侗族自治县'),(1890,220,'秀峰区'),(1891,220,'叠彩区'),(1892,220,'象山区'),(1893,220,'七星区'),(1894,220,'雁山区'),(1895,220,'阳朔县'),(1896,220,'临桂县'),(1897,220,'灵川县'),(1898,220,'全州县'),(1899,220,'兴安县'),(1900,220,'永福县'),(1901,220,'灌阳县'),(1902,220,'龙胜各族自治县'),(1903,220,'资源县'),(1904,220,'平乐县'),(1905,220,'荔蒲县'),(1906,220,'恭城瑶族自治县'),(1907,221,'万秀区'),(1908,221,'蝶山区'),(1909,221,'长洲区'),(1910,221,'苍梧县'),(1911,221,'藤县'),(1912,221,'蒙山县'),(1913,221,'岑溪市'),(1914,222,'海城区'),(1915,222,'银海区'),(1916,222,'铁山港区'),(1917,222,'合浦县'),(1918,223,'港口区'),(1919,223,'防城区'),(1920,223,'上思县'),(1921,223,'东兴市'),(1922,224,'钦南区'),(1923,224,'钦北区'),(1924,224,'灵山县'),(1925,224,'浦北县'),(1926,225,'港北区'),(1927,225,'港南区'),(1928,225,'覃塘区'),(1929,225,'平南县'),(1930,225,'桂平市'),(1931,226,'玉州区'),(1932,226,'容县'),(1933,226,'陆川县'),(1934,226,'博白县'),(1935,226,'兴业县'),(1936,226,'北流市'),(1937,227,'右江区'),(1938,227,'田阳县'),(1939,227,'田东县'),(1940,227,'平果县'),(1941,227,'德保县'),(1942,227,'靖西县'),(1943,227,'那坡县'),(1944,227,'凌云县'),(1945,227,'乐业县'),(1946,227,'田林县'),(1947,227,'西林县'),(1948,227,'隆林各族自治县'),(1949,228,'八步区'),(1950,228,'昭平县'),(1951,228,'钟山县'),(1952,228,'富川瑶族自治县'),(1953,229,'金城江区'),(1954,229,'南丹县'),(1955,229,'天峨县'),(1956,229,'凤山县'),(1957,229,'东兰县'),(1958,229,'罗城仫佬族自治县'),(1959,229,'环江毛南族自治县'),(1960,229,'巴马瑶族自治县'),(1961,229,'都安瑶族自治县'),(1962,229,'大化瑶族自治县'),(1963,229,'宜州市'),(1964,230,'兴宾区'),(1965,230,'忻城县'),(1966,230,'象州县'),(1967,230,'武宣县'),(1968,230,'金秀瑶族自治县'),(1969,230,'合山市'),(1970,231,'江洲区'),(1971,231,'扶绥县'),(1972,231,'宁明县'),(1973,231,'龙州县'),(1974,231,'大新县'),(1975,231,'天等县'),(1976,231,'凭祥市'),(1977,232,'秀英区'),(1978,232,'龙华区'),(1979,232,'琼山区'),(1980,232,'美兰区'),(1981,233,'五指山市'),(1982,233,'琼海市'),(1983,233,'儋州市'),(1984,233,'文昌市'),(1985,233,'万宁市'),(1986,233,'东方市'),(1987,233,'定安县'),(1988,233,'屯昌县'),(1989,233,'澄迈县'),(1990,233,'临高县'),(1991,233,'白沙黎族自治县'),(1992,233,'昌江黎族自治县'),(1993,233,'乐东黎族自治县'),(1994,233,'陵水黎族自治县'),(1995,233,'保亭黎族苗族自治县'),(1996,233,'琼中黎族苗族自治县'),(1997,233,'西沙群岛'),(1998,233,'南沙群岛'),(1999,233,'中沙群岛的岛礁及其海域'),(2000,234,'万州区'),(2001,234,'涪陵区'),(2002,234,'渝中区'),(2003,234,'大渡口区'),(2004,234,'江北区'),(2005,234,'沙坪坝区'),(2006,234,'九龙坡区'),(2007,234,'南岸区'),(2008,234,'北碚区'),(2009,234,'万盛区'),(2010,234,'双桥区'),(2011,234,'渝北区'),(2012,234,'巴南区'),(2013,234,'黔江区'),(2014,234,'长寿区'),(2015,234,'綦江县'),(2016,234,'潼南县'),(2017,234,'铜梁县'),(2018,234,'大足县'),(2019,234,'荣昌县'),(2020,234,'璧山县'),(2021,234,'梁平县'),(2022,234,'城口县'),(2023,234,'丰都县'),(2024,234,'垫江县'),(2025,234,'武隆县'),(2026,234,'忠县'),(2027,234,'开县'),(2028,234,'云阳县'),(2029,234,'奉节县'),(2030,234,'巫山县'),(2031,234,'巫溪县'),(2032,234,'石柱土家族自治县'),(2033,234,'秀山土家族苗族自治县'),(2034,234,'酉阳土家族苗族自治县'),(2035,234,'彭水苗族土家族自治县'),(2036,234,'江津市'),(2037,234,'合川市'),(2038,234,'永川市'),(2039,234,'南川市'),(2040,235,'锦江区'),(2041,235,'青羊区'),(2042,235,'金牛区'),(2043,235,'武侯区'),(2044,235,'成华区'),(2045,235,'龙泉驿区'),(2046,235,'青白江区'),(2047,235,'新都区'),(2048,235,'温江区'),(2049,235,'金堂县'),(2050,235,'双流县'),(2051,235,'郫县'),(2052,235,'大邑县'),(2053,235,'蒲江县'),(2054,235,'新津县'),(2055,235,'都江堰市'),(2056,235,'彭州市'),(2057,235,'邛崃市'),(2058,235,'崇州市'),(2059,236,'自流井区'),(2060,236,'贡井区'),(2061,236,'大安区'),(2062,236,'沿滩区'),(2063,236,'荣县'),(2064,236,'富顺县'),(2065,237,'东区'),(2066,237,'西区'),(2067,237,'仁和区'),(2068,237,'米易县'),(2069,237,'盐边县'),(2070,238,'江阳区'),(2071,238,'纳溪区'),(2072,238,'龙马潭区'),(2073,238,'泸县'),(2074,238,'合江县'),(2075,238,'叙永县'),(2076,238,'古蔺县'),(2077,239,'旌阳区'),(2078,239,'中江县'),(2079,239,'罗江县'),(2080,239,'广汉市'),(2081,239,'什邡市'),(2082,239,'绵竹市'),(2083,240,'涪城区'),(2084,240,'游仙区'),(2085,240,'三台县'),(2086,240,'盐亭县'),(2087,240,'安县'),(2088,240,'梓潼县'),(2089,240,'北川羌族自治县'),(2090,240,'平武县'),(2091,240,'江油市'),(2092,241,'市中区'),(2093,241,'元坝区'),(2094,241,'朝天区'),(2095,241,'旺苍县'),(2096,241,'青川县'),(2097,241,'剑阁县'),(2098,241,'苍溪县'),(2099,242,'船山区'),(2100,242,'安居区'),(2101,242,'蓬溪县'),(2102,242,'射洪县'),(2103,242,'大英县'),(2104,243,'市中区'),(2105,243,'东兴区'),(2106,243,'威远县'),(2107,243,'资中县'),(2108,243,'隆昌县'),(2109,244,'市中区'),(2110,244,'沙湾区'),(2111,244,'五通桥区'),(2112,244,'金口河区'),(2113,244,'犍为县'),(2114,244,'井研县'),(2115,244,'夹江县'),(2116,244,'沐川县'),(2117,244,'峨边彝族自治县'),(2118,244,'马边彝族自治县'),(2119,244,'峨眉山市'),(2120,245,'顺庆区'),(2121,245,'高坪区'),(2122,245,'嘉陵区'),(2123,245,'南部县'),(2124,245,'营山县'),(2125,245,'蓬安县'),(2126,245,'仪陇县'),(2127,245,'西充县'),(2128,245,'阆中市'),(2129,246,'东坡区'),(2130,246,'仁寿县'),(2131,246,'彭山县'),(2132,246,'洪雅县'),(2133,246,'丹棱县'),(2134,246,'青神县'),(2135,247,'翠屏区'),(2136,247,'宜宾县'),(2137,247,'南溪县'),(2138,247,'江安县'),(2139,247,'长宁县'),(2140,247,'高县'),(2141,247,'珙县'),(2142,247,'筠连县'),(2143,247,'兴文县'),(2144,247,'屏山县'),(2145,248,'广安区'),(2146,248,'岳池县'),(2147,248,'武胜县'),(2148,248,'邻水县'),(2149,248,'华蓥市'),(2150,249,'通川区'),(2151,249,'达县'),(2152,249,'宣汉县'),(2153,249,'开江县'),(2154,249,'大竹县'),(2155,249,'渠县'),(2156,249,'万源市'),(2157,250,'雨城区'),(2158,250,'名山县'),(2159,250,'荥经县'),(2160,250,'汉源县'),(2161,250,'石棉县'),(2162,250,'天全县'),(2163,250,'芦山县'),(2164,250,'宝兴县'),(2165,251,'巴州区'),(2166,251,'通江县'),(2167,251,'南江县'),(2168,251,'平昌县'),(2169,252,'雁江区'),(2170,252,'安岳县'),(2171,252,'乐至县'),(2172,252,'简阳市'),(2173,253,'汶川县'),(2174,253,'理县'),(2175,253,'茂县'),(2176,253,'松潘县'),(2177,253,'九寨沟县'),(2178,253,'金川县'),(2179,253,'小金县'),(2180,253,'黑水县'),(2181,253,'马尔康县'),(2182,253,'壤塘县'),(2183,253,'阿坝县'),(2184,253,'若尔盖县'),(2185,253,'红原县'),(2186,254,'康定县'),(2187,254,'泸定县'),(2188,254,'丹巴县'),(2189,254,'九龙县'),(2190,254,'雅江县'),(2191,254,'道孚县'),(2192,254,'炉霍县'),(2193,254,'甘孜县'),(2194,254,'新龙县'),(2195,254,'德格县'),(2196,254,'白玉县'),(2197,254,'石渠县'),(2198,254,'色达县'),(2199,254,'理塘县'),(2200,254,'巴塘县'),(2201,254,'乡城县'),(2202,254,'稻城县'),(2203,254,'得荣县'),(2204,255,'西昌市'),(2205,255,'木里藏族自治县'),(2206,255,'盐源县'),(2207,255,'德昌县'),(2208,255,'会理县'),(2209,255,'会东县'),(2210,255,'宁南县'),(2211,255,'普格县'),(2212,255,'布拖县'),(2213,255,'金阳县'),(2214,255,'昭觉县'),(2215,255,'喜德县'),(2216,255,'冕宁县'),(2217,255,'越西县'),(2218,255,'甘洛县'),(2219,255,'美姑县'),(2220,255,'雷波县'),(2221,256,'南明区'),(2222,256,'云岩区'),(2223,256,'花溪区'),(2224,256,'乌当区'),(2225,256,'白云区'),(2226,256,'小河区'),(2227,256,'开阳县'),(2228,256,'息烽县'),(2229,256,'修文县'),(2230,256,'清镇市'),(2231,257,'钟山区'),(2232,257,'六枝特区'),(2233,257,'水城县'),(2234,257,'盘县'),(2235,258,'红花岗区'),(2236,258,'汇川区'),(2237,258,'遵义县'),(2238,258,'桐梓县'),(2239,258,'绥阳县'),(2240,258,'正安县'),(2241,258,'道真仡佬族苗族自治县'),(2242,258,'务川仡佬族苗族自治县'),(2243,258,'凤冈县'),(2244,258,'湄潭县'),(2245,258,'余庆县'),(2246,258,'习水县'),(2247,258,'赤水市'),(2248,258,'仁怀市'),(2249,259,'西秀区'),(2250,259,'平坝县'),(2251,259,'普定县'),(2252,259,'镇宁布依族苗族自治县'),(2253,259,'关岭布依族苗族自治县'),(2254,259,'紫云苗族布依族自治县'),(2255,260,'铜仁市'),(2256,260,'江口县'),(2257,260,'玉屏侗族自治县'),(2258,260,'石阡县'),(2259,260,'思南县'),(2260,260,'印江土家族苗族自治县'),(2261,260,'德江县'),(2262,260,'沿河土家族自治县'),(2263,260,'松桃苗族自治县'),(2264,260,'万山特区'),(2265,261,'兴义市'),(2266,261,'兴仁县'),(2267,261,'普安县'),(2268,261,'晴隆县'),(2269,261,'贞丰县'),(2270,261,'望谟县'),(2271,261,'册亨县'),(2272,261,'安龙县'),(2273,262,'毕节市'),(2274,262,'大方县'),(2275,262,'黔西县'),(2276,262,'金沙县'),(2277,262,'织金县'),(2278,262,'纳雍县'),(2279,262,'威宁彝族回族苗族自治县'),(2280,262,'赫章县'),(2281,263,'凯里市'),(2282,263,'黄平县'),(2283,263,'施秉县'),(2284,263,'三穗县'),(2285,263,'镇远县'),(2286,263,'岑巩县'),(2287,263,'天柱县'),(2288,263,'锦屏县'),(2289,263,'剑河县'),(2290,263,'台江县'),(2291,263,'黎平县'),(2292,263,'榕江县'),(2293,263,'从江县'),(2294,263,'雷山县'),(2295,263,'麻江县'),(2296,263,'丹寨县'),(2297,264,'都匀市'),(2298,264,'福泉市'),(2299,264,'荔波县'),(2300,264,'贵定县'),(2301,264,'瓮安县'),(2302,264,'独山县'),(2303,264,'平塘县'),(2304,264,'罗甸县'),(2305,264,'长顺县'),(2306,264,'龙里县'),(2307,264,'惠水县'),(2308,264,'三都水族自治县'),(2309,265,'五华区'),(2310,265,'盘龙区'),(2311,265,'官渡区'),(2312,265,'西山区'),(2313,265,'东川区'),(2314,265,'呈贡县'),(2315,265,'晋宁县'),(2316,265,'富民县'),(2317,265,'宜良县'),(2318,265,'石林彝族自治县'),(2319,265,'嵩明县'),(2320,265,'禄劝彝族苗族自治县'),(2321,265,'寻甸回族彝族自治县'),(2322,265,'安宁市'),(2323,266,'麒麟区'),(2324,266,'马龙县'),(2325,266,'陆良县'),(2326,266,'师宗县'),(2327,266,'罗平县'),(2328,266,'富源县'),(2329,266,'会泽县'),(2330,266,'沾益县'),(2331,266,'宣威市'),(2332,267,'红塔区'),(2333,267,'江川县'),(2334,267,'澄江县'),(2335,267,'通海县'),(2336,267,'华宁县'),(2337,267,'易门县'),(2338,267,'峨山彝族自治县'),(2339,267,'新平彝族傣族自治县'),(2340,267,'元江哈尼族彝族傣族自治县'),(2341,268,'隆阳区'),(2342,268,'施甸县'),(2343,268,'腾冲县'),(2344,268,'龙陵县'),(2345,268,'昌宁县'),(2346,269,'昭阳区'),(2347,269,'鲁甸县'),(2348,269,'巧家县'),(2349,269,'盐津县'),(2350,269,'大关县'),(2351,269,'永善县'),(2352,269,'绥江县'),(2353,269,'镇雄县'),(2354,269,'彝良县'),(2355,269,'威信县'),(2356,269,'水富县'),(2357,270,'古城区'),(2358,270,'玉龙纳西族自治县'),(2359,270,'永胜县'),(2360,270,'华坪县'),(2361,270,'宁蒗彝族自治县'),(2362,271,'翠云区'),(2363,271,'普洱哈尼族彝族自治县'),(2364,271,'墨江哈尼族自治县'),(2365,271,'景东彝族自治县'),(2366,271,'景谷傣族彝族自治县'),(2367,271,'镇沅彝族哈尼族拉祜族自治县'),(2368,271,'江城哈尼族彝族自治县'),(2369,271,'孟连傣族拉祜族佤族自治县'),(2370,271,'澜沧拉祜族自治县'),(2371,271,'西盟佤族自治县'),(2372,272,'临翔区'),(2373,272,'凤庆县'),(2374,272,'云县'),(2375,272,'永德县'),(2376,272,'镇康县'),(2377,272,'双江拉祜族佤族布朗族傣族自治县'),(2378,272,'耿马傣族佤族自治县'),(2379,272,'沧源佤族自治县'),(2380,273,'楚雄市'),(2381,273,'双柏县'),(2382,273,'牟定县'),(2383,273,'南华县'),(2384,273,'姚安县'),(2385,273,'大姚县'),(2386,273,'永仁县'),(2387,273,'元谋县'),(2388,273,'武定县'),(2389,273,'禄丰县'),(2390,274,'个旧市'),(2391,274,'开远市'),(2392,274,'蒙自县'),(2393,274,'屏边苗族自治县'),(2394,274,'建水县'),(2395,274,'石屏县'),(2396,274,'弥勒县'),(2397,274,'泸西县'),(2398,274,'元阳县'),(2399,274,'红河县'),(2400,274,'金平苗族瑶族傣族自治县'),(2401,274,'绿春县'),(2402,274,'河口瑶族自治县'),(2403,275,'文山县'),(2404,275,'砚山县'),(2405,275,'西畴县'),(2406,275,'麻栗坡县'),(2407,275,'马关县'),(2408,275,'丘北县'),(2409,275,'广南县'),(2410,275,'富宁县'),(2411,276,'景洪市'),(2412,276,'勐海县'),(2413,276,'勐腊县'),(2414,277,'大理市'),(2415,277,'漾濞彝族自治县'),(2416,277,'祥云县'),(2417,277,'宾川县'),(2418,277,'弥渡县'),(2419,277,'南涧彝族自治县'),(2420,277,'巍山彝族回族自治县'),(2421,277,'永平县'),(2422,277,'云龙县'),(2423,277,'洱源县'),(2424,277,'剑川县'),(2425,277,'鹤庆县'),(2426,278,'瑞丽市'),(2427,278,'潞西市'),(2428,278,'梁河县'),(2429,278,'盈江县'),(2430,278,'陇川县'),(2431,279,'泸水县'),(2432,279,'福贡县'),(2433,279,'贡山独龙族怒族自治县'),(2434,279,'兰坪白族普米族自治县'),(2435,280,'香格里拉县'),(2436,280,'德钦县'),(2437,280,'维西傈僳族自治县'),(2438,281,'城关区'),(2439,281,'林周县'),(2440,281,'当雄县'),(2441,281,'尼木县'),(2442,281,'曲水县'),(2443,281,'堆龙德庆县'),(2444,281,'达孜县'),(2445,281,'墨竹工卡县'),(2446,282,'昌都县'),(2447,282,'江达县'),(2448,282,'贡觉县'),(2449,282,'类乌齐县'),(2450,282,'丁青县'),(2451,282,'察雅县'),(2452,282,'八宿县'),(2453,282,'左贡县'),(2454,282,'芒康县'),(2455,282,'洛隆县'),(2456,282,'边坝县'),(2457,283,'乃东县'),(2458,283,'扎囊县'),(2459,283,'贡嘎县'),(2460,283,'桑日县'),(2461,283,'琼结县'),(2462,283,'曲松县'),(2463,283,'措美县'),(2464,283,'洛扎县'),(2465,283,'加查县'),(2466,283,'隆子县'),(2467,283,'错那县'),(2468,283,'浪卡子县'),(2469,284,'日喀则市'),(2470,284,'南木林县'),(2471,284,'江孜县'),(2472,284,'定日县'),(2473,284,'萨迦县'),(2474,284,'拉孜县'),(2475,284,'昂仁县'),(2476,284,'谢通门县'),(2477,284,'白朗县'),(2478,284,'仁布县'),(2479,284,'康马县'),(2480,284,'定结县'),(2481,284,'仲巴县'),(2482,284,'亚东县'),(2483,284,'吉隆县'),(2484,284,'聂拉木县'),(2485,284,'萨嘎县'),(2486,284,'岗巴县'),(2487,285,'那曲县'),(2488,285,'嘉黎县'),(2489,285,'比如县'),(2490,285,'聂荣县'),(2491,285,'安多县'),(2492,285,'申扎县'),(2493,285,'索县'),(2494,285,'班戈县'),(2495,285,'巴青县'),(2496,285,'尼玛县'),(2497,286,'普兰县'),(2498,286,'札达县'),(2499,286,'噶尔县'),(2500,286,'日土县'),(2501,286,'革吉县'),(2502,286,'改则县'),(2503,286,'措勤县'),(2504,287,'林芝县'),(2505,287,'工布江达县'),(2506,287,'米林县'),(2507,287,'墨脱县'),(2508,287,'波密县'),(2509,287,'察隅县'),(2510,287,'朗县'),(2511,288,'新城区'),(2512,288,'碑林区'),(2513,288,'莲湖区'),(2514,288,'灞桥区'),(2515,288,'未央区'),(2516,288,'雁塔区'),(2517,288,'阎良区'),(2518,288,'临潼区'),(2519,288,'长安区'),(2520,288,'蓝田县'),(2521,288,'周至县'),(2522,288,'户县'),(2523,288,'高陵县'),(2524,289,'王益区'),(2525,289,'印台区'),(2526,289,'耀州区'),(2527,289,'宜君县'),(2528,290,'渭滨区'),(2529,290,'金台区'),(2530,290,'陈仓区'),(2531,290,'凤翔县'),(2532,290,'岐山县'),(2533,290,'扶风县'),(2534,290,'眉县'),(2535,290,'陇县'),(2536,290,'千阳县'),(2537,290,'麟游县'),(2538,290,'凤县'),(2539,290,'太白县'),(2540,291,'秦都区'),(2541,291,'杨凌区'),(2542,291,'渭城区'),(2543,291,'三原县'),(2544,291,'泾阳县'),(2545,291,'乾县'),(2546,291,'礼泉县'),(2547,291,'永寿县'),(2548,291,'彬县'),(2549,291,'长武县'),(2550,291,'旬邑县'),(2551,291,'淳化县'),(2552,291,'武功县'),(2553,291,'兴平市'),(2554,292,'临渭区'),(2555,292,'华县'),(2556,292,'潼关县'),(2557,292,'大荔县'),(2558,292,'合阳县'),(2559,292,'澄城县'),(2560,292,'蒲城县'),(2561,292,'白水县'),(2562,292,'富平县'),(2563,292,'韩城市'),(2564,292,'华阴市'),(2565,293,'宝塔区'),(2566,293,'延长县'),(2567,293,'延川县'),(2568,293,'子长县'),(2569,293,'安塞县'),(2570,293,'志丹县'),(2571,293,'吴旗县'),(2572,293,'甘泉县'),(2573,293,'富县'),(2574,293,'洛川县'),(2575,293,'宜川县'),(2576,293,'黄龙县'),(2577,293,'黄陵县'),(2578,294,'汉台区'),(2579,294,'南郑县'),(2580,294,'城固县'),(2581,294,'洋县'),(2582,294,'西乡县'),(2583,294,'勉县'),(2584,294,'宁强县'),(2585,294,'略阳县'),(2586,294,'镇巴县'),(2587,294,'留坝县'),(2588,294,'佛坪县'),(2589,295,'榆阳区'),(2590,295,'神木县'),(2591,295,'府谷县'),(2592,295,'横山县'),(2593,295,'靖边县'),(2594,295,'定边县'),(2595,295,'绥德县'),(2596,295,'米脂县'),(2597,295,'佳县'),(2598,295,'吴堡县'),(2599,295,'清涧县'),(2600,295,'子洲县'),(2601,296,'汉滨区'),(2602,296,'汉阴县'),(2603,296,'石泉县'),(2604,296,'宁陕县'),(2605,296,'紫阳县'),(2606,296,'岚皋县'),(2607,296,'平利县'),(2608,296,'镇坪县'),(2609,296,'旬阳县'),(2610,296,'白河县'),(2611,297,'商州区'),(2612,297,'洛南县'),(2613,297,'丹凤县'),(2614,297,'商南县'),(2615,297,'山阳县'),(2616,297,'镇安县'),(2617,297,'柞水县'),(2618,298,'城关区'),(2619,298,'七里河区'),(2620,298,'西固区'),(2621,298,'安宁区'),(2622,298,'红古区'),(2623,298,'永登县'),(2624,298,'皋兰县'),(2625,298,'榆中县'),(2626,300,'金川区'),(2627,300,'永昌县'),(2628,301,'白银区'),(2629,301,'平川区'),(2630,301,'靖远县'),(2631,301,'会宁县'),(2632,301,'景泰县'),(2633,302,'秦城区'),(2634,302,'北道区'),(2635,302,'清水县'),(2636,302,'秦安县'),(2637,302,'甘谷县'),(2638,302,'武山县'),(2639,302,'张家川回族自治县'),(2640,303,'凉州区'),(2641,303,'民勤县'),(2642,303,'古浪县'),(2643,303,'天祝藏族自治县'),(2644,304,'甘州区'),(2645,304,'肃南裕固族自治县'),(2646,304,'民乐县'),(2647,304,'临泽县'),(2648,304,'高台县'),(2649,304,'山丹县'),(2650,305,'崆峒区'),(2651,305,'泾川县'),(2652,305,'灵台县'),(2653,305,'崇信县'),(2654,305,'华亭县'),(2655,305,'庄浪县'),(2656,305,'静宁县'),(2657,306,'肃州区'),(2658,306,'金塔县'),(2659,306,'安西县'),(2660,306,'肃北蒙古族自治县'),(2661,306,'阿克塞哈萨克族自治县'),(2662,306,'玉门市'),(2663,306,'敦煌市'),(2664,307,'西峰区'),(2665,307,'庆城县'),(2666,307,'环县'),(2667,307,'华池县'),(2668,307,'合水县'),(2669,307,'正宁县'),(2670,307,'宁县'),(2671,307,'镇原县'),(2672,308,'安定区'),(2673,308,'通渭县'),(2674,308,'陇西县'),(2675,308,'渭源县'),(2676,308,'临洮县'),(2677,308,'漳县'),(2678,308,'岷县'),(2679,309,'武都区'),(2680,309,'成县'),(2681,309,'文县'),(2682,309,'宕昌县'),(2683,309,'康县'),(2684,309,'西和县'),(2685,309,'礼县'),(2686,309,'徽县'),(2687,309,'两当县'),(2688,310,'临夏市'),(2689,310,'临夏县'),(2690,310,'康乐县'),(2691,310,'永靖县'),(2692,310,'广河县'),(2693,310,'和政县'),(2694,310,'东乡族自治县'),(2695,310,'积石山保安族东乡族撒拉族自治县'),(2696,311,'合作市'),(2697,311,'临潭县'),(2698,311,'卓尼县'),(2699,311,'舟曲县'),(2700,311,'迭部县'),(2701,311,'玛曲县'),(2702,311,'碌曲县'),(2703,311,'夏河县'),(2704,312,'城东区'),(2705,312,'城中区'),(2706,312,'城西区'),(2707,312,'城北区'),(2708,312,'大通回族土族自治县'),(2709,312,'湟中县'),(2710,312,'湟源县'),(2711,313,'平安县'),(2712,313,'民和回族土族自治县'),(2713,313,'乐都县'),(2714,313,'互助土族自治县'),(2715,313,'化隆回族自治县'),(2716,313,'循化撒拉族自治县'),(2717,314,'门源回族自治县'),(2718,314,'祁连县'),(2719,314,'海晏县'),(2720,314,'刚察县'),(2721,315,'同仁县'),(2722,315,'尖扎县'),(2723,315,'泽库县'),(2724,315,'河南蒙古族自治县'),(2725,316,'共和县'),(2726,316,'同德县'),(2727,316,'贵德县'),(2728,316,'兴海县'),(2729,316,'贵南县'),(2730,317,'玛沁县'),(2731,317,'班玛县'),(2732,317,'甘德县'),(2733,317,'达日县'),(2734,317,'久治县'),(2735,317,'玛多县'),(2736,318,'玉树县'),(2737,318,'杂多县'),(2738,318,'称多县'),(2739,318,'治多县'),(2740,318,'囊谦县'),(2741,318,'曲麻莱县'),(2742,319,'格尔木市'),(2743,319,'德令哈市'),(2744,319,'乌兰县'),(2745,319,'都兰县'),(2746,319,'天峻县'),(2747,320,'兴庆区'),(2748,320,'西夏区'),(2749,320,'金凤区'),(2750,320,'永宁县'),(2751,320,'贺兰县'),(2752,320,'灵武市'),(2753,321,'大武口区'),(2754,321,'惠农区'),(2755,321,'平罗县'),(2756,322,'利通区'),(2757,322,'盐池县'),(2758,322,'同心县'),(2759,322,'青铜峡市'),(2760,323,'原州区'),(2761,323,'西吉县'),(2762,323,'隆德县'),(2763,323,'泾源县'),(2764,323,'彭阳县'),(2765,324,'沙坡头区'),(2766,324,'中宁县'),(2767,324,'海原县'),(2768,325,'天山区'),(2769,325,'沙依巴克区'),(2770,325,'新市区'),(2771,325,'水磨沟区'),(2772,325,'头屯河区'),(2773,325,'达坂城区'),(2774,325,'东山区'),(2775,325,'乌鲁木齐县'),(2776,326,'独山子区'),(2777,326,'克拉玛依区'),(2778,326,'白碱滩区'),(2779,326,'乌尔禾区'),(2780,327,'吐鲁番市'),(2781,327,'鄯善县'),(2782,327,'托克逊县'),(2783,328,'哈密市'),(2784,328,'巴里坤哈萨克自治县'),(2785,328,'伊吾县'),(2786,329,'昌吉市'),(2787,329,'阜康市'),(2788,329,'米泉市'),(2789,329,'呼图壁县'),(2790,329,'玛纳斯县'),(2791,329,'奇台县'),(2792,329,'吉木萨尔县'),(2793,329,'木垒哈萨克自治县'),(2794,330,'博乐市'),(2795,330,'精河县'),(2796,330,'温泉县'),(2797,331,'库尔勒市'),(2798,331,'轮台县'),(2799,331,'尉犁县'),(2800,331,'若羌县'),(2801,331,'且末县'),(2802,331,'焉耆回族自治县'),(2803,331,'和静县'),(2804,331,'和硕县'),(2805,331,'博湖县'),(2806,332,'阿克苏市'),(2807,332,'温宿县'),(2808,332,'库车县'),(2809,332,'沙雅县'),(2810,332,'新和县'),(2811,332,'拜城县'),(2812,332,'乌什县'),(2813,332,'阿瓦提县'),(2814,332,'柯坪县'),(2815,333,'阿图什市'),(2816,333,'阿克陶县'),(2817,333,'阿合奇县'),(2818,333,'乌恰县'),(2819,334,'喀什市'),(2820,334,'疏附县'),(2821,334,'疏勒县'),(2822,334,'英吉沙县'),(2823,334,'泽普县'),(2824,334,'莎车县'),(2825,334,'叶城县'),(2826,334,'麦盖提县'),(2827,334,'岳普湖县'),(2828,334,'伽师县'),(2829,334,'巴楚县'),(2830,334,'塔什库尔干塔吉克自治县'),(2831,335,'和田市'),(2832,335,'和田县'),(2833,335,'墨玉县'),(2834,335,'皮山县'),(2835,335,'洛浦县'),(2836,335,'策勒县'),(2837,335,'于田县'),(2838,335,'民丰县'),(2839,336,'伊宁市'),(2840,336,'奎屯市'),(2841,336,'伊宁县'),(2842,336,'察布查尔锡伯自治县'),(2843,336,'霍城县'),(2844,336,'巩留县'),(2845,336,'新源县'),(2846,336,'昭苏县'),(2847,336,'特克斯县'),(2848,336,'尼勒克县'),(2849,337,'塔城市'),(2850,337,'乌苏市'),(2851,337,'额敏县'),(2852,337,'沙湾县'),(2853,337,'托里县'),(2854,337,'裕民县'),(2855,337,'和布克赛尔蒙古自治县'),(2856,338,'阿勒泰市'),(2857,338,'布尔津县'),(2858,338,'富蕴县'),(2859,338,'福海县'),(2860,338,'哈巴河县'),(2861,338,'青河县'),(2862,338,'吉木乃县');

/*Table structure for table `product` */

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品表',
  `name` varchar(1000) DEFAULT NULL COMMENT '商品名称',
  `category_id` int(11) DEFAULT NULL COMMENT '商品分类',
  `price` decimal(8,2) DEFAULT NULL COMMENT '商品金额',
  `discount_price` decimal(8,2) DEFAULT '0.00' COMMENT '优惠价格； 大于 0 则有优惠，否则无优惠',
  `freight_price` decimal(8,2) DEFAULT '0.00' COMMENT '运费价格； 大于 0 则由买家支付，否则免运费',
  `payment_type` int(1) DEFAULT '0' COMMENT '0 余额支付',
  `quantity` int(11) DEFAULT NULL COMMENT '库存',
  `detail` text COMMENT '商品详情',
  `default_img` varchar(255) DEFAULT NULL COMMENT '商品默认展示图',
  `status` int(1) DEFAULT '1' COMMENT '是否上架 0 否 1 是',
  `hot` int(1) DEFAULT '0' COMMENT '是否是热门商品 0 否 1 是',
  `invisible` int(1) DEFAULT '0' COMMENT '是否删除 0 否 1 是',
  `create_time` datetime DEFAULT NULL COMMENT '商品创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `product` */

insert  into `product`(`id`,`name`,`category_id`,`price`,`discount_price`,`freight_price`,`payment_type`,`quantity`,`detail`,`default_img`,`status`,`hot`,`invisible`,`create_time`) values (2,'黑人牙膏q',2,'22.00','22.00','10.00',1,20,'<p>黑人牙膏，谁用谁知<img src=\"http://localhost:8099/ssm/imagesHwUI1476953911477_S.jpg\" title=\"\" alt=\"\"/><img src=\"http://localhost:8099/ssm/temp/1476954949677_S.png\" title=\"\" alt=\"\"/></p>','Ms\\Qz\\1476417883813.jpg',1,1,0,'2016-10-13 17:35:09'),(3,'潜艇',2,'1.00','1.00','0.00',1,1,'<p>123123</p>','A3\\Sp\\1476411071876.png',1,1,1,'2016-10-14 10:11:14'),(4,'遥控赛车',3,'111.00',NULL,'12.00',1,123,'<p>访问时访问非威风威风违反&nbsp;</p>','X1\\Yq\\1476417929895.jpg',1,1,0,'2016-10-14 12:05:36'),(5,'自行车',4,'1234.00',NULL,'1.00',1,12,'<p>的前雾灯去</p>','Vq\\wF\\1476426202439.jpg',1,1,0,'2016-10-14 14:23:25'),(6,'大炮',3,'34352.00','3.00','32.00',1,3,'<p>234</p>','FG\\Da\\1476426519774.jpeg',1,1,0,'2016-10-14 14:28:42'),(7,'手枪',5,'3432.00',NULL,'0.00',1,2345,'<p>3223二分2<img src=\"http://img.baidu.com/hi/jx2/j_0060.gif\"/></p>','pI\\RC\\1476426633095.jpeg',1,1,0,'2016-10-14 14:30:38'),(8,'qwe',3,'11.00',NULL,'11.00',1,11,'<p>121we1</p>','3f\\MC\\1476757748004.jpg',1,0,0,'2016-10-18 10:29:10');

/*Table structure for table `product_category` */

DROP TABLE IF EXISTS `product_category`;

CREATE TABLE `product_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品分类表',
  `name` varchar(1000) DEFAULT NULL COMMENT '分类名称',
  `icon` varchar(255) DEFAULT NULL COMMENT '分类图标',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `product_category` */

insert  into `product_category`(`id`,`name`,`icon`) values (2,'话费Q币','Jx/s4/1475203910224.png'),(3,'电子产品','Jx/s4/1475203910224.png'),(4,'生活用品','Jx/s4/1475203910224.png'),(5,'家用小电器','Jx/s4/1475203910224.png');

/*Table structure for table `product_comment` */

DROP TABLE IF EXISTS `product_comment`;

CREATE TABLE `product_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品评论表',
  `pid` int(11) DEFAULT NULL COMMENT '商品ID',
  `mid` int(11) DEFAULT NULL COMMENT '用户ID',
  `comment` text COMMENT '用户评论',
  `score` int(11) DEFAULT NULL COMMENT '用户评分',
  `name` varchar(255) DEFAULT NULL COMMENT '用户名称',
  `create_time` datetime DEFAULT NULL COMMENT '评论时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `product_comment` */

insert  into `product_comment`(`id`,`pid`,`mid`,`comment`,`score`,`name`,`create_time`) values (1,2,3,'111111111111111111',1,'1','2016-01-01 00:00:00'),(2,2,4,'222222222222222222222',2,'2','2016-01-02 00:00:00'),(3,2,5,'33333333333333333',3,'3','2016-01-03 00:00:00'),(4,2,6,'444444444444444',4,'4','2016-01-04 00:00:00'),(5,4,1,'qwe',5,'18380426135','2016-10-19 18:31:20');

/*Table structure for table `product_img` */

DROP TABLE IF EXISTS `product_img`;

CREATE TABLE `product_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品图片表',
  `pid` int(11) DEFAULT NULL COMMENT '商品ID',
  `img` varchar(255) DEFAULT NULL COMMENT '商品图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8;

/*Data for the table `product_img` */

insert  into `product_img`(`id`,`pid`,`img`) values (83,5,'Vq\\wF\\1476426202439.jpg'),(84,6,'FG\\Da\\1476426519774.jpeg'),(92,3,'A3\\Sp\\1476411071876.png'),(131,7,'pI\\RC\\1476426633095.jpeg'),(132,4,'X1\\Yq\\1476417929895.jpg'),(133,4,'tJ\\ww\\1476417931565.jpg'),(134,4,'Fj\\jT\\1476417933261.png'),(135,8,'3f\\MC\\1476757748004.jpg'),(151,2,'Ms\\Qz\\1476417883813.jpg'),(152,2,'Qe\\De\\1476410984424.png'),(153,2,'II\\xf\\1476410992045.jpg'),(154,2,'K5\\rb\\1476410989521.png'),(155,2,'Lz\\jZ\\1476410995469.jpg');

/*Table structure for table `province` */

DROP TABLE IF EXISTS `province`;

CREATE TABLE `province` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '省份表',
  `name` varchar(255) DEFAULT NULL COMMENT '省份名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

/*Data for the table `province` */

insert  into `province`(`id`,`name`) values (1,'直辖市'),(3,'河北省'),(4,'山西省'),(5,'内蒙古自治区'),(6,'辽宁省'),(7,'吉林省'),(8,'黑龙江省'),(10,'江苏省'),(11,'浙江省'),(12,'安徽省'),(13,'福建省'),(14,'江西省'),(15,'山东省'),(16,'河南省'),(17,'湖北省'),(18,'湖南省'),(19,'广东省'),(20,'广西壮族自治区'),(21,'海南省'),(23,'四川省'),(24,'贵州省'),(25,'云南省'),(26,'西藏自治区'),(27,'陕西省'),(28,'甘肃省'),(29,'青海省'),(30,'宁夏回族自治区'),(31,'新疆维吾尔自治区'),(32,'香港特别行政区'),(33,'澳门特别行政区'),(34,'台湾省');

/*Table structure for table `sys_menus` */

DROP TABLE IF EXISTS `sys_menus`;

CREATE TABLE `sys_menus` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单表',
  `name` varchar(20) DEFAULT NULL COMMENT '菜单名称',
  `parent_id` int(11) DEFAULT NULL COMMENT '上级菜单ID',
  `url` varchar(255) DEFAULT NULL COMMENT '菜单地址',
  `weight` int(11) DEFAULT NULL COMMENT '权重',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `level` int(1) DEFAULT NULL COMMENT '菜单级别',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='菜单表';

/*Data for the table `sys_menus` */

insert  into `sys_menus`(`id`,`name`,`parent_id`,`url`,`weight`,`icon`,`level`) values (1,'用户管理',0,NULL,1,'/assets/imgs/menu/member.png',1),(2,'管理员管理',0,NULL,2,'/assets/imgs/menu/account.png',1),(3,'管理员列表',2,'/admin/user/list',1,NULL,2),(4,'管理员新增',2,'/admin/user/add',2,NULL,2),(5,'商品管理',0,NULL,3,'/assets/imgs/menu/product.png',1),(6,'商品列表',5,'/admin/product/list',1,NULL,2),(7,'商品新增',5,'/admin/product/add',2,NULL,2),(8,'订单管理',0,NULL,4,'/assets/imgs/menu/order.png',1),(9,'订单列表',8,'/admin/order/list',1,NULL,2),(11,'用户列表',1,'/admin/member/list',1,NULL,2),(12,'公告管理',0,NULL,5,'/assets/imgs/menu/order.png',1),(13,'公告列表',12,'/admin/bulletin/index',1,NULL,2),(14,'公告新增',12,'/admin/bulletin/add',2,NULL,2);

/*Table structure for table `sys_roles` */

DROP TABLE IF EXISTS `sys_roles`;

CREATE TABLE `sys_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '角色名称',
  `code` varchar(50) NOT NULL COMMENT '角色名称代码',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `sys_roles` */

insert  into `sys_roles`(`id`,`name`,`code`) values (1,'超级管理员','SUPER_ADMIN'),(2,'管理员','ADMIN');

/*Table structure for table `sys_roles_menus` */

DROP TABLE IF EXISTS `sys_roles_menus`;

CREATE TABLE `sys_roles_menus` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` int(11) DEFAULT NULL COMMENT '角色ID',
  `menu_id` int(11) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `INDEX_SRM_rid_mid` (`role_id`,`menu_id`),
  KEY `FK_Reference_35` (`role_id`),
  KEY `FK_Reference_36` (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='角色菜单表';

/*Data for the table `sys_roles_menus` */

insert  into `sys_roles_menus`(`id`,`role_id`,`menu_id`) values (1,1,1),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(11,1,11),(12,1,12),(13,1,13),(14,1,14),(15,2,1),(16,2,11);

/*Table structure for table `sys_roles_users` */

DROP TABLE IF EXISTS `sys_roles_users`;

CREATE TABLE `sys_roles_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL COMMENT '角色ID',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户ID',
  PRIMARY KEY (`id`),
  KEY `fk_sru_role_id` (`role_id`),
  KEY `fk_sru_user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `sys_roles_users` */

insert  into `sys_roles_users`(`id`,`role_id`,`user_id`) values (1,1,1),(3,2,2);

/*Table structure for table `sys_users` */

DROP TABLE IF EXISTS `sys_users`;

CREATE TABLE `sys_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台用户表',
  `username` varchar(50) DEFAULT NULL COMMENT '用户登录名',
  `name` varchar(50) DEFAULT NULL COMMENT '用户名称',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '用户创建日期',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录日期',
  `last_login_ip` varchar(23) DEFAULT NULL COMMENT '最后登录IP',
  `enabled` int(1) DEFAULT '1' COMMENT '是否可用，1可用，0不可用',
  `head` varchar(255) DEFAULT NULL COMMENT '头像',
  `type` int(11) DEFAULT '2' COMMENT '账号类型:  1 管理员,  2 企业用户',
  `verify_code` varchar(10) DEFAULT NULL COMMENT '验证码',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=270 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `sys_users` */

insert  into `sys_users`(`id`,`username`,`name`,`password`,`create_time`,`last_login_time`,`last_login_ip`,`enabled`,`head`,`type`,`verify_code`) values (1,'admin','超级管理员','$2a$10$TeKfUiYucql6FBOkAtqLDuGylsEXX1tCExHMi/T81htqHXS7Qg.dS','2016-03-25 19:01:29','2015-05-28 12:54:59','127.0.0.1',1,'X1\\Yq\\1476417929895.jpg',1,'7732'),(2,'kqc','管理员','$2a$10$TeKfUiYucql6FBOkAtqLDuGylsEXX1tCExHMi/T81htqHXS7Qg.dS','2016-03-25 19:01:29','2015-05-28 12:54:59','127.0.0.1',1,'X1\\Yq\\1476417929895.jpg',2,'7732');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;