代码拉取完成,页面将自动刷新
-- MySQL dump 10.13 Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: wenjianguanli
-- ------------------------------------------------------
-- Server version 8.0.13
/*!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 */;
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 `account_request`
--
DROP TABLE IF EXISTS `account_request`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `account_request` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`accountType` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`content` text COLLATE utf8_bin,
`status` int(10) DEFAULT NULL COMMENT '0代表未受理,1代表同意,2代表拒绝注册',
`username` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`password` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`nickName` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`sex` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`age` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`phone` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`email` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`level` varchar(45) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='账号注册申请';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account_request`
--
LOCK TABLES `account_request` WRITE;
/*!40000 ALTER TABLE `account_request` DISABLE KEYS */;
INSERT INTO `account_request` VALUES (1,'user','我是user33',1,'user1','123456','用户1','男','1','134555512','23123@qq.com','2'),(3,'filer','hello',2,'filer1','123456','文管2','男','32','12327772','21312@163.com','3'),(4,'filer','filer2',1,'filer2','filer2','filer2','男',NULL,'13145125','21312@qq.com','3'),(5,'filer','filer3',1,'filer3','filer3','filer3','男',NULL,'137723727','12367218@163.com','3'),(6,'filer','user2',1,'user2','user2','user2','男',NULL,'123213123','123213@qq.com','2'),(7,'filer','user2',0,'user2','user2','user2','男',NULL,'123213123','123213@qq.com','2'),(8,'filer','user2',0,'user2','user2','user2','男',NULL,'12345623','sdfds@qq.com','2'),(10,'filer','user4',1,'user4','user4','user4','男',NULL,'','','2'),(11,'filer','user5',0,'user5','user5','user5','男',NULL,'','','2'),(12,'user','user5',0,'user5','user5','user5','男',NULL,'','','2'),(13,'filer','filer4',0,'filer4','filer4','filer4','男',NULL,'','','3'),(14,'user','user2',1,'user2','123456','user2','男',NULL,'','','2');
/*!40000 ALTER TABLE `account_request` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_info`
--
DROP TABLE IF EXISTS `admin_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `admin_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
`nickName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
`sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
`age` int(10) DEFAULT NULL COMMENT '年龄',
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号',
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
`level` int(10) NOT NULL DEFAULT '1' COMMENT '权限等级',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_info`
--
LOCK TABLES `admin_info` WRITE;
/*!40000 ALTER TABLE `admin_info` DISABLE KEYS */;
INSERT INTO `admin_info` VALUES (1,'admin','e10adc3949ba59abbe56e057f20f883e','管理员','男',22,'18843232356','aa@163.com',1),(2,'admin2','e10adc3949ba59abbe56e057f20f883e','管理员','男',23,'18843232356','bb@163.com',1),(3,'admin3','e10adc3949ba59abbe56e057f20f883e','管理员','女',32,'18843232356','cc@163.com',1);
/*!40000 ALTER TABLE `admin_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_info`
--
DROP TABLE IF EXISTS `file_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `file_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名称',
`time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '上传时间',
`typeId` bigint(20) DEFAULT NULL COMMENT '文件分类id',
`fileId` bigint(20) DEFAULT NULL COMMENT '文件id',
`fileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名',
`userName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '上传人',
`level` int(10) DEFAULT NULL COMMENT '用户等级',
`uploadUserId` bigint(20) DEFAULT NULL COMMENT '用户id',
`diretion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '相关方向',
`department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来报单位',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='文件信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_info`
--
LOCK TABLES `file_info` WRITE;
/*!40000 ALTER TABLE `file_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `file_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `filer_info`
--
DROP TABLE IF EXISTS `filer_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `filer_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
`nickName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
`sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
`age` int(10) DEFAULT NULL COMMENT '年龄',
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号',
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
`level` int(10) NOT NULL DEFAULT '1' COMMENT '权限等级',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='文件管理员信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `filer_info`
--
LOCK TABLES `filer_info` WRITE;
/*!40000 ALTER TABLE `filer_info` DISABLE KEYS */;
INSERT INTO `filer_info` VALUES (1,'filer1','e10adc3949ba59abbe56e057f20f883e','小飞','男',32,NULL,NULL,3),(2,'filer2','f0a39847b99a40d1a9453b110edeef13','filer2','男',NULL,'13145125','21312@qq.com',3),(3,'user4','3f02ebe3d7929b091e3d8ccfde2f3bc6','user4','男',NULL,'','',2),(4,'filer3','0bf3f3f4b293c7adce64225c5c81e99f','filer3','男',NULL,'137723727','12367218@163.com',3);
/*!40000 ALTER TABLE `filer_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nx_system_file_info`
--
DROP TABLE IF EXISTS `nx_system_file_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `nx_system_file_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`originName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '原始文件名',
`fileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '存储文件名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='文件信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nx_system_file_info`
--
LOCK TABLES `nx_system_file_info` WRITE;
/*!40000 ALTER TABLE `nx_system_file_info` DISABLE KEYS */;
INSERT INTO `nx_system_file_info` VALUES (18,'基于SOA动态框架实现方案的探讨_粟圣森.pdf','基于SOA动态框架实现方案的探讨_粟圣森1626618730287.pdf'),(19,'linux安装.pptx','linux安装1626621553582.pptx'),(21,'53a7d0fce37b5.jpg','53a7d0fce37b51626623951168.jpg'),(22,'57c1466d6e8e4.jpg','57c1466d6e8e41626624431658.jpg'),(23,'附件1:TXT报文.txt','附件1:TXT报文1626705302871.txt'),(24,'附件1:TXT报文.txt','附件1:TXT报文1626705432478.txt'),(25,'附件1:TXT报文.txt','附件1:TXT报文1626705636881.txt'),(26,'附件1:TXT报文.txt','附件1:TXT报文1626705696544.txt'),(28,'附件1:TXT报文.txt','附件1:TXT报文1626706293031.txt'),(31,'附件1:TXT报文.txt','附件1:TXT报文1626706624612.txt'),(33,'附件1:TXT报文.txt','附件1:TXT报文1626707210478.txt'),(34,'附件1:TXT报文.txt','附件1:TXT报文1626707345444.txt'),(35,'附件2:20210525第XX期每日要情(总XXX期).docx','附件2:20210525第XX期每日要情(总XXX期)1626708262660.docx'),(36,'附件1:TXT报文.txt','附件1:TXT报文1626708666985.txt'),(37,'附件1:TXT报文.txt','附件1:TXT报文1626708992193.txt'),(38,'附件1:TXT报文.txt','附件1:TXT报文1626711586962.txt'),(39,'附件1:TXT报文.txt','附件1:TXT报文1626711684711.txt'),(40,'附件1:TXT报文.txt','附件1:TXT报文1626712199708.txt'),(41,'附件1:TXT报文.txt','附件1:TXT报文1626712413414.txt'),(42,'附件1:TXT报文.txt','附件1:TXT报文1626712664459.txt'),(43,'附件1:TXT报文.txt','附件1:TXT报文1626712762390.txt'),(44,'附件1:TXT报文.txt','附件1:TXT报文1626713352928.txt'),(45,'附件1:TXT报文.txt','附件1:TXT报文1626713441666.txt'),(46,'附件1:TXT报文.txt','附件1:TXT报文1626713648530.txt'),(47,'附件1:TXT报文2.txt','附件1:TXT报文21626766288741.txt'),(48,'附件1:TXT报文.txt','附件1:TXT报文1626770632592.txt'),(49,'附件1:TXT报文2.txt','附件1:TXT报文21626770741971.txt'),(50,'附件1:TXT报文2.txt','附件1:TXT报文21626770923261.txt'),(51,'附件1:TXT报文2.txt','附件1:TXT报文21626771097084.txt'),(52,'附件1:TXT报文2.txt','附件1:TXT报文21626771476229.txt'),(53,'接口表.docx','接口表1626775955526.docx'),(54,'接口表.docx','接口表1626776051471.docx'),(55,'文件门户网站需求的基本考虑.docx','文件门户网站需求的基本考虑1626776061930.docx'),(56,'附件1:TXT报文2.txt','附件1:TXT报文21626793801231.txt'),(57,'附件1:TXT报文2.txt','附件1:TXT报文21626793905834.txt'),(58,'附件1:TXT报文2.txt','附件1:TXT报文21626793954994.txt'),(59,'附件1:TXT报文.txt','附件1:TXT报文1626794028867.txt'),(62,'附件1:TXT报文2.txt','附件1:TXT报文21626796481958.txt'),(63,'附件1:TXT报文2.txt','附件1:TXT报文21626796969734.txt'),(64,'附件1:TXT报文2.txt','附件1:TXT报文21626797068087.txt'),(65,'附件1:TXT报文.txt','附件1:TXT报文1626797378514.txt'),(66,'附件1:TXT报文2.txt','附件1:TXT报文21626797503978.txt'),(67,'附件1:TXT报文2.txt','附件1:TXT报文21626797637749.txt'),(68,'附件1:TXT报文2.txt','附件1:TXT报文21626797714956.txt'),(69,'附件1:TXT报文2.txt','附件1:TXT报文21626797835264.txt'),(70,'附件1:TXT报文2.txt','附件1:TXT报文21626798223126.txt'),(71,'附件1:TXT报文2.txt','附件1:TXT报文21626798784583.txt'),(72,'附件1:TXT报文2.txt','附件1:TXT报文21626798869423.txt'),(74,'附件1:TXT报文2.txt','附件1:TXT报文21626799862543.txt'),(75,'附件1:TXT报文2.txt','附件1:TXT报文21626800374318.txt'),(76,'附件1:TXT报文3.txt','附件1:TXT报文31626800500698.txt'),(77,'附件1:TXT报文.txt','附件1:TXT报文1626827834453.txt'),(78,'附件1:TXT报文2.txt','附件1:TXT报文21626827907764.txt'),(79,'附件1:TXT报文2.txt','附件1:TXT报文21626828210221.txt'),(80,'附件1:TXT报文3.txt','附件1:TXT报文31626828908401.txt');
/*!40000 ALTER TABLE `nx_system_file_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `txt_report`
--
DROP TABLE IF EXISTS `txt_report`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `txt_report` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reporterName` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`organization` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`area` text COLLATE utf8_bin,
`happentime` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`accident` text COLLATE utf8_bin,
`effect` text COLLATE utf8_bin,
`fileId` int(11) DEFAULT NULL,
`username` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`userid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='txt报文报告';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `txt_report`
--
LOCK TABLES `txt_report` WRITE;
/*!40000 ALTER TABLE `txt_report` DISABLE KEYS */;
INSERT INTO `txt_report` VALUES (1,'广工小订','广工','广州','2021.05.30-20:06','广工出现雷暴雨','变成了供液大学',79,'user1',13),(2,'广工小飞','广工','广州','2021.05.30-20:06','广工出现UFO','出现外星人!',80,'user1',13);
/*!40000 ALTER TABLE `txt_report` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `type_info`
--
DROP TABLE IF EXISTS `type_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `type_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='文件分类信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `type_info`
--
LOCK TABLES `type_info` WRITE;
/*!40000 ALTER TABLE `type_info` DISABLE KEYS */;
INSERT INTO `type_info` VALUES (1,'基本资料'),(2,'专题报告'),(3,'综合研究'),(4,'重要图册'),(5,'重要动向'),(6,'一级文件');
/*!40000 ALTER TABLE `type_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_info`
--
DROP TABLE IF EXISTS `user_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `user_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
`nickName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
`sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
`age` int(10) DEFAULT NULL COMMENT '年龄',
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号',
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
`level` int(10) NOT NULL DEFAULT '2' COMMENT '权限等级',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='用户信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_info`
--
LOCK TABLES `user_info` WRITE;
/*!40000 ALTER TABLE `user_info` DISABLE KEYS */;
INSERT INTO `user_info` VALUES (1,'黄小飞','e10adc3949ba59abbe56e057f20f883e','老张','男',22,'18843232356','aa@163.com',2),(2,'赵千里','e10adc3949ba59abbe56e057f20f883e','老赵','男',23,'18843232356','bb@163.com',2),(3,'钱优优','e10adc3949ba59abbe56e057f20f883e','老钱','女',32,'18843232356','cc@163.com',2),(13,'user1','e10adc3949ba59abbe56e057f20f883e','用户1','男',1,'134555512','23123@qq.com',2),(15,'filer2','f0a39847b99a40d1a9453b110edeef13','filer2','男',NULL,'13145125','21312@qq.com',3),(16,'user2','e10adc3949ba59abbe56e057f20f883e','user2','男',NULL,'','',2);
/*!40000 ALTER TABLE `user_info` 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 2021-09-05 10:23:42
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。