900字范文 > 基于微信小程序的英语互助考试兴趣小组平台springboot-JAVA【数据库设计论文源码

基于微信小程序的英语互助考试兴趣小组平台springboot-JAVA【数据库设计论文源码

时间：2022-08-19 02:30:47

功能介绍

本系统采用SpringBoot框架、Java语言以及微信小程序技术、MySQL数据库进行设计，实现：

（1）用户信息管理，对用户信息新增和修改、删除；

（2）兴趣小组管理，管理员添加、删除、修改兴趣小组，用户审核加入小组；

（3）小组打卡管理，管理员添加、删除、修改小组打卡信息，用户进行打卡；

（4）试卷信息管理，管理员组织新试卷、修改有问题的试卷、删除试卷等，用户选择试卷进行在线测试；

（5）主题资讯管理，管理员添加、修改、删除主题资讯，用户浏览主题资讯；

（6）学习讨论管理，管理员审核学习讨论的内容，用户发布讨论信息。

使用技术

使用框架：springboot

开发语言：Java、小程序，

前端技术：JavaScript、VUE.js（2.X）、css3

框架：springboot，JDK版本：JDK1.8 ，

服务器：tomcat9 ，

数据库：mysql 5.7，

数据库工具：Navicat11，

开发软件：eclipse/myeclipse/idea，

浏览器：谷歌浏览器，

小程序运行软件：微信开发者

数据库脚本

