开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Ajax > 查看源码
ajax.sql
资源名称：Ajax.rar　[点击查看]
上传用户：shjgzm
上传日期：2017-08-31
资源大小：2757k
文件大小：572k
源码类别：

Ajax

开发平台：

Java

ajax.sql：源码内容
  1.   `col` int(11) NOT NULL,
  2.   PRIMARY KEY  (`id`)
  3. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='9.2';
  5. --
  6. -- Dumping data for table `portal`
  7. --
  9. LOCK TABLES `portal` WRITE;
  10. /*!40000 ALTER TABLE `portal` DISABLE KEYS */;
  11. INSERT INTO `portal` VALUES (1,'模块1',80,1,1),(2,'模块2',150,2,1),(3,'模块3',80,3,1),(4,'模块4',150,4,2),(5,'模块5',80,5,2),(6,'模块6',80,6,2),(7,'模块7',80,7,3),(8,'模块8',80,8,3),(9,'模块9',150,9,3);
  12. /*!40000 ALTER TABLE `portal` ENABLE KEYS */;
  13. UNLOCK TABLES;
  15. --
  16. -- Table structure for table `postalcode`
  17. --
  19. DROP TABLE IF EXISTS `postalcode`;
  20. CREATE TABLE `postalcode` (
  21.   `id` int(11) NOT NULL auto_increment,
  22.   `area` varchar(255) NOT NULL,
  23.   `city` varchar(255) NOT NULL,
  24.   `code` varchar(6) NOT NULL,
  25.   PRIMARY KEY  (`id`)
  26. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='1.2';
  28. --
  29. -- Dumping data for table `postalcode`
  30. --
  32. LOCK TABLES `postalcode` WRITE;
  33. /*!40000 ALTER TABLE `postalcode` DISABLE KEYS */;
  34. INSERT INTO `postalcode` VALUES (1,'北京','北京','100000'),(2,'北京','通县','101100'),(3,'北京','昌平','102200'),(4,'北京','大兴','102600'),(5,'北京','密云','101500'),(6,'北京','延庆','102100'),(7,'北京','顺义','101300'),(8,'北京','怀柔','101400'),(9,'北京','平台','101200'),(10,'上海','上海','200000'),(11,'上海','上海县','201100'),(12,'上海','嘉定','201800'),(13,'上海','松江','201600'),(14,'上海','南汇','201300'),(15,'上海','奉贤','201400'),(16,'上海','川沙','201200'),(17,'上海','青浦','201700'),(18,'上海','崇明','202100'),(19,'上海','金山','201500'),(20,'天津','天津','300000'),(21,'天津','蓟县','301900'),(22,'天津','宝坻','301800'),(23,'天津','武清','301700'),(24,'天津','静海','301600'),(25,'天津','宁河','301500'),(26,'重庆','万县','404000'),(27,'重庆','永川','402000'),(28,'重庆','北碚','400700'),(29,'重庆','巴县','401320'),(30,'重庆','江北','401120'),(31,'重庆','重庆','400000'),(32,'重庆','涪陵','408000'),(33,'重庆','石柱','409100'),(34,'重庆','丰都','408200'),(35,'重庆','南川','408400'),(36,'重庆','城口','405900'),(37,'重庆','巫溪','405800'),(38,'重庆','奉节','404600'),(39,'重庆','云阳','404500'),(40,'重庆','忠县','404300'),(41,'重庆','梁平','405200'),(42,'重庆','开县','405400'),(43,'重庆','大足','402360'),(44,'重庆','荣昌','402460'),(45,'重庆','壁山','402760'),(46,'重庆','铜梁','402560'),(47,'重庆','潼南','402660'),(48,'重庆','合川','401520'),(49,'重庆','江津','402260'),(50,'重庆','双桥','400900'),(51,'重庆','南桐','400800'),(52,'重庆','长寿','401220'),(53,'重庆','綦江','401420'),(54,'重庆','黔江','409700'),(55,'重庆','武隆','408500'),(56,'重庆','垫江','408300'),(57,'重庆','巫山','404700'),(58,'河北','石家庄','050000'),(59,'河北','获鹿','050200'),(60,'河北','正定','050800'),(61,'河北','栾城','051400'),(62,'河北','井陉','050300'),(63,'河北','元氏','051100'),(64,'河北','新乐','050700'),(65,'河北','无极','052400'),(66,'河北','深泽','052500'),(67,'河北','辛集','052300'),(68,'河北','晋州','052200'),(69,'河北','赵县','051500'),(70,'河北','赞皇','051200'),(71,'河北','高邑','051300'),(72,'河北','平山','050400'),(73,'河北','灵寿','050500'),(74,'河北','行唐','050600'),(75,'河北','保定','071000'),(76,'河北','潢城','072100'),(77,'河北','清苑','071100'),(78,'河北','涞水','074100'),(79,'河北','易县','074200'),(80,'河北','涞源','102900'),(81,'河北','唐县','072300'),(82,'河北','定兴','072600'),(83,'河北','涿州','072700'),(84,'河北','高碑店','074000'),(85,'河北','博野','071300'),(86,'河北','安国','071200'),(87,'河北','定州','073000'),(88,'河北','曲阳','073100'),(89,'河北','阜平','073200'),(90,'河北','高阳','071500'),(91,'河北','徐水','072500'),(92,'河北','容城','071700'),(93,'河北','雄县','071800'),(94,'河北','安新','071600'),(95,'河北','望都','072400'),(96,'河北','蠡县','071400'),(97,'河北','顺平','072200'),(98,'河北','张家口','075000'),(99,'河北','宣化','075100'),(100,'河北','怀安','076100'),(101,'河北','万全','076200'),(102,'河北','张北','076400'),(103,'河北','崇礼','076300'),(104,'河北','沽源','076500'),(105,'河北','尚义','076700'),(106,'河北','康保','076600'),(107,'河北','赤城','075500'),(108,'河北','怀来','075400'),(109,'河北','涿鹿','075600'),(110,'河北','蔚县','075700'),(111,'河北','阳原','075800'),(112,'河北','承德','067000'),(113,'河北','承德县','067400'),(114,'河北','兴隆','067300'),(115,'河北','隆化','068100'),(116,'河北','围场','068400'),(117,'河北','平泉','067500'),(118,'河北','宽城','067600'),(119,'河北','丰宁','068300'),(120,'河北','滦平','068200'),(121,'河北','唐山','063000'),(122,'河北','玉田','064100'),(123,'河北','滦县','063700'),(124,'河北','遵化','064200'),(125,'河北','滦南','063500'),(126,'河北','唐海','063200'),(127,'河北','丰南','063300'),(128,'河北','乐亭','063600'),(129,'河北','丰润','064000'),(130,'河北','迁安','064400'),(131,'河北','迁西','064300'),(132,'河北','廊坊','102800'),(133,'河北','霸州','065700'),(134,'河北','永清','302650'),(135,'河北','大城','302950'),(136,'河北','文安','302850'),(137,'河北','固安','102700'),(138,'河北','香河','302550'),(139,'河北','大厂','101700'),(140,'河北','三河','101600'),(141,'河北','沧州','061000'),(142,'河北','黄骅','061100'),(143,'河北','海兴','061200'),(144,'河北','盐山','061300'),(145,'河北','孟村','061400'),(146,'河北','青县','062600'),(147,'河北','南皮','061500'),(148,'河北','东光','061600'),(149,'河北','吴桥','061800'),(150,'河北','泊头','062100'),(151,'河北','河间','062400'),(152,'河北','肃宁','062300'),(153,'河北','任丘','062500'),(154,'河北','献县','062200'),(155,'河北','衡水','053000'),(156,'河北','铙阳','052700'),(157,'河北','武强','053300'),(158,'河北','武邑','053400'),(159,'河北','阜城','061700'),(160,'河北','景县','053500'),(161,'河北','故城','253800'),(162,'河北','枣强','053100'),(163,'河北','冀县','053200'),(164,'河北','深州','052800'),(165,'河北','安平','052600'),(166,'河北','邢台','054000'),(167,'河北','临西','057800'),(168,'河北','内丘','054200'),(169,'河北','临城','054300'),(170,'河北','柏乡','055400'),(171,'河北','宁晋','051600'),(172,'河北','隆尧','055300'),(173,'河北','巨鹿','055200'),(174,'河北','新河','051700'),(175,'河北','南宫','051800'),(176,'河北','清河','054800'),(177,'河北','威县','054700'),(178,'河北','广宗','054600'),(179,'河北','平乡','054500'),(180,'河北','南和','054400'),(181,'河北','任县','055100'),(182,'河北','沙河','054100'),(183,'河北','邯郸','056000'),(184,'河北','武安','056300'),(185,'河北','临漳','056600'),(186,'河北','磁县','056500'),(187,'河北','涉县','056400'),(188,'河北','成安','056700'),(189,'河北','永年','057100'),(190,'河北','鸡泽','057300'),(191,'河北','曲周','057200'),(192,'河北','丘县','057400'),(193,'河北','馆陶','057700'),(194,'河北','大名','056900'),(195,'河北','魏县','056800'),(196,'河北','广平','057600'),(197,'河北','肥乡','057500'),(198,'河北','秦皇岛','066000'),(199,'河北','昌黎','066600'),(200,'河北','卢龙','066400'),(201,'河北','抚宁','066300'),(202,'河北','青龙','066500'),(203,'山西','朔州','038500'),(204,'山西','怀仁','038300'),(205,'山西','应县','037600'),(206,'山西','右玉','037200'),(207,'山西','山阴','038400'),(208,'山西','忻州','034000'),(209,'山西','原平','034100'),(210,'山西','定襄','035400'),(211,'山西','五台','035500'),(212,'山西','代县','034200'),(213,'山西','繁峙','034300'),(214,'山西','宁武','036000'),(215,'山西','神池','036100'),(216,'山西','五寨','036200'),(217,'山西','岢岚','036300'),(218,'山西','河曲','036500'),(219,'山西','保德','036600'),(220,'山西','偏关','036400'),(221,'山西','静乐','035100'),(222,'山西','太原','030000'),(223,'山西','阳曲','030100'),(224,'山西','娄烦','030300'),(225,'山西','清徐','030400'),(226,'山西','古交','030200'),(227,'山西','大同','037000'),(228,'山西','大同县','037300'),(229,'山西','天镇','038200'),(230,'山西','阳高','038100'),(231,'山西','浑源','037400'),(233,'山西','灵丘','034400'),(234,'山西','左云','037100'),(235,'山西','孟县','045100'),(236,'山西','平定','045200'),(237,'山西','榆次','030600'),(238,'山西','灵石','031300'),(239,'山西','昔阳','045300'),(240,'山西','和顺','032700'),(241,'山西','左权','032600'),(242,'山西','榆社','031800'),(243,'山西','寿阳','031700'),(244,'山西','太谷','030800'),(245,'山西','祁县','030900'),(246,'山西','平遥','031100'),(247,'山西','介休','031200'),(248,'山西','长治','046000'),(249,'山西','长治县','047100'),(250,'山西','壶关','047300'),(251,'山西','平顺','047400'),(252,'山西','黎城','047600'),(253,'山西','襄坦','046200'),(254,'山西','武乡','046300'),(255,'山西','沁县','046400'),(256,'山西','沁源','046500'),(257,'山西','屯留','046100'),(258,'山西','长子','046600'),(259,'山西','潞城','047500'),(260,'山西','晋城','048000'),(261,'山西','高平','046700'),(262,'山西','阳城','048100'),(263,'山西','沁水','048200'),(264,'山西','陵川','048300'),(265,'山西','临汾','041000'),(266,'山西','候马','043000'),(267,'山西','大宁','042300'),(268,'山西','曲沃','043400'),(269,'山西','翼城','043500'),(270,'山西','襄汾','041500'),(271,'山西','洪洞','031600'),(272,'山西','霍州','031400'),(273,'山西','汾西','031500'),(274,'山西','蒲县','041200'),(275,'山西','隰县','041300'),(276,'山西','永和','041400'),(277,'山西','乡宁','042100'),(278,'山西','吉县','042200'),(279,'山西','安泽','042500'),(280,'山西','浮山','042600'),(281,'山西','古县','042400'),(282,'山西','离石','033000'),(283,'山西','石楼','032500'),(284,'山西','方山','033100'),(285,'山西','临县','033200'),(287,'山西','文水','032100'),(288,'山西','交城','030500'),(289,'山西','孝义','032300'),(290,'山西','交口','032400'),(291,'山西','中阳','033400'),(292,'山西','柳林','033300'),(293,'山西','兴县','035300'),(294,'山西','岚县','035200'),(295,'山西','运城','044000'),(296,'山西','芮城','044600'),(297,'山西','平陆','044300'),(298,'山西','临猗','044100'),(299,'山西','万荣','044200'),(300,'山西','稷山','043200'),(301,'山西','河津','043300'),(302,'山西','新绛','043100'),(303,'山西','闻喜','043800'),(304,'山西','夏县','044400'),(305,'山西','永剂','044500'),(306,'山西','绛县','043600'),(307,'山西','垣曲','043700'),(308,'河南','商丘','476000'),(309,'河南','商丘县','476100'),(310,'河南','虞城','476300'),(311,'河南','夏邑','476400'),(312,'河南','永城','476600'),(313,'河南','柘城','476200'),(314,'河南','宁陵','476700'),(315,'河南','睢县','476900'),(316,'河南','民权','476800'),(317,'河南','郑州','450000'),(318,'河南','上街','451000'),(319,'河南','荥阳','450100'),(320,'河南','新郑','451100'),(321,'河南','中牟','451400'),(322,'河南','新密','452300'),(323,'河南','登封','452400'),(324,'河南','巩县','451200'),(325,'河南','安阳','455000'),(326,'河南','安阳县','455100'),(327,'河南','汤阴','456100'),(328,'河南','林县','456500'),(329,'河南','内黄','456300'),(330,'河南','滑县','456400'),(331,'河南','新乡','453700'),(332,'河南','卫辉','453100'),(333,'河南','延津','453200'),(334,'河南','原阳','453500'),(335,'河南','获嘉','453800'),(336,'河南','长垣','453400'),(337,'河南','封丘','453300'),(338,'河南','辉县','453600'),(339,'河南','许昌','461000'),(340,'河南','长葛','461500'),(341,'河南','鄢陵','461200'),(342,'河南','禹州','452500'),(343,'河南','平顶山','467000'),(344,'河南','舞钢','462500'),(345,'河南','郏县','467100'),(346,'河南','襄城','452600'),(347,'河南','叶县','467200'),(348,'河南','鲁山','467300'),(349,'河南','宝丰','467400'),(350,'河南','汝州','467500'),(351,'河南','信阳','464000'),(352,'河南','信阳县','464100'),(353,'河南','罗山','464200'),(354,'河南','卧龙','473000'),(355,'河南','宛城','473100'),(356,'河南','邓州','474100'),(357,'河南','西峡','474500'),(358,'河南','浙川','474400'),(359,'河南','方城','473200'),(360,'河南','社旗','473300'),(361,'河南','唐河','473400'),(362,'河南','新野','473500'),(363,'河南','镇平','474200'),(364,'河南','南召','474600'),(365,'河南','桐柏','474700'),(366,'河南','内乡','474300'),(367,'河南','开封','475000'),(368,'河南','开封县','475100'),(369,'河南','兰考','475300'),(370,'河南','杞县','475200'),(371,'河南','通许','452200'),(372,'河南','尉氏','452100'),(373,'河南','洛阳','471000'),(374,'河南','洛宁','471700'),(375,'河南','孟津','471100'),(376,'河南','偃师','471900'),(377,'河南','伊川','471300'),(378,'河南','宜阳','471600'),(379,'河南','新安','471800'),(380,'河南','汝阳','471200'),(381,'河南','嵩县','471400'),(382,'河南','栾川','471500'),(383,'河南','焦作','454100'),(384,'河南','修武','454300'),(385,'河南','武陟','454900'),(386,'河南','温县','454800'),(387,'河南','孟县','454700'),(388,'河南','博爱','454400'),(389,'河南','沁阳','454500'),(390,'河南','济源','454600'),(391,'河南','鹤壁','456600'),(392,'河南','浚县','456200'),(393,'河南','淇县','456700'),(394,'河南','濮阳','457000'),(395,'河南','濮阳县','457002'),(396,'河南','台前','457600'),(397,'河南','范县','457500'),(398,'河南','南乐','457400'),(399,'河南','清丰','457300'),(400,'河南','周口','466000'),(401,'河南','西华','466600'),(402,'河南','淮阳','466700'),(403,'河南','郸城','477100'),(404,'河南','鹿邑','477200'),(405,'河南','沈丘','466300'),(406,'河南','项城','466200'),(407,'河南','扶沟','461300'),(408,'河南','太康','475400'),(409,'河南','商水','466100'),(410,'河南','漯河','462000'),(411,'河南','临颖','462600'),(412,'河南','舞阳','462400'),(413,'河南','郾城','462300'),(414,'河南','驻马店','463000'),(415,'河南','泌阳','463700'),(416,'河南','遂平','463100'),(417,'河南','汝南','463300'),(418,'河南','确山','463200'),(419,'河南','西平','462100'),(420,'河南','上蔡','463800'),(421,'河南','平舆','463400'),(422,'河南','新蔡','463500'),(423,'河南','正阳','463600'),(424,'河南','潢川','465100'),(425,'河南','光山','465400'),(426,'河南','新县','465500'),(427,'河南','淮滨','464400'),(428,'河南','固始','465200'),(429,'河南','商城','465300'),(430,'河南','息县','464300'),(431,'河南','三门峡','472000'),(432,'河南','卢氏','472200'),(433,'河南','渑池','472400'),(434,'河南','义马','472300'),(435,'河南','灵宝','472500'),(436,'河南','陕县','472100'),(437,'辽宁','沈阳','110000'),(438,'辽宁','新民','110300'),(439,'辽宁','辽中','110200'),(440,'辽宁','康平','112200'),(441,'辽宁','法库','112100'),(442,'辽宁','铁岭','112000'),(443,'辽宁','铁岭县','112600'),(444,'辽宁','昌图','112500'),(445,'辽宁','开原','112300'),(446,'辽宁','西丰','112400'),(447,'辽宁','铁法','112700'),(448,'辽宁','大连','116000'),(449,'辽宁','庄河','116400'),(450,'辽宁','长海','116500'),(451,'辽宁','瓦房店','116300'),(452,'辽宁','普兰店','116600'),(453,'辽宁','金县','116100'),(454,'辽宁','新金','116200'),(455,'辽宁','鞍山','114000'),(456,'辽宁','海城','114200'),(457,'辽宁','台安','114100'),(458,'辽宁','岫岩','114300'),(459,'辽宁','抚顺','113000'),(460,'辽宁','抚顺县','113100'),(461,'辽宁','清原','113300'),(462,'辽宁','新宾','113200'),(463,'辽宁','本溪','117000'),(464,'辽宁','本溪县','117100'),(465,'辽宁','桓仁','117200'),(466,'辽宁','丹东','118000'),(467,'辽宁','东港','118300'),(468,'辽宁','凤城','118100'),(469,'辽宁','宽甸','118200'),(470,'辽宁','锦州','121000'),(471,'辽宁','凌海','121200'),(472,'辽宁','黑山','121400'),(473,'辽宁','义县','121100'),(474,'辽宁','北宁','121300'),(475,'辽宁','营口','115000'),(476,'辽宁','盖州','115200'),(477,'辽宁','大石桥','115100'),(478,'辽宁','阜新','123000'),(479,'辽宁','阜新县','123100'),(480,'辽宁','彰武','123200'),(481,'辽宁','辽阳','111000'),(482,'辽宁','辽阳县','111200'),(483,'辽宁','灯塔','111300'),(484,'辽宁','朝阳','122000'),(485,'辽宁','朝阳县','122600'),(486,'辽宁','建平','122400'),(487,'辽宁','北票','122100'),(488,'辽宁','凌源','122500'),(489,'辽宁','喀喇沁左翼','122300'),(490,'辽宁','盘锦','124000'),(491,'辽宁','盘山','124100'),(492,'辽宁','大洼','124200'),(493,'辽宁','葫芦岛','121500'),(494,'辽宁','绥中','121700'),(495,'辽宁','建昌','122200'),(496,'辽宁','兴城','121600'),(497,'吉林','长春','130000'),(498,'吉林','双阳','130600'),(499,'吉林','农安','130200'),(500,'吉林','九台','130500'),(501,'吉林','德惠','130300'),(502,'吉林','榆树','130400'),(503,'吉林','吉林','132000'),(504,'吉林','永吉','132200'),(505,'吉林','磬石','132300'),(506,'吉林','桦甸','132400'),(507,'吉林','蛟河','132500'),(508,'吉林','舒兰','132600'),(509,'吉林','延吉','133000'),(510,'吉林','汪清','133200'),(511,'吉林','和龙','133500'),(512,'吉林','安图','133600'),(513,'吉林','敦化','133700'),(514,'吉林','图们','133100'),(515,'吉林','龙井','133400'),(516,'吉林','四平','136000'),(517,'吉林','双辽','136400'),(518,'吉林','犁树','136500'),(519,'吉林','公主岭','136100'),(520,'吉林','通化','134000'),(521,'吉林','通化县','134100'),(522,'吉林','集安','134200'),(523,'吉林','白城','137000'),(524,'吉林','通榆','137200'),(525,'吉林','大安','131300'),(526,'吉林','洮南','137100'),(527,'吉林','镇赉','137300'),(528,'吉林','辽源','136200'),(529,'吉林','东辽','136600'),(530,'吉林','东丰','136300'),(531,'吉林','松原','131000'),(532,'吉林','扶余','131200'),(533,'吉林','前郭','131100'),(534,'吉林','长岭','131500'),(535,'吉林','乾安','131400'),(537,'吉林','靖宇','135200'),(538,'吉林','长白','134400'),(539,'吉林','抚松','134500'),(540,'吉林','江源','134300'),(541,'吉林','珲春','133300'),(542,'吉林','梅河口','135000'),(543,'吉林','柳河','135300'),(544,'吉林','辉南','135100'),(545,'黑龙江','哈尔滨','150000'),(546,'黑龙江','阿城','150300'),(547,'黑龙江','通河','150900'),(548,'黑龙江','方正','150800'),(549,'黑龙江','尚志','150600'),(550,'黑龙江','延寿','150700'),(551,'黑龙江','双成','150100'),(552,'黑龙江','肇东','151100'),(553,'黑龙江','宾县','150400'),(554,'黑龙江','木兰','151900'),(555,'黑龙江','五常','150200'),(556,'黑龙江','巴彦','151800'),(557,'黑龙江','呼兰','150500'),(558,'黑龙江','齐齐哈尔','161000'),(559,'黑龙江','克山','161600'),(560,'黑龙江','拜泉','161700'),(561,'黑龙江','依安','161500'),(562,'黑龙江','龙江','161100'),(563,'黑龙江','讷河','161300'),(564,'黑龙江','甘南','162100'),(565,'黑龙江','富裕','161200'),(566,'黑龙江','克东','161800'),(567,'黑龙江','泰来','162400'),(568,'黑龙江','牡丹江','157000'),(569,'黑龙江','林口','157600'),(570,'黑龙江','穆棱','157500'),(571,'黑龙江','东宁','157200'),(572,'黑龙江','海林','157100'),(573,'黑龙江','宁安','157400'),(574,'黑龙江','绥芬河','157300'),(575,'黑龙江','虎林','158400'),(576,'黑龙江','鸡西','158100'),(577,'黑龙江','鸡东','158200'),(578,'黑龙江','密山','158300'),(579,'黑龙江','七台河','154600'),(580,'黑龙江','勃利','154500'),(581,'黑龙江','佳木斯','154000'),(582,'黑龙江','依兰','154800'),(583,'黑龙江','汤原','154700'),(584,'黑龙江','桦南','154400'),(585,'黑龙江','富锦','156100'),(586,'黑龙江','抚远','156500'),(587,'黑龙江','同江','156400'),(588,'黑龙江','桦川','154300'),(589,'黑龙江','饶河','156700'),(590,'黑龙江','萝北','154200'),(591,'黑龙江','鹤岗','154100'),(592,'黑龙江','绥滨','156200'),(593,'黑龙江','双鸭山','155100'),(594,'黑龙江','友谊','156900'),(595,'黑龙江','宝清','156600'),(596,'黑龙江','集贤','154900'),(597,'黑龙江','绥化','152000'),(598,'黑龙江','明水','151700'),(599,'黑龙江','庆安','152400'),(600,'黑龙江','海伦','152300'),(601,'黑龙江','绥棱','152200'),(602,'黑龙江','望奎','152100'),(603,'黑龙江','兰西','151500'),(604,'黑龙江','青冈','151600'),(605,'黑龙江','黑河','164300'),(606,'黑龙江','北安','164000'),(607,'黑龙江','孙吴','164200'),(608,'黑龙江','逊克','164400'),(609,'黑龙江','德都','164100'),(610,'黑龙江','嫩江','161400'),(611,'黑龙江','五大连池','164500'),(612,'黑龙江','加格达奇','165000'),(613,'黑龙江','塔河','165200'),(614,'黑龙江','呼玛','165100'),(615,'黑龙江','漠河','165300'),(616,'黑龙江','伊春','153000'),(617,'黑龙江','嘉荫','153200'),(618,'黑龙江','铁力','152500'),(619,'黑龙江','大庆','163000'),(620,'黑龙江','林甸','162300'),(621,'黑龙江','安达','151400'),(622,'黑龙江','肇州','151200'),(623,'黑龙江','杜尔伯特','162000'),(624,'黑龙江','肇源','151300'),(625,'内蒙古','海拉尔','021000'),(626,'内蒙古','鄂温克','021100'),(627,'内蒙古','阿荣旗','162750'),(628,'内蒙古','牙克石','022100'),(629,'内蒙古','扎兰屯','162650'),(630,'内蒙古','鄂伦春','022400'),(631,'内蒙古','陈巴尔虎旗','021500'),(632,'内蒙古','新巴尔虎左旗','021200'),(633,'内蒙古','新巴尔虎右旗','021300'),(634,'内蒙古','根河','022300'),(635,'内蒙古','额尔古纳右旗','022200'),(636,'内蒙古','莫力达瓦旗','162800'),(637,'内蒙古','满洲里','021400'),(638,'内蒙古','呼和浩特','010000'),(639,'内蒙古','托克托','010200'),(640,'内蒙古','土默特左旗','010100'),(641,'内蒙古','和林格尔','011500'),(642,'内蒙古','武川','011700'),(643,'内蒙古','清水河','011600'),(644,'内蒙古','鄂托克前旗','016200'),(645,'内蒙古','包头','014000'),(646,'内蒙古','固阳','014200'),(647,'内蒙古','土默特右旗','014100'),(648,'内蒙古','白云鄂博','014080'),(650,'内蒙古','乌海','016000'),(651,'内蒙古','集宁','012000'),(652,'内蒙古','四子王旗','011800'),(653,'内蒙古','化德','013300'),(654,'内蒙古','丰镇','012100'),(655,'内蒙古','卓资','012300'),(656,'内蒙古','商都','013400'),(657,'内蒙古','兴和','013600'),(658,'内蒙古','凉城','013700'),(659,'内蒙古','察哈尔右翼前旗','012200'),(660,'内蒙古','察哈尔右翼中旗','013500'),(661,'内蒙古','察哈尔右翼后旗','012400'),(662,'内蒙古','通辽','028000'),(663,'内蒙古','开鲁','028400'),(664,'内蒙古','库伦旗','028200'),(665,'内蒙古','奈曼旗','028300'),(666,'内蒙古','扎鲁特旗','029100'),(667,'内蒙古','科尔沁左翼中旗','029300'),(668,'内蒙古','科尔沁左翼后旗','028100'),(669,'内蒙古','霍林郭勒','029200'),(670,'内蒙古','赤峰','024000'),(671,'内蒙古','阿鲁科尔沁','025500'),(672,'内蒙古','宁城','024200'),(673,'内蒙古','敖汉旗','024300'),(674,'内蒙古','翁牛特旗','024500'),(675,'内蒙古','巴林左旗','025400'),(676,'内蒙古','巴林右旗','025100'),(677,'内蒙古','林西','025200'),(678,'内蒙古','克什克腾旗','025300'),(679,'内蒙古','喀喇沁旗','024400'),(680,'内蒙古','东胜','017000'),(681,'内蒙古','达拉特旗','014300'),(682,'内蒙古','伊金霍洛旗','017200'),(683,'内蒙古','准格尔旗','017100'),(684,'内蒙古','杭棉旗','017400'),(685,'内蒙古','乌审','017300'),(686,'内蒙古','鄂托克旗','016100'),(688,'内蒙古','临河','015000'),(689,'内蒙古','五原','015100'),(690,'内蒙古','磴口','015200'),(691,'内蒙古','乌拉特前镇','014400'),(692,'内蒙古','乌拉特中镇','015300'),(693,'内蒙古','乌拉特后镇','015500'),(694,'内蒙古','杭锦后旗','015400'),(695,'内蒙古','锡林浩特','026000'),(696,'内蒙古','二连浩特','012600'),(697,'内蒙古','多伦','027300'),(698,'内蒙古','太仆寺旗','027000'),(699,'内蒙古','苏尼特左旗','013100'),(700,'内蒙古','苏尼特右旗','012500'),(701,'内蒙古','镶黄旗','013200'),(702,'内蒙古','东乌珠穆沁旗','026300'),(703,'内蒙古','西乌珠穆沁旗','026200'),(704,'内蒙古','阿马嗄旗','026100'),(705,'内蒙古','正镶白旗','027100'),(706,'内蒙古','正蓝旗','027200'),(707,'内蒙古','乌兰浩特','137400'),(708,'内蒙古','扎赉特旗','137600'),(709,'内蒙古','突泉','037500'),(710,'内蒙古','科右中旗','029400'),(711,'内蒙古','阿拉善左旗','750300'),(712,'内蒙古','阿拉善右旗','737300'),(713,'内蒙古','额济纳旗','735400'),(714,'江苏','南京','210000'),(715,'江苏','江浦','211800'),(716,'江苏','六合','211500'),(717,'江苏','江宁','211100'),(718,'江苏','高淳','211300'),(719,'江苏','溧水','211200'),(720,'江苏','无锡','214000'),(721,'江苏','江阴','214400'),(722,'江苏','宜兴','214200'),(723,'江苏','锡山','214100'),(724,'江苏','镇江','212000'),(725,'江苏','丹徒','212100'),(726,'江苏','丹阳','212300'),(727,'江苏','句容','212400'),(728,'江苏','扬中','212200'),(729,'江苏','苏州','215000'),(730,'江苏','吴江','215200'),(731,'江苏','吴县','215100'),(732,'江苏','南通','226300'),(733,'江苏','如东','226400'),(734,'江苏','如皋','226500'),(736,'江苏','海门','226100'),(737,'江苏','启东','226200'),(738,'江苏','海安','226600'),(739,'江苏','扬州','225000'),(740,'江苏','江都','225200'),(741,'江苏','邗江','225100'),(742,'江苏','仪征','211400'),(743,'江苏','高邮','225600'),(744,'江苏','宝应','225800'),(745,'江苏','盐城','224000'),(746,'江苏','响水','224600'),(747,'江苏','滨海','224500'),(748,'江苏','阜宁','224400'),(749,'江苏','射阳','224300'),(750,'江苏','建湖','224700'),(751,'江苏','大丰','224100'),(752,'江苏','东台','224200'),(753,'江苏','徐州','221000'),(754,'江苏','铜山','221100'),(755,'江苏','丰县','221700'),(756,'江苏','沛县','221600'),(757,'江苏','邳县','221300'),(758,'江苏','新沂','221400'),(759,'江苏','睢宁','221200'),(760,'江苏','淮安','223000'),(761,'江苏','淮阴县','223300'),(762,'江苏','淮安','223200'),(763,'江苏','洪泽','223100'),(764,'江苏','金湖','211600'),(765,'江苏','涟水','223400'),(766,'江苏','盱眙','211700'),(767,'江苏','连云港','222000'),(768,'江苏','东海','222300'),(769,'江苏','赣榆','222100'),(770,'江苏','灌云','222200'),(771,'江苏','灌南','223500'),(772,'江苏','常州','213000'),(773,'江苏','武进','213100'),(774,'江苏','金坛','213200'),(775,'江苏','溧阳','213300'),(776,'江苏','张家港','215600'),(777,'江苏','常熟','215500'),(778,'江苏','昆山','215300'),(779,'江苏','太仓','215400'),(780,'江苏','泰州','225300'),(781,'江苏','靖江','214500'),(782,'江苏','泰兴','225400'),(783,'江苏','姜堰','225500'),(784,'江苏','兴化','225700'),(785,'江苏','沐阳','223600'),(786,'江苏','宿迁','223800'),(787,'江苏','泗阳','223700'),(788,'江苏','泗洪','211900'),(789,'山东','荷泽','274000'),(790,'山东','巨野','274900'),(791,'山东','定陶','274100'),(792,'山东','成武','243600'),(793,'山东','单县','273700'),(794,'山东','曹县','274400'),(795,'山东','东明','274500'),(796,'山东','鄄城','274600'),(797,'山东','郓城','274700'),(798,'山东','济南','250000'),(799,'山东','长清','250300'),(800,'山东','章丘','250200'),(801,'山东','商河','251600'),(802,'山东','济阳','251400'),(803,'山东','平阴','250400'),(804,'山东','青岛','266000'),(805,'山东','胶南','266400'),(806,'山东','胶州','266300'),(807,'山东','平度','262800'),(808,'山东','莱西','266600'),(809,'山东','即墨','266200'),(810,'山东','淄博','255000'),(811,'山东','桓台','256400'),(812,'山东','高青','256300'),(813,'山东','沂源','256100'),(814,'山东','德州','253000'),(815,'山东','庆云','253700'),(816,'山东','监邑','251500'),(817,'山东','夏津','253200'),(818,'山东','平原','253100'),(819,'山东','宁津','253400'),(820,'山东','齐河','251100'),(821,'山东','乐陵','253600'),(822,'山东','武城','253300'),(823,'山东','禹城','251200'),(824,'山东','陵县','253500'),(825,'山东','烟台','264000'),(826,'山东','招远','265400'),(827,'山东','莱阳','265200'),(828,'山东','海阳','265100'),(829,'山东','长岛','265800'),(830,'山东','莱州','261400'),(831,'山东','龙口','265700'),(832,'山东','蓬莱','265600'),(833,'山东','栖霞','265300'),(834,'山东','牟平','264100'),(835,'山东','潍坊','261000'),(836,'山东','寿光','262700'),(837,'山东','昌邑','261300'),(838,'山东','高密','261500'),(839,'山东','诸城','262200'),(840,'山东','安丘','262100'),(841,'山东','临朐','262600'),(842,'山东','青州','262500'),(843,'山东','昌乐','262400'),(844,'山东','济宁','272100'),(845,'山东','梁山','274800'),(846,'山东','曲阜','273100'),(847,'山东','兖州','272000'),(848,'山东','邹城','273500'),(849,'山东','微山','277600'),(850,'山东','鱼台','272300'),(851,'山东','金乡','272200'),(852,'山东','嘉祥','272400'),(853,'山东','泗水','273200'),(854,'山东','汶上','272500'),(855,'山东','泰安','271000'),(856,'山东','新泰','271200'),(857,'山东','宁阳','271400'),(858,'山东','东平','271500'),(859,'山东','肥城','271600'),(860,'山东','临沂','276000'),(861,'山东','苍山','277700'),(862,'山东','平邑','273300'),(863,'山东','蒙阴','276200'),(864,'山东','沂水','276400'),(865,'山东','沂南','276300'),(866,'山东','莒南','276600'),(867,'山东','临沭','276700'),(868,'山东','郯城','276100'),(869,'山东','费县','273400'),(870,'山东','滨州','256600'),(871,'山东','博兴','256500'),(872,'山东','邹平','256200'),(873,'山东','惠民','251700'),(874,'山东','无棣','251900'),(875,'山东','沾化','256800'),(876,'山东','阳信','251800'),(877,'山东','东营','257000'),(878,'山东','利津','257400'),(879,'山东','广饶','257300'),(880,'山东','垦利','257500'),(881,'山东','威海','264200'),(882,'山东','荣城','264300'),(883,'山东','文登','264400'),(884,'山东','乳山','264500'),(885,'山东','枣庄','277100'),(886,'山东','滕州','277500'),(887,'山东','日照','276800'),(888,'山东','五莲','262300'),(889,'山东','河口','257200'),(890,'山东','莱芜','271100'),(891,'山东','聊城','252000'),(892,'山东','临清','252600'),(893,'山东','茌平','252100'),(894,'山东','高唐','251300'),(895,'山东','东阿','252200'),(896,'山东','阳谷','252300'),(897,'山东','莘县','252400'),(898,'山东','冠县','252500'),(899,'安徽','寿县','232200'),(900,'安徽','舒城','231300'),(901,'安徽','六安','237000'),(902,'安徽','绩溪','245300'),(903,'安徽','广德','242200'),(904,'安徽','旌德','242600'),(905,'安徽','宁国','242300'),(906,'安徽','郎溪','242100'),(907,'安徽','泾县','242500'),(908,'安徽','宣州','242000'),(909,'安徽','铜陵县','244100'),(910,'安徽','铜陵','244000'),(911,'安徽','濉溪','235100'),(912,'安徽','淮北','235000'),(913,'安徽','黟县','245500'),(914,'安徽','休宁','245400'),(915,'安徽','祁门','245600'),(916,'安徽','歙县','245200'),(917,'安徽','黄山','245000'),(918,'安徽','利辛','236700'),(919,'安徽','临泉','236400'),(920,'安徽','太和','236600'),(921,'安徽','颍上','236200'),(922,'安徽','界首','236500'),(923,'安徽','涡阳','233600'),(924,'安徽','蒙城','233500'),(925,'安徽','阜南','236300'),(926,'安徽','毫州','236800'),(927,'安徽','阜阳','236000'),(928,'安徽','泗县','234300'),(929,'安徽','灵壁','234200'),(930,'安徽','砀山','235300'),(931,'安徽','萧县','235200'),(932,'安徽','宿州','234000'),(933,'安徽','岳西','246600'),(934,'安徽','怀宁','246100'),(935,'安徽','宿松','246500'),(936,'安徽','潜山','246300'),(937,'安徽','望江','246200'),(938,'安徽','桐城','231400'),(939,'安徽','枞阳','246700'),(940,'安徽','太湖','246400'),(941,'安徽','安庆','246000'),(942,'安徽','当涂','243100'),(943,'安徽','马鞍山','243000'),(944,'安徽','凤台','232100'),(945,'安徽','淮南','232000'),(946,'安徽','南陵','242400'),(947,'安徽','繁昌','241200'),(948,'安徽','芜湖县','241100'),(949,'安徽','芜湖','241000'),(950,'安徽','固镇','233700'),(951,'安徽','怀远','233400'),(952,'安徽','五河','233300'),(953,'安徽','蚌埠','233000'),(954,'安徽','长丰','231100'),(955,'安徽','肥西','231200'),(956,'安徽','肥东','231600'),(957,'安徽','明光','239400'),(958,'安徽','定远','233200'),(959,'安徽','来安','239200'),(960,'安徽','天长','239300'),(961,'安徽','凤阳','233100'),(962,'安徽','全椒','239500'),(963,'安徽','滁州','239000'),(964,'安徽','合肥','230000'),(965,'安徽','石台','245100'),(966,'安徽','东至','247200'),(967,'安徽','青阳','242800'),(968,'安徽','贵池','247100'),(969,'安徽','含山','238100'),(970,'安徽','和县','238200'),(971,'安徽','庐江','231500'),(972,'安徽','无为','238300'),(973,'安徽','巢湖','238000'),(974,'安徽','金寨','237300'),(975,'安徽','霍山','237200'),(976,'安徽','霍邱','237400'),(978,'浙江','江山','324100'),(979,'浙江','常山','324200'),(980,'浙江','开化','324300'),(981,'浙江','衢县','324000'),(982,'浙江','龙游','324400'),(983,'浙江','杭州','310000'),(984,'浙江','余杭','311100'),(985,'浙江','富阳','311400'),(986,'浙江','淳安','311700'),(987,'浙江','建德','311600'),(988,'浙江','桐庐','311500'),(989,'浙江','临安','311300'),(990,'浙江','萧山','311200'),(991,'浙江','湖州','313000'),(992,'浙江','德清','313200'),(993,'浙江','安吉','313300'),(994,'浙江','长兴','313100'),(995,'浙江','嘉兴','314000'),(996,'浙江','桐乡','314500'),(997,'浙江','嘉善','314100'),(998,'浙江','海盐','314300'),(999,'浙江','平湖','314200'),(1000,'浙江','海宁','314400'),(1001,'浙江','宁波','315000'),(1002,'浙江','镇海','315200'),(1003,'浙江','余姚','315400'),(1004,'浙江','慈溪','315300'),(1005,'浙江','鄞县','315100'),(1006,'浙江','奉化','315500'),(1007,'浙江','宁海','315600'),(1008,'浙江','象山','315700'),(1009,'浙江','绍兴','312000'),(1010,'浙江','绍兴县','312300'),(1012,'浙江','嵊县','312400'),(1013,'浙江','新昌','312500'),(1014,'浙江','诸暨','311800'),(1016,'浙江','临海','317000'),(1017,'浙江','黄岩','317400'),(1018,'浙江','椒江','317700'),(1019,'浙江','温岭','317500'),(1020,'浙江','玉环','317600'),(1021,'浙江','仙居','317300'),(1022,'浙江','天台','317200'),(1023,'浙江','三门','317100'),(1024,'浙江','温州','325000'),(1026,'浙江','永嘉','325100'),(1027,'浙江','乐清','325600'),(1028,'浙江','洞头','325700'),(1029,'浙江','瑞安','325200'),(1030,'浙江','平阳','325400'),(1031,'浙江','苍南','325800'),(1032,'浙江','泰顺','325500'),(1033,'浙江','文成','325300'),(1034,'浙江','丽水','323000'),(1035,'浙江','缙云','321400'),(1036,'浙江','青田','323900'),(1037,'浙江','云和','323600'),(1038,'浙江','庆元','323800'),(1039,'浙江','龙泉','323700'),(1040,'浙江','遂昌','323300'),(1041,'浙江','松阳','323400'),(1042,'浙江','景宁','323500'),(1044,'浙江','金华县','321000'),(1045,'浙江','义乌','322000'),(1046,'浙江','东阳','322100'),(1047,'浙江','浦江','322200'),(1048,'浙江','永康','321300'),(1049,'浙江','武义','321200'),(1050,'浙江','兰溪','321100'),(1051,'浙江','磐安','322300'),(1052,'浙江','舟山','316000'),(1053,'浙江','岱山','316200'),(1054,'浙江','嵊泗','202450'),(1055,'浙江','普陀','316100'),(1056,'福建','福州','350000'),(1057,'福建','闽候','350100'),(1058,'福建','连江','350500'),(1059,'福建','长乐','350200'),(1060,'福建','福清','350300'),(1061,'福建','平潭','350400'),(1062,'福建','永泰','350700'),(1063,'福建','闽清','350800'),(1064,'福建','罗源','350600'),(1065,'福建','厦门','361000'),(1066,'福建','同安','361100'),(1067,'福建','宁德','352100'),(1068,'福建','福安','355000'),(1069,'福建','柘荣','355300'),(1070,'福建','福鼎','355200'),(1071,'福建','霞浦','355100'),(1072,'福建','寿宁','355500'),(1073,'福建','古田','352200'),(1074,'福建','屏南','352300'),(1075,'福建','周宁','355400'),(1076,'福建','莆田','351100'),(1077,'福建','仙游','351200'),(1078,'福建','泉州','362000'),(1079,'福建','晋江','362200'),(1080,'福建','南安','362300'),(1081,'福建','安溪','362400'),(1082,'福建','永春','362600'),(1083,'福建','德化','362500'),(1084,'福建','惠安','362100'),(1085,'福建','石狮','362700'),(1086,'福建','漳州','363000'),(1087,'福建','南靖','363600'),(1088,'福建','华安','363800'),(1089,'福建','长泰','363900'),(1090,'福建','龙海','363100'),(1091,'福建','漳浦','363200'),(1092,'福建','云霄','363300'),(1093,'福建','东山','363400'),(1094,'福建','诏安','363500'),(1095,'福建','平和','363700'),(1096,'福建','龙岩','364000'),(1097,'福建','漳平','364400'),(1098,'福建','永定','364100'),(1099,'福建','上杭','364200'),(1100,'福建','武平','364300'),(1101,'福建','长汀','366300'),(1102,'福建','连城','366200'),(1103,'福建','三明','365000'),(1104,'福建','沙县','365500'),(1105,'福建','尤溪','365100'),(1106,'福建','大田','366100'),(1107,'福建','永安','366000'),(1108,'福建','清流','365300'),(1109,'福建','宁化','365400'),(1110,'福建','明溪','365200'),(1111,'福建','建宁','354500'),(1112,'福建','泰宁','354400'),(1113,'福建','将乐','353300'),(1114,'福建','南平','353000'),(1115,'福建','建瓯','353100'),(1116,'福建','顺昌','353200'),(1117,'福建','建阳','354200'),(1118,'福建','邵武','354000'),(1119,'福建','浦城','353400'),(1120,'福建','松溪','353500'),(1121,'福建','政和','353600'),(1122,'福建','光泽','354100'),(1123,'福建','武夷山','354300'),(1124,'湖北','武汉','430000'),(1125,'湖北','武昌','430200'),(1127,'湖北','蔡甸','430100'),(1128,'湖北','黄陂','432200'),(1129,'湖北','新洲','431400'),(1130,'湖北','襄樊','441000'),(1131,'湖北','襄阳','441100'),(1132,'湖北','宜城','441400'),(1133,'湖北','南漳','441500'),(1134,'湖北','谷城','441700'),(1135,'湖北','枣阳','441200'),(1136,'湖北','老河口','441800'),(1137,'湖北','保康','441600'),(1138,'湖北','鄂州','436000'),(1139,'湖北','孝感','432100'),(1140,'湖北','大悟','432800'),(1141,'湖北','汉川','432300'),(1142,'湖北','应城','432400'),(1143,'湖北','云梦','432500'),(1144,'湖北','安陆','432600'),(1145,'湖北','广水','432700'),(1146,'湖北','黄冈','436100'),(1148,'湖北','麻城','431600'),(1149,'湖北','红安','431500'),(1150,'湖北','浠水','436200'),(1151,'湖北','罗田','436600'),(1152,'湖北','英山','436700'),(1153,'湖北','蕲春','436300'),(1154,'湖北','黄梅','436500'),(1155,'湖北','武穴','436400'),(1156,'湖北','黄石','435000'),(1157,'湖北','大冶','435100'),(1158,'湖北','咸宁','437000'),(1159,'湖北','阳新','435200'),(1160,'湖北','通山','437600'),(1161,'湖北','崇阳','437500'),(1162,'湖北','通城','437400'),(1163,'湖北','蒲圻','437300'),(1164,'湖北','嘉鱼','437200'),(1165,'湖北','荆沙','434100'),(1166,'湖北','沙市','434000'),(1167,'湖北','监利','433300'),(1168,'湖北','石首','434400'),(1169,'湖北','公安','434300'),(1170,'湖北','松滋','434200'),(1171,'湖北','钟祥','431900'),(1172,'湖北','京山','431800'),(1173,'湖北','宜昌','443000'),(1174,'湖北','宜昌县','443100'),(1175,'湖北','远发','444200'),(1176,'湖北','当阳','444100'),(1177,'湖北','枝江','443200'),(1178,'湖北','枝城','443300'),(1179,'湖北','长阳','443500'),(1180,'湖北','五峰','443400'),(1181,'湖北','秭归','443600'),(1182,'湖北','兴山','443700'),(1183,'湖北','恩施','445000'),(1184,'湖北','建始','445300'),(1185,'湖北','巴东','444300'),(1186,'湖北','鹤峰','445800'),(1187,'湖北','宣恩','445500'),(1188,'湖北','来凤','445700'),(1189,'湖北','咸丰','445600'),(1190,'湖北','利川','445400'),(1191,'湖北','十堰','442000'),(1192,'湖北','郧县','442500'),(1193,'湖北','丹江口','441900'),(1194,'湖北','房县','442100'),(1195,'湖北','神农架','442400'),(1196,'湖北','竹山','442200'),(1197,'湖北','竹溪','442300'),(1198,'湖北','郧西','442600'),(1200,'湖北','随州','441300'),(1201,'湖北','荆门','434500'),(1202,'湖北','江汉','433000'),(1203,'湖北','天门','431700'),(1204,'湖北','潜江','433100'),(1205,'湖北','洪湖','433200'),(1206,'湖南','岳阳','414000'),(1207,'湖南','岳阳县','414100'),(1208,'湖南','湘阴','410500'),(1209,'湖南','华容','414200'),(1210,'湖南','临湘','414300'),(1211,'湖南','平江','410400'),(1212,'湖南','汨罗','414400'),(1213,'湖南','长沙','410000'),(1214,'湖南','长沙县','410100'),(1215,'湖南','宁乡','410600'),(1216,'湖南','望城','410200'),(1217,'湖南','浏阳','410300'),(1218,'湖南','湘潭','411100'),(1219,'湖南','湘潭县','411200'),(1220,'湖南','韶山','411300'),(1221,'湖南','湘乡','411400'),(1222,'湖南','株洲','412000'),(1223,'湖南','株洲县','412100'),(1224,'湖南','攸县','412300'),(1225,'湖南','茶陵','412400'),(1226,'湖南','醴陵','412200'),(1227,'湖南','炎陵','412500'),(1228,'湖南','衡阳','421000'),(1229,'湖南','衡阳县','421200'),(1230,'湖南','耒阳','421800'),(1231,'湖南','常宁','421500'),(1232,'湖南','衡南','421100'),(1233,'湖南','衡东','421400'),(1234,'湖南','衡山','421300'),(1235,'湖南','祁东','421600'),(1236,'湖南','郴州','423000'),(1237,'湖南','资兴','423400'),(1238,'湖南','桂东','423500'),(1239,'湖南','汝城','424100'),(1240,'湖南','临武','424300'),(1241,'湖南','嘉禾','424500'),(1242,'湖南','安仁','423600'),(1243,'湖南','桂阳','424400'),(1244,'湖南','永兴','423300'),(1245,'湖南','宜章','424200'),(1246,'湖南','常德','415100'),(1247,'湖南','桃源','425700'),(1248,'湖南','汉寿','415900'),(1249,'湖南','石门','415300'),(1251,'湖南','津市','415400'),(1252,'湖南','安乡','415600'),(1253,'湖南','临澧','415200'),(1254,'湖南','益阳','413000'),(1255,'湖南','桃江','413400'),(1256,'湖南','安化','413500'),(1257,'湖南','南县','413200'),(1258,'湖南','沅江','413100'),(1259,'湖南','娄底','417000'),(1260,'湖南','双峰','411500'),(1261,'湖南','冷水江','417500'),(1262,'湖南','新化','417600'),(1263,'湖南','涟源','417100'),(1264,'湖南','邵阳','422000'),(1265,'湖南','邵阳县','422100'),(1266,'湖南','新宁','422700'),(1267,'湖南','城步','422500'),(1268,'湖南','新邵','422900'),(1269,'湖南','绥宁','422600'),(1270,'湖南','武岗','422400'),(1271,'湖南','洞口','422300'),(1272,'湖南','邵东','422800'),(1273,'湖南','隆回','422200'),(1274,'湖南','吉首','416000'),(1275,'湖南','凤凰','416200'),(1276,'湖南','龙山','416800'),(1277,'湖南','永顺','416700'),(1278,'湖南','保靖','416500'),(1279,'湖南','花垣','416400'),(1280,'湖南','古丈','416300'),(1281,'湖南','泸溪','416100'),(1282,'湖南','张家界','416600'),(1283,'湖南','桑植','416900'),(1284,'湖南','慈利','415800'),(1285,'湖南','怀化','418000'),(1286,'湖南','麻阳','419400'),(1287,'湖南','芷江','419100'),(1288,'湖南','黔阳','418100'),(1289,'湖南','溆浦','419300'),(1290,'湖南','通道','418500'),(1291,'湖南','靖州','418400'),(1292,'湖南','会同','418300'),(1293,'湖南','新晃','419200'),(1294,'湖南','辰溪','419500'),(1295,'湖南','沅陵','419600'),(1296,'湖南','洪江','418200'),(1297,'湖南','永州','425000'),(1298,'湖南','东安','425900'),(1299,'湖南','祁阳','421700'),(1301,'湖南','宁远','425600'),(1302,'湖南','蓝山','425800'),(1303,'湖南','江华','425500'),(1304,'湖南','江永','425400'),(1305,'湖南','道县','425300'),(1306,'湖南','双牌','425200'),(1307,'广东','广州','510000'),(1308,'广东','番禺','511400'),(1309,'广东','花县','510800'),(1310,'广东','从化','510900'),(1311,'广东','增城','511300'),(1312,'广东','汕尾','516600'),(1313,'广东','海丰','516400'),(1314,'广东','陆河','516700'),(1315,'广东','陆丰','516500'),(1316,'广东','潮阳','515100'),(1317,'广东','阳江','529500'),(1318,'广东','阳春','529600'),(1320,'广东','阳西','529800'),(1321,'广东','揭阳','515500'),(1323,'广东','惠来','515200'),(1324,'广东','揭西','515400'),(1325,'广东','普宁','515300'),(1326,'广东','茂名','525000'),(1327,'广东','化州','525100'),(1328,'广东','高州','525200'),(1329,'广东','信宜','525300'),(1330,'广东','电白','525400'),(1331,'广东','江门','529000'),(1332,'广东','台山','529200'),(1333,'广东','开平','529300'),(1334,'广东','恩平','529400'),(1335,'广东','新会','529100'),(1336,'广东','鹤山','529700'),(1337,'广东','韶关','512000'),(1338,'广东','曲江','512100'),(1339,'广东','翁源','512600'),(1340,'广东','新丰','511100'),(1341,'广东','始兴','512500'),(1342,'广东','仁化','512300'),(1343,'广东','南雄','512400'),(1344,'广东','乳源','512700'),(1345,'广东','乐昌','512200'),(1346,'广东','惠州','516000'),(1347,'广东','惠东','526300'),(1348,'广东','惠阳','516200'),(1349,'广东','博罗','516100'),(1350,'广东','龙门','511200'),(1351,'广东','梅州','514000'),(1353,'广东','蕉岭','514100'),(1354,'广东','大埔','514200'),(1355,'广东','丰顺','514300'),(1356,'广东','五华','514400'),(1357,'广东','兴宁','514500'),(1358,'广东','平远','514600'),(1359,'广东','汕头','515000'),(1360,'广东','澄海','515800'),(1361,'广东','南澳','515900'),(1362,'广东','深圳','518000'),(1363,'广东','宝安','518100'),(1364,'广东','珠海','519000'),(1365,'广东','斗门','519100'),(1366,'广东','佛山','528000'),(1367,'广东','南海','528200'),(1368,'广东','高明','528500'),(1369,'广东','三水','528100'),(1370,'广东','肇庆','526000'),(1371,'广东','高要','526100'),(1372,'广东','四会','526200'),(1373,'广东','怀集','526400'),(1374,'广东','封开','526500'),(1375,'广东','德庆','526600'),(1377,'广东','湛江','524000'),(1378,'广东','遂溪','524300'),(1379,'广东','廉江','524400'),(1380,'广东','吴川','524500'),(1381,'广东','徐闻','524100'),(1382,'广东','雷州','524200'),(1383,'广东','中山','528400'),(1384,'广东','河源','517000'),(1385,'广东','连平','517100'),(1386,'广东','和平','517200'),(1387,'广东','龙川','517300'),(1388,'广东','紫金','517400'),(1389,'广东','清远','511500'),(1390,'广东','佛冈','511600'),(1391,'广东','英德','513000'),(1392,'广东','连山','513200'),(1393,'广东','阳山','513100'),(1394,'广东','连南','513300'),(1395,'广东','连州','513400'),(1396,'广东','顺德','528300'),(1397,'广东','云浮','527300'),(1398,'广东','罗定','527200'),(1399,'广东','郁南','527100'),(1400,'广东','新兴','527400'),(1401,'广东','潮州','515600'),(1403,'广东','饶平','515700'),(1404,'广东','东莞','511700'),(1405,'广西','防城港','535700'),(1406,'广西','上思','535500'),(1407,'广西','南宁','530000'),(1408,'广西','上林','530500'),(1409,'广西','凭祥','532600'),(1410,'广西','邕宁','530200'),(1411,'广西','崇左','532200'),(1412,'广西','宁明','532500'),(1413,'广西','武鸣','530100'),(1414,'广西','马山','530600'),(1415,'广西','龙州','532400'),(1416,'广西','宾阳','530400'),(1417,'广西','大新','532300'),(1418,'广西','天等','532800'),(1419,'广西','横县','530300'),(1420,'广西','隆安','532700'),(1421,'广西','扶绥','532100'),(1422,'广西','柳州','545000'),(1423,'广西','柳江','545100'),(1424,'广西','鹿寨','545600'),(1425,'广西','柳城','545200'),(1426,'广西','三江','545500'),(1427,'广西','融安','545400'),(1428,'广西','融冰','545300'),(1429,'广西','金秀','545700'),(1430,'广西','合山','546500'),(1431,'广西','忻城','546200'),(1432,'广西','来宾','546100'),(1433,'广西','武宣','545900'),(1434,'广西','象州','545800'),(1435,'广西','桂林','541000'),(1436,'广西','阳朔','541900'),(1437,'广西','临桂','541100'),(1438,'广西','荔浦','546600'),(1439,'广西','灌阳','541600'),(1440,'广西','平乐','542400'),(1441,'广西','兴安','541300'),(1442,'广西','灵川','541200'),(1443,'广西','全州','541500'),(1444,'广西','永福','541800'),(1445,'广西','龙胜','541700'),(1446,'广西','恭城','542500'),(1447,'广西','资源','541400'),(1448,'广西','梧州','543000'),(1449,'广西','苍梧','543100'),(1450,'广西','藤县','543300'),(1451,'广西','岑溪','543200'),(1452,'广西','昭平','546800'),(1453,'广西','贺县','542800'),(1454,'广西','蒙山','546700'),(1455,'广西','钟山','542600'),(1456,'广西','富川','542700'),(1457,'广西','玉林','537000'),(1458,'广西','容县','537500'),(1459,'广西','北流','537400'),(1460,'广西','陆川','537700'),(1461,'广西','博白','537600'),(1462,'广西','贵港','537100'),(1463,'广西','桂平','537200'),(1464,'广西','平南','537300'),(1465,'广西','百色','533000'),(1467,'广西','隆林','533400'),(1468,'广西','西林','533500'),(1469,'广西','凌云','533100'),(1470,'广西','田阳','533600'),(1471,'广西','靖西','533800'),(1472,'广西','田东','531500'),(1473,'广西','乐业','533200'),(1474,'广西','平果','531400'),(1475,'广西','德保','533700'),(1476,'广西','那坡','533900'),(1477,'广西','钦州','535000'),(1478,'广西','灵山','535400'),(1479,'广西','浦北','535300'),(1480,'广西','河池','547000'),(1481,'广西','宜州','546300'),(1482,'广西','罗城','546400'),(1483,'广西','环江','547100'),(1484,'广西','天峨','547300'),(1485,'广西','凤山','547600'),(1486,'广西','东兰','547400'),(1487,'广西','南丹','547200'),(1488,'广西','巴马','547500'),(1489,'广西','都安','530700'),(1490,'广西','大化','530800'),(1491,'广西','北海','536000'),(1492,'广西','合浦','536100'),(1493,'江西','新余','336500'),(1494,'江西','分宜','336600'),(1495,'江西','南昌','330000'),(1496,'江西','南昌县','330200'),(1497,'江西','新建','330100'),(1498,'江西','进贤','331700'),(1499,'江西','安义','330500'),(1500,'江西','九江','332000'),(1501,'江西','九江县','332100'),(1502,'江西','庐山','332900'),(1503,'江西','修水','322400'),(1504,'江西','湖口','332500'),(1505,'江西','星子','332800'),(1506,'江西','瑞昌','333200'),(1507,'江西','德安','330400'),(1508,'江西','彭泽','332700'),(1509,'江西','都昌','332600'),(1510,'江西','永修','330300'),(1511,'江西','武宁','332300'),(1512,'江西','上饶','334000'),(1513,'江西','上饶县','334100'),(1514,'江西','玉山','334700'),(1515,'江西','余干','335100'),(1516,'江西','弋阳','334400'),(1517,'江西','波阳','333100'),(1518,'江西','广丰','334600'),(1519,'江西','万年','335500'),(1520,'江西','铅山','334500'),(1521,'江西','横峰','334300'),(1523,'江西','德兴','334200'),(1524,'江西','抚州','344000'),(1525,'江西','资溪','335300'),(1526,'江西','广昌','344900'),(1527,'江西','东乡','331800'),(1528,'江西','金溪','344800'),(1529,'江西','崇仁','344200'),(1530,'江西','临川','344100'),(1531,'江西','宜黄','344400'),(1532,'江西','尔安','344300'),(1533,'江西','南城','344700'),(1534,'江西','南丰','344500'),(1535,'江西','黎川','344600'),(1536,'江西','宜春','336000'),(1537,'江西','宜丰','336300'),(1538,'江西','上高','336400'),(1539,'江西','奉新','330700'),(1540,'江西','靖安','330600'),(1541,'江西','高安','330800'),(1542,'江西','丰城','331100'),(1543,'江西','樟树','331200'),(1544,'江西','万载','336100'),(1545,'江西','铜鼓','336200'),(1546,'江西','吉安','343000'),(1547,'江西','吉安县','343100'),(1548,'江西','新干','331300'),(1549,'江西','永丰','331500'),(1550,'江西','吉水','331600'),(1551,'江西','峡江','331400'),(1552,'江西','泰和','343700'),(1553,'江西','万安','343800'),(1554,'江西','遂川','343900'),(1555,'江西','宁冈','343500'),(1556,'江西','永新','343400'),(1557,'江西','井岗山','343600'),(1558,'江西','安福','343200'),(1559,'江西','赣州','341000'),(1560,'江西','瑞金','342500'),(1561,'江西','于都','342300'),(1562,'江西','兴国','342400'),(1563,'江西','宁都','342800'),(1564,'江西','石城','342700'),(1565,'江西','寻乌','342200'),(1566,'江西','南康','341400'),(1567,'江西','赣县','341100'),(1568,'江西','大余','341500'),(1569,'江西','上犹','341200'),(1570,'江西','崇义','341300'),(1571,'江西','信丰','341600'),(1572,'江西','龙南','341700'),(1573,'江西','定南','341900'),(1574,'江西','全南','341800'),(1575,'江西','安远','342100'),(1576,'江西','会昌','342600'),(1577,'江西','景德镇','333000'),(1578,'江西','乐平','333300'),(1579,'江西','浮梁','333400'),(1580,'江西','萍乡','337000'),(1581,'江西','莲花','337100'),(1582,'江西','鹰潭','335000'),(1583,'江西','贵溪','335400'),(1584,'江西','余江','335200'),(1585,'四川','成都','610000'),(1586,'四川','温江','611100'),(1587,'四川','金堂','610400'),(1588,'四川','双流','610200'),(1589,'四川','新津','611400'),(1590,'四川','蒲江','611600'),(1591,'四川','郫县','611700'),(1592,'四川','新都','610500'),(1593,'四川','彭州','611900'),(1594,'四川','都江堰','611800'),(1595,'四川','崇州','611200'),(1596,'四川','大邑','611300'),(1597,'四川','邛崃','611500'),(1598,'四川','攀枝花','617000'),(1599,'四川','自贡','643000'),(1600,'四川','富顺','643200'),(1601,'四川','荣县','643100'),(1602,'四川','绵阳','621000'),(1603,'四川','平武','622500'),(1604,'四川','安县','622600'),(1605,'四川','江油','621700'),(1606,'四川','梓潼','622100'),(1607,'四川','三台','621100'),(1608,'四川','盐亭','621600'),(1609,'四川','南充','637100'),(1610,'四川','西充','637200'),(1611,'四川','南部','637300'),(1612,'四川','阆中','637400'),(1613,'四川','营山','638150'),(1614,'四川','蓬安','638200'),(1615,'四川','仪陇','637600'),(1616,'四川','达川','636400'),(1617,'四川','宣汉','636100'),(1618,'四川','开江','636200'),(1619,'四川','万源','636300'),(1620,'四川','大竹','635100'),(1621,'四川','渠县','635200'),(1622,'四川','遂宁','629000'),(1623,'四川','蓬溪','629100'),(1624,'四川','射洪','629200'),(1625,'四川','广安','638500'),(1626,'四川','岳池','638300'),(1627,'四川','武胜','638400'),(1628,'四川','华蓥','638600'),(1629,'四川','邻水','635300'),(1630,'四川','泸州','646000'),(1631,'四川','合江','646200'),(1632,'四川','纳溪','646300'),(1633,'四川','叙永','646400'),(1634,'四川','古蔺','646500'),(1635,'四川','宜宾','644000'),(1636,'四川','南溪','644100'),(1637,'四川','屏山','645300'),(1638,'四川','兴文','644400'),(1639,'四川','长宁','644300'),(1640,'四川','珙县','644500'),(1641,'四川','高县','645100'),(1642,'四川','筠连','645200'),(1643,'四川','江安','644200'),(1644,'四川','内江','641000'),(1645,'四川','资中','641200'),(1646,'四川','资阳','641300'),(1647,'四川','简阳','641400'),(1648,'四川','威远','642400'),(1649,'四川','隆昌','642100'),(1650,'四川','乐至','641500'),(1651,'四川','乐山','614000'),(1652,'四川','峨边','614300'),(1653,'四川','眉山','612100'),(1654,'四川','峨眉山','614200'),(1655,'四川','仁寿','612500'),(1656,'四川','井研','612600'),(1657,'四川','洪雅','612300'),(1658,'四川','沐川','614500'),(1659,'四川','彭山','612700'),(1660,'四川','青神','612400'),(1661,'四川','丹梭','612200'),(1662,'四川','马边','614600'),(1663,'四川','犍为','614400'),(1664,'四川','夹江','614100'),(1665,'四川','金口河','614700'),(1666,'四川','西昌','615000'),(1667,'四川','雅安','625000'),(1668,'四川','康定','626000'),(1669,'四川','马尔康','624000'),(1671,'四川','广汉','618300'),(1672,'四川','什邡','618400'),(1673,'四川','绵竹','618200'),(1674,'四川','中江','618100'),(1675,'四川','广元','628000'),(1676,'四川','剑阁','628300'),(1677,'四川','旺苍','628200'),(1678,'四川','青川','628100'),(1679,'四川','苍溪','628400'),(1681,'四川','璧山','632700'),(1682,'四川','米易','617200'),(1683,'四川','盐边','617100'),(1684,'四川','宁南','615400'),(1685,'四川','盐源','615700'),(1686,'四川','平昌','635400'),(1687,'四川','通江','635700'),(1688,'四川','南江','635600'),(1689,'四川','巴中','635500'),(1690,'四川','酉阳','648800'),(1691,'四川','秀山','648900'),(1692,'四川','彭水','648600'),(1694,'四川','理县','623100'),(1695,'四川','昭觉','616100'),(1696,'四川','甘洛','616800'),(1697,'四川','宝兴','625700'),(1698,'四川','石棉','625400'),(1699,'四川','木里','615800'),(1700,'四川','会理','615100'),(1701,'四川','会东','615200'),(1702,'四川','冕宁','615600'),(1703,'四川','越西','616600'),(1704,'四川','雷波','616500'),(1705,'四川','喜德','616700'),(1706,'四川','普格','615300'),(1707,'四川','布拖','616300'),(1708,'四川','金阳','616200'),(1709,'四川','美姑','616400'),(1710,'四川','名山','625100'),(1711,'四川','荥经','625200'),(1712,'四川','汉源','625300'),(1713,'四川','天全','625500'),(1714,'四川','芦山','625600'),(1715,'四川','汶川','623000'),(1716,'四川','松潘','623300'),(1717,'海南','海口','570000'),(1718,'海南','澄迈','571900'),(1719,'海南','安定','571200'),(1720,'海南','文昌','571300'),(1721,'海南','屯昌','571600'),(1722,'海南','琼海','571400'),(1723,'海南','万宁','571500'),(1724,'海南','琼山','571100'),(1725,'海南','三亚','572000'),(1726,'海南','通什','572200'),(1727,'海南','乐东','572500'),(1728,'海南','保亭','572300'),(1729,'海南','陵水','572400'),(1730,'海南','琼中','572900'),(1731,'海南','儋州','571700'),(1732,'海南','白沙','572800'),(1733,'海南','洋浦','578000'),(1734,'海南','东方','572600'),(1735,'海南','昌江','572700'),(1736,'海南','临高','571800'),(1737,'贵州','贵阳','550000'),(1738,'贵州','清镇','551400'),(1739,'贵州','修文','550200'),(1740,'贵州','息烽','551100'),(1741,'贵州','开阳','550300'),(1742,'贵州','遵义','563000'),(1743,'贵州','赤水','564700'),(1744,'贵州','习水','564600'),(1745,'贵州','仁怀','564500'),(1746,'贵州','遵义县','563100'),(1747,'贵州','桐梓','563200'),(1748,'贵州','绥阳','533300'),(1749,'贵州','正安','563400'),(1750,'贵州','道真','563500'),(1751,'贵州','湄潭','564100'),(1752,'贵州','凤冈','564200'),(1753,'贵州','务川','564300'),(1754,'贵州','余庆','564400'),(1755,'贵州','安顺','561000'),(1756,'贵州','都匀','558000'),(1757,'贵州','凯里','556000'),(1759,'贵州','毕节','551700'),(1760,'贵州','六盘水','553000'),(1761,'贵州','兴义','562400'),(1762,'贵州','册亨','552200'),(1763,'贵州','望谟','552300'),(1764,'贵州','安龙','552400'),(1765,'贵州','兴仁','562300'),(1766,'贵州','贞丰','562200'),(1767,'贵州','普安','561500'),(1768,'贵州','晴隆','561400'),(1769,'贵州','平坝','561100'),(1770,'贵州','紫云','550800'),(1771,'贵州','关岭','561300'),(1772,'贵州','镇宁','561200'),(1773,'贵州','普定','562100'),(1774,'贵州','贵定','551300'),(1775,'贵州','福泉','550500'),(1776,'贵州','瓮安','550400'),(1777,'贵州','三都','558100'),(1778,'贵州','荔波','558400'),(1779,'贵州','独山','558200'),(1780,'贵州','平塘','558300'),(1781,'贵州','罗甸','550100'),(1782,'贵州','惠水','550600'),(1783,'贵州','龙里','551200'),(1784,'贵州','榕江','557200'),(1785,'贵州','黄平','556100'),(1786,'贵州','施秉','556200'),(1787,'贵州','镇远','557700'),(1788,'贵州','岑巩','557800'),(1789,'贵州','三穗','556500'),(1790,'贵州','天柱','556600'),(1791,'贵州','锦屏','556700'),(1792,'贵州','黎平','557300'),(1793,'贵州','从江','557400'),(1794,'贵州','沿河','565300'),(1795,'贵州','松桃','554100'),(1796,'贵州','万山','554200'),(1797,'贵州','玉屏','554000'),(1798,'贵州','江口','554400'),(1799,'贵州','石阡','555100'),(1800,'贵州','思南','565100'),(1801,'贵州','印江','555200'),(1802,'贵州','德江','565200'),(1803,'贵州','长顺','550700'),(1804,'贵州','威宁','553100'),(1805,'贵州','赫章','553200'),(1806,'贵州','纳雍','553300'),(1807,'贵州','黔西','551500'),(1808,'贵州','大方','551600'),(1809,'贵州','金沙','551800'),(1810,'贵州','织金','552100'),(1811,'贵州','剑河','556400'),(1812,'贵州','六枝','553400'),(1813,'贵州','盘县','561600'),(1814,'贵州','雷山','557100'),(1815,'贵州','丹寨','557500'),(1816,'贵州','麻江','557600'),(1817,'贵州','台江','556300'),(1818,'云南','昭通','657000'),(1819,'云南','镇雄','657200'),(1820,'云南','永善','657300'),(1821,'云南','彝良','657600'),(1822,'云南','大关','657400'),(1823,'云南','威信','657900'),(1824,'云南','盐津','657500'),(1825,'云南','巧家','654600'),(1826,'云南','绥江','657700'),(1827,'云南','鲁甸','657100'),(1828,'云南','水富','657800'),(1829,'云南','昆明','650000'),(1830,'云南','富民','650400'),(1831,'云南','嵩明','651700'),(1832,'云南','宜良','652100'),(1833,'云南','呈贡','650500'),(1834,'云南','晋宁','650600'),(1835,'云南','安宁','650300'),(1836,'云南','路南','652200'),(1837,'云南','禄劝','651500'),(1838,'云南','大理','671000'),(1839,'云南','鹤庆','671500'),(1840,'云南','剑川','671300'),(1841,'云南','祥云','672100'),(1842,'云南','南涧','675700'),(1843,'云南','宾川','671600'),(1844,'云南','云龙','672700'),(1845,'云南','弥渡','675600'),(1846,'云南','洱源','671200'),(1847,'云南','永平','672600'),(1848,'云南','巍山','672400'),(1849,'云南','漾濞','672500'),(1850,'云南','个旧','661400'),(1851,'云南','石屏','662200'),(1852,'云南','弥勒','652300'),(1853,'云南','红河','654400'),(1854,'云南','开远','661000'),(1855,'云南','蒙自','661100'),(1856,'云南','建水','654300'),(1857,'云南','河口','661300'),(1858,'云南','泸西','652400'),(1859,'云南','金平','661500'),(1860,'云南','绿春','662500'),(1861,'云南','元阳','662400'),(1862,'云南','屏边','661200'),(1863,'云南','曲靖','655000'),(1864,'云南','寻甸','655200'),(1865,'云南','马龙','655100'),(1866,'云南','会泽','654200'),(1867,'云南','师宗','655700'),(1868,'云南','陆良','655600'),(1869,'云南','富源','655500'),(1870,'云南','宣威','665400'),(1872,'云南','保山','678000'),(1873,'云南','腾冲','679100'),(1874,'云南','昌宁','678100'),(1875,'云南','龙陵','678300'),(1876,'云南','施甸','678200'),(1877,'云南','文山','663000'),(1878,'云南','砚山','663100'),(1879,'云南','丘北','663200'),(1880,'云南','广南','663300'),(1881,'云南','马关','663700'),(1882,'云南','富宁','663400'),(1883,'云南','西畴','663500'),(1884,'云南','麻栗坡','663600'),(1885,'云南','玉溪','653100'),(1886,'云南','华宁','652800'),(1887,'云南','江川','652600'),(1888,'云南','新平','653400'),(1889,'云南','元江','653300'),(1890,'云南','通海','652700'),(1891,'云南','易门','651100'),(1892,'云南','澄江','652500'),(1893,'云南','峨山','653200'),(1894,'云南','楚雄','675000'),(1895,'云南','禄丰','651200'),(1896,'云南','牟定','675500'),(1897,'云南','大姚','675400'),(1898,'云南','永仁','651400'),(1899,'云南','南华','675200'),(1900,'云南','姚安','675300'),(1901,'云南','元谋','651300'),(1902,'云南','双柏','675100'),(1903,'云南','武定','651600'),(1904,'云南','思茅','665000'),(1905,'云南','普洱','665100'),(1906,'云南','墨江','654800'),(1907,'云南','景谷','666400'),(1908,'云南','景东','676200'),(1909,'云南','澜沧','665600'),(1910,'云南','西盟','665700'),(1911,'云南','江城','665900'),(1912,'云南','镇沅','666500'),(1913,'云南','孟连','665800'),(1914,'云南','东川','654100'),(1915,'云南','临沧','677000'),(1916,'云南','耿马','677500'),(1917,'云南','镇康','677700'),(1918,'云南','沧源','677400'),(1919,'云南','永德','677600'),(1920,'云南','凤庆','675900'),(1921,'云南','云县','675800'),(1922,'云南','双江','677300'),(1923,'云南','六库','673100'),(1924,'云南','泸水','673200'),(1925,'云南','福贡','673400'),(1926,'云南','贡山','673500'),(1927,'云南','兰坪','671400'),(1928,'云南','中甸','674400'),(1929,'云南','维西','674600'),(1930,'云南','德钦','674500'),(1931,'云南','丽江','674100'),(1932,'云南','宁蒗','674300'),(1933,'云南','华坪','617300'),(1934,'云南','永胜','674200'),(1935,'云南','景洪','666100'),(1936,'云南','孟海','666200'),(1937,'云南','孟腊','666300'),(1938,'云南','潞西','678400'),(1939,'云南','畹町','678500'),(1940,'云南','瑞丽','678600'),(1941,'云南','陇川','678700'),(1942,'云南','盈江','679300'),(1943,'云南','梁河','679200'),(1944,'西藏','拉萨','850000'),(1945,'西藏','日喀则','857000'),(1946,'西藏','林芝','850400'),(1947,'西藏','昌都','854000'),(1948,'西藏','堆龙德庆','851400'),(1949,'西藏','曲水','850600'),(1950,'西藏','尼木','851300'),(1951,'西藏','仁布','857200'),(1952,'西藏','扎囊','850800'),(1953,'西藏','贡嘎','850700'),(1954,'西藏','江达','854100'),(1955,'西藏','芒康','854500'),(1956,'西藏','八宿','854600'),(1957,'西藏','洛隆','855400'),(1958,'西藏','丁青','855700'),(1959,'西藏','巴青','852100'),(1960,'西藏','比如','852300'),(1961,'西藏','那曲','852000'),(1962,'西藏','班戈','852500'),(1963,'西藏','措勤','859300'),(1964,'西藏','阿里','859000'),(1965,'西藏','索县','852200'),(1966,'西藏','尼玛','852600'),(1968,'陕西','合阳','715300'),(1969,'陕西','蒲城','715500'),(1970,'陕西','韩城','715400'),(1971,'陕西','富平','711700'),(1972,'陕西','潼关','714300'),(1973,'陕西','华阴','714200'),(1974,'陕西','大荔','715100'),(1975,'陕西','华县','714100'),(1976,'陕西','渭南','714000'),(1977,'陕西','榆林','719000'),(1978,'陕西','富县','727500'),(1979,'陕西','安塞','717400'),(1980,'陕西','甘泉','716100'),(1981,'陕西','志丹','717500'),(1982,'陕西','洛川','727400'),(1983,'陕西','宜川','716200'),(1984,'陕西','黄龙','715700'),(1985,'陕西','吴旗','717600'),(1986,'陕西','延长','717100'),(1987,'陕西','子长','717300'),(1988,'陕西','延川','717200'),(1989,'陕西','黄陵','727300'),(1990,'陕西','延安','716000'),(1991,'陕西','彬县','713500'),(1992,'陕西','乾县','713300'),(1993,'陕西','武功','712200'),(1994,'陕西','礼泉','713200'),(1995,'陕西','泾阳','713700'),(1996,'陕西','三原','713800'),(1997,'陕西','淳化','711200'),(1998,'陕西','旬邑','711300'),(1999,'陕西','兴平','713100'),(2000,'陕西','永寿','713400'),(2001,'陕西','长武','713600'),(2003,'陕西','咸阳','712000'),(2004,'陕西','长安','710100'),(2005,'陕西','临潼','710600'),(2006,'陕西','蓝田','710500'),(2007,'陕西','周至','710400'),(2008,'陕西','户县','710300'),(2009,'陕西','高陵','710200'),(2010,'陕西','西安','710000'),(2011,'陕西','商南','726300'),(2012,'陕西','略阳','724300'),(2013,'陕西','宁强','724400'),(2014,'陕西','佛坪','723400'),(2015,'陕西','留坝','724100'),(2016,'陕西','白河','725800'),(2017,'陕西','镇坪','725600'),(2018,'陕西','山阳','726400'),(2019,'陕西','镇安','711500'),(2020,'陕西','柞水','711400'),(2021,'陕西','清涧','718300'),(2022,'陕西','神木','719300'),(2023,'陕西','靖边','718500'),(2024,'陕西','定边','718600'),(2025,'陕西','绥德','718000'),(2026,'陕西','米脂','718100'),(2027,'陕西','横山','719100'),(2028,'陕西','府谷','719400'),(2029,'陕西','佳县','719200'),(2030,'陕西','子洲','718400'),(2031,'陕西','吴堡','718200'),(2032,'陕西','宜君','727200'),(2033,'陕西','耀县','727100'),(2034,'陕西','铜川','727000'),(2035,'陕西','麟游','721500'),(2036,'陕西','太白','721600'),(2037,'陕西','千阳','721100'),(2038,'陕西','陇县','721200'),(2039,'陕西','凤县','721700'),(2040,'陕西','眉县','722300'),(2041,'陕西','扶风','722200'),(2042,'陕西','岐山','722400'),(2043,'陕西','凤翔','721400'),(2044,'陕西','宝鸡县','721300'),(2045,'陕西','宝鸡','721000'),(2046,'陕西','勉县','724200'),(2048,'陕西','西乡','723500'),(2049,'陕西','洋县','723300'),(2050,'陕西','城固','723200'),(2051,'陕西','南郑','723100'),(2052,'陕西','汉中','723000'),(2053,'陕西','紫阳','725300'),(2054,'陕西','平利','725500'),(2055,'陕西','石泉','725200'),(2056,'陕西','旬阳','725700'),(2057,'陕西','汉阴','725100'),(2058,'陕西','宁陕','711600'),(2059,'陕西','岚皋','725400'),(2060,'陕西','安康','725000'),(2061,'陕西','洛南','726100'),(2062,'陕西','丹凤','726200'),(2063,'陕西','商州','726000'),(2064,'陕西','澄城','715200'),(2065,'陕西','白水','715600'),(2066,'甘肃','临夏市','731100'),(2067,'甘肃','兰州','730000'),(2069,'甘肃','皋兰','730200'),(2070,'甘肃','榆中','730100'),(2071,'甘肃','永登','730300'),(2072,'甘肃','定西','743000'),(2073,'甘肃','静宁','743400'),(2074,'甘肃','泾川','744300'),(2075,'甘肃','灵台','744400'),(2076,'甘肃','崇信','744200'),(2077,'甘肃','华亭','744100'),(2078,'甘肃','庄浪','741700'),(2079,'甘肃','西峰','745000'),(2080,'甘肃','金昌','733000'),(2081,'甘肃','民勤','733300'),(2082,'甘肃','天祝','733200'),(2083,'甘肃','古浪','733100'),(2084,'甘肃','金川','737100'),(2085,'甘肃','永昌','737200'),(2086,'甘肃','张掖','734000'),(2087,'甘肃','山丹','734100'),(2088,'甘肃','高台','734300'),(2089,'甘肃','民乐','734500'),(2090,'甘肃','临泽','734200'),(2091,'甘肃','萧南','734400'),(2092,'甘肃','酒泉','735000'),(2093,'甘肃','玉门','735200'),(2094,'甘肃','安西','736100'),(2095,'甘肃','敦煌','736200'),(2096,'甘肃','金塔','735300'),(2097,'甘肃','阿克塞','736400'),(2098,'甘肃','嘉峪关','735100'),(2099,'甘肃','肃北','736300'),(2100,'甘肃','天水','741000'),(2101,'甘肃','甘谷','741200'),(2102,'甘肃','武山','741300'),(2103,'甘肃','秦安','741600'),(2104,'甘肃','张家川','741500'),(2105,'甘肃','清水','741400'),(2106,'甘肃','武都','746000'),(2107,'甘肃','白银','730900'),(2108,'甘肃','靖远','730600'),(2109,'甘肃','平凉','744000'),(2110,'甘肃','景泰','730400'),(2111,'甘肃','会宁','743200'),(2112,'甘肃','临夏县','731800'),(2113,'甘肃','永靖','731600'),(2114,'甘肃','和政','731200'),(2115,'甘肃','东乡','731400'),(2116,'甘肃','康乐','731500'),(2117,'甘肃','广河','731300'),(2118,'甘肃','积石山','731700'),(2119,'甘肃','甘南州','747000'),(2120,'甘肃','夏河','747100'),(2121,'甘肃','临潭','747500'),(2122,'甘肃','舟曲','746300'),(2123,'甘肃','碌曲','747200'),(2124,'甘肃','玛曲','747300'),(2125,'甘肃','旧尼','747600'),(2126,'甘肃','迭部','747400'),(2127,'甘肃','陇西','748100'),(2128,'甘肃','漳县','748300'),(2129,'甘肃','通渭','743300'),(2130,'甘肃','岷县','748400'),(2131,'甘肃','临洮','730500'),(2132,'甘肃','渭源','748200'),(2133,'甘肃','庆阳','745100'),(2134,'甘肃','宁县','745200'),(2135,'甘肃','镇原','744500'),(2136,'甘肃','环县','745700'),(2137,'甘肃','合水','745400'),(2138,'甘肃','正宁','745300'),(2139,'甘肃','华池','745600'),(2140,'甘肃','成县','742500'),(2141,'甘肃','康县','746500'),(2142,'甘肃','文县','746400'),(2143,'甘肃','宕昌','748500'),(2144,'甘肃','西和','742100'),(2145,'甘肃','礼县','742200'),(2146,'甘肃','徽县','742300'),(2147,'甘肃','两当','742400'),(2148,'青海','海晏','812200'),(2149,'青海','西宁','810000'),(2150,'青海','大通','810100'),(2151,'青海','乐都','810700'),(2152,'青海','湟中','811600'),(2153,'青海','互助','810500'),(2154,'青海','湟源','812100'),(2155,'青海','民和','810800'),(2156,'青海','循化','811100'),(2157,'青海','化隆','810900'),(2158,'青海','同仁','811300'),(2159,'青海','共和','813000'),(2160,'青海','玛沁','814000'),(2161,'青海','玉树','815000'),(2162,'青海','德令哈','817000'),(2163,'青海','门源','810300'),(2164,'青海','格尔木','816000'),(2165,'青海','河南','811500'),(2166,'青海','尖扎','811200'),(2167,'青海','泽库','811400'),(2168,'青海','乌兰','817100'),(2169,'青海','都兰','816100'),(2170,'青海','天峻','817200'),(2171,'青海','治多','815400'),(2172,'青海','称多','815100'),(2173,'青海','囊谦','815200'),(2174,'青海','杂多','815300'),(2175,'青海','曲麻莱','815500'),(2176,'青海','龙羊峡','811800'),(2177,'青海','茫崖','817500'),(2178,'青海','贵德','811700'),(2179,'青海','贵南','813100'),(2180,'青海','兴海','813300'),(2181,'青海','同德','813200'),(2182,'青海','祁连','810400'),(2183,'青海','刚察','812300'),(2184,'青海','大柴旦','817300'),(2185,'青海','冷湖','817400'),(2186,'青海','达日','814200'),(2187,'青海','玛多','813500'),(2188,'青海','班玛','814300'),(2189,'青海','甘德','814100'),(2190,'宁夏','银川','750000'),(2191,'宁夏','贺兰','750200'),(2192,'宁夏','永宁','750100'),(2193,'宁夏','石嘴山','753000'),(2194,'宁夏','平罗','753400'),(2195,'宁夏','惠农','753600'),(2196,'宁夏','陶乐','753500'),(2197,'宁夏','吴忠','751100'),(2198,'宁夏','中宁','751200'),(2199,'宁夏','中卫','751700'),(2200,'宁夏','青铜峡','751600'),(2201,'宁夏','灵武','751400'),(2202,'宁夏','同心','751300'),(2203,'宁夏','盐池','751500'),(2204,'宁夏','固原','756000'),(2205,'宁夏','海原','756100'),(2206,'宁夏','西吉','756200'),(2207,'宁夏','隆德','756300'),(2208,'宁夏','泾源','756400'),(2209,'宁夏','彭阳','756500'),(2210,'新疆','塔城','834700'),(2211,'新疆','额敏','834600'),(2212,'新疆','裕民','834800'),(2213,'新疆','托里','834500'),(2214,'新疆','哈密','839000'),(2215,'新疆','马里坤','839200'),(2216,'新疆','伊吾','839300'),(2217,'新疆','和田','848000'),(2218,'新疆','皮山','845100'),(2219,'新疆','墨玉','848100'),(2220,'新疆','洛浦','848200'),(2221,'新疆','策勒','848300'),(2222,'新疆','于田','848400'),(2223,'新疆','民丰','848500'),(2224,'新疆','阿勒泰','836500'),(2225,'新疆','青河','836200'),(2226,'新疆','布尔律','836600'),(2227,'新疆','哈巴河','836700'),(2228,'新疆','富蕴','836100'),(2229,'新疆','福海','836400'),(2230,'新疆','吉木乃','836800'),(2231,'新疆','阿图什','845300'),(2232,'新疆','乌恰','845400'),(2233,'新疆','阿克陶','845500'),(2234,'新疆','博乐','833400'),(2235,'新疆','精河','833300'),(2236,'新疆','温泉','833500'),(2237,'新疆','克拉玛依','834000'),(2239,'新疆','乌鲁木齐','830000'),(2240,'新疆','奎屯','833200'),(2241,'新疆','乌苏','833000'),(2242,'新疆','石河子','832000'),(2243,'新疆','沙湾','832100'),(2244,'新疆','昌吉','831100'),(2245,'新疆','奇台','831800'),(2246,'新疆','米泉','831400'),(2247,'新疆','呼图壁','831200'),(2248,'新疆','玛纳斯','832200'),(2249,'新疆','吉木萨尔','831700'),(2250,'新疆','阜康','831500'),(2251,'新疆','木垒','831900'),(2252,'新疆','吐鲁番','838000'),(2253,'新疆','鄯善','838200'),(2254,'新疆','托克逊','838100'),(2255,'新疆','库尔勒','841000'),(2256,'新疆','焉耆','841100'),(2257,'新疆','博湖','841400'),(2258,'新疆','轮台','841600'),(2259,'新疆','和静','841300'),(2260,'新疆','和硕','841200'),(2261,'新疆','若羌','841800'),(2262,'新疆','尉犁','841500'),(2263,'新疆','且末','841900'),(2264,'新疆','阿克苏','843000'),(2265,'新疆','库车','842000'),(2266,'新疆','新和','842100'),(2267,'新疆','沙雅','842200'),(2268,'新疆','拜城','842300'),(2269,'新疆','温宿','843100'),(2270,'新疆','乌什','843400'),(2271,'新疆','阿拉尔','843300'),(2272,'新疆','阿瓦提','843200'),(2273,'新疆','柯坪','843600'),(2274,'新疆','阿合奇','843500'),(2275,'新疆','咯什','844000'),(2276,'新疆','疏附','844100'),(2277,'新疆','伽师','844300'),(2278,'新疆','巴楚','843800'),(2279,'新疆','麦盖提','844600'),(2280,'新疆','叶城','844900'),(2281,'新疆','泽普','844800'),(2282,'新疆','莎车','844700'),(2283,'新疆','岳普湖','844400'),(2284,'新疆','英吉沙','844500'),(2285,'新疆','塔什库尔干','845200'),(2286,'新疆','疏勒','844200'),(2287,'新疆','伊宁','835000'),(2288,'新疆','察布查尔','835300'),(2289,'新疆','霍城','835200'),(2290,'新疆','新源','835800'),(2291,'新疆','巩留','835400'),(2292,'新疆','尼勒克','835700'),(2293,'新疆','特克斯','835500'),(2294,'新疆','昭苏','835600');
  35. /*!40000 ALTER TABLE `postalcode` ENABLE KEYS */;
  36. UNLOCK TABLES;
  38. --
  39. -- Table structure for table `products`
  40. --
  42. DROP TABLE IF EXISTS `products`;
  43. CREATE TABLE `products` (
  44.   `pid` varchar(255) NOT NULL,
  45.   `pname` varchar(255) NOT NULL,
  46.   `price` double NOT NULL,
  47.   PRIMARY KEY  (`pid`)
  48. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='3.2';
  50. --
  51. -- Dumping data for table `products`
  52. --
  54. LOCK TABLES `products` WRITE;
  55. /*!40000 ALTER TABLE `products` DISABLE KEYS */;
  56. INSERT INTO `products` VALUES ('p1001','MP3随身听',188),('p1002','CD播放器',240),('p1003','商务手机',1899),('p1004','笔记本电脑',7250),('p1005','GPS',2300);
  57. /*!40000 ALTER TABLE `products` ENABLE KEYS */;
  58. UNLOCK TABLES;
  60. --
  61. -- Table structure for table `query_step`
  62. --
  64. DROP TABLE IF EXISTS `query_step`;
  65. CREATE TABLE `query_step` (
  66.   `id` int(11) NOT NULL auto_increment,
  67.   `name` varchar(100) NOT NULL,
  68.   `type` varchar(100) NOT NULL,
  69.   `info` varchar(100) default NULL,
  70.   `items` varchar(255) default NULL,
  71.   `islast` varchar(10) NOT NULL default 'false',
  72.   PRIMARY KEY  (`id`)
  73. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='1.5';
  75. --
  76. -- Dumping data for table `query_step`
  77. --
  79. LOCK TABLES `query_step` WRITE;
  80. /*!40000 ALTER TABLE `query_step` DISABLE KEYS */;
  81. INSERT INTO `query_step` VALUES (1,'queryWay','select','查询方式：','{'quick':'快速查询','detail':'分类查询'}','false'),(2,'productType','select','产品分类：','{'ptype01':'分类01','ptype02':'分类02','ptype03':'分类03'}','false'),(3,'keyword','text','产品关键字：','','true');
  82. /*!40000 ALTER TABLE `query_step` ENABLE KEYS */;
  83. UNLOCK TABLES;
  85. --
  86. -- Table structure for table `questions`
  87. --
  89. DROP TABLE IF EXISTS `questions`;
  90. CREATE TABLE `questions` (
  91.   `id` int(11) NOT NULL auto_increment,
  92.   `type` int(11) NOT NULL,
  93.   `content` text NOT NULL,
  94.   PRIMARY KEY  (`id`)
  95. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='9.6';
  97. --
  98. -- Dumping data for table `questions`
  99. --
  101. LOCK TABLES `questions` WRITE;
  102. /*!40000 ALTER TABLE `questions` DISABLE KEYS */;
  103. INSERT INTO `questions` VALUES (1,1,'<?xml version="1.0" encoding="utf-8"?>rn<question type="1" id="1">rn<title>AJAX术语是由哪家公司或组织最先提出的</title>rn<options>rn <option>Google</option>rn <option>IBM</option>rn <option mark="1">Adaptive Path</option>rn <option>Dojo Foundation</option>rn</options>rn</question>'),(2,2,'<?xml version="1.0" encoding="utf-8"?>rn<question type="2" id="2">rn<title>以下哪些Web应用属于Ajax应用</title>rn<options>rn <option>Hotmail</option>rn <option mark="1">Google Maps</option>rn <option mark="1">Flickr</option>rn <option mark="1">Windows Live</option>rn</options>rn</question>'),(3,3,'<?xml version="1.0" encoding="utf-8"?>rn<question type="3" id="3">rn<title>CSS属性 text-overflow 属于W3C的CSS2规范</title>rn<options>rn <option>对</option>rn <option mark="1">错</option>rn</options>rn</question>'),(4,4,'<?xml version="1.0" encoding="utf-8"?>rn<question type="4" id="4">rn<title>15-3 = $__$，28+2 = $__$</title>rn<options>rn <option mark="1">12</option>rn <option mark="1">30</option>rn</options>rn</question>');
  104. /*!40000 ALTER TABLE `questions` ENABLE KEYS */;
  105. UNLOCK TABLES;
  107. --
  108. -- Table structure for table `rating`
  109. --
  111. DROP TABLE IF EXISTS `rating`;
  112. CREATE TABLE `rating` (
  113.   `id` int(11) NOT NULL auto_increment,
  114.   `name` varchar(255) NOT NULL,
  115.   `totaltimes` int(11) NOT NULL default '0',
  116.   `totaldiamonds` int(11) NOT NULL default '0',
  117.   PRIMARY KEY  (`id`)
  118. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='3.6';
  120. --
  121. -- Dumping data for table `rating`
  122. --
  124. LOCK TABLES `rating` WRITE;
  125. /*!40000 ALTER TABLE `rating` DISABLE KEYS */;
  126. INSERT INTO `rating` VALUES (1,'产品1',2,6),(2,'产品2',3,10),(3,'产品3',7,17),(4,'产品4',2,10),(5,'产品5',7,19);
  127. /*!40000 ALTER TABLE `rating` ENABLE KEYS */;
  128. UNLOCK TABLES;
  130. --
  131. -- Table structure for table `schedule`
  132. --
  134. DROP TABLE IF EXISTS `schedule`;
  135. CREATE TABLE `schedule` (
  136.   `id` int(11) NOT NULL auto_increment,
  137.   `task` varchar(255) NOT NULL,
  138.   `builddate` varchar(10) NOT NULL,
  139.   PRIMARY KEY  (`id`)
  140. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='9.5';
  142. --
  143. -- Dumping data for table `schedule`
  144. --
  146. LOCK TABLES `schedule` WRITE;
  147. /*!40000 ALTER TABLE `schedule` DISABLE KEYS */;
  148. INSERT INTO `schedule` VALUES (2,'圣诞节','2006-12-25'),(9,'过节家庭聚会','2007-1-1'),(10,'朋友请客','2007-1-2'),(11,'给老张去电话','2007-1-2'),(12,'部门联欢会','2007-1-5'),(13,'交费','2007-1-9'),(16,'明年工作规划','2007-1-22'),(19,'部门会议','2007-1-17'),(20,'回家买票','2007-1-31'),(21,'周末回家','2007-1-20');
  149. /*!40000 ALTER TABLE `schedule` ENABLE KEYS */;
  150. UNLOCK TABLES;
  152. --
  153. -- Table structure for table `select_menu`
  154. --
  156. DROP TABLE IF EXISTS `select_menu`;
  157. CREATE TABLE `select_menu` (
  158.   `id` varchar(255) NOT NULL default '',
  159.   `text` varchar(255) NOT NULL,
  160.   `pid` varchar(255) NOT NULL,