Springboot校园微信小程序作业辅导系统.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: springboot97wec92x -- ------------------------------------------------------ -- 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 */; -- -- Current Database: `springboot97wec92x` -- /*!40000 DROP DATABASE IF EXISTS `springboot97wec92x`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboot97wec92x` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `springboot97wec92x`; -- -- 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 '配置参数值', `url` varchar(500) DEFAULT NULL COMMENT 'url', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 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','upload/1712318000327.jpg',NULL),(2,'picture2','upload/picture2.jpg',NULL),(3,'picture3','upload/picture3.jpg',NULL); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discusskechengxinxi` -- DROP TABLE IF EXISTS `discusskechengxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discusskechengxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `refid` bigint(20) NOT NULL COMMENT '关联表id', `userid` bigint(20) NOT NULL COMMENT '用户id', `avatarurl` longtext COMMENT '头像', `nickname` varchar(200) DEFAULT NULL COMMENT '用户名', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='课程信息评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discusskechengxinxi` -- LOCK TABLES `discusskechengxinxi` WRITE; /*!40000 ALTER TABLE `discusskechengxinxi` DISABLE KEYS */; INSERT INTO `discusskechengxinxi` VALUES (1,'2024-04-05 11:56:50',39,1712318059807,'upload/1712318053902.jpg','001','<p>测试测试测试</p>','<p>测试666</p>'); /*!40000 ALTER TABLE `discusskechengxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `forum` -- DROP TABLE IF EXISTS `forum`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `forum` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) DEFAULT NULL COMMENT '帖子标题', `content` longtext NOT NULL COMMENT '帖子内容', `parentid` bigint(20) DEFAULT NULL COMMENT '父节点id', `userid` bigint(20) NOT NULL COMMENT '用户id', `username` varchar(200) DEFAULT NULL COMMENT '用户名', `avatarurl` longtext COMMENT '头像', `isdone` varchar(200) DEFAULT NULL COMMENT '状态', `istop` int(11) DEFAULT '0' COMMENT '是否置顶', `toptime` datetime DEFAULT NULL COMMENT '置顶时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='在线论坛'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `forum` -- LOCK TABLES `forum` WRITE; /*!40000 ALTER TABLE `forum` DISABLE KEYS */; INSERT INTO `forum` VALUES (91,'2024-04-05 11:26:48','帖子标题1','帖子内容1',0,1,'用户名1','upload/forum_avatarurl1.jpg,upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg','开放',0,'2024-04-05 19:26:48'),(92,'2024-04-05 11:26:48','帖子标题2','帖子内容2',0,2,'用户名2','upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg','开放',0,'2024-04-05 19:26:48'),(93,'2024-04-05 11:26:48','帖子标题3','帖子内容3',0,3,'用户名3','upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg','开放',0,'2024-04-05 19:26:48'),(94,'2024-04-05 11:26:48','帖子标题4','帖子内容4',0,4,'用户名4','upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg','开放',0,'2024-04-05 19:26:48'),(95,'2024-04-05 11:26:48','帖子标题5','帖子内容5',0,5,'用户名5','upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg','开放',0,'2024-04-05 19:26:48'),(96,'2024-04-05 11:26:48','帖子标题6','帖子内容6',0,6,'用户名6','upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg','开放',0,'2024-04-05 19:26:48'),(97,'2024-04-05 11:26:48','帖子标题7','帖子内容7',0,7,'用户名7','upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg','开放',0,'2024-04-05 19:26:48'),(99,'2024-04-05 11:58:14','测试','<p>测试测试测试</p>',0,1712318059807,'001',NULL,'开放',0,'2024-04-05 19:57:49'); /*!40000 ALTER TABLE `forum` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jiaoshi` -- DROP TABLE IF EXISTS `jiaoshi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jiaoshi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `jiaoshizhanghao` varchar(200) NOT NULL COMMENT '教师账号', `jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名', `mima` varchar(200) NOT NULL COMMENT '密码', `xingbie` varchar(200) DEFAULT NULL COMMENT '性别', `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式', `jiaoshijianjie` varchar(200) DEFAULT NULL COMMENT '教师简介', `zhaopian` longtext COMMENT '照片', PRIMARY KEY (`id`), UNIQUE KEY `jiaoshizhanghao` (`jiaoshizhanghao`) ) ENGINE=InnoDB AUTO_INCREMENT=1712317949159 DEFAULT CHARSET=utf8 COMMENT='教师'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jiaoshi` -- LOCK TABLES `jiaoshi` WRITE; /*!40000 ALTER TABLE `jiaoshi` DISABLE KEYS */; INSERT INTO `jiaoshi` VALUES (21,'2024-04-05 11:26:48','教师账号1','教师姓名1','123456','男','13823888881','教师简介1','upload/jiaoshi_zhaopian1.jpg'),(22,'2024-04-05 11:26:48','教师账号2','教师姓名2','123456','男','13823888882','教师简介2','upload/jiaoshi_zhaopian2.jpg'),(23,'2024-04-05 11:26:48','教师账号3','教师姓名3','123456','男','13823888883','教师简介3','upload/jiaoshi_zhaopian3.jpg'),(24,'2024-04-05 11:26:48','教师账号4','教师姓名4','123456','男','13823888884','教师简介4','upload/jiaoshi_zhaopian4.jpg'),(25,'2024-04-05 11:26:48','教师账号5','教师姓名5','123456','男','13823888885','教师简介5','upload/jiaoshi_zhaopian5.jpg'),(26,'2024-04-05 11:26:48','教师账号6','教师姓名6','123456','男','13823888886','教师简介6','upload/jiaoshi_zhaopian6.jpg'),(27,'2024-04-05 11:26:48','教师账号7','教师姓名7','123456','男','13823888887','教师简介7','upload/jiaoshi_zhaopian7.jpg'),(28,'2024-04-05 11