5 Star 1 Fork 0

项目引领式软件工程项目训练/3-高校竞赛组织管理系统-管理端

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
_localhost-2024_06_28_03_47_04-dump.sql 16.63 KB
一键复制 编辑 原始数据 按行查看 历史
汤智博 提交于 2024-07-04 11:02 +08:00 . project
-- MySQL dump 10.13 Distrib 8.0.30, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: sims
-- ------------------------------------------------------
-- Server version 8.0.30
/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 `admin`
--
DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin` (
`a_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`a_password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
PRIMARY KEY (`a_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin`
--
LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES ('1111111111','111'),('3333333333','111'),('admin','admin');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `college_department_class`
--
DROP TABLE IF EXISTS `college_department_class`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `college_department_class` (
`college` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`department` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`cclass` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
PRIMARY KEY (`college`,`department`,`cclass`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `college_department_class`
--
LOCK TABLES `college_department_class` WRITE;
/*!40000 ALTER TABLE `college_department_class` DISABLE KEYS */;
INSERT INTO `college_department_class` VALUES ('应用数学学院','数学','数学1'),('应用数学学院','数学','数学2'),('应用数学学院','数理基础科学','数理基础1'),('应用数学学院','数理基础科学','数理基础2'),('软件工程学院','新媒体','18新媒体1'),('软件工程学院','新媒体','18新媒体2'),('软件工程学院','软件工程','18软件(理软)1'),('软件工程学院','软件工程','18软件(理软)2'),('软件工程学院','软件工程','19软件(理软)1'),('软件工程学院','软件工程','19软件(理软)2');
/*!40000 ALTER TABLE `college_department_class` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `complaint`
--
DROP TABLE IF EXISTS `complaint`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `complaint` (
`id` int NOT NULL AUTO_INCREMENT,
`cdate` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`content` varchar(2000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `complaint`
--
LOCK TABLES `complaint` WRITE;
/*!40000 ALTER TABLE `complaint` DISABLE KEYS */;
INSERT INTO `complaint` VALUES (1,'2020-05-02 17:40:17','这是第一条小吐槽哦'),(2,'2020-05-02 18:07:51','哈哈哈,界面不错'),(3,'2020-05-02 18:09:33','可以的兄弟'),(4,'2020-05-02 18:16:24','我测试下'),(31,'2020-05-02 21:05:26','input'),(32,'2020-05-20 19:07:45','我我我我'),(33,'2020-05-26 22:41:34','input/'),(36,'2020-05-27 17:59:14','<h1 style=\"font-style: italic;\"><ins>灌灌灌灌灌过过fffffdsfljhidldf</ins></h1>\r\n\r\n<ul>\r\n <li>\r\n <h1 style=\"font-style: italic;\"><ins>sFFDSFS</ins></h1>\r\n </li>\r\n <li><ins>23234234asd</ins></li>\r\n</ul>\r\n'),(45,'2020-05-27 20:36:37','<h2><s>做个测试啊</s></h2>\r\n\r\n<p><s><img alt=\"t\" src=\"https://cdn.yoyling.com/2020/05/github-speed/github-speed.jpg\" style=\"height:111px; width:200px\" /></s></p>\r\n'),(47,'2020-05-27 20:42:28','<p><img alt=\"smiley\" src=\"https://cdn.ckeditor.com/4.14.0/full/plugins/smiley/images/regular_smile.png\" style=\"height:23px; width:23px\" title=\"smiley\" /><img alt=\"laugh\" src=\"https://cdn.ckeditor.com/4.14.0/full/plugins/smiley/images/teeth_smile.png\" style=\"height:23px; width:23px\" title=\"laugh\" /><img alt=\"yes\" src=\"https://cdn.ckeditor.com/4.14.0/full/plugins/smiley/images/thumbs_up.png\" style=\"height:23px; width:23px\" title=\"yes\" />Nice</p>\r\n');
/*!40000 ALTER TABLE `complaint` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `course`
--
DROP TABLE IF EXISTS `course`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course` (
`c_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`c_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`t_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`c_info` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`c_id`) USING BTREE,
KEY `t_id` (`t_id`) USING BTREE,
CONSTRAINT `course_ibfk_1` FOREIGN KEY (`t_id`) REFERENCES `teacher` (`t_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `course`
--
LOCK TABLES `course` WRITE;
/*!40000 ALTER TABLE `course` DISABLE KEYS */;
INSERT INTO `course` VALUES ('c1111','java进阶','9912123206','关于java进阶的故事啊啊啊啊'),('c1113','软件测试','9912123206','软件测试课程'),('cccc','as撒大大','9912123206','第三方爽肤水发顺丰所ddd'),('ye_course_124','JVM虚拟机性能优化','1','巴拉巴拉巴拉巴拉巴拉巴拉巴拉巴拉巴拉巴拉');
/*!40000 ALTER TABLE `course` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notify`
--
DROP TABLE IF EXISTS `notify`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notify` (
`id` int NOT NULL AUTO_INCREMENT,
`notifyDate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`notifyInfo` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notify`
--
LOCK TABLES `notify` WRITE;
/*!40000 ALTER TABLE `notify` DISABLE KEYS */;
INSERT INTO `notify` VALUES (3,'2020-04-24 15:36:22','222222222222222222'),(4,'2020-04-24 15:36:22','奥术大师所所所所所所所所所所所所所所所所所所所所所所所'),(5,'2020-04-24 15:36:22','这是一条测试文本啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊'),(16,'2020-04-24 18:51:15','这是4.24最新公告,仅供测试'),(17,'2020-04-24 19:40:45','测试发布公告'),(18,'2020-04-24 19:42:40','敖德萨大萨达大所多'),(22,'2020-04-24 20:34:00','2111111111111'),(23,'2020-04-24 20:42:31','4.24最新公告'),(24,'2020-04-24 20:44:30','2020.4.24最新公告哈哈哈哈还好哈哈哈哈还好哈哈哈哈还好或或或或'),(25,'2020-04-24 20:49:35','增加几个查询模块'),(26,'2020-04-24 21:00:14','增加管理员公告发布'),(28,'2020-05-01 22:06:35','增加学生端选课系统,增加修改用户信息,修改密码功能'),(29,'2020-05-13 12:20:10','增加学生分页功能,管理端添加学生选中列表删除,添加全选'),(30,'2020-05-18 23:39:16','增加文件传输服务,管理上传,全员可下载,任意大小类型'),(31,'2020-05-27 18:29:16','小吐槽增加富文本编辑器,开源CKEditor 4');
/*!40000 ALTER TABLE `notify` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `page`
--
DROP TABLE IF EXISTS `page`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page` (
`p_id` varchar(12) NOT NULL,
`p_name` varchar(20) DEFAULT NULL,
`p_sex` varchar(20) DEFAULT NULL,
`p_education` varchar(20) DEFAULT NULL,
`p_title` varchar(20) DEFAULT NULL,
`p_password` varchar(20) DEFAULT NULL,
PRIMARY KEY (`p_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `page`
--
LOCK TABLES `page` WRITE;
/*!40000 ALTER TABLE `page` DISABLE KEYS */;
INSERT INTO `page` VALUES ('1','线性代数','男','小明','高数','2'),('2','论文','男','小红','语文',NULL);
/*!40000 ALTER TABLE `page` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `photo`
--
DROP TABLE IF EXISTS `photo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `photo` (
`id` int NOT NULL AUTO_INCREMENT,
`photo_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`photo_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '0.jpg',
PRIMARY KEY (`id`) USING BTREE,
KEY `photo_id` (`photo_id`) USING BTREE,
CONSTRAINT `photo_ibfk_1` FOREIGN KEY (`photo_id`) REFERENCES `student` (`s_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `photo`
--
LOCK TABLES `photo` WRITE;
/*!40000 ALTER TABLE `photo` DISABLE KEYS */;
INSERT INTO `photo` VALUES (10,'1812123206','1812123206.jpg'),(11,'1812123205','1812123205.jpg');
/*!40000 ALTER TABLE `photo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `select_course`
--
DROP TABLE IF EXISTS `select_course`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `select_course` (
`s_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`c_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`score` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
PRIMARY KEY (`s_id`,`c_id`) USING BTREE,
KEY `s_id` (`s_id`) USING BTREE,
KEY `c_id` (`c_id`) USING BTREE,
CONSTRAINT `select_course_ibfk_1` FOREIGN KEY (`s_id`) REFERENCES `student` (`s_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `select_course_ibfk_2` FOREIGN KEY (`c_id`) REFERENCES `course` (`c_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `select_course`
--
LOCK TABLES `select_course` WRITE;
/*!40000 ALTER TABLE `select_course` DISABLE KEYS */;
INSERT INTO `select_course` VALUES ('1','ye_course_124',NULL),('1812123205','c1111','70'),('1812123205','c1113',NULL),('1812123205','cccc',NULL),('1812123206','c1111','10'),('1812123206','c1113',NULL),('1812123206','cccc',NULL),('5555555555','ye_course_124','60');
/*!40000 ALTER TABLE `select_course` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student`
--
DROP TABLE IF EXISTS `student`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `student` (
`s_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`s_college` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '待分配',
`s_department` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '待分配',
`s_class` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '待分配',
`s_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`s_sex` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`s_age` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`s_address` varchar(35) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`s_phone` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`s_email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`s_password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '123',
PRIMARY KEY (`s_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student`
--
LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` VALUES ('1','软件工程学院','软件工程','18软件(理软)1','陈毅','男','数学','福建','12131231','22@qq.com','123'),('1111111112','待分配','待分配','待分配','哈哈哈','女','数学','敖德萨','23136456','123@qq.com','123'),('1111111113','待分配','待分配','待分配','大大大','男','数学','福建','231335353','123@qq.com','123'),('1111111114','待分配','待分配','待分配','仍然让','男','数学','福建','2313124325','123@qq.com','123'),('1231231231','待分配','待分配','待分配','上官怡蓝','女','数学','西藏','233245','1@icloud.com','123'),('1231238768','应用数学学院','数学','数学1','陈欣','女','数学','福建','23136457','123@qq.com','123'),('1234567890','软件工程学院','软件工程','18软件(理软)2','csq','男','数学','福建','2313213','123@qq.com','123'),('1812123205','软件工程学院','软件工程','18软件(理软)1','陈善涛','男','数学','福建','110','cst@qq.com','123'),('1812123206','软件工程学院','软件工程','18软件(理软)1','陈双全','男','数学','福建省厦门市','18259234126','2221999792@qq.com','123'),('1812123238','软件工程学院','软件工程','18软件(理软)1','张怀洲','男','数学','福建','120','zhz@qq.com','123'),('1812123299','软件工程学院','软件工程','18新媒体1','陈双全2','女','数学','福建省龙岩市','18259234999','888@qq.com','123'),('1812123405','软件工程学院','软件工程','18软件(理软)2','王五','男','数学','福建省厦门市','18323847123','123972@qq.com','123'),('2222222222','软件工程学院','软件工程','18新媒体1','碧华','男','数学','福建','4231323','213@qq.com','123'),('5555555555','待分配','待分配','待分配','打发打','女','数学','','','','555'),('7777777777','待分配','待分配','待分配','李子柒','女','数学','福建','124123132','123@qq.com','123');
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `teacher`
--
DROP TABLE IF EXISTS `teacher`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `teacher` (
`t_id` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`t_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`t_sex` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`t_education` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`t_title` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`t_password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '123',
PRIMARY KEY (`t_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `teacher`
--
LOCK TABLES `teacher` WRITE;
/*!40000 ALTER TABLE `teacher` DISABLE KEYS */;
INSERT INTO `teacher` VALUES ('1','叶问','男','2','2','123'),('9912123206','陈老师','男','博士','讲师','123');
/*!40000 ALTER TABLE `teacher` 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 2024-06-28 3:47:04
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/projectLeading/dong.git
git@gitee.com:projectLeading/dong.git
projectLeading
dong
3-高校竞赛组织管理系统-管理端
master

搜索帮助