gym.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50714
Source Host           : localhost:3306
Source Database       : gym

Target Server Type    : MYSQL
Target Server Version : 50714
File Encoding         : 65001

Date: 2023-01-15 22:26:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for classrecord
-- ----------------------------
DROP TABLE IF EXISTS `classrecord`;
CREATE TABLE `classrecord` (
  `crid` int(11) NOT NULL AUTO_INCREMENT,
  `csid` int(11) DEFAULT NULL,
  `mbid` int(11) DEFAULT NULL,
  `crtime` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`crid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of classrecord
-- ----------------------------
INSERT INTO `classrecord` VALUES ('4', '1', '1', '2023-01-08');
INSERT INTO `classrecord` VALUES ('5', '1', '6', '2023-01-09');
INSERT INTO `classrecord` VALUES ('6', '1', '1', '2023-01-09');

-- ----------------------------
-- Table structure for coach
-- ----------------------------
DROP TABLE IF EXISTS `coach`;
CREATE TABLE `coach` (
  `caid` int(11) NOT NULL AUTO_INCREMENT,
  `caname` varchar(255) DEFAULT NULL,
  `casex` varchar(255) DEFAULT NULL,
  `caage` varchar(255) DEFAULT NULL,
  `caspecial` varchar(255) DEFAULT NULL,
  `capicture` varchar(255) DEFAULT NULL,
  `caintro` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`caid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of coach
-- ----------------------------
INSERT INTO `coach` VALUES ('1', '张明', '男', '25', '自己搏击', '/upload/1673166139880.jpg', '今天都是是的');
INSERT INTO `coach` VALUES ('2', '陈刚', '男', '26', '体能训练', '/upload/1673168230924.jpg', '大幅度发');

-- ----------------------------
-- Table structure for course
-- ----------------------------