forked from wujun728/jun_java_plugin
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmybatis.sql
More file actions
137 lines (120 loc) · 5.43 KB
/
mybatis.sql
File metadata and controls
137 lines (120 loc) · 5.43 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
/*
Navicat Premium Data Transfer
Source Server : 127.0.0.1_3306
Source Server Type : MySQL
Source Server Version : 80019
Source Host : 127.0.0.1:3306
Source Schema : mybatis
Target Server Type : MySQL
Target Server Version : 80019
File Encoding : 65001
Date: 24/12/2020 14:37:21
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
`sex` int(0) NULL DEFAULT NULL,
`id` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '博客id',
`title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '博客标题',
`author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '博客作者',
`create_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`views` int(0) NULL DEFAULT NULL COMMENT '浏览量'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of blog
-- ----------------------------
INSERT INTO `blog` VALUES (0, '1', '好困好累', '李斌', '2020-12-13 10:08:29', 5555);
INSERT INTO `blog` VALUES (1, '2', '好想睡觉', '李斌2', '2020-12-13 10:08:29', 15555);
INSERT INTO `blog` VALUES (0, '3', '咩咩咩咩', '李斌3', '2020-12-13 10:08:29', 3255);
INSERT INTO `blog` VALUES (1, '99', '测试', 'yznl2', '2020-12-22 15.52.22', 1);
INSERT INTO `blog` VALUES (1, '199', '1测试', 'yznl', '2020-12-22 15.52.22', 1);
INSERT INTO `blog` VALUES (0, '10', '测试转换器', '转换器', '2020-12-22 15.52.22', 8);
INSERT INTO `blog` VALUES (1, '999', '测试', 'sex测试', '2020-12-22 15.52.22', 1);
INSERT INTO `blog` VALUES (1, '999', '测试', 'sex测试', '2020-12-22 15.52.22', 1);
INSERT INTO `blog` VALUES (NULL, '222', '1测试', 'yznl', '2020-12-22 15.52.22', 1);
-- ----------------------------
-- Table structure for books
-- ----------------------------
DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
`bookID` int(0) NOT NULL AUTO_INCREMENT,
`bookName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '书名',
`bookCounts` int(0) NOT NULL COMMENT '数量',
`detail` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述',
INDEX `bookID`(`bookID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of books
-- ----------------------------
INSERT INTO `books` VALUES (1, 'Java', 1, '从入门到放弃');
INSERT INTO `books` VALUES (2, 'Mysql', 100, '从删库到跑路');
INSERT INTO `books` VALUES (3, 'Linux', 5, '从进门到进牢');
-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` int(0) NOT NULL,
`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`sex` int(0) NULL DEFAULT NULL,
`class_id` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `fktid`(`sex`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (1, '张三', 0, 2);
INSERT INTO `student` VALUES (2, '李四', 1, 1);
INSERT INTO `student` VALUES (3, '王刚', 1, 1);
INSERT INTO `student` VALUES (4, '广顺', 0, 1);
-- ----------------------------
-- Table structure for studentclass
-- ----------------------------
DROP TABLE IF EXISTS `studentclass`;
CREATE TABLE `studentclass` (
`class_id` int(0) NOT NULL COMMENT '班级Id',
`class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级名称',
PRIMARY KEY (`class_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of studentclass
-- ----------------------------
INSERT INTO `studentclass` VALUES (1, '高三四班');
-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
`id` int(0) NOT NULL,
`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES (113, '李老师');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(0) NOT NULL,
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`pwd` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '李斌', '123456');
INSERT INTO `user` VALUES (2, '李斌2', '123456');
INSERT INTO `user` VALUES (3, '李斌3', '123456');
INSERT INTO `user` VALUES (13, 'l13', '123456');
INSERT INTO `user` VALUES (824, 'lb', '123');
INSERT INTO `user` VALUES (825, 'lb', '123');
SET FOREIGN_KEY_CHECKS = 1;