功能介绍
用户端功能有:首页、学习资源、资源推荐、资源评价、公告信息、个人中心、后台管理。登录后台有个人信息管理、学习记录管理、资源评价管理、收藏管理。
管理端功能有:科目管理、教师管理、学生管理、学习资源管理、学习记录管理、资源评价管理、系统管理等。
教师端的功能有:个人中心、学习资源管理、学习记录管理、资源评价管理
更多功能请看运行截图!
使用技术
开发语言:python
使用框架:Django2.0
前端技术:JavaScript、VUE.js(2.X)、css3
数据库:MySQL 5.7
数据库管理工具:Navicat或sqlyog
开发工具:pycharm
python版本:python3.7及以上
项目截图
数据库脚本
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: djangoqn3mz
-- ------------------------------------------------------
-- 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: `djangoqn3mz`
--
/*!40000 DROP DATABASE IF EXISTS `djangoqn3mz`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `djangoqn3mz` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `djangoqn3mz`;
--
-- 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=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/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussxuexiziyuan`
--
DROP TABLE IF EXISTS `discussxuexiziyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussxuexiziyuan` (
`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',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='学习资源评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussxuexiziyuan`
--
LOCK TABLES `discussxuexiziyuan` WRITE;
/*!40000 ALTER TABLE `discussxuexiziyuan` DISABLE KEYS */;
/*!40000 ALTER TABLE `discussxuexiziyuan` 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 '创建时间',
`jiaoshigonghao` varchar(200) NOT NULL COMMENT '教师工号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
`zhicheng` varchar(200) DEFAULT NULL COMMENT '职称',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`jiaoshiyouxiang` varchar(200) DEFAULT NULL COMMENT '教师邮箱',
PRIMARY KEY (`id`),
UNIQUE KEY `jiaoshigonghao` (`jiaoshigonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 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 */;
/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kemu`
--
DROP TABLE IF EXISTS `kemu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kemu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`kemu` varchar(200) NOT NULL COMMENT '科目',
PRIMARY KEY (`id`),
UNIQUE KEY `kemu` (`kemu`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='科目';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kemu`
--
LOCK TABLES `kemu` WRITE;
/*!40000 ALTER TABLE `kemu` DISABLE KEYS */;
INSERT INTO `kemu` VALUES (11,'2022-02-23 12:58:48','科目1'),(12,'2022-02-23 12:58:48','科目2'),(13,'2022-02-23 12:58:48','科目3'),(14,'2022-02-23 12:58:48','科目4'),(15,'2022-02-23 12:58:48','科目5'),(16,'2022-02-23 12:58:48','科目6');
/*!40000 ALTER TABLE `kemu` 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=87 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 */;
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '收藏名称',
`picture` varchar(200) NOT NULL COMMENT '收藏图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-02-23 12:58:48');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuesheng`
--
DROP TABLE IF EXISTS `xuesheng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuesheng` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) NOT NULL COMMENT '学号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (`id`),
UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='学生';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuesheng`
--
LOCK TABLES `xuesheng` WRITE;
/*!40000 ALTER TABLE `xuesheng` DISABLE KEYS */;
INSERT INTO `xuesheng` VALUES (31,'2022-02-23 12:58:48','学号1','123456','姓名1','男','upload/xuesheng_touxiang1.jpg','13823888881','773890001@qq.com'),(32,'2022-02-23 12:58:48','学号2','123456','姓名2','男','upload/xuesheng_touxiang2.jpg','13823888882','773890002@qq.com'),(33,'2022-02-23 12:58:48','学号3','123456','姓名3','男','upload/xuesheng_touxiang3.jpg','13823888883','773890003@qq.com'),(34,'2022-02-23 12:58:48','学号4','123456','姓名4','男','upload/xuesheng_touxiang4.jpg','13823888884','773890004@qq.com'),(35,'2022-02-23 12:58:48','学号5','123456','姓名5','男','upload/xuesheng_touxiang5.jpg','13823888885','773890005@qq.com'),(36,'2022-02-23 12:58:48','学号6','123456','姓名6','男','upload/xuesheng_touxiang6.jpg','13823888886','773890006@qq.com');
/*!40000 ALTER TABLE `xuesheng` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuexijilu`
--
DROP TABLE IF EXISTS `xuexijilu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuexijilu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`mingcheng` varchar(200) DEFAULT NULL COMMENT '名称',
`kemu` varchar(200) DEFAULT NULL COMMENT '科目',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`shipin` varchar(200) DEFAULT NULL COMMENT '视频',
`ziyuan` varchar(200) DEFAULT NULL COMMENT '资源',
`xuexijindu` varchar(200) NOT NULL COMMENT '学习进度',
`xuexibiji` longtext COMMENT '学习笔记',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`xuexiriqi` date DEFAULT NULL COMMENT '学习日期',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='学习记录';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuexijilu`
--
LOCK TABLES `xuexijilu` WRITE;
/*!40000 ALTER TABLE `xuexijilu` DISABLE KEYS */;
INSERT INTO `xuexijilu` VALUES (51,'2022-02-23 12:58:48','名称1','科目1','upload/xuexijilu_tupian1.jpg','','','学习中','学习笔记1','教师工号1','教师姓名1','2022-02-23','学号1','姓名1','13823888881',1,1,'是',''),(52,'2022-02-23 12:58:48','名称2','科目2','upload/xuexijilu_tupian2.jpg','','','学习中','学习笔记2','教师工号2','教师姓名2','2022-02-23','学号2','姓名2','13823888882',2,2,'是',''),(53,'2022-02-23 12:58:48','名称3','科目3','upload/xuexijilu_tupian3.jpg','','','学习中','学习笔记3','教师工号3','教师姓名3','2022-02-23','学号3','姓名3','13823888883',3,3,'是',''),(54,'2022-02-23 12:58:48','名称4','科目4','upload/xuexijilu_tupian4.jpg','','','学习中','学习笔记4','教师工号4','教师姓名4','2022-02-23','学号4','姓名4','13823888884',4,4,'是',''),(55,'2022-02-23 12:58:48','名称5','科目5','upload/xuexijilu_tupian5.jpg','','','学习中','学习笔记5','教师工号5','教师姓名5','2022-02-23','学号5','姓名5','13823888885',5,5,'是',''),(56,'2022-02-23 12:58:48','名称6','科目6','upload/xuexijilu_tupian6.jpg','','','学习中','学习笔记6','教师工号6','教师姓名6','2022-02-23','学号6','姓名6','13823888886',6,6,'是','');
/*!40000 ALTER TABLE `xuexijilu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuexiziyuan`
--
DROP TABLE IF EXISTS `xuexiziyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuexiziyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`mingcheng` varchar(200) NOT NULL COMMENT '名称',
`kemu` varchar(200) DEFAULT NULL COMMENT '科目',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`shipin` varchar(200) DEFAULT NULL COMMENT '视频',
`ziyuan` varchar(200) DEFAULT NULL COMMENT '资源',
`xiangqing` longtext COMMENT '详情',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='学习资源';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuexiziyuan`
--
LOCK TABLES `xuexiziyuan` WRITE;
/*!40000 ALTER TABLE `xuexiziyuan` DISABLE KEYS */;
INSERT INTO `xuexiziyuan` VALUES (41,'2022-02-23 12:58:48','名称1','科目1','upload/xuexiziyuan_tupian1.jpg','','','详情1','教师工号1','教师姓名1','13823888881','2022-02-23','2022-02-23 20:58:48'),(42,'2022-02-23 12:58:48','名称2','科目2','upload/xuexiziyuan_tupian2.jpg','','','详情2','教师工号2','教师姓名2','13823888882','2022-02-23','2022-02-23 20:58:48'),(43,'2022-02-23 12:58:48','名称3','科目3','upload/xuexiziyuan_tupian3.jpg','','','详情3','教师工号3','教师姓名3','13823888883','2022-02-23','2022-02-23 20:58:48'),(44,'2022-02-23 12:58:48','名称4','科目4','upload/xuexiziyuan_tupian4.jpg','','','详情4','教师工号4','教师姓名4','13823888884','2022-02-23','2022-02-23 20:58:48'),(45,'2022-02-23 12:58:48','名称5','科目5','upload/xuexiziyuan_tupian5.jpg','','','详情5','教师工号5','教师姓名5','13823888885','2022-02-23','2022-02-23 20:58:48'),(46,'2022-02-23 12:58:48','名称6','科目6','upload/xuexiziyuan_tupian6.jpg','','','详情6','教师工号6','教师姓名6','13823888886','2022-02-23','2022-02-23 20:58:48');
/*!40000 ALTER TABLE `xuexiziyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ziyuanpingjia`
--
DROP TABLE IF EXISTS `ziyuanpingjia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ziyuanpingjia` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`mingcheng` varchar(200) DEFAULT NULL COMMENT '名称',
`kemu` varchar(200) DEFAULT NULL COMMENT '科目',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`ziyuanpingfen` varchar(200) NOT NULL COMMENT '资源评分',
`ziyuanpingjia` longtext COMMENT '资源评价',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`pingjiariqi` date DEFAULT NULL COMMENT '评价日期',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='资源评价';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ziyuanpingjia`
--
LOCK TABLES `ziyuanpingjia` WRITE;
/*!40000 ALTER TABLE `ziyuanpingjia` DISABLE KEYS */;
INSERT INTO `ziyuanpingjia` VALUES (61,'2022-02-23 12:58:48','名称1','科目1','upload/ziyuanpingjia_tupian1.jpg','1','资源评价1','教师工号1','2022-02-23','学号1',1,1,'是',''),(62,'2022-02-23 12:58:48','名称2','科目2','upload/ziyuanpingjia_tupian2.jpg','1','资源评价2','教师工号2','2022-02-23','学号2',2,2,'是',''),(63,'2022-02-23 12:58:48','名称3','科目3','upload/ziyuanpingjia_tupian3.jpg','1','资源评价3','教师工号3','2022-02-23','学号3',3,3,'是',''),(64,'2022-02-23 12:58:48','名称4','科目4','upload/ziyuanpingjia_tupian4.jpg','1','资源评价4','教师工号4','2022-02-23','学号4',4,4,'是',''),(65,'2022-02-23 12:58:48','名称5','科目5','upload/ziyuanpingjia_tupian5.jpg','1','资源评价5','教师工号5','2022-02-23','学号5',5,5,'是',''),(66,'2022-02-23 12:58:48','名称6','科目6','upload/ziyuanpingjia_tupian6.jpg','1','资源评价6','教师工号6','2022-02-23','学号6',6,6,'是','');
/*!40000 ALTER TABLE `ziyuanpingjia` 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 2022-02-27 11:26:06