/*
Navicat Premium Data Transfer
Source Server : springbootTest
Source Server Type : MySQL
Source Server Version : 50727
Source Host : localhost:3306
Source Schema : test
Target Server Type : MySQL
Target Server Version : 50727
File Encoding : 65001
Date: 29/10/2019 15:59:04
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`c_id` int(11) NOT NULL AUTO_INCREMENT,
`c_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`c_grade` int(11) DEFAULT NULL,
`stu_id` int(11) DEFAULT NULL,
PRIMARY KEY (`c_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES (1, '数学', 80, 1);
INSERT INTO `course` VALUES (2, '英语', 90, 1);
INSERT INTO `course` VALUES (3, '语文', 100, 1);
INSERT INTO `course` VALUES (4, '语文', 12, 2);
INSERT INTO `course` VALUES (5, '数学', 100, 2);
-- ----------------------------
-- Table structure for stu
-- ----------------------------
DROP TABLE IF EXISTS `stu`;
CREATE TABLE `stu` (
`stu_id` int(11) NOT NULL AUTO_INCREMENT,
`stu_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`stu_age` int(11) DEFAULT NULL,
PRIMARY KEY (`stu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stu
-- ----------------------------
INSERT INTO `stu` VALUES (1, '张三', 18);
INSERT INTO `stu` VALUES (2, '李四', 19);
SET FOREIGN_KEY_CHECKS = 1;
