-- ----------------------------
-- Table structure for class
-- ----------------------------
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` ?(
?`class_id` int(11) 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 ?= Compact;

-- ----------------------------
-- Records of class
-- ----------------------------
INSERT INTO `class` VALUES (1, '蒙德');
INSERT INTO `class` VALUES (2, '璃月');

-- ----------------------------
-- Table structure for score
-- ----------------------------
DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` ?(
?`id` int(11) NOT NULL AUTO_INCREMENT,
?`score` decimal(22, 2) NULL DEFAULT NULL,
?`course` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ?DEFAULT NULL,
?`user_id` int(11) NULL DEFAULT NULL,
?PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = ?utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of score
-- ----------------------------
INSERT INTO `score` VALUES (1, 71.00, '元素反應(yīng)', 1);
INSERT INTO `score` VALUES (2, 83.00, '飛行指南', 1);
INSERT INTO `score` VALUES (3, 63.00, '保底不外', 1);
INSERT INTO `score` VALUES (4, 61.00, '元素反應(yīng)', 2);
INSERT INTO `score` VALUES (5, 77.00, '飛行指南', 2);
INSERT INTO `score` VALUES (6, 86.00, '保底不外', 2);
INSERT INTO `score` VALUES (7, 90.00, '元素反應(yīng)', 3);
INSERT INTO `score` VALUES (8, 58.00, '飛行指南', 3);
INSERT INTO `score` VALUES (9, 76.00, '保底不外', 3);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` ?(
?`user_id` int(11) NOT NULL,
?`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ?DEFAULT NULL,
?`user_gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci ?NULL DEFAULT NULL,
?`user_score` decimal(22, 2) NULL DEFAULT NULL,
?`class_id` int(11) NULL DEFAULT NULL,
?PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT ?= Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '琴', '女', NULL, 1);
INSERT INTO `user` VALUES (2, '迪盧克', '男', NULL, 1);

INSERT INTO `user` VALUES (3, '刻晴', '女', NULL, 2);