-- MySQL dump 10.14 Distrib 5.5.60-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: qicheoa -- ------------------------------------------------------ -- Server version 5.5.60-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `plate_no_city_ref` -- DROP TABLE IF EXISTS `plate_no_city_ref`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `plate_no_city_ref` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `PLATE_NO_CODE` varchar(45) NOT NULL, `CITY_NAME` varchar(45) NOT NULL, `REMARK` varchar(10000) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=363 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plate_no_city_ref` -- LOCK TABLES `plate_no_city_ref` WRITE; /*!40000 ALTER TABLE `plate_no_city_ref` DISABLE KEYS */; INSERT INTO `plate_no_city_ref` VALUES (1,'冀A','河北省石家庄市',''),(2,'冀B','河北省唐山市',''),(3,'冀C','河北省秦皇岛市',''),(4,'冀D','河北省邯郸市',''),(5,'冀E','河北省邢台市',''),(6,'冀F','河北省保定市',''),(7,'冀G','河北省张家口市',''),(8,'冀H','河北省承德市',''),(9,'冀J','河北省沧州市',''),(10,'冀R','河北省廊坊市',''),(11,'冀S','河北省沧州行署',''),(12,'冀T','河北省衡水市',''),(13,'豫A','河南省郑州市',''),(14,'豫B','河南省开封市',''),(15,'豫C','河南省洛阳市',''),(16,'豫D','河南省平顶山市',''),(17,'豫E','河南省安阳市',''),(18,'豫F','河南省鹤壁市',''),(19,'豫G','河南省新乡市',''),(20,'豫H','河南省焦作市',''),(21,'豫J','河南省濮阳市',''),(22,'豫K','河南省许昌市',''),(23,'豫L','河南省漯河市',''),(24,'豫M','河南省三门峡市',''),(25,'豫N','河南省商丘市',''),(26,'豫P','河南省周口市',''),(27,'豫Q','河南省驻马店市',''),(28,'豫R','河南省南阳市',''),(29,'豫S','河南省信阳市',''),(30,'豫U','河南省济源市',''),(31,'云A','云南省昆明市',''),(32,'云C','云南省昭通市',''),(33,'云D','云南省曲靖市',''),(34,'云E','云南省楚雄彝族自治州',''),(35,'云F','云南省玉溪市',''),(36,'云G','云南省红河哈尼族彝族自治州',''),(37,'云H','云南省文山壮族苗族自治州',''),(38,'云J','云南省普洱市',''),(39,'云K','云南省西双版纳傣族自治州',''),(40,'云L','云南省大理白族自治州',''),(41,'云M','云南省保山市',''),(42,'云N','云南省德宏傣族景颇族自治州',''),(43,'云P','云南省丽江市',''),(44,'云Q','云南省怒江傈僳族自治州',''),(45,'云R','云南省迪庆藏族自治州',''),(46,'云S','云南省临沧市',''),(47,'辽A','辽宁省沈阳市',''),(48,'辽B','辽宁省大连市',''),(49,'辽C','辽宁省鞍山市',''),(50,'辽D','辽宁省抚顺市',''),(51,'辽E','辽宁省本溪市',''),(52,'辽F','辽宁省丹东市',''),(53,'辽G','辽宁省锦州市',''),(54,'辽H','辽宁省营口市',''),(55,'辽J','辽宁省阜新市',''),(56,'辽K','辽宁省辽阳市',''),(57,'辽L','辽宁省盘锦市',''),(58,'辽M','辽宁省铁岭市',''),(59,'辽N','辽宁省朝阳市',''),(60,'辽P','辽宁省葫芦岛市',''),(61,'黑A','黑龙江省哈尔滨市',''),(62,'黑B','黑龙江省齐齐哈尔市',''),(63,'黑C','黑龙江省牡丹江市',''),(64,'黑D','黑龙江省佳木斯市',''),(65,'黑E','黑龙江省大庆市',''),(66,'黑F','黑龙江省伊春市',''),(67,'黑G','黑龙江省鸡西市',''),(68,'黑H','黑龙江省鹤岗市',''),(69,'黑J','黑龙江省双鸭山市',''),(70,'黑K','黑龙江省七台河市',''),(71,'黑L','黑龙江省哈尔滨市',''),(72,'黑M','黑龙江省绥化市',''),(73,'黑N','黑龙江省黑河市',''),(74,'黑P','黑龙江省大兴安岭地区',''),(75,'黑R','黑龙江省垦区',''),(76,'湘A','湖南省长沙市',''),(77,'湘B','湖南省株洲市',''),(78,'湘C','湖南省湘潭市',''),(79,'湘D','湖南省衡阳市',''),(80,'湘E','湖南省邵阳市',''),(81,'湘F','湖南省岳阳市',''),(82,'湘G','湖南省张家界市',''),(83,'湘H','湖南省益阳市',''),(84,'湘J','湖南省常德市',''),(85,'湘K','湖南省娄底市',''),(86,'湘L','湖南省郴州市',''),(87,'湘M','湖南省永州市',''),(88,'湘N','湖南省怀化市',''),(89,'湘U','湖南省湘西土家族苗族自治州',''),(90,'湘S','湖南省长沙市',''),(91,'皖A','安徽省合肥市',''),(92,'皖B','安徽省芜湖市',''),(93,'皖C','安徽省蚌埠市',''),(94,'皖D','安徽省淮南市',''),(95,'皖E','安徽省马鞍山市',''),(96,'皖F','安徽省淮北市',''),(97,'皖G','安徽省铜陵市',''),(98,'皖H','安徽省安庆市',''),(99,'皖J','安徽省黄山市',''),(100,'皖K','安徽省阜阳市',''),(101,'皖L','安徽省宿州市',''),(102,'皖M','安徽省滁州市',''),(103,'皖N','安徽省六安市',''),(104,'皖P','安徽省宣城市',''),(105,'皖Q','安徽省巢湖市',''),(106,'皖R','安徽省池州市',''),(107,'皖S','安徽省亳州市',''),(108,'鲁A','山东省济南市',''),(109,'鲁B','山东省青岛市',''),(110,'鲁C','山东省淄博市',''),(111,'鲁D','山东省枣庄市',''),(112,'鲁E','山东省东营市',''),(113,'鲁F','山东省烟台市',''),(114,'鲁G','山东省潍坊市',''),(115,'鲁H','山东省济宁市',''),(116,'鲁J','山东省泰安市',''),(117,'鲁K','山东省威海市',''),(118,'鲁L','山东省日照市',''),(119,'鲁M','山东省滨州市',''),(120,'鲁N','山东省德州市',''),(121,'鲁P','山东省聊城市',''),(122,'鲁Q','山东省临沂市',''),(123,'鲁R','山东省菏泽市',''),(124,'鲁S','山东省莱芜市',''),(125,'鲁U','山东省青岛市',''),(126,'鲁V','山东省潍坊市',''),(127,'鲁Y','山东省烟台市',''),(128,'新A','新疆维吾尔乌鲁木齐市',''),(129,'新B','新疆维吾尔昌吉回族自治州',''),(130,'新C','新疆维吾尔石河子市',''),(131,'新D','新疆维吾尔伊犁哈萨克自治州',''),(132,'新E','新疆维吾尔博尔塔拉蒙古自治州',''),(133,'新F','新疆维吾尔伊犁哈萨克自治州',''),(134,'新G','新疆维吾尔塔城地区',''),(135,'新H','新疆维吾尔阿勒泰地区',''),(136,'新J','新疆维吾尔克拉玛依市',''),(137,'新K','新疆维吾尔吐鲁番地区',''),(138,'新L','新疆维吾尔哈密地区',''),(139,'新M','新疆维吾尔巴音郭愣蒙古自治州',''),(140,'新N','新疆维吾尔阿克苏地区',''),(141,'新P','新疆维吾尔克孜勒苏柯尔克孜自治州',''),(142,'新Q','新疆维吾尔喀什地区',''),(143,'新R','新疆维吾尔和田地区',''),(144,'苏A','江苏省南京市',''),(145,'苏B','江苏省无锡市',''),(146,'苏C','江苏省徐州市',''),(147,'苏D','江苏省常州市',''),(148,'苏E','江苏省苏州市',''),(149,'苏F','江苏省南通市',''),(150,'苏G','江苏省连云港市',''),(151,'苏H','江苏省淮安市',''),(152,'苏J','江苏省盐城市',''),(153,'苏K','江苏省扬州市',''),(154,'苏L','江苏省镇江市',''),(155,'苏M','江苏省泰州市',''),(156,'苏N','江苏省宿迁市',''),(157,'浙A','浙江省杭州市',''),(158,'浙B','浙江省宁波市',''),(159,'浙C','浙江省温州市',''),(160,'浙D','浙江省绍兴市',''),(161,'浙E','浙江省湖州市',''),(162,'浙F','浙江省嘉兴市',''),(163,'浙G','浙江省金华市',''),(164,'浙H','浙江省衢州市',''),(165,'浙J','浙江省台州市',''),(166,'浙K','浙江省丽水市',''),(167,'浙L','浙江省舟山市',''),(168,'赣A','江西省南昌市',''),(169,'赣B','江西省赣州市',''),(170,'赣C','江西省宜春市',''),(171,'赣D','江西省吉安市',''),(172,'赣E','江西省上饶市',''),(173,'赣F','江西省抚州市',''),(174,'赣G','江西省九江市',''),(175,'赣H','江西省景德镇市',''),(176,'赣J','江西省萍乡市',''),(177,'赣K','江西省新余市',''),(178,'赣L','江西省鹰潭市',''),(179,'赣M','江西省南昌市',''),(180,'鄂A','湖北省武汉市',''),(181,'鄂B','湖北省黄石市',''),(182,'鄂C','湖北省十堰市',''),(183,'鄂D','湖北省荆州市',''),(184,'鄂E','湖北省宜昌市',''),(185,'鄂F','湖北省襄樊市',''),(186,'鄂G','湖北省鄂州市',''),(187,'鄂H','湖北省荆门市',''),(188,'鄂J','湖北省黄冈市',''),(189,'鄂K','湖北省孝感市',''),(190,'鄂L','湖北省咸宁市',''),(191,'鄂M','湖北省仙桃市',''),(192,'鄂N','湖北省潜江市',''),(193,'鄂P','湖北省神农架林区',''),(194,'鄂Q','湖北省恩施土家族苗族自治州',''),(195,'鄂R','湖北省天门市',''),(196,'鄂S','湖北省随州市',''),(197,'桂A','广西壮族南宁市',''),(198,'桂B','广西壮族柳州市',''),(199,'桂C','广西壮族桂林市',''),(200,'桂D','广西壮族梧州市',''),(201,'桂E','广西壮族北海市',''),(202,'桂F','广西壮族崇左市',''),(203,'桂G','广西壮族来宾市',''),(204,'桂H','广西壮族桂林市',''),(205,'桂J','广西壮族贺州市',''),(206,'桂K','广西壮族玉林市',''),(207,'桂L','广西壮族百色市',''),(208,'桂M','广西壮族河池市',''),(209,'桂N','广西壮族钦州市',''),(210,'桂P','广西壮族防城港市',''),(211,'桂R','广西壮族贵港市',''),(212,'甘A','甘肃省兰州市',''),(213,'甘B','甘肃省嘉峪关市',''),(214,'甘C','甘肃省金昌市',''),(215,'甘D','甘肃省白银市',''),(216,'甘E','甘肃省天水市',''),(217,'甘F','甘肃省酒泉市',''),(218,'甘G','甘肃省张掖市',''),(219,'甘H','甘肃省武威市',''),(220,'甘J','甘肃省定西市',''),(221,'甘K','甘肃省陇南市',''),(222,'甘L','甘肃省平凉市',''),(223,'甘M','甘肃省庆阳市',''),(224,'甘N','甘肃省临夏回族自治州',''),(225,'甘P','甘肃省甘南藏族自治州',''),(226,'晋A','山西省太原市',''),(227,'晋B','山西省大同市',''),(228,'晋C','山西省阳泉市',''),(229,'晋D','山西省长治市',''),(230,'晋E','山西省晋城市',''),(231,'晋F','山西省朔州市',''),(232,'晋H','山西省忻州市',''),(233,'晋J','山西省吕梁市',''),(234,'晋K','山西省晋中市',''),(235,'晋L','山西省临汾市',''),(236,'晋M','山西省运城市',''),(237,'蒙A','内蒙古呼和浩特市',''),(238,'蒙B','内蒙古包头市',''),(239,'蒙C','内蒙古乌海市',''),(240,'蒙D','内蒙古赤峰市',''),(241,'蒙E','内蒙古呼伦贝尔市',''),(242,'蒙F','内蒙古兴安盟',''),(243,'蒙G','内蒙古通辽市',''),(244,'蒙H','内蒙古锡林郭勒盟',''),(245,'蒙J','内蒙古乌兰察布市',''),(246,'蒙K','内蒙古鄂尔多斯市',''),(247,'蒙L','内蒙古巴彦淖尔市',''),(248,'蒙M','内蒙古阿拉善盟',''),(249,'陕A','陕西省西安市',''),(250,'陕B','陕西省铜川市',''),(251,'陕C','陕西省宝鸡市',''),(252,'陕D','陕西省咸阳市',''),(253,'陕E','陕西省渭南市',''),(254,'陕F','陕西省汉中市',''),(255,'陕G','陕西省安康市',''),(256,'陕H','陕西省商洛市',''),(257,'陕J','陕西省延安市',''),(258,'陕K','陕西省榆林市',''),(259,'陕V','陕西省杨凌',''),(260,'吉A','吉林省长春市',''),(261,'吉B','吉林省吉林市',''),(262,'吉C','吉林省四平市',''),(263,'吉D','吉林省辽源市',''),(264,'吉E','吉林省通化市',''),(265,'吉F','吉林省白山市',''),(266,'吉G','吉林省白城市',''),(267,'吉H','吉林省延边朝鲜族自治州',''),(268,'吉J','吉林省松原市',''),(269,'吉K','吉林省长白山保护开发区',''),(270,'闽A','福建省福州市',''),(271,'闽B','福建省莆田市',''),(272,'闽C','福建省泉州市',''),(273,'闽D','福建省厦门市',''),(274,'闽E','福建省漳州市',''),(275,'闽F','福建省龙岩市',''),(276,'闽G','福建省三明市',''),(277,'闽H','福建省南平市',''),(278,'闽J','福建省宁德市',''),(279,'闽K','福建省福州市',''),(280,'贵A','贵州省贵阳市',''),(281,'贵B','贵州省六盘水市',''),(282,'贵C','贵州省遵义市',''),(283,'贵D','贵州省铜仁地区',''),(284,'贵E','贵州省黔西南布依族苗族自治州',''),(285,'贵F','贵州省毕节地区',''),(286,'贵G','贵州省安顺市',''),(287,'贵H','贵州省黔东南苗族侗族自治州',''),(288,'贵J','贵州省黔南布依族苗族自治州',''),(289,'粤A','广东省广州市',''),(290,'粤B','广东省深圳市',''),(291,'粤C','广东省珠海市',''),(292,'粤D','广东省汕头市',''),(293,'粤E','广东省佛山市',''),(294,'粤F','广东省韶关市',''),(295,'粤G','广东省湛江市',''),(296,'粤H','广东省肇庆市',''),(297,'粤J','广东省江门市',''),(298,'粤K','广东省茂名市',''),(299,'粤L','广东省惠州市',''),(300,'粤M','广东省梅州市',''),(301,'粤N','广东省汕尾市',''),(302,'粤P','广东省河源市',''),(303,'粤Q','广东省阳江市',''),(304,'粤R','广东省清远市',''),(305,'粤S','广东省东莞市',''),(306,'粤T','广东省中山市',''),(307,'粤U','广东省潮州市',''),(308,'粤V','广东省揭阳市',''),(309,'粤W','广东省云浮市',''),(310,'粤X','广东省佛山市',''),(311,'粤Y','广东省佛山市',''),(312,'粤Z','广东省港澳进入内地车辆',''),(313,'川A','四川省成都市',''),(314,'川B','四川省绵阳市',''),(315,'川C','四川省自贡市',''),(316,'川D','四川省攀枝花市',''),(317,'川E','四川省泸州市',''),(318,'川F','四川省德阳市',''),(319,'川H','四川省广元市',''),(320,'川J','四川省遂宁市',''),(321,'川K','四川省内江市',''),(322,'川L','四川省乐山市',''),(323,'川M','四川省资阳市',''),(324,'川N','四川省宜宾市',''),(325,'川P','四川省宜宾市',''),(326,'川Q','四川省宜宾市',''),(327,'川R','四川省南充市',''),(328,'川S','四川省达州市',''),(329,'川T','四川省雅安市',''),(330,'川U','四川省阿坝藏族羌族自治州',''),(331,'川V','四川省甘孜藏族自治州',''),(332,'川W','四川省凉山彝族自治州',''),(333,'川X','四川省广安市',''),(334,'川Y','四川省巴中市',''),(335,'川Z','四川省眉山市',''),(336,'青A','青海省西宁市',''),(337,'青B','青海省海东市',''),(338,'青C','青海省海北藏族自治州',''),(339,'青D','青海省黄南藏族自治州',''),(340,'青E','青海省海南藏族自治州',''),(341,'青F','青海省果洛藏族自治州',''),(342,'青G','青海省玉树藏族自治州',''),(343,'青H','青海省海西蒙古族藏族自治州',''),(344,'藏A','西藏拉萨市',''),(345,'藏B','西藏昌都地区',''),(346,'藏C','西藏山南地区',''),(347,'藏D','西藏日喀则地区',''),(348,'藏E','西藏那曲地区',''),(349,'藏F','西藏阿里地区',''),(350,'藏G','西藏林芝地区',''),(351,'藏H','西藏四川双流',''),(352,'藏J','西藏青海格尔木',''),(353,'琼A','海南省海口市',''),(354,'琼B','海南省三亚市',''),(355,'琼C','海南省琼北',''),(356,'琼D','海南省琼南',''),(357,'琼E','海南省洋浦经济开发区',''),(358,'宁A','宁夏回族银川市',''),(359,'宁B','宁夏回族石嘴山市',''),(360,'宁C','宁夏回族吴忠市',''),(361,'宁D','宁夏回族固原市',''),(362,'宁E','宁夏回族中卫市',''); /*!40000 ALTER TABLE `plate_no_city_ref` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-07-06 14:05:15