text: -- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
  --
  -- Host: localhost    Database: oa_sys
  -- ------------------------------------------------------
  -- Server version	5.7.17-log
  
  /*!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 `sys_provice`
  --
  
  DROP TABLE IF EXISTS `sys_provice`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `sys_provice` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `provice_id` int(11) unsigned NOT NULL COMMENT '省份id、省份编号',
    `provice_name` char(32) NOT NULL COMMENT '省份名称',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `provice_id` (`provice_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='省份表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `sys_provice`
  --
  
  LOCK TABLES `sys_provice` WRITE;
  /*!40000 ALTER TABLE `sys_provice` DISABLE KEYS */;
  INSERT INTO `sys_provice` VALUES (1,110,'北京市'),(2,120,'天津市'),(3,130,'河北省'),(4,140,'山西省'),(5,150,'内蒙古自治区'),(6,210,'辽宁省'),(7,220,'吉林省'),(8,230,'黑龙江省'),(9,310,'上海市'),(10,320,'江苏省'),(11,330,'浙江省'),(12,340,'安徽省'),(13,350,'福建省'),(14,360,'江西省'),(15,370,'山东省'),(16,410,'河南省'),(17,420,'湖北省'),(18,430,'湖南省'),(19,440,'广东省'),(20,450,'广西壮族自治区'),(21,460,'海南省'),(22,500,'重庆市'),(23,510,'四川省'),(24,520,'贵州省'),(25,530,'云南省'),(26,540,'西藏自治区'),(27,610,'陕西省'),(28,620,'甘肃省'),(29,630,'青海省'),(30,640,'宁夏回族自治区'),(31,650,'新疆维吾尔自治区');
  /*!40000 ALTER TABLE `sys_provice` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2020-01-15  9:40:53
  