sql建表文

-- ----------------------------
-- 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, '元素反应', 1);
INSERT INTO `score` VALUES (2, 83.00, '飞行指南', 1);
INSERT INTO `score` VALUES (3, 63.00, '保底不外', 1);
INSERT INTO `score` VALUES (4, 61.00, '元素反应', 2);
INSERT INTO `score` VALUES (5, 77.00, '飞行指南', 2);
INSERT INTO `score` VALUES (6, 86.00, '保底不外', 2);
INSERT INTO `score` VALUES (7, 90.00, '元素反应', 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);