|
|
-- phpMyAdmin SQL Dump
|
|
|
-- version 5.2.1
|
|
|
-- https://www.phpmyadmin.net/
|
|
|
--
|
|
|
-- 主机: 127.0.0.1:3306
|
|
|
-- 生成日期: 2024-12-25 03:42:26
|
|
|
-- 服务器版本: 8.0.31
|
|
|
-- PHP 版本: 7.4.33
|
|
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
|
START TRANSACTION;
|
|
|
SET time_zone = "+00:00";
|
|
|
|
|
|
|
|
|
/*!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 utf8mb4 */;
|
|
|
|
|
|
--
|
|
|
-- 数据库: `test`
|
|
|
--
|
|
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
|
|
--
|
|
|
-- 表的结构 `answer`
|
|
|
--
|
|
|
|
|
|
DROP TABLE IF EXISTS `answer`;
|
|
|
CREATE TABLE IF NOT EXISTS `answer` (
|
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
|
`exam_id` bigint DEFAULT NULL,
|
|
|
`user_id` bigint DEFAULT NULL,
|
|
|
`teacher_id` bigint DEFAULT NULL,
|
|
|
`answers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
|
|
`score` varchar(255) DEFAULT NULL,
|
|
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
|
|
`question_ids` varchar(255) DEFAULT NULL,
|
|
|
`is_score` varchar(255) DEFAULT NULL,
|
|
|
`submit_Time` datetime DEFAULT NULL,
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
|
|
--
|
|
|
-- 转存表中的数据 `answer`
|
|
|
--
|
|
|
|
|
|
INSERT INTO `answer` (`id`, `exam_id`, `user_id`, `teacher_id`, `answers`, `score`, `name`, `question_ids`, `is_score`, `submit_Time`) VALUES
|
|
|
(195, 4, 4, 3, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]}]', '10', '考试2', '1', '已评分', '2024-12-16 16:44:33'),
|
|
|
(197, 5, 4, 3, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":2,\"name\":\"以下哪种语言是面向对象的?\",\"type\":\"单选题\",\"options\":[\"A. Java\",\"B. C\",\"C. Assembly\",\"D. Python\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":4,\"name\":\"HTML是什么的缩写?\",\"type\":\"单选题\",\"options\":[\"A. HyperText Markup Language\",\"B. HyperText Modeling Language\",\"C. HyperText Management Language\",\"D. HyperText Method Language\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":5,\"name\":\"以下哪些是Python的数据类型?\",\"type\":\"多选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"ABCD\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":\"0\",\"userAnswers\":[\"A\",\"B\",\"C\",\"D\"]},{\"id\":6,\"name\":\"什么是CSS?\",\"type\":\"单选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]}]', '50', '考试3', '1,2,4,5,6', '已评分', '2024-12-16 22:12:23'),
|
|
|
(198, 4, 1, 3, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]}]', '10', '考试2', '1', '已评分', '2024-12-17 15:11:42'),
|
|
|
(202, 5, 1, 3, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":2,\"name\":\"以下哪种语言是面向对象的?\",\"type\":\"单选题\",\"options\":[\"A. Java\",\"B. C\",\"C. Assembly\",\"D. Python\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":4,\"name\":\"HTML是什么的缩写?\",\"type\":\"单选题\",\"options\":[\"A. HyperText Markup Language\",\"B. HyperText Modeling Language\",\"C. HyperText Management Language\",\"D. HyperText Method Language\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":5,\"name\":\"以下哪些是Python的数据类型?\",\"type\":\"多选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"ABCD\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\",\"B\",\"C\",\"D\"]},{\"id\":6,\"name\":\"什么是CSS?\",\"type\":\"单选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]}]', '50', '考试3', '1,2,4,5,6', '未评分', '2024-12-17 15:31:22'),
|
|
|
(203, 3, 4, 2, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":2,\"name\":\"以下哪种语言是面向对象的?\",\"type\":\"单选题\",\"options\":[\"A. Java\",\"B. C\",\"C. Assembly\",\"D. Python\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":4,\"name\":\"HTML是什么的缩写?\",\"type\":\"单选题\",\"options\":[\"A. HyperText Markup Language\",\"B. HyperText Modeling Language\",\"C. HyperText Management Language\",\"D. HyperText Method Language\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":5,\"name\":\"以下哪些是Python的数据类型?\",\"type\":\"多选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"ABCD\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\",\"B\",\"C\",\"D\"]},{\"id\":25,\"name\":\"简述一下计算机的组成原理?\",\"type\":\"主观题\",\"options\":[],\"answer\":\"123\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":\"9\",\"userAnswers\":[\"123\"]},{\"id\":24,\"name\":\"1+1=?\",\"type\":\"单选题\",\"options\":[\"A:1\",\"B:2\",\"C:3\",\"D:4\"],\"answer\":\"B\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"B\"]},{\"id\":21,\"name\":\"1+1=?\",\"type\":\"填空题\",\"options\":[],\"answer\":\"2\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"2\"]},{\"id\":19,\"name\":\"1\",\"type\":\"单选题\",\"options\":[\"A:1\",\"B:1\",\"C:1\",\"D:1\"],\"answer\":\"D\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"D\"]}]', '79', '123', '1,2,4,5,25,24,21,19', '已评分', '2024-12-19 13:50:44'),
|
|
|
(204, 13, 4, 2, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":2,\"name\":\"以下哪种语言是面向对象的?\",\"type\":\"单选题\",\"options\":[\"A. Java\",\"B. C\",\"C. Assembly\",\"D. Python\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":4,\"name\":\"HTML是什么的缩写?\",\"type\":\"单选题\",\"options\":[\"A. HyperText Markup Language\",\"B. HyperText Modeling Language\",\"C. HyperText Management Language\",\"D. HyperText Method Language\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]}]', '30', '试卷10', '1,2,4', '已评分', '2024-12-24 23:40:56');
|
|
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
|
|
--
|
|
|
-- 表的结构 `comment`
|
|
|
--
|
|
|
|
|
|
DROP TABLE IF EXISTS `comment`;
|
|
|
CREATE TABLE IF NOT EXISTS `comment` (
|
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
|
`username` varchar(255) NOT NULL,
|
|
|
`content` varchar(255) DEFAULT NULL,
|
|
|
`time` datetime(6) DEFAULT NULL,
|
|
|
`parent_id` bigint DEFAULT NULL,
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
|
|
--
|
|
|
-- 转存表中的数据 `comment`
|
|
|
--
|
|
|
|
|
|
INSERT INTO `comment` (`id`, `username`, `content`, `time`, `parent_id`) VALUES
|
|
|
(6, 'chx', '123', '2024-12-23 14:24:17.637000', NULL),
|
|
|
(7, 'chx', '456', '2024-12-23 15:59:38.945000', NULL),
|
|
|
(8, 'chx2', '@chx 46', '2024-12-23 16:00:06.741000', 6);
|
|
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
|
|
--
|
|
|
-- 表的结构 `exam`
|
|
|
--
|
|
|
|
|
|
DROP TABLE IF EXISTS `exam`;
|
|
|
CREATE TABLE IF NOT EXISTS `exam` (
|
|
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '考试标题',
|
|
|
`img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封面图',
|
|
|
`start_time` datetime DEFAULT NULL COMMENT '考试开始时间',
|
|
|
`end_time` datetime DEFAULT NULL COMMENT '考试结束时间',
|
|
|
`question_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '试题列表',
|
|
|
`total` int DEFAULT NULL COMMENT '考试总分',
|
|
|
`user_id` int DEFAULT NULL COMMENT '用户ID',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='考试表' ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
--
|
|
|
-- 转存表中的数据 `exam`
|
|
|
--
|
|
|
|
|
|
INSERT INTO `exam` (`id`, `title`, `img`, `start_time`, `end_time`, `question_ids`, `total`, `user_id`) VALUES
|
|
|
(2, '测试', 'https://cdn.pixabay.com/photo/2015/04/23/22/00/tree-736885__480.jpg', '2024-05-29 00:00:00', '2024-12-16 16:42:00', '1,2,4,5,6', 50, 2),
|
|
|
(3, '123', 'https://cdn.pixabay.com/photo/2015/04/23/22/00/tree-736885__480.jpg', '2024-06-08 08:00:00', '2024-12-20 19:51:00', '1,2,4,5,25,24,21,19', 110, 2),
|
|
|
(4, '考试2', 'https://cdn.pixabay.com/photo/2015/04/23/22/00/tree-736885__480.jpg', '2024-11-05 03:55:00', '2024-12-31 12:00:00', '1', 10, 3),
|
|
|
(5, '考试3', 'https://cdn.pixabay.com/photo/2015/04/23/22/00/tree-736885__480.jpg', '2024-11-05 03:55:00', '2024-12-31 19:12:00', '1,2,4,5,6', 50, 3);
|
|
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
|
|
--
|
|
|
-- 表的结构 `question`
|
|
|
--
|
|
|
|
|
|
DROP TABLE IF EXISTS `question`;
|
|
|
CREATE TABLE IF NOT EXISTS `question` (
|
|
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|
|
`name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '题目文本',
|
|
|
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '题型',
|
|
|
`options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '选择题选项',
|
|
|
`answer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '正确答案',
|
|
|
`score` int DEFAULT NULL COMMENT '分值',
|
|
|
`user_id` int DEFAULT NULL COMMENT '用户ID',
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='试题表' ROW_FORMAT=DYNAMIC;
|
|
|
|
|
|
--
|
|
|
-- 转存表中的数据 `question`
|
|
|
--
|
|
|
|
|
|
INSERT INTO `question` (`id`, `name`, `type`, `options`, `answer`, `score`, `user_id`) VALUES
|
|
|
(1, '什么是数据库?', '单选题', '[\"A. 数据存储\", \"B. 数据库\", \"C. 数据表\", \"D. 数据项\"]', 'A', 10, 3),
|
|
|
(2, '以下哪种语言是面向对象的?', '单选题', '[\"A. Java\", \"B. C\", \"C. Assembly\", \"D. Python\"]', 'A', 10, 3),
|
|
|
(4, 'HTML是什么的缩写?', '单选题', '[\"A. HyperText Markup Language\", \"B. HyperText Modeling Language\", \"C. HyperText Management Language\", \"D. HyperText Method Language\"]', 'A', 10, 3),
|
|
|
(5, '以下哪些是Python的数据类型?', '多选题', '[\"A. Cascading Style Sheets\", \"B. Centralized Style Sheets\", \"C. Creative Style Sheets\", \"D. Computer Style Sheets\"]', 'ABCD', 10, 3),
|
|
|
(6, '什么是CSS?', '单选题', '[\"A. Cascading Style Sheets\", \"B. Centralized Style Sheets\", \"C. Creative Style Sheets\", \"D. Computer Style Sheets\"]', 'A', 10, 3),
|
|
|
(9, 'React是哪家公司开发的?', '多选题', '[\"A. Facebook\", \"B. Google\", \"C. Microsoft\", \"D. Apple\"]', 'ABCD', 10, 3),
|
|
|
(10, '机器学习的主要分类有哪些?', '多选题', '[\"A. Cascading Style Sheets\", \"B. Centralized Style Sheets\", \"C. Creative Style Sheets\", \"D. Computer Style Sheets\"]', 'ABCD', 10, 3),
|
|
|
(13, '1+2=?', '单选题', '[\"A. 1\", \"B. 2\", \"C. 3\", \"D. 4\"]', 'C', 10, 3),
|
|
|
(14, '1+1+1+1=?', '单选题', '[\"A. 1\", \"B. 2\", \"C. 3\", \"D. 4\"]', 'D', 10, 3),
|
|
|
(15, '1+0=?', '单选题', '[\"A. 1\", \"B. 22222\", \"C. 3\", \"D. 4\"]\n', '2', 10, 3),
|
|
|
(16, '10+10=?', '单选题', '[\"A. 1\", \"B. 22222\", \"C. 3\", \"D. 20\"]\n', 'D', 10, 3),
|
|
|
(17, '1+2+3=?', '单选题', '[\"A. 1\", \"B. 6\", \"C. 3\", \"D. 20\"]', 'D', 10, 3),
|
|
|
(18, '1+10=?', '单选题', '[\"A:11\",\"B:22\",\"C:22\",\"D:113\"]', 'D', 10, 3),
|
|
|
(19, '1', '单选题', '[\"A:1\",\"B:1\",\"C:1\",\"D:1\"]', 'D', 10, 3),
|
|
|
(20, '1+1=2对吗', '判断题', '', '对', 10, 3),
|
|
|
(21, '1+1=?', '填空题', '{\"0\":\"A:\",\"1\":\"B:\",\"2\":\"C:\",\"3\":\"D:\"}', '2', 10, 3),
|
|
|
(22, '1+1=2?', '判断题', '', '对', 10, 3),
|
|
|
(23, '1+1+1=3?', '判断题', '', '对', 10, 3),
|
|
|
(24, '1+1=?', '单选题', '[\"A:1\",\"B:2\",\"C:3\",\"D:4\"]', 'B', 10, 3),
|
|
|
(25, '简述一下计算机的组成原理?', '主观题', NULL, '计算机的组成原理', 10, 3);
|
|
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
|
|
--
|
|
|
-- 表的结构 `user`
|
|
|
--
|
|
|
|
|
|
DROP TABLE IF EXISTS `user`;
|
|
|
CREATE TABLE IF NOT EXISTS `user` (
|
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
|
`username` varchar(50) NOT NULL,
|
|
|
`password` varchar(100) NOT NULL,
|
|
|
`role` varchar(20) NOT NULL COMMENT '用户角色:student, teacher, admin',
|
|
|
`email` varchar(255) DEFAULT NULL,
|
|
|
`mobile` varchar(255) DEFAULT NULL,
|
|
|
`avatar` varchar(255) DEFAULT NULL,
|
|
|
`gender` varchar(255) DEFAULT NULL,
|
|
|
`address` varchar(255) DEFAULT NULL,
|
|
|
PRIMARY KEY (`id`),
|
|
|
UNIQUE KEY `username` (`username`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
|
|
--
|
|
|
-- 转存表中的数据 `user`
|
|
|
--
|
|
|
|
|
|
INSERT INTO `user` (`id`, `username`, `password`, `role`, `email`, `mobile`, `avatar`, `gender`, `address`) VALUES
|
|
|
(1, 'student', '$2a$10$fclE/Dgq1Ej5fEG9cNwIZu.Me0aFCbGy3naccAZOa/Fa/1tBAsZGq', 'student', NULL, NULL, 'http://localhost:8080/file/download?name=bf0d4510-f8db-4afb-bf9e-4fa76da41b4e_user.png', '男', ''),
|
|
|
(2, 'teacher', '$2a$10$fclE/Dgq1Ej5fEG9cNwIZu.Me0aFCbGy3naccAZOa/Fa/1tBAsZGq', 'teacher', NULL, NULL, NULL, NULL, NULL),
|
|
|
(3, 'admin', '$2a$10$fclE/Dgq1Ej5fEG9cNwIZu.Me0aFCbGy3naccAZOa/Fa/1tBAsZGq', 'admin', NULL, NULL, NULL, NULL, NULL),
|
|
|
(4, 'chx', '$2a$10$fclE/Dgq1Ej5fEG9cNwIZu.Me0aFCbGy3naccAZOa/Fa/1tBAsZGq', 'student', '12313156', '1233456', 'http://localhost:8080/file/download?name=c5ab3687-2f15-428e-a8e9-4e07bb1ef56d_user.png', '男', '北京市 市辖区 东城区'),
|
|
|
(18, 'chx2', '$2a$10$TtgftGGLDzMgy7TOPbnBJuXZpybkFApZMaZPA8yPg3iqeMJR8CZNm', 'student', NULL, NULL, 'http://localhost:8080/file/download?name=24d23157-044d-46b2-b6f2-759ce9e6d287_背景1.jpg', NULL, '');
|
|
|
COMMIT;
|
|
|
|
|
|
/*!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 */;
|