ssm高校四六级报名管理系统.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: jspm9lq7g -- ------------------------------------------------------ -- Server version 5.7.31 /*!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 `baomingjilu` -- DROP TABLE IF EXISTS `baomingjilu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `baomingjilu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `kaoshibianhao` varchar(200) DEFAULT NULL COMMENT '考试编号', `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '项目名称', `leibie` varchar(200) DEFAULT NULL COMMENT '类别', `baokaojiage` int(11) DEFAULT NULL COMMENT '报考价格', `kaoshishijian` varchar(200) DEFAULT NULL COMMENT '考试时间', `kaoshididian` varchar(200) DEFAULT NULL COMMENT '考试地点', `xuehao` varchar(200) DEFAULT NULL COMMENT '学号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `xueyuan` varchar(200) DEFAULT NULL COMMENT '学院', `banji` varchar(200) DEFAULT NULL COMMENT '班级', `baomingshijian` datetime DEFAULT NULL COMMENT '报名时间', `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核', `shhf` longtext COMMENT '审核回复', `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1617704821205 DEFAULT CHARSET=utf8 COMMENT='报名记录'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `baomingjilu` -- LOCK TABLES `baomingjilu` WRITE; /*!40000 ALTER TABLE `baomingjilu` DISABLE KEYS */; INSERT INTO `baomingjilu` VALUES (31,'2021-04-06 10:22:19','考试编号1','项目名称1','类别1',1,'考试时间1','考试地点1','学号1','姓名1','学院1','班级1','2021-04-06 18:22:19','是','','未支付'),(32,'2021-04-06 10:22:19','考试编号2','项目名称2','类别2',2,'考试时间2','考试地点2','学号2','姓名2','学院2','班级2','2021-04-06 18:22:19','是','','未支付'),(33,'2021-04-06 10:22:19','考试编号3','项目名称3','类别3',3,'考试时间3','考试地点3','学号3','姓名3','学院3','班级3','2021-04-06 18:22:19','是','','未支付'),(34,'2021-04-06 10:22:19','考试编号4','项目名称4','类别4',4,'考试时间4','考试地点4','学号4','姓名4','学院4','班级4','2021-04-06 18:22:19','是','','未支付'),(35,'2021-04-06 10:22:19','考试编号5','项目名称5','类别5',5,'考试时间5','考试地点5','学号5','姓名5','学院5','班级5','2021-04-06 18:22:19','是','','未支付'),(36,'2021-04-06 10:22:19','考试编号6','项目名称6','类别6',6,'考试时间6','考试地点6','学号6','姓名6','学院6','班级6','2021-04-06 18:22:19','是','','未支付'),(1617704821204,'2021-04-06 10:27:01','1617704668','上半年四级考试','四级',36,'2021-04-22','XX大学XX地点','1','1','XXX学院','XX班级','2021-04-06 18:26:56','是','报名成功','已支付'); /*!40000 ALTER TABLE `baomingjilu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat` -- DROP TABLE IF EXISTS `chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id', `ask` longtext COMMENT '提问', `reply` longtext COMMENT '回复', `isreply` int(11) DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1617704854826 DEFAULT CHARSET=utf8 COMMENT='客服咨询'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat` -- LOCK TABLES `chat` WRITE; /*!40000 ALTER TABLE `chat` DISABLE KEYS */; INSERT INTO `chat` VALUES (61,'2021-04-06 10:22:19',1,1,'‍提问1\r\n','客服回复\r\n',0),(62,'2021-04-06 10:22:19',2,2,'提问2','回复2',2),(63,'2021-04-06 10:22:19',3,3,'提问3','回复3',3),(64,'2021-04-06 10:22:19',4,4,'提问4','回复4',4),(65,'2021-04-06 10:22:19',5,5,'提问5','回复5',5),(66,'2021-04-06 10:22:19',6,6,'提问6','回复6',6),(1617704854825,'2021-04-06 10:27:34',1617704789869,NULL,'‍客服咨询\r\n','客服回复测试\r\n',0); /*!40000 ALTER TABLE `chat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config` -- LOCK TABLES `config` WRITE; /*!40000 ALTER TABLE `config` DISABLE KEYS */; INSERT INTO `config` VALUES (1,'picture1','http://localhost:8080/jspm9lq7g/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/jspm9lq7g/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/jspm9lq7g/upload/picture3.jpg'),(6,'homepage',NULL); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `news` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) NOT NULL COMMENT '标题', `introduction` longtext COMMENT '简介', `picture` varchar(200) NOT NULL COMMENT '图片', `content` longtext NOT NULL COMMENT '内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='考试资讯'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; INSERT INTO `news` VALUES (71,'2021-04-06 10:22:19','标题1','简介1','http://localhost:8080/jspm9lq7g/upload/news_picture1.jpg','内容1'),(72,'2021-04-06 10:22:19','标题2','简介2','http://localhost:8080/jspm9lq7g/upload/news_picture2.jpg','内容2'),(73,'2021-04-06 10:22:19','标题3','简介3','http://localhost:8080/jspm9lq7g/upload/news_picture3.jpg','内容3'),(74,'2021-04-06 10:22:19','标题4','简介4','http://localhost:8080/jspm9lq7g/upload/news_picture4.jpg','内容4'),(75,'2021-04-06 10:22:19','标题5','简介5','http://localhost:8080/jspm9lq7g/upload/news_picture5.jpg','内容5'),(76,'2021-04-06 10:22:19','标题6','简介6','http://localhost:8080/jspm9lq7g/upload/news_picture6.jpg','内容6'); /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `shenfenzhengrenzheng` -- DROP TABLE IF EXISTS `shenfenzhengrenzheng`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shenfenzhengrenzheng` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` time