/*SQLyog Ultimate v11.3 (64 bit)MySQL - 5.7.32-log : Database - yingyuhuzhuxiaochengxu**********************************************************************//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!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 */;CREATE DATABASE /*!32312 IF NOT EXISTS*/`yingyuhuzhuxiaochengxu` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `yingyuhuzhuxiaochengxu`;/*Table structure for table `chat` */DROP TABLE IF EXISTS `chat`;CREATE TABLE `chat` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`yonghu_id` int(11) DEFAULT NULL COMMENT '提问用户',`chat_issue` varchar(200) DEFAULT NULL COMMENT '问题',`issue_time` timestamp NULL DEFAULT NULL COMMENT '问题时间 Search111',`chat_reply` varchar(200) DEFAULT NULL COMMENT '回复',`reply_time` timestamp NULL DEFAULT NULL COMMENT '回复时间 Search111',`zhuangtai_types` int(255) DEFAULT NULL COMMENT '状态',`chat_types` int(11) DEFAULT NULL COMMENT '数据类型',`insert_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='客服聊天';/*Data for the table `chat` */insert into `chat`(`id`,`yonghu_id`,`chat_issue`,`issue_time`,`chat_reply`,`reply_time`,`zhuangtai_types`,`chat_types`,`insert_time`) values (1,1,'112233',NULL,NULL,NULL,1,1,'-03-28 09:28:40'),(2,1,'管理在后台可以回复',NULL,NULL,NULL,1,1,'-03-28 09:28:52');/*Table structure for table `config` */DROP TABLE IF EXISTS `config`;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=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';/*Data for the table `config` */insert into `config`(`id`,`name`,`value`) values (1,'轮播图1','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/config1.jpg'),(2,'轮播图2','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/config2.jpg'),(3,'轮播图3','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/config3.jpg');/*Table structure for table `dictionary` */DROP TABLE IF EXISTS `dictionary`;CREATE TABLE `dictionary` (`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`dic_code` varchar(200) DEFAULT NULL COMMENT '字段',`dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',`code_index` int(11) DEFAULT NULL COMMENT '编码',`index_name` varchar(200) DEFAULT NULL COMMENT '编码名字 Search111 ',`super_id` int(11) DEFAULT NULL COMMENT '父字段id',`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='字典表';/*Data for the table `dictionary` */insert into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`beizhu`,`create_time`) values (1,'xingquxiaozu_types','小组类型',1,'小组类型1',NULL,NULL,'-03-22 16:21:30'),(2,'xingquxiaozu_types','小组类型',2,'小组类型2',NULL,NULL,'-03-22 16:21:30'),(3,'xingquxiaozu_types','小组类型',3,'小组类型3',NULL,NULL,'-03-22 16:21:30'),(4,'zhuanye_types','专业',1,'专业1',NULL,NULL,'-03-22 16:21:30'),(5,'zhuanye_types','专业',2,'专业2',NULL,NULL,'-03-22 16:21:30'),(6,'zhuanye_types','专业',3,'专业3',NULL,NULL,'-03-22 16:21:30'),(7,'shuiping_types','英语水平',1,'英语水平1',NULL,NULL,'-03-22 16:21:30'),(8,'shuiping_types','英语水平',2,'英语水平2',NULL,NULL,'-03-22 16:21:30'),(9,'shuiping_types','英语水平',3,'英语水平3',NULL,NULL,'-03-22 16:21:30'),(10,'zhutizixun_types','资讯类型',1,'资讯类型1',NULL,NULL,'-03-22 16:21:31'),(11,'zhutizixun_types','资讯类型',2,'资讯类型2',NULL,NULL,'-03-22 16:21:31'),(12,'zhutizixun_types','资讯类型',3,'资讯类型3',NULL,NULL,'-03-22 16:21:31'),(13,'zhutizixun_collection_types','收藏表类型',1,'收藏',NULL,NULL,'-03-22 16:21:31'),(14,'zhutizixun_collection_types','收藏表类型',2,'赞',NULL,NULL,'-03-22 16:21:31'),(15,'zhutizixun_collection_types','收藏表类型',3,'踩',NULL,NULL,'-03-22 16:21:31'),(16,'chat_types','数据类型',1,'问题',NULL,NULL,'-03-22 16:21:31'),(17,'chat_types','数据类型',2,'回复',NULL,NULL,'-03-22 16:21:31'),(18,'zhuangtai_types','状态',1,'未回复',NULL,NULL,'-03-22 16:21:31'),(19,'zhuangtai_types','状态',2,'已回复',NULL,NULL,'-03-22 16:21:31'),(20,'news_types','公告类型',1,'公告类型1',NULL,NULL,'-03-22 16:21:31'),(21,'news_types','公告类型',2,'公告类型2',NULL,NULL,'-03-22 16:21:31'),(22,'news_types','公告类型',3,'公告类型3',NULL,NULL,'-03-22 16:21:31'),(23,'sex_types','性别',1,'男',NULL,NULL,'-03-22 16:21:31'),(24,'sex_types','性别',2,'女',NULL,NULL,'-03-22 16:21:31'),(25,'forum_types','帖子类型',1,'四六级',NULL,NULL,'-03-22 16:21:31'),(26,'forum_types','帖子类型',2,'雅思托福',NULL,NULL,'-03-22 16:21:31'),(27,'forum_state_types','帖子状态',1,'发帖',NULL,NULL,'-03-22 16:21:31'),(28,'forum_state_types','帖子状态',2,'回帖',NULL,NULL,'-03-22 16:21:31'),(29,'examquestion_types','试题类型',1,'单选题',NULL,NULL,'-03-22 16:21:31'),(30,'examquestion_types','试题类型',2,'多选题',NULL,NULL,'-03-22 16:21:31'),(31,'examquestion_types','试题类型',3,'判断题',NULL,NULL,'-03-22 16:21:31'),(32,'examquestion_types','试题类型',4,'填空题',NULL,NULL,'-03-22 16:21:31'),(33,'exampaper_types','试卷状态',1,'启用',NULL,NULL,'-03-22 16:21:31'),(34,'exampaper_types','试卷状态',2,'禁用',NULL,NULL,'-03-22 16:21:31');/*Table structure for table `exampaper` */DROP TABLE IF EXISTS `exampaper`;CREATE TABLE `exampaper` (`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`exampaper_name` varchar(200) NOT NULL COMMENT '试卷名称 Search111',`exampaper_date` int(11) NOT NULL COMMENT '考试时长(分钟)',`exampaper_myscore` int(20) NOT NULL DEFAULT '0' COMMENT '试卷总分数',`exampaper_types` int(11) NOT NULL DEFAULT '0' COMMENT '试卷状态 Search111',`exampaper_delete` int(255) DEFAULT '0' COMMENT '逻辑删除（0代表未删除 1代表已删除）',`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 show2 photoShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='试卷表';/*Data for the table `exampaper` */insert into `exampaper`(`id`,`exampaper_name`,`exampaper_date`,`exampaper_myscore`,`exampaper_types`,`exampaper_delete`,`create_time`) values (1,'测试试卷1',100,50,1,1,'-03-22 16:21:31'),(2,'123',123,0,1,2,'-03-28 09:19:55');/*Table structure for table `examquestion` */DROP TABLE IF EXISTS `examquestion`;CREATE TABLE `examquestion` (`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`exampaper_id` int(20) NOT NULL COMMENT '所属试卷id（外键）',`examquestion_name` varchar(400) NOT NULL COMMENT '试题名称 Search111',`examquestion_options` longtext COMMENT '选项，json字符串',`examquestion_score` int(20) DEFAULT '0' COMMENT '分值 Search111',`examquestion_answer` varchar(200) DEFAULT NULL COMMENT '正确答案',`examquestion_analysis` longtext COMMENT '答案解析',`examquestion_types` int(20) DEFAULT '0' COMMENT '试题类型',`examquestion_sequence` int(20) DEFAULT '100' COMMENT '试题排序，值越大排越前面',`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COMMENT='试题表';/*Data for the table `examquestion` */insert into `examquestion`(`id`,`exampaper_id`,`examquestion_name`,`examquestion_options`,`examquestion_score`,`examquestion_answer`,`examquestion_analysis`,`examquestion_types`,`examquestion_sequence`,`create_time`) values (54,1,'I can’ t_____on my studies with all that noise going on.','[{\"text\":\"absorb\",\"code\":\"A\"},{\"text\":\"concern\",\"code\":\"B\"},{\"text\":\"involve\",\"code\":\"C\"},{\"text\":\"concentrate\",\"code\":\"D\"}]',5,'D','无',1,6,'-03-22 16:21:31'),(55,1,'It is said that math teacher seems_____towards bright student.(2000.6)','[{\"text\":\"partial\",\"code\":\"A\"},{\"text\":\"beneficial\",\"code\":\"B\"},{\"text\":\"preferable\",\"code\":\"C\"},{\"text\":\"liable\",\"code\":\"D\"}]',5,'A','无',1,7,'-03-22 16:21:31'),(56,1,'During the recent__1___, three men lost their jobs for every woman. Many unemployed fathers have ended up caring for their children full-time while their wives are the___2__wage earners. ','[{\"text\":\"occurring\",\"code\":\"A\"},{\"text\":\"primary\",\"code\":\"B\"},{\"text\":\"recession\",\"code\":\"C\"},{\"text\":\"positions\",\"code\":\"D\"}]',10,'B,C','无',2,17,'-03-22 16:21:31'),(57,1,'The more secure we are in our_____to Mom, the more likely we are to try new things and take risks. ','[]',10,'attachment','无',4,26,'-03-23 00:38:25'),(58,1,'Sun School in the town of Ashbert in England is a day school for children age 10 _____ 18.','[]',10,'to','无',4,35,'-03-23 00:38:25'),(59,1,'The weekly school meeting is at the center of the way sun school is orgnized.','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',5,'B','无',3,36,'-03-23 00:38:25'),(60,1,'It seemed very confusing for a long time.','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',5,'A','无',3,37,'-03-23 00:38:25');/*Table structure for table `examrecord` */DROP TABLE IF EXISTS `examrecord`;CREATE TABLE `examrecord` (`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`examrecord_uuid_number` varchar(200) DEFAULT NULL COMMENT '考试编号',`yonghu_id` int(20) NOT NULL COMMENT '考试用户',`exampaper_id` int(20) NOT NULL COMMENT '所属试卷id（外键）',`total_score` int(200) DEFAULT NULL COMMENT '所得总分',`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '考试时间',`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='考试记录表';/*Data for the table `examrecord` */insert into `examrecord`(`id`,`examrecord_uuid_number`,`yonghu_id`,`exampaper_id`,`total_score`,`insert_time`,`create_time`) values (3,'1648006267807',1,1,10,'-03-23 11:31:08','-03-23 11:31:08'),(4,'1648430991769',1,1,10,'-03-28 09:29:52','-03-28 09:29:52'),(5,'1648431017113',1,1,0,'-03-28 09:30:17','-03-28 09:30:17');/*Table structure for table `examredetails` */DROP TABLE IF EXISTS `examredetails`;CREATE TABLE `examredetails` (`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`examredetails_uuid_number` varchar(200) DEFAULT NULL COMMENT '试卷编号',`yonghu_id` int(20) NOT NULL COMMENT '用户id',`examquestion_id` int(20) NOT NULL COMMENT '试题id（外键）',`examredetails_myanswer` varchar(200) DEFAULT NULL COMMENT '考生答案',`examredetails_myscore` int(20) NOT NULL DEFAULT '0' COMMENT '试题得分',`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='答题详情表';/*Data for the table `examredetails` */insert into `examredetails`(`id`,`examredetails_uuid_number`,`yonghu_id`,`examquestion_id`,`examredetails_myanswer`,`examredetails_myscore`,`create_time`) values (52,'1648006267807',1,60,'A',5,'-03-23 11:31:10'),(53,'1648006267807',1,59,'B',5,'-03-23 11:31:13'),(54,'1648006267807',1,58,'123',0,'-03-23 11:31:16'),(55,'1648006267807',1,57,'123',0,'-03-23 11:31:18'),(56,'1648006267807',1,56,'A,B',0,'-03-23 11:31:32'),(57,'1648006267807',1,55,'D',0,'-03-23 11:31:34'),(58,'1648006267807',1,54,'B',0,'-03-23 11:31:36'),(59,'1648430991769',1,60,'B',0,'-03-28 09:29:54'),(60,'1648430991769',1,59,'A',0,'-03-28 09:29:56'),(61,'1648430991769',1,58,'123',0,'-03-28 09:30:02'),(62,'1648430991769',1,57,'123',0,'-03-28 09:30:04'),(63,'1648430991769',1,56,'B,C',10,'-03-28 09:30:08'),(64,'1648430991769',1,55,'C',0,'-03-28 09:30:11'),(65,'1648430991769',1,54,'C',0,'-03-28 09:30:14'),(66,'1648431017113',1,54,'未作答',0,'-03-28 09:30:20'),(67,'1648431017113',1,55,'未作答',0,'-03-28 09:30:20'),(68,'1648431017113',1,56,'未作答',0,'-03-28 09:30:20'),(69,'1648431017113',1,57,'未作答',0,'-03-28 09:30:20'),(70,'1648431017113',1,58,'未作答',0,'-03-28 09:30:20'),(71,'1648431017113',1,59,'未作答',0,'-03-28 09:30:20'),(72,'1648431017113',1,60,'未作答',0,'-03-28 09:30:20');/*Table structure for table `examrewrongquestion` */DROP TABLE IF EXISTS `examrewrongquestion`;CREATE TABLE `examrewrongquestion` (`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`yonghu_id` int(20) NOT NULL COMMENT '用户id',`exampaper_id` int(20) NOT NULL COMMENT '试卷（外键）',`examquestion_id` int(20) NOT NULL COMMENT '试题id（外键）',`examredetails_myanswer` varchar(200) DEFAULT NULL COMMENT '考生作答',`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录时间',`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 show3',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8 COMMENT='错题表';/*Data for the table `examrewrongquestion` */insert into `examrewrongquestion`(`id`,`yonghu_id`,`exampaper_id`,`examquestion_id`,`examredetails_myanswer`,`insert_time`,`create_time`) values (52,1,1,58,'123','-03-23 11:31:16','-03-23 11:31:16'),(53,1,1,57,'123','-03-23 11:31:18','-03-23 11:31:18'),(54,1,1,56,'A,B','-03-23 11:31:32','-03-23 11:31:32'),(55,1,1,55,'D','-03-23 11:31:34','-03-23 11:31:34'),(56,1,1,54,'B','-03-23 11:31:36','-03-23 11:31:36'),(57,1,1,60,'B','-03-28 09:29:54','-03-28 09:29:54'),(58,1,1,59,'A','-03-28 09:29:56','-03-28 09:29:56'),(59,1,1,58,'123','-03-28 09:30:02','-03-28 09:30:02'),(60,1,1,57,'123','-03-28 09:30:04','-03-28 09:30:04'),(61,1,1,55,'C','-03-28 09:30:11','-03-28 09:30:11'),(62,1,1,54,'C','-03-28 09:30:14','-03-28 09:30:14'),(63,1,1,54,'未作答','-03-28 09:30:20','-03-28 09:30:20'),(64,1,1,55,'未作答','-03-28 09:30:20','-03-28 09:30:20'),(65,1,1,56,'未作答','-03-28 09:30:20','-03-28 09:30:20'),(66,1,1,57,'未作答','-03-28 09:30:20','-03-28 09:30:20'),(67,1,1,58,'未作答','-03-28 09:30:20','-03-28 09:30:20'),(68,1,1,59,'未作答','-03-28 09:30:20','-03-28 09:30:20'),(69,1,1,60,'未作答','-03-28 09:30:20','-03-28 09:30:20');/*Table structure for table `forum` */DROP TABLE IF EXISTS `forum`;CREATE TABLE `forum` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`forum_name` varchar(200) DEFAULT NULL COMMENT '帖子标题 Search111 ',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`users_id` int(11) DEFAULT NULL COMMENT '管理员',`forum_content` text COMMENT '发布内容',`super_ids` int(11) DEFAULT NULL COMMENT '父id',`forum_types` int(11) DEFAULT NULL COMMENT '帖子类型',`forum_state_types` int(11) DEFAULT NULL COMMENT '帖子状态',`insert_time` timestamp NULL DEFAULT NULL COMMENT '发帖时间',`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='学习讨论';/*Data for the table `forum` */insert into `forum`(`id`,`forum_name`,`yonghu_id`,`users_id`,`forum_content`,`super_ids`,`forum_types`,`forum_state_types`,`insert_time`,`update_time`,`create_time`) values (1,'帖子标题1',2,NULL,'发布内容1',NULL,1,1,'-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(2,'帖子标题2',2,NULL,'发布内容2',NULL,2,1,'-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(3,'帖子标题3',1,NULL,'发布内容3',NULL,1,1,'-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(4,'帖子标题4',3,NULL,'发布内容4',NULL,2,1,'-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(6,NULL,NULL,1,'111',5,NULL,2,'-03-28 09:18:20',NULL,'-03-28 09:18:20'),(7,NULL,1,NULL,'用户评论123',5,NULL,2,'-03-28 09:28:27',NULL,'-03-28 09:28:27');/*Table structure for table `jiarudexiaozu` */DROP TABLE IF EXISTS `jiarudexiaozu`;CREATE TABLE `jiarudexiaozu` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`xingquxiaozu_id` int(11) DEFAULT NULL COMMENT '小组',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`insert_time` timestamp NULL DEFAULT NULL COMMENT '加入时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='加入的小组';/*Data for the table `jiarudexiaozu` */insert into `jiarudexiaozu`(`id`,`xingquxiaozu_id`,`yonghu_id`,`insert_time`,`create_time`) values (10,3,1,'-03-22 19:27:52','-03-22 19:27:52'),(11,4,1,'-03-28 09:27:29','-03-28 09:27:29');/*Table structure for table `news` */DROP TABLE IF EXISTS `news`;CREATE TABLE `news` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`news_name` varchar(200) DEFAULT NULL COMMENT '公告标题 Search111 ',`news_types` int(11) DEFAULT NULL COMMENT '公告类型 Search111 ',`news_photo` varchar(200) DEFAULT NULL COMMENT '公告图片',`insert_time` timestamp NULL DEFAULT NULL COMMENT '公告时间',`news_content` text COMMENT '公告详情',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='公告信息';/*Data for the table `news` */insert into `news`(`id`,`news_name`,`news_types`,`news_photo`,`insert_time`,`news_content`,`create_time`) values (1,'公告标题1',3,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/news1.jpg','-03-22 16:31:01','公告详情1','-03-22 16:31:01'),(2,'公告标题2',2,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/news2.jpg','-03-22 16:31:01','公告详情2','-03-22 16:31:01'),(3,'公告标题3',2,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/news3.jpg','-03-22 16:31:01','公告详情3','-03-22 16:31:01'),(4,'公告标题4',1,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/news4.jpg','-03-22 16:31:01','公告详情4','-03-22 16:31:01'),(5,'公告标题5',2,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/news5.jpg','-03-22 16:31:01','公告详情5','-03-22 16:31:01');/*Table structure for table `token` */DROP TABLE IF EXISTS `token`;CREATE TABLE `token` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`userid` bigint(20) NOT NULL COMMENT '用户id',`username` varchar(100) NOT NULL COMMENT '用户名',`tablename` varchar(100) DEFAULT NULL COMMENT '表名',`role` varchar(100) DEFAULT NULL COMMENT '角色',`token` varchar(200) NOT NULL COMMENT '密码',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='token表';/*Data for the table `token` */insert into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,1,'admin','users','管理员','lmpqh0emr7vmyiywlh920rx6x6g7ag0g','-03-22 16:49:05','-03-28 10:34:44'),(2,1,'a1','yonghu','用户','klxq8fbmcbrfes0kv2el415hm78yinoj','-03-22 16:59:35','-03-28 10:32:38'),(3,2,'a2','yonghu','用户','7yptklh84j1q36lb6nkchym2d8agl818','-03-28 09:24:46','-03-28 10:24:47');/*Table structure for table `users` */DROP TABLE IF EXISTS `users`;CREATE TABLE `users` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(100) NOT NULL COMMENT '用户名',`password` varchar(100) NOT NULL COMMENT '密码',`role` varchar(100) DEFAULT '管理员' COMMENT '角色',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';/*Data for the table `users` */insert into `users`(`id`,`username`,`password`,`role`,`addtime`) values (1,'admin','admin','管理员','-05-01 00:00:00');/*Table structure for table `xingquxiaozu` */DROP TABLE IF EXISTS `xingquxiaozu`;CREATE TABLE `xingquxiaozu` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`xingquxiaozu_name` varchar(200) DEFAULT NULL COMMENT '小组名称 Search111 ',`xingquxiaozu_photo` varchar(200) DEFAULT NULL COMMENT '小组封面',`xingquxiaozu_types` int(11) DEFAULT NULL COMMENT '小组类型 Search111',`zhuanye_types` int(11) DEFAULT NULL COMMENT '专业 Search111',`shuiping_types` int(11) DEFAULT NULL COMMENT '英语水平 Search111',`xingquxiaozu_address` varchar(200) DEFAULT NULL COMMENT '所属地点',`yonghu_id` int(11) DEFAULT NULL COMMENT '小组组长',`xingquxiaozu_content` text COMMENT '小组简介 ',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='兴趣小组';/*Data for the table `xingquxiaozu` */insert into `xingquxiaozu`(`id`,`xingquxiaozu_name`,`xingquxiaozu_photo`,`xingquxiaozu_types`,`zhuanye_types`,`shuiping_types`,`xingquxiaozu_address`,`yonghu_id`,`xingquxiaozu_content`,`create_time`) values (1,'小组名称1','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430203015.jpeg',2,2,1,'所属地点1',3,'小组简介1','-03-22 16:31:01'),(2,'小组名称2','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430194691.jpeg',2,2,3,'所属地点2',1,'小组简介2','-03-22 16:31:01'),(3,'小组名称3','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430185043.jpeg',3,1,3,'所属地点3',3,'小组简介3','-03-22 16:31:01'),(4,'小组名称4','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430177991.jpeg',2,3,3,'所属地点4',3,'小组简介4','-03-22 16:31:01'),(5,'小组名称5','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430170045.jpeg',1,3,3,'所属地点5',1,'小组简介5','-03-22 16:31:01');/*Table structure for table `xingquxiaozu_liuyan` */DROP TABLE IF EXISTS `xingquxiaozu_liuyan`;CREATE TABLE `xingquxiaozu_liuyan` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`xingquxiaozu_id` int(11) DEFAULT NULL COMMENT '兴趣小组',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`xingquxiaozu_liuyan_text` text COMMENT '小组打卡内容',`insert_time` timestamp NULL DEFAULT NULL COMMENT '小组打卡时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='小组打卡';/*Data for the table `xingquxiaozu_liuyan` */insert into `xingquxiaozu_liuyan`(`id`,`xingquxiaozu_id`,`yonghu_id`,`xingquxiaozu_liuyan_text`,`insert_time`,`create_time`) values (1,1,3,'小组打卡内容1','-03-22 16:31:01','-03-22 16:31:01'),(2,2,2,'小组打卡内容2','-03-22 16:31:01','-03-22 16:31:01'),(3,3,3,'小组打卡内容3','-03-22 16:31:01','-03-22 16:31:01'),(4,4,2,'小组打卡内容4','-03-22 16:31:01','-03-22 16:31:01'),(5,5,3,'小组打卡内容5','-03-22 16:31:01','-03-22 16:31:01'),(6,5,1,'打卡内容1','-03-22 19:09:10','-03-22 19:09:10'),(7,5,1,'组长发言','-03-28 09:27:16','-03-28 09:27:16');/*Table structure for table `yonghu` */DROP TABLE IF EXISTS `yonghu`;CREATE TABLE `yonghu` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(200) DEFAULT NULL COMMENT '账户',`password` varchar(200) DEFAULT NULL COMMENT '密码',`yonghu_name` varchar(200) DEFAULT NULL COMMENT '用户姓名 Search111 ',`yonghu_photo` varchar(255) DEFAULT NULL COMMENT '头像',`sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111 ',`yonghu_phone` varchar(200) DEFAULT NULL COMMENT '联系方式',`yonghu_id_number` varchar(200) DEFAULT NULL COMMENT '身份证号 ',`yonghu_email` varchar(200) DEFAULT NULL COMMENT '邮箱',`yonghu_delete` int(11) DEFAULT '1' COMMENT '假删',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户';/*Data for the table `yonghu` */insert into `yonghu`(`id`,`username`,`password`,`yonghu_name`,`yonghu_photo`,`sex_types`,`yonghu_phone`,`yonghu_id_number`,`yonghu_email`,`yonghu_delete`,`create_time`) values (1,'a1','123456','用户姓名1','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/yonghu1.jpg',2,'17703786901','410224199610232001','1@',1,'-03-22 16:31:01'),(2,'a2','123456','用户姓名2','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/yonghu2.jpg',2,'17703786902','410224199610232002','2@',1,'-03-22 16:31:01'),(3,'a3','123456','用户姓名3','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/yonghu3.jpg',2,'17703786903','41022419961023','3@',1,'-03-22 16:31:01');/*Table structure for table `zhutizixun` */DROP TABLE IF EXISTS `zhutizixun`;CREATE TABLE `zhutizixun` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`zhutizixun_name` varchar(200) DEFAULT NULL COMMENT '资讯标题 Search111 ',`zhutizixun_types` int(11) DEFAULT NULL COMMENT '资讯类型 Search111 ',`zhutizixun_photo` varchar(200) DEFAULT NULL COMMENT '资讯封面',`zhutizixun_video` varchar(200) DEFAULT NULL COMMENT '资讯视频',`zan_number` int(11) DEFAULT NULL COMMENT '赞',`cai_number` int(11) DEFAULT NULL COMMENT '踩',`insert_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',`zhutizixun_content` text COMMENT '资讯内容',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='主题资讯';/*Data for the table `zhutizixun` */insert into `zhutizixun`(`id`,`zhutizixun_name`,`zhutizixun_types`,`zhutizixun_photo`,`zhutizixun_video`,`zan_number`,`cai_number`,`insert_time`,`zhutizixun_content`,`create_time`) values (1,'资讯标题1',3,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430257241.jpeg','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/video.mp4',380,45,'-03-22 16:31:01','资讯内容1','-03-22 16:31:01'),(2,'资讯标题2',3,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430249311.jpg','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/video.mp4',325,107,'-03-22 16:31:01','资讯内容2','-03-22 16:31:01'),(3,'资讯标题3',3,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430241853.jpg','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/video.mp4',176,314,'-03-22 16:31:01','资讯内容3','-03-22 16:31:01'),(4,'资讯标题4',2,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430232974.jpeg','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/video.mp4',171,310,'-03-22 16:31:01','资讯内容4','-03-22 16:31:01'),(5,'资讯标题5',1,'http://localhost:8080/yingyuhuzhuxiaochengxu/upload/1648430224785.jpeg','http://localhost:8080/yingyuhuzhuxiaochengxu/upload/video.mp4',313,284,'-03-22 16:31:01','资讯内容5','-03-22 16:31:01');/*Table structure for table `zhutizixun_collection` */DROP TABLE IF EXISTS `zhutizixun_collection`;CREATE TABLE `zhutizixun_collection` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`zhutizixun_id` int(11) DEFAULT NULL COMMENT '主题资讯',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`zhutizixun_collection_types` int(11) DEFAULT NULL COMMENT '类型',`insert_time` timestamp NULL DEFAULT NULL COMMENT '收藏时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 photoShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='资讯收藏';/*Data for the table `zhutizixun_collection` */insert into `zhutizixun_collection`(`id`,`zhutizixun_id`,`yonghu_id`,`zhutizixun_collection_types`,`insert_time`,`create_time`) values (1,1,2,1,'-03-22 16:31:01','-03-22 16:31:01'),(2,2,3,1,'-03-22 16:31:01','-03-22 16:31:01'),(3,3,1,1,'-03-22 16:31:01','-03-22 16:31:01'),(5,5,3,1,'-03-22 16:31:01','-03-22 16:31:01'),(6,4,1,NULL,'-03-22 16:59:50','-03-22 16:59:50'),(8,1,1,NULL,'-03-22 17:21:11','-03-22 17:21:11');/*Table structure for table `zhutizixun_liuyan` */DROP TABLE IF EXISTS `zhutizixun_liuyan`;CREATE TABLE `zhutizixun_liuyan` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`zhutizixun_id` int(11) DEFAULT NULL COMMENT '主题资讯',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`zhutizixun_liuyan_text` text COMMENT '评论内容',`insert_time` timestamp NULL DEFAULT NULL COMMENT '评论时间',`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='资讯评论';/*Data for the table `zhutizixun_liuyan` */insert into `zhutizixun_liuyan`(`id`,`zhutizixun_id`,`yonghu_id`,`zhutizixun_liuyan_text`,`insert_time`,`update_time`,`create_time`) values (1,1,2,'评论内容1','-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(2,2,2,'评论内容2','-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(3,3,1,'评论内容3','-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(4,4,1,'评论内容4','-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(5,5,2,'评论内容5','-03-22 16:31:01','-03-22 16:31:01','-03-22 16:31:01'),(6,5,1,'用户1评论','-03-28 09:26:56',NULL,'-03-28 09:26:56');/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;