CREATE TABLE `class` (
`classId` int(11) NOT NULL,
`className` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`classId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `class` VALUES (1, 'class 1'),(2, 'class 2'),(3, 'class 3'),(4, 'class 4');
CREATE TABLE `course` (
`courseid` int(11) NOT NULL AUTO_INCREMENT,
`courseName` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`courseid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
INSERT INTO `course` VALUES (1, 'yuwen'),(2, 'shuxue');
CREATE TABLE `score` (
`courseid` int(11) NULL DEFAULT NULL,
`stuid` int(11) NULL DEFAULT NULL,
`score` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
INSERT INTO `score` VALUES (1, 1, 45),(1, 2, 12),(1, 3, 34),(1, 4, 44),(1, 5, 54),(1, 6, 64),(1, 7, 74),(1, 8, 84),(1, 9, 94),(1, 10, 104),(1, 11, 114),(1, 12, 124),(1, 13, 134),(1, 14, 144),(1, 15, 154),(1, 16, 164),(2, 1, 15),(2, 2, 25),(2, 3, 35),(2, 4, 45),(2, 5, 55),(2, 6, 65),(2, 7, 75),(2, 8, 85),(2, 9, 95),(2, 10, 81),(2, 11, 11),(2, 12, 21),(2, 13, 31),(2, 14, 41),(2, 15, 51),(2, 16, 61);
CREATE TABLE `student` (
`stuId` int(11) NOT NULL AUTO_INCREMENT,
`classId` int(11) NULL DEFAULT NULL,
`stuName` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`stuId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
INSERT INTO `student` VALUES (1, 1, '1xiaoming'),(2, 1, '1xiaohong'),(3, 1, '1kunjia'),(4, 1, '1shewang'),(5, 2, '2poo'),(6, 2, '2lk'),(7, 2, '2quanse'),(8, 2, '2yuan'),(9, 3, '3poo'),(10, 3, '3lk'),(11, 3, '3quanse'),(12, 3, '3yuan'),(13, 4, '4poo'),(14, 4, '4lk'),(15, 4, '4quanse'),(16, 4, '4yuan');