-- MySQL dump 10.13  Distrib 8.0.23, for Linux (x86_64)
--
-- Host: localhost    Database: ehs
-- ------------------------------------------------------
-- Server version	8.0.23

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cp_area`
--

DROP TABLE IF EXISTS `cp_area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cp_area` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
  `parent_id` int unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `sort` int unsigned NOT NULL DEFAULT '0' COMMENT '排序 由小到大',
  `level` smallint unsigned NOT NULL DEFAULT '1' COMMENT '级别',
  `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '状态 1:正常 2:删除',
  `createtime` bigint unsigned NOT NULL COMMENT '创建时间',
  `lasttime` bigint unsigned DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cp_area`
--

LOCK TABLES `cp_area` WRITE;
/*!40000 ALTER TABLE `cp_area` DISABLE KEYS */;
INSERT INTO `cp_area` VALUES (3,'国家',0,1,1,1,1651292623939,1652518646943),(4,'安徽',3,1,2,1,1651292636052,NULL),(5,'安庆',4,1,3,2,1651292667508,1657533574351),(6,'马鞍山',4,1,3,2,1651292675348,1657533576785),(7,'滁州',4,1,3,2,1651292684570,1657533579380),(8,'北京',3,1,2,2,1651292703497,1655706072714),(9,'重庆',3,1,2,2,1651292713866,1655706070743),(10,'福建',3,1,2,2,1651292722855,1651292805684),(11,'厦门',10,1,3,2,1651292731617,1651292800965),(12,'漳州',10,1,3,2,1651292742297,1651292797533),(13,'广东',3,1,2,2,1651292763622,1651292789526),(14,'福建',3,1,2,1,1651292896728,1651292913790),(15,'厦门',14,1,3,1,1651292924765,NULL),(16,'漳州',14,1,3,2,1651292934394,1657682405279),(17,'广东',3,1,2,1,1651292943774,NULL),(18,'广州',17,1,3,1,1651292956934,NULL),(19,'佛山',17,1,3,1,1651292968239,NULL),(20,'东莞',17,1,3,1,1651292974428,NULL),(21,'珠海',17,1,3,2,1651292981450,1657533469977),(22,'深圳',17,1,3,2,1651292987113,1657533465421),(23,'江门',17,1,3,2,1651292995895,1657533458252),(24,'云浮',17,1,3,2,1651293002117,1657533455617),(25,'广西',3,1,2,2,1651293042545,1657524436240),(26,'贵州',3,1,2,2,1651293093526,1657524439115),(27,'贵阳',26,1,3,1,1651293108113,NULL),(28,'湖北',3,1,1,1,1651293191260,NULL),(29,'武汉',28,1,2,1,1651293205448,NULL),(30,'宜昌',28,1,2,1,1651293218651,NULL),(31,'随州',28,1,2,2,1651293226096,1657533418597),(32,'黄冈',28,1,2,2,1651293236892,1657533415064),(33,'河北',3,1,2,1,1651293311825,NULL),(34,'邯郸',33,1,3,1,1651303694384,NULL),(35,'廊坊',33,1,3,1,1651303703479,NULL),(36,'黑龙江',3,1,2,2,1651303712370,1655706066470),(37,'河南',3,1,2,1,1651303728722,NULL),(38,'郑州',37,1,3,1,1651303739848,NULL),(39,'驻马店',37,1,3,2,1651303747915,1657533597323),(40,'南阳',37,1,3,2,1651303756024,1657533594866),(41,'洛阳',37,1,3,2,1651303765209,1657533592142),(42,'湖南',3,1,2,2,1651303772161,1657524511780),(43,'长沙',42,1,3,1,1651303797588,NULL),(44,'吉林',3,1,1,2,1651303808264,1657524430940),(45,'吉林市',44,1,2,1,1651303881318,1651303899170),(46,'江苏',3,1,2,1,1651303952740,NULL),(47,'南京',46,1,3,1,1651303961209,NULL),(48,'苏州',46,1,3,1,1651303968997,NULL),(49,'南通',46,1,3,1,1651303975356,NULL),(50,'扬州',46,1,3,2,1651303981964,1657533522272),(51,'常州',46,1,3,2,1651303989430,1657533532478),(52,'连云港',46,1,3,2,1651304004294,1657533529910),(53,'无锡',46,1,3,2,1651304010811,1657533537690),(54,'徐州',46,1,3,2,1651304016946,1657533526096),(55,'江西',3,1,2,2,1651304025318,1657524448163),(56,'辽宁',3,1,2,2,1651304053423,1657524452745),(57,'沈阳',56,1,3,1,1651304070919,NULL),(58,'葫芦岛',56,1,3,1,1651304079079,NULL),(59,'丹东',56,1,3,1,1651304086843,NULL),(60,'四川',3,1,2,1,1651304095570,NULL),(61,'成都',60,1,3,1,1651304103875,NULL),(62,'德阳',60,1,3,2,1651304112128,1657533440094),(63,'山东',3,1,2,1,1651304128291,NULL),(64,'青岛',63,1,3,1,1651304135390,NULL),(65,'潍坊',63,1,3,2,1651304149550,1657533369737),(66,'日照',63,1,3,2,1651304156105,1657533372512),(67,'聊城',63,1,3,2,1651304163165,1657533375091),(68,'临沂',63,1,3,2,1651304191087,1657533381566),(69,'陕西',3,1,2,2,1651304218276,1657524458541),(70,'西安',69,1,3,1,1651304225510,NULL),(71,'山西',3,1,2,2,1651304236856,1657524485890),(72,'运城',71,1,3,1,1651304247456,NULL),(73,'上海',3,1,2,1,1651304254602,NULL),(74,'天津',3,1,2,2,1651304262931,1655706063209),(75,'浙江',3,1,2,1,1651304268249,NULL),(76,'杭州',75,1,3,1,1651304276121,NULL),(77,'宁波',75,1,3,2,1651304282367,1657682479755),(78,'湖州',75,1,3,2,1651304288435,1657682482339),(79,'年终总结2',28,1,2,2,1655279780008,1655279795334),(80,'上海',3,1,2,2,1655288014742,1655288074145),(81,'上海市',73,1,3,2,1655288056639,1657533320199),(82,'甘肃',0,1,1,2,1655623234486,1655628267053),(83,'甘肃',0,1,1,2,1655628283188,1655628417858),(84,'甘肃',3,1,2,2,1655628439246,1655706060900),(85,'天津',3,1,2,1,1657295882058,NULL),(86,'宁波',75,1,3,1,1658195927942,NULL),(87,'扬州',46,1,3,1,1661152286792,NULL),(88,'深圳',17,1,3,1,1661242121552,NULL),(89,'广西',0,1,1,2,1661847058809,1661847250190),(90,'广西',3,1,2,1,1661847261056,NULL),(91,'辽宁',3,1,2,1,1661853638797,NULL),(92,'北京',3,1,2,1,1661853681211,NULL),(93,'重庆',3,1,2,1,1661920853505,NULL);
/*!40000 ALTER TABLE `cp_area` 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 2023-05-25  7:50:04
