/*
 Navicat Premium Data Transfer

 Source Server         : 82.156.204.14
 Source Server Type    : MySQL
 Source Server Version : 80033
 Source Host           : 82.156.204.14:3306
 Source Schema         : sports_dating

 Target Server Type    : MySQL
 Target Server Version : 80033
 File Encoding         : 65001

 Date: 04/07/2024 15:02:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for activity
-- ----------------------------
DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `activity_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动名称',
  `activity_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动描述',
  `activity_count` int NULL DEFAULT 0 COMMENT '参与人数',
  `topic_id` int NULL DEFAULT NULL COMMENT '活动关联专题id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `activity_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '热门活动表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of activity
-- ----------------------------
INSERT INTO `activity` VALUES (1, '活动测试', '测试一下内容', 0, 1, '2024-04-26 19:21:01', NULL);
INSERT INTO `activity` VALUES (2, '活动2', '测试另一个', 0, 2, '2024-05-15 21:18:10', NULL);

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `user_id` int NULL DEFAULT NULL COMMENT '发表用户',
  `article_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '文章内容',
  `article_title` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文章标题',
  `article_cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文章缩略图',
  `article_count` int NULL DEFAULT NULL COMMENT '文章点击数量',
  `category_id` int NULL DEFAULT NULL COMMENT '分类id',
  `is_recommend` int NULL DEFAULT NULL COMMENT '是否推荐',
  `audit_status` int NULL DEFAULT NULL COMMENT '审核通过（0：未审核，1：成功，2：审核未通过）',
  `status` int NULL DEFAULT NULL COMMENT '当前状态（1：保存，2：脱敏，3：审核，4：审核通过，5：发布帖子）',
  `is_delete` int NULL DEFAULT NULL COMMENT '是否删除',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `article_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '论坛文章表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of article
-- ----------------------------
INSERT INTO `article` VALUES (6, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 2, NULL, '2024-05-30 08:36:51', '2024-05-30 08:38:20');
INSERT INTO `article` VALUES (7, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 1, NULL, '2024-05-30 08:42:15', NULL);
INSERT INTO `article` VALUES (9, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 2, NULL, '2024-05-30 09:06:41', '2024-05-30 09:06:42');
INSERT INTO `article` VALUES (10, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 2, NULL, '2024-05-30 09:13:08', '2024-05-30 09:13:08');
INSERT INTO `article` VALUES (11, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 2, NULL, '2024-05-30 09:21:29', '2024-05-30 09:21:29');
INSERT INTO `article` VALUES (12, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 2, NULL, '2024-05-30 09:23:00', '2024-05-30 09:23:01');
INSERT INTO `article` VALUES (13, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 2, NULL, '2024-05-30 09:24:07', '2024-05-30 09:24:08');
INSERT INTO `article` VALUES (14, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 4, NULL, '2024-05-30 09:29:01', '2024-05-30 09:29:01');
INSERT INTO `article` VALUES (15, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 4, NULL, '2024-05-30 09:30:41', '2024-05-30 09:30:52');
INSERT INTO `article` VALUES (21, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 4, NULL, '2024-05-30 10:24:04', '2024-05-30 10:24:04');
INSERT INTO `article` VALUES (22, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 4, NULL, '2024-05-30 10:26:31', '2024-05-30 10:26:31');
INSERT INTO `article` VALUES (23, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 4, NULL, '2024-05-30 10:30:03', '2024-05-30 10:30:03');
INSERT INTO `article` VALUES (24, 10, '测试内容', '测试标题', '测试封面', NULL, NULL, NULL, 1, 4, NULL, '2024-05-30 10:31:24', '2024-05-30 10:31:24');
INSERT INTO `article` VALUES (25, 10, '内容', '测试', '内容', NULL, NULL, NULL, 1, 4, NULL, '2024-05-30 10:33:19', '2024-05-30 10:33:19');
INSERT INTO `article` VALUES (26, 10, '内容', '测试', '内容', NULL, NULL, NULL, 1, 4, NULL, '2024-05-30 10:34:43', '2024-05-30 10:34:47');
INSERT INTO `article` VALUES (27, 10, '内容', '测试', '内容', NULL, NULL, NULL, 1, 2, NULL, '2024-05-30 10:37:09', '2024-05-30 10:37:09');
INSERT INTO `article` VALUES (28, 10, '内容', '测试', '内容', NULL, NULL, NULL, 1, 5, NULL, '2024-05-30 10:39:00', '2024-05-30 10:39:00');
INSERT INTO `article` VALUES (29, 10, '内容', '测试', '内容', NULL, NULL, NULL, 1, 2, NULL, '2024-05-30 10:40:41', '2024-05-30 10:40:41');
INSERT INTO `article` VALUES (30, 10, '内容', '测试', '内容', NULL, NULL, NULL, 1, 5, NULL, '2024-05-30 10:41:58', '2024-05-30 10:41:58');

-- ----------------------------
-- Table structure for article_file
-- ----------------------------
DROP TABLE IF EXISTS `article_file`;
CREATE TABLE `article_file`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `article_id` int NULL DEFAULT NULL COMMENT '文章id',
  `file_id` int NULL DEFAULT NULL COMMENT '文件id',
  `status` int NULL DEFAULT 0 COMMENT '文章id是否存在(0存在，1不存在)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of article_file
-- ----------------------------
INSERT INTO `article_file` VALUES (5, 5, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (6, 6, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (7, 7, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (9, 9, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (10, 10, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (11, 11, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (12, 12, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (13, 13, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (14, 14, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (15, 15, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (16, 21, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (17, 22, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (18, 23, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (19, 24, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (20, 25, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (21, 26, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (22, 27, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (23, 28, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (24, 29, 1, 0, NULL, NULL);
INSERT INTO `article_file` VALUES (25, 30, 1, 0, NULL, NULL);

-- ----------------------------
-- Table structure for article_tag
-- ----------------------------
DROP TABLE IF EXISTS `article_tag`;
CREATE TABLE `article_tag`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `article_id` int NULL DEFAULT NULL COMMENT '文章id',
  `tag_id` int NULL DEFAULT NULL COMMENT '标签id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '论坛文章表和标签表的中间表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of article_tag
-- ----------------------------
INSERT INTO `article_tag` VALUES (1, 5, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (2, 5, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (3, 5, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (4, 6, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (5, 6, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (6, 6, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (7, 7, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (8, 7, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (9, 7, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (13, 9, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (14, 9, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (15, 9, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (16, 10, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (17, 10, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (18, 10, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (19, 11, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (20, 11, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (21, 11, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (22, 12, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (23, 12, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (24, 12, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (25, 13, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (26, 13, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (27, 13, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (28, 14, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (29, 14, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (30, 14, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (31, 15, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (32, 15, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (33, 15, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (34, 21, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (35, 21, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (36, 21, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (37, 22, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (38, 22, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (39, 22, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (40, 23, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (41, 23, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (42, 23, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (43, 24, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (44, 24, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (45, 24, 5, NULL, NULL);
INSERT INTO `article_tag` VALUES (46, 25, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (47, 25, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (48, 26, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (49, 26, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (50, 27, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (51, 27, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (52, 28, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (53, 28, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (54, 29, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (55, 29, 4, NULL, NULL);
INSERT INTO `article_tag` VALUES (56, 30, 1, NULL, NULL);
INSERT INTO `article_tag` VALUES (57, 30, 4, NULL, NULL);

-- ----------------------------
-- Table structure for body_dimension
-- ----------------------------
DROP TABLE IF EXISTS `body_dimension`;
CREATE TABLE `body_dimension`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL COMMENT '用户id',
  `height` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '身高',
  `weight` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '体重',
  `bust` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '胸围',
  `waistline` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '腰围',
  `hips` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '臀围',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '身体维度表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of body_dimension
-- ----------------------------
INSERT INTO `body_dimension` VALUES (2, 17, 170.25, 130.00, 75.50, 148.22, 0.00, '2024-04-18 17:00:58', '2024-04-19 01:04:48');
INSERT INTO `body_dimension` VALUES (4, 18, 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL);

-- ----------------------------
-- Table structure for chat_info
-- ----------------------------
DROP TABLE IF EXISTS `chat_info`;
CREATE TABLE `chat_info`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NULL DEFAULT NULL COMMENT '发送用户',
  `another_id` int NULL DEFAULT NULL COMMENT '对方用户',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '发送内容',
  `time` datetime NULL DEFAULT NULL COMMENT '发送时间',
  `has_read` tinyint(1) NULL DEFAULT NULL COMMENT '是否已读',
  `type` int NULL DEFAULT NULL COMMENT '发送类型（0：文字，1：图片，2：视频，3：运动专题分享，4.论坛文章链接）',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `chat_info_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '聊天详情表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of chat_info
-- ----------------------------

-- ----------------------------
-- Table structure for clock_plan
-- ----------------------------
DROP TABLE IF EXISTS `clock_plan`;
CREATE TABLE `clock_plan`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `plan_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '计划名称',
  `sport_id` int NULL DEFAULT NULL COMMENT '运动视频id',
  `exercise_duration` int NULL DEFAULT NULL COMMENT '运动时长（以分钟为单位）',
  `consumption` int NULL DEFAULT NULL COMMENT '消耗能量',
  `is_finish` tinyint(1) NULL DEFAULT NULL COMMENT '是否已完成',
  `date` date NULL DEFAULT NULL COMMENT '日期',
  `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `clock_plan_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '打卡计划表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of clock_plan
-- ----------------------------
INSERT INTO `clock_plan` VALUES (5, '熬夜计划1', 6, 86, 100, NULL, '2024-04-20', 10, '2024-04-20 06:23:00', '2024-04-20 07:49:00');
INSERT INTO `clock_plan` VALUES (6, '熬夜计划1', NULL, 86, NULL, NULL, '2024-04-20', 10, '2024-04-20 06:23:00', '2024-04-20 07:49:00');

-- ----------------------------
-- Table structure for combination_topic
-- ----------------------------
DROP TABLE IF EXISTS `combination_topic`;
CREATE TABLE `combination_topic`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `topic_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专题名称',
  `topic_info` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专题描述',
  `topic_person_count` int NULL DEFAULT 0 COMMENT '专题训练人数',
  `topic_consumable` int NULL DEFAULT NULL COMMENT '专题消耗大卡',
  `topic_class_id` int NULL DEFAULT NULL COMMENT '专题所属大类',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `topic_images` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专题封面',
  `video_author_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频作者名称',
  `author_images` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '作者头像url',
  `video_id` int NULL DEFAULT NULL COMMENT '视频素材表id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `combination_topic_id_uindex`(`id` ASC) USING BTREE,
  INDEX `idx_topic_class_id`(`topic_class_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '锻炼视频组合专题' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of combination_topic
-- ----------------------------
INSERT INTO `combination_topic` VALUES (1, '臀部训练', '训练臀部', 1, 100, 3, '2024-04-22 16:52:37', NULL, 'https://static.fotor.com.cn/assets/projects/pages/8bd4ab60-c3a9-11e8-8179-c9019fa2bf33_36099e8a-87e5-49b5-bf2c-23a6dd2bdef2_thumb.jpg', '小杰', 'http://82.156.204.14:9001/sport-test/admin@qq.com/image/20240510/1715337981797.png', 7);
INSERT INTO `combination_topic` VALUES (2, '健美操15分钟', '健美操视频', 0, 100, 3, '2024-05-10 12:02:02', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class2-851492d592.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 4);
INSERT INTO `combination_topic` VALUES (3, '美丽芭蕾', '芭蕾可以锻炼身体', 500, 200, 3, '2024-05-10 12:20:07', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (4, '美丽芭蕾111', '芭蕾可以锻炼身体111', 0, 200, 5, '2024-05-12 07:56:15', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (5, '美丽芭蕾222', '芭蕾可以锻炼身体222', 0, 200, 5, '2024-05-12 07:56:23', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (6, '美丽芭蕾333', '芭蕾可以锻炼身体333', 0, 200, 5, '2024-05-12 07:56:28', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (7, '美丽芭蕾444', '芭蕾可以锻炼身体444', 0, 200, 5, '2024-05-12 07:56:34', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (8, '美丽芭蕾555', '芭蕾可以锻炼身体555', 0, 200, 5, '2024-05-12 07:56:39', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (9, 'HIT训练111', 'HIT训练111', 0, 200, 1, '2024-05-12 07:57:57', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (10, 'HIT训练111', 'HIT训练222', 0, 200, 1, '2024-05-12 07:58:01', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (11, 'HIT训练222', 'HIT训练222', 0, 200, 1, '2024-05-12 07:58:04', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (12, 'HIT训练222', 'HIT训练333', 0, 200, 1, '2024-05-12 07:58:07', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (13, 'HIT训练333', 'HIT训练333', 0, 200, 1, '2024-05-12 07:58:09', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (14, 'HIT训练444', 'HIT训练444', 0, 200, 1, '2024-05-12 07:58:15', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (15, 'HIT训练555', 'HIT训练555', 0, 200, 1, '2024-05-12 07:58:21', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (16, '拉伸动作111', '拉伸动作111', 0, 200, 2, '2024-05-12 07:58:43', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (17, '拉伸动作222', '拉伸动作222', 0, 200, 2, '2024-05-12 07:58:48', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);
INSERT INTO `combination_topic` VALUES (18, '拉伸动作333', '拉伸动作333', 0, 200, 2, '2024-05-12 07:58:52', NULL, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 27);

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `parent_id` int NULL DEFAULT NULL COMMENT '父评论id',
  `reply_id` int NULL DEFAULT NULL COMMENT '回复评论id',
  `comment_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评论内容',
  `from_uid` int NULL DEFAULT NULL COMMENT '评论用户id',
  `to_uid` int NULL DEFAULT NULL COMMENT '回复用户id',
  `is_check` int NULL DEFAULT NULL COMMENT '是否通过 (0否 1是)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `comment_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '论坛评论表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of comment
-- ----------------------------

-- ----------------------------
-- Table structure for friend
-- ----------------------------
DROP TABLE IF EXISTS `friend`;
CREATE TABLE `friend`  (
  `id` int NULL DEFAULT NULL COMMENT 'FriendID',
  `current_user_id` int NULL DEFAULT NULL COMMENT '当前用户id',
  `counterpart_user_id` int NULL DEFAULT NULL COMMENT '对方用户id',
  `is_blocking` tinyint(1) NULL DEFAULT NULL COMMENT '是否拉黑',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '好友表（互关就是好友）' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of friend
-- ----------------------------

-- ----------------------------
-- Table structure for health_info
-- ----------------------------
DROP TABLE IF EXISTS `health_info`;
CREATE TABLE `health_info`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  `sport_time` int NULL DEFAULT NULL COMMENT '运动总时间',
  `body_dimension_id` int NULL DEFAULT NULL COMMENT '身体维度id',
  `calories_burned` int NULL DEFAULT NULL COMMENT '今日卡路里消耗',
  `heart_rate` int NULL DEFAULT NULL COMMENT '心率',
  `step_count` int NULL DEFAULT NULL COMMENT '步数',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `health_info_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户健康数据信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of health_info
-- ----------------------------
INSERT INTO `health_info` VALUES (1, 17, NULL, 2, NULL, NULL, NULL, '2024-04-20 07:23:12', NULL);
INSERT INTO `health_info` VALUES (2, 10, NULL, 2, NULL, NULL, NULL, '2024-04-22 17:04:06', NULL);
INSERT INTO `health_info` VALUES (3, 18, NULL, 4, NULL, NULL, NULL, '2024-07-02 09:33:54', NULL);

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单名',
  `path` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单路径',
  `component` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '组件',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单icon',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `require_auth` int NULL DEFAULT NULL COMMENT '是否要权限',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `order_num` tinyint(1) NOT NULL COMMENT '排序',
  `parent_id` int NULL DEFAULT NULL COMMENT '父id',
  `is_hidden` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否隐藏  0否1是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (1, '首页', '/home', 'Home', 'el-icon-help', '2021-01-26 17:06:51', NULL, '2021-01-26 17:06:53', 1, NULL, 0);
INSERT INTO `menu` VALUES (2, '用户管理', '/user', 'Home', 'el-icon-user-solid', '2022-01-12 15:55:14', NULL, '2022-01-12 15:55:16', 2, NULL, 0);
INSERT INTO `menu` VALUES (3, '权限管理', '/per', 'Home', 'el-icon-unlock', '2022-01-12 15:56:32', NULL, '2022-01-12 15:56:35', 3, NULL, 0);
INSERT INTO `menu` VALUES (4, '系统管理', '/setting', 'Home', 'el-icon-s-tools', '2022-01-12 15:58:16', NULL, '2022-01-12 15:58:20', 4, NULL, 0);
INSERT INTO `menu` VALUES (5, '接口管理', '/per/interface', 'PerInterface', 'el-icon-star-on', '2022-01-12 15:59:36', NULL, '2022-01-12 15:59:38', 5, 3, 0);
INSERT INTO `menu` VALUES (6, '角色管理', '/per/perRoles', 'PerRoles', 'el-icon-s-tools', '2022-01-12 16:00:41', NULL, '2022-01-12 16:00:43', 6, 3, 0);
INSERT INTO `menu` VALUES (7, '用户信息', '/users/user', 'UsersUser', 'el-icon-user', '2022-01-12 16:01:44', NULL, '2022-01-12 16:01:47', 7, 2, 0);
INSERT INTO `menu` VALUES (8, '操作日志', '/sysLog', 'SysLog', 'el-icon-document', '2022-01-12 16:02:33', NULL, '2022-01-12 16:02:35', 8, 4, 0);
INSERT INTO `menu` VALUES (11, '个人中心', '/personal', 'Personal', 'el-icon-document', '2022-05-29 15:06:20', NULL, '2022-05-29 15:06:23', 11, 8, 0);

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通知标题',
  `notice_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通知信息',
  `push_state` int NOT NULL DEFAULT 0 COMMENT '推送状态0：未推送，1：正在推送，2：推送成功。3推送失败',
  `is_show` int NULL DEFAULT NULL COMMENT '是否展示\n(0是，1不）',
  `is_delete` int NULL DEFAULT NULL COMMENT '是否删除(0不，1删）',
  `create_user_id` int NOT NULL COMMENT '创建用户',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES (1, '测试', '测试敏感词***', 0, 1, 0, 12, '2024-07-04 03:20:22', NULL);

-- ----------------------------
-- Table structure for operation_log
-- ----------------------------
DROP TABLE IF EXISTS `operation_log`;
CREATE TABLE `operation_log`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `opt_module` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作模块',
  `opt_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作类型',
  `opt_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作url',
  `opt_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作方法',
  `opt_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作描述',
  `request_param` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '请求参数',
  `request_method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求方式',
  `response_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '返回数据',
  `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称',
  `ip_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作ip',
  `ip_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作地址',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 968 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of operation_log
-- ----------------------------
INSERT INTO `operation_log` VALUES (954, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":0,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":false}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:14:58', NULL);
INSERT INTO `operation_log` VALUES (955, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":0,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":false}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:17:34', NULL);
INSERT INTO `operation_log` VALUES (956, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":0,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":false}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:19:17', NULL);
INSERT INTO `operation_log` VALUES (957, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":0,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":false}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:22:44', NULL);
INSERT INTO `operation_log` VALUES (958, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":0,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":false}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:25:10', NULL);
INSERT INTO `operation_log` VALUES (959, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":0,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":false}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:27:34', NULL);
INSERT INTO `operation_log` VALUES (960, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":0,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":true}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:28:33', NULL);
INSERT INTO `operation_log` VALUES (961, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":50,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":true}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:29:09', NULL);
INSERT INTO `operation_log` VALUES (962, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":1,\"sportDate\":\"2024-04-23T08:41:36.357\",\"topicId\":1,\"trainingProgress\":50,\"userId\":10}]', 'POST', '{\"code\":200,\"message\":\"用户训练成功\",\"obj\":true}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-04-23 08:29:23', NULL);
INSERT INTO `operation_log` VALUES (963, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"topicId\":2,\"trainingProgress\":40,\"userId\":10}]', 'POST', '{\"code\":200,\"data\":true,\"message\":\"用户训练成功\"}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-05-10 12:11:17', NULL);
INSERT INTO `operation_log` VALUES (964, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":11,\"topicId\":2,\"trainingProgress\":50,\"userId\":10}]', 'POST', '{\"code\":200,\"data\":true,\"message\":\"用户训练成功\"}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-05-10 12:11:31', NULL);
INSERT INTO `operation_log` VALUES (965, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":3,\"topicId\":2,\"trainingProgress\":50,\"userId\":10}]', 'POST', '{\"code\":200,\"data\":true,\"message\":\"用户训练成功\"}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-05-10 12:11:49', NULL);
INSERT INTO `operation_log` VALUES (966, '运动视频素材', '新增', '/video/admin/saveVideo', 'com.jie.controller.VideoController.saveVideo', '添加运动视频素材', '[{\"consumable\":200,\"multipartFile\":\"https://www.bilibili.com/video/BV1uT411r7dc/?spm_id_from=333.337.search-card.all.click\",\"sportClass\":\"全身1\",\"sportInfo\":\"美丽芭蕾锻炼身体\",\"sportName\":\"美丽芭蕾\"}]', 'POST', '{\"code\":200,\"data\":true,\"message\":\"添加运动视频素材是否成功\"}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-05-10 12:18:44', NULL);
INSERT INTO `operation_log` VALUES (967, '用户锻炼信息模块', '新增或修改', '/user-exercise/addOrUpdate/userExerciseInfo', 'com.jie.controller.UserExerciseController.addUserExerciseInfo', '用户训练专题接口，调用就是开始运动，会记录进度条', '[{\"id\":0,\"topicId\":3,\"trainingProgress\":50,\"userId\":10}]', 'POST', '{\"code\":200,\"data\":true,\"message\":\"用户训练成功\"}', 10, '杰的号', '192.168.137.1', '本地局域网', '2024-05-10 12:21:03', NULL);

-- ----------------------------
-- Table structure for participate
-- ----------------------------
DROP TABLE IF EXISTS `participate`;
CREATE TABLE `participate`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `activity_id` int NULL DEFAULT NULL COMMENT '活动id',
  `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `participate_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '活动参与表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of participate
-- ----------------------------

-- ----------------------------
-- Table structure for resource
-- ----------------------------
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `resource_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '资源名',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限路径',
  `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求方式',
  `parent_id` int NULL DEFAULT NULL COMMENT '父权限id',
  `is_anonymous` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否匿名访问 0否 1是',
  `create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 321 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of resource
-- ----------------------------
INSERT INTO `resource` VALUES (166, '日志模块', NULL, NULL, NULL, 0, '2021-08-11 21:04:21', NULL);
INSERT INTO `resource` VALUES (172, '用户信息模块', NULL, NULL, NULL, 0, '2021-08-11 21:04:21', NULL);
INSERT INTO `resource` VALUES (177, '角色模块', NULL, NULL, NULL, 0, '2021-08-11 21:04:21', NULL);
INSERT INTO `resource` VALUES (179, '资源模块', NULL, NULL, NULL, 0, '2021-08-11 21:04:21', NULL);
INSERT INTO `resource` VALUES (180, '用户模块', NULL, NULL, NULL, 0, '2022-07-27 12:29:01', NULL);
INSERT INTO `resource` VALUES (181, '运动视频资源管理', NULL, NULL, NULL, 0, '2024-04-19 14:45:53', NULL);
INSERT INTO `resource` VALUES (285, '通过角色查询菜单列表', '/system/cfg/menu', 'GET', 176, 0, '2022-07-27 12:13:01', NULL);
INSERT INTO `resource` VALUES (286, '查看当前用户查询菜单', '/system/cfg/user/menus', 'GET', 176, 0, '2022-07-27 12:13:26', NULL);
INSERT INTO `resource` VALUES (287, '查看操作日志', '/api/log/admin/operation/logs', 'GET', 166, 0, '2022-07-27 12:14:41', NULL);
INSERT INTO `resource` VALUES (288, '删除操作日志', '/api/log/admin/operation/logs', 'DELETE', 166, 0, '2022-07-27 12:15:21', NULL);
INSERT INTO `resource` VALUES (292, '查看接口资源列表', '/resource/admin/resources', 'GET', 179, 0, '2022-07-27 12:17:58', NULL);
INSERT INTO `resource` VALUES (293, '查看角色资源选项', '/resource/admin/role/resources', 'GET', 179, 0, '2022-07-27 12:18:26', NULL);
INSERT INTO `resource` VALUES (294, '删除资源', '/resource/admin/deleteResource/*', 'DELETE', 179, 0, '2022-07-27 12:19:05', NULL);
INSERT INTO `resource` VALUES (295, '新增或修改资源', '/resource/admin/saveOrUpdateResource', 'POST', 179, 0, '2022-07-27 12:19:54', NULL);
INSERT INTO `resource` VALUES (296, '获取全部角色', '/role/roles/list', 'GET', 177, 0, '2022-07-27 12:21:33', NULL);
INSERT INTO `resource` VALUES (297, '删除角色', '/role/admin/roles', 'DELETE', 177, 0, '2022-07-27 12:22:14', NULL);
INSERT INTO `resource` VALUES (298, '更新角色信息', '/role/updateRole', 'POST', 177, 0, '2022-07-27 12:23:15', NULL);
INSERT INTO `resource` VALUES (299, '保存或更新角色', '/role/admin/saveOrUpdateRole', 'POST', 177, 0, '2022-07-27 12:24:56', NULL);
INSERT INTO `resource` VALUES (303, '用户app注册', '/registered', 'POST', 180, 0, '2022-07-27 12:28:09', NULL);
INSERT INTO `resource` VALUES (304, '用户app登录', '/app/login', 'POST', 180, 0, '2022-07-27 12:29:59', NULL);
INSERT INTO `resource` VALUES (305, '后台登录', '/login', 'POST', 180, 0, '2022-07-27 12:30:27', NULL);
INSERT INTO `resource` VALUES (306, '获取当前登录用户的信息', '/admin/info', 'GET', 180, 0, '2022-07-27 12:30:49', NULL);
INSERT INTO `resource` VALUES (307, '退出登录', '/logout', 'POST', 180, 0, '2022-07-27 12:31:11', NULL);
INSERT INTO `resource` VALUES (308, '验证码', '/captcha', 'GET', 180, 0, '2022-07-27 12:31:31', NULL);
INSERT INTO `resource` VALUES (309, '管理员修改其他用户密码', '/updateAdminPassword', 'PUT', 180, 0, '2022-07-27 12:31:51', NULL);
INSERT INTO `resource` VALUES (310, '用户修改密码', '/updateUserPassword', 'PUT', 180, 0, '2022-07-27 12:32:11', NULL);
INSERT INTO `resource` VALUES (311, '查询后台用户列表', '/users', 'GET', 180, 0, '2022-07-27 12:32:30', NULL);
INSERT INTO `resource` VALUES (312, '修改当前登录用户的名称', '/user-info/updateNickname', 'POST', 172, 0, '2022-07-27 12:33:17', NULL);
INSERT INTO `resource` VALUES (313, '修改用户的头像信息', '/user-info/updateUserInfoImages', 'POST', 172, 0, '2022-07-27 12:33:59', NULL);
INSERT INTO `resource` VALUES (314, '修改用户权限', '/user-info/role', 'PUT', 172, 0, '2022-07-27 12:34:34', NULL);
INSERT INTO `resource` VALUES (315, '根据用户id获取用户信息', '/user-info/getUserInfoById', 'GET', 172, 0, '2022-07-27 12:34:48', NULL);
INSERT INTO `resource` VALUES (316, '后台统计接口', '/user-info/getStatistics', 'GET', 172, 0, '2022-07-27 12:35:35', NULL);
INSERT INTO `resource` VALUES (317, '添加运动视频素材', '/video/admin/saveVideo', 'POST', 181, 0, '2024-04-19 14:46:00', NULL);
INSERT INTO `resource` VALUES (318, '删除运动视频素材', '/video/admin/deleteVideo/*', 'DELETE', 181, 0, '2024-04-19 18:37:34', NULL);
INSERT INTO `resource` VALUES (319, '根据id查看运动视频素材', '/video/admin/getSportVideoById/*', 'GET', 181, 0, '2024-04-19 18:37:37', NULL);
INSERT INTO `resource` VALUES (320, '查看运动视频素材', '/video/admin/operation/logs', 'GET', 181, 0, '2024-04-19 18:37:38', NULL);

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名',
  `role_label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色描述',
  `is_disable` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用  0否 1是',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, '管理员', 'admin', 0, '2021-03-22 00:00:00', '2021-08-24 11:25:30');
INSERT INTO `role` VALUES (2, '用户', 'user', 0, '2021-03-22 14:25:25', '2021-08-11 21:12:21');
INSERT INTO `role` VALUES (3, '测试', 'test', 0, '2021-03-22 00:00:00', '2021-08-24 11:25:39');
INSERT INTO `role` VALUES (4, '会员等级1', 'vip1', 0, '2024-04-16 20:33:19', '2024-04-16 20:33:21');

-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` int NULL DEFAULT NULL COMMENT '角色id',
  `menu_id` int NULL DEFAULT NULL COMMENT '菜单id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_menu
-- ----------------------------
INSERT INTO `role_menu` VALUES (1, 1, 1);
INSERT INTO `role_menu` VALUES (2, 1, 2);
INSERT INTO `role_menu` VALUES (3, 1, 3);
INSERT INTO `role_menu` VALUES (4, 1, 5);
INSERT INTO `role_menu` VALUES (5, 1, 6);
INSERT INTO `role_menu` VALUES (6, 1, 4);
INSERT INTO `role_menu` VALUES (7, 1, 7);
INSERT INTO `role_menu` VALUES (8, 1, 8);
INSERT INTO `role_menu` VALUES (9, 1, 9);
INSERT INTO `role_menu` VALUES (10, 1, 11);

-- ----------------------------
-- Table structure for role_resource
-- ----------------------------
DROP TABLE IF EXISTS `role_resource`;
CREATE TABLE `role_resource`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_id` int NULL DEFAULT NULL COMMENT '角色id',
  `resource_id` int NULL DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4541 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_resource
-- ----------------------------
INSERT INTO `role_resource` VALUES (1, 2, 296);
INSERT INTO `role_resource` VALUES (4505, 1, 292);
INSERT INTO `role_resource` VALUES (4506, 1, 293);
INSERT INTO `role_resource` VALUES (4507, 1, 294);
INSERT INTO `role_resource` VALUES (4508, 1, 295);
INSERT INTO `role_resource` VALUES (4509, 1, 296);
INSERT INTO `role_resource` VALUES (4510, 1, 297);
INSERT INTO `role_resource` VALUES (4511, 1, 298);
INSERT INTO `role_resource` VALUES (4512, 1, 299);
INSERT INTO `role_resource` VALUES (4513, 1, 300);
INSERT INTO `role_resource` VALUES (4514, 1, 301);
INSERT INTO `role_resource` VALUES (4515, 1, 302);
INSERT INTO `role_resource` VALUES (4516, 1, 303);
INSERT INTO `role_resource` VALUES (4517, 1, 304);
INSERT INTO `role_resource` VALUES (4518, 1, 305);
INSERT INTO `role_resource` VALUES (4519, 1, 306);
INSERT INTO `role_resource` VALUES (4520, 1, 307);
INSERT INTO `role_resource` VALUES (4521, 1, 308);
INSERT INTO `role_resource` VALUES (4522, 1, 309);
INSERT INTO `role_resource` VALUES (4523, 1, 310);
INSERT INTO `role_resource` VALUES (4524, 1, 311);
INSERT INTO `role_resource` VALUES (4525, 1, 312);
INSERT INTO `role_resource` VALUES (4526, 1, 313);
INSERT INTO `role_resource` VALUES (4527, 1, 314);
INSERT INTO `role_resource` VALUES (4528, 1, 315);
INSERT INTO `role_resource` VALUES (4529, 1, 316);
INSERT INTO `role_resource` VALUES (4530, 1, 166);
INSERT INTO `role_resource` VALUES (4531, 1, 285);
INSERT INTO `role_resource` VALUES (4532, 1, 286);
INSERT INTO `role_resource` VALUES (4533, 1, 287);
INSERT INTO `role_resource` VALUES (4534, 1, 288);
INSERT INTO `role_resource` VALUES (4537, 1, 318);
INSERT INTO `role_resource` VALUES (4538, 1, 317);
INSERT INTO `role_resource` VALUES (4539, 1, 319);
INSERT INTO `role_resource` VALUES (4540, 1, 320);

-- ----------------------------
-- Table structure for sport_file
-- ----------------------------
DROP TABLE IF EXISTS `sport_file`;
CREATE TABLE `sport_file`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件url',
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
  `file_size` int NULL DEFAULT NULL COMMENT '文件大小',
  `extend_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件类型',
  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件路径',
  `is_dir` int NULL DEFAULT NULL COMMENT '文件是否为目录(0是，1不是)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统的文件存储表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sport_file
-- ----------------------------
INSERT INTO `sport_file` VALUES (1, 'http://82.156.204.14:9001/sport-test/test/file/20240529/1716965399267.jpg', 'file', 144017, 'image/jpeg', NULL, NULL, '2024-05-29 06:49:59', NULL);
INSERT INTO `sport_file` VALUES (2, 'http://82.156.204.14:9001/sport-test/test/file/20240529/1716965923949.jpg', 'file', 144017, 'image/jpeg', '/sport-test/test/file/20240529/1716965923949.jpg', NULL, '2024-05-29 06:58:44', NULL);
INSERT INTO `sport_file` VALUES (3, 'http://82.156.204.14:9001/sport-test/test/file/20240529/1716966677323.jpg', 'file', 144017, 'image/jpeg', '/sport-test/test/file/20240529/1716966677323.jpg', NULL, '2024-05-29 07:11:17', NULL);
INSERT INTO `sport_file` VALUES (4, 'http://82.156.204.14:9001/sport-test/test/file/20240529/1716966723684.jpg', 'file', 144017, 'image/jpeg', '/sport-test/test/file/20240529/1716966723684.jpg', NULL, '2024-05-29 07:12:04', NULL);

-- ----------------------------
-- Table structure for tag
-- ----------------------------
DROP TABLE IF EXISTS `tag`;
CREATE TABLE `tag`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `tag_name` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标签名称',
  `tag_info` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标签类型描述',
  `is_hidden` tinyint(1) NULL DEFAULT NULL COMMENT '是否隐藏',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `article_type_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '论坛标签类型表(类似选择标签）' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tag
-- ----------------------------
INSERT INTO `tag` VALUES (1, 'Java', 'Java描述', 0, '2024-05-30 16:10:07', NULL);
INSERT INTO `tag` VALUES (4, 'java', NULL, NULL, '2024-05-30 08:33:00', NULL);
INSERT INTO `tag` VALUES (5, 'python', NULL, NULL, '2024-05-30 08:33:00', NULL);

-- ----------------------------
-- Table structure for thematic_category
-- ----------------------------
DROP TABLE IF EXISTS `thematic_category`;
CREATE TABLE `thematic_category`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id\n',
  `tipic_class_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专题大类名称',
  `tipic_class_info` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专题大类描述',
  `tipic_person_count` int NULL DEFAULT NULL COMMENT '专题训练人数',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `thematic_category_id_uindex`(`id` ASC) USING BTREE,
  INDEX `idx_tipic_class_name`(`tipic_class_name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '专题大类' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of thematic_category
-- ----------------------------
INSERT INTO `thematic_category` VALUES (1, 'HIIT训练', '短时间内提供比较大的训练量，单位时间给身体带来较高的消耗', 100, NULL, NULL);
INSERT INTO `thematic_category` VALUES (2, '拉伸动作', '放松拉伸', 60, '2024-04-21 10:45:09', '2024-04-21 10:47:18');
INSERT INTO `thematic_category` VALUES (3, '健身操', '用跳舞的方式来进行锻炼', 80, '2024-04-21 10:48:17', NULL);
INSERT INTO `thematic_category` VALUES (4, '臀部', '臀部专题', 1, '2024-05-10 19:56:03', NULL);
INSERT INTO `thematic_category` VALUES (5, '芭蕾', '芭蕾舞蹈', 0, '2024-05-10 12:13:42', NULL);

-- ----------------------------
-- Table structure for user_activity
-- ----------------------------
DROP TABLE IF EXISTS `user_activity`;
CREATE TABLE `user_activity`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  `activity_id` int NULL DEFAULT NULL COMMENT '活动id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_activity
-- ----------------------------
INSERT INTO `user_activity` VALUES (5, 10, 2, '2024-05-15 13:18:18', NULL);
INSERT INTO `user_activity` VALUES (7, 12, 1, '2024-05-15 13:20:41', NULL);
INSERT INTO `user_activity` VALUES (9, 12, 2, '2024-05-15 13:21:07', NULL);

-- ----------------------------
-- Table structure for user_exercise
-- ----------------------------
DROP TABLE IF EXISTS `user_exercise`;
CREATE TABLE `user_exercise`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  `topic_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '训练姓名',
  `topic_id` int NULL DEFAULT NULL COMMENT '训练专题',
  `training_progress` int NULL DEFAULT NULL COMMENT '训练进度',
  `topic_images` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '训练封面',
  `sport_date` datetime NULL DEFAULT NULL COMMENT '训练日期',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `video_author_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频作者名称',
  `author_images` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '作者头像url',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `user_exercise_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户锻炼表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user_exercise
-- ----------------------------
INSERT INTO `user_exercise` VALUES (1, 10, '臀部训练', 1, 50, 'https://static.fotor.com.cn/assets/projects/pages/8bd4ab60-c3a9-11e8-8179-c9019fa2bf33_36099e8a-87e5-49b5-bf2c-23a6dd2bdef2_thumb.jpg', '2024-04-23 00:41:36', '2024-04-23 08:28:33', '2024-04-23 08:29:23', '小杰', 'http://82.156.204.14:9001/sport-test/admin@qq.com/image/20240510/1715337981797.png');
INSERT INTO `user_exercise` VALUES (3, 10, '健美操15分钟', 2, 50, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class2-851492d592.png', '2024-05-10 12:11:49', '2024-05-10 12:11:16', '2024-05-10 12:11:49', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png');
INSERT INTO `user_exercise` VALUES (5, 10, '美丽芭蕾', 3, 50, 'https://staticweb.keepcdn.com/staticShow/images/appintro/app_pic_t2_class1-227e7b6a59.png', '2024-05-10 12:21:03', '2024-05-10 12:21:03', NULL, '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png');

-- ----------------------------
-- Table structure for user_experience
-- ----------------------------
DROP TABLE IF EXISTS `user_experience`;
CREATE TABLE `user_experience`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int NOT NULL COMMENT '用户id',
  `experience` int NOT NULL COMMENT '经验值',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '称号（默认为k1，k1(0-100),k2(100-200)）',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_experience
-- ----------------------------

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账户',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名称',
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像地址',
  `is_disable` tinyint(1) NULL DEFAULT 0 COMMENT '是否禁用(0:未禁用,1：禁用)',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',
  `login_type` int(1) UNSIGNED ZEROFILL NULL DEFAULT NULL COMMENT '登录类型',
  `ip_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ip地址',
  `ip_source` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ip来源',
  `last_login_time` datetime NULL DEFAULT NULL COMMENT '最近登录时间',
  `user_experience_id` int NULL DEFAULT NULL COMMENT '用户称号id',
  `birthday` datetime NULL DEFAULT NULL COMMENT '出生年月日',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱ID',
  `create_time` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (9, 'string', '$2a$10$MzbSMnPhW8VzEcL6MS0JzOKSF6XhK7QYm1EwXzsp92RtCWPM8lkti', 'string', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-17 03:14:08', NULL);
INSERT INTO `user_info` VALUES (10, 'admin@qq.com', '$2a$10$/ceJZYDSLJqLwX1pzmLZpOy11E8lIlQjPqMHCpEQCBxJOLZTYjn6K', '杰的号', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 0, NULL, 0, '100.67.243.231', '保留地址', '2024-05-20 12:04:23', NULL, NULL, NULL, '2024-05-20 12:04:23', '2024-05-20 12:04:24');
INSERT INTO `user_info` VALUES (12, 'test', '$2a$10$Vd2uIKuTn0Jqk781ydZ/Nex71UnPxJCltne/Jx2yCTI17cFv79RzO', '测试一些', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 0, NULL, 0, '10.6.217.86', '本地局域网', '2024-07-04 03:18:42', NULL, NULL, NULL, '2024-07-04 03:18:42', '2024-07-04 03:18:43');
INSERT INTO `user_info` VALUES (13, 'test111', '$2a$10$Lf/q2x/10xgVaP7ejpCijOx9qb6L4BBjtAXQIxjGZFRSvRsaMPU8S', '测试', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (14, 'test222', '$2a$10$M6tGqM.vcNdRWv3KM2rNjed4p3wtGYJYImo6wrw3i9fWN66ZvQg3e', '测试2222', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (16, 'testha', '$2a$10$u1WLO2bRVa3dV3a7QZeWHOEimfst83VQTOD8JA8jL9So73HKrVSrG', '测试新功能', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` VALUES (17, 'testhah', '$2a$10$Q0cFTlH14FcRGW6BLkqqQ.KPQk4cSfXkdBp/hrgw4rsK9NYaEttte', '测试新功能', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 0, NULL, 0, '192.168.137.1', '本地局域网', '2024-04-22 09:21:55', NULL, NULL, NULL, '2024-04-22 09:21:55', '2024-04-22 09:21:55');
INSERT INTO `user_info` VALUES (18, 'xainsir', '$2a$10$lCskZktixms7dphil5d.gOwz3WAN9Z4qodSPRJwxp09LkTPNCWtVK', 'xainsir', 'https://img.51miz.com/Element/00/88/08/86/716b81c7_E880886_bebe0ef3.png', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  `role_id` int NULL DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 663 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES (652, 4, 2);
INSERT INTO `user_role` VALUES (653, 5, 1);
INSERT INTO `user_role` VALUES (654, 6, 3);
INSERT INTO `user_role` VALUES (655, 10, 1);
INSERT INTO `user_role` VALUES (656, 11, 2);
INSERT INTO `user_role` VALUES (657, 12, 1);
INSERT INTO `user_role` VALUES (658, 14, 2);
INSERT INTO `user_role` VALUES (661, 17, 1);
INSERT INTO `user_role` VALUES (662, 18, 2);

-- ----------------------------
-- Table structure for video_material
-- ----------------------------
DROP TABLE IF EXISTS `video_material`;
CREATE TABLE `video_material`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `sport_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '运动名称',
  `sport_info` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '运动描述信息',
  `sport_class` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '运动种类',
  `sport_count` int NULL DEFAULT NULL COMMENT '运动数量',
  `sport_video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频资源路径',
  `consumable` int NULL DEFAULT NULL COMMENT '消耗大卡',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `video_material_id_uindex`(`id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '锻炼视频素材表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of video_material
-- ----------------------------
INSERT INTO `video_material` VALUES (4, '全身燃脂', '15分钟燃脂运动', '全身', 1, 'https://www.bilibili.com/video/BV1a5411J7V9/?spm_id_from=333.337.search-card.all.click', 100, '2024-04-19 07:00:04', '2024-04-19 07:00:04');
INSERT INTO `video_material` VALUES (5, '腹部锻炼', '8分钟腹部+拉伸', '腹部', 1, 'https://www.bilibili.com/video/BV1ky4y117wd/?spm_id_from=333.788&vd_source=da8d988cabf177bcba64ec79fc4bede1', 100, '2024-04-19 07:02:11', '2024-04-19 07:02:11');
INSERT INTO `video_material` VALUES (6, '疯狂燃脂', '12分钟全身运动', '全身', 1, 'https://www.bilibili.com/video/BV1wp4y1S7jw/?spm_id_from=333.337.search-card.all.click&vd_source=da8d988cabf177bcba64ec79fc4bede1', 100, '2024-04-19 07:04:12', '2024-04-19 07:04:12');
INSERT INTO `video_material` VALUES (7, '臀部训练1', '15分钟臀部训练', '臀部', 1, 'https://www.bilibili.com/video/BV1r5411s7Ck/?spm_id_from=333.337.search-card.all.click', 100, '2024-04-19 07:07:06', '2024-04-19 07:07:06');
INSERT INTO `video_material` VALUES (8, '臀部训练2', '15分钟臀部训练', '臀部', 1, 'https://www.bilibili.com/video/BV1ug4y1q7sM/?spm_id_from=333.337.search-card.all.click&vd_source=da8d988cabf177bcba64ec79fc4bede1', 100, '2024-04-19 07:07:29', '2024-04-19 07:07:29');
INSERT INTO `video_material` VALUES (9, '臀部训练3', '5个最好的臀部训练', '臀部', 1, 'https://www.bilibili.com/video/BV1z3411Q7AV/?spm_id_from=333.337.search-card.all.click&vd_source=da8d988cabf177bcba64ec79fc4bede1', 100, '2024-04-19 07:08:18', '2024-04-19 07:08:18');
INSERT INTO `video_material` VALUES (10, '臀部训练4', '20分钟高能虐臀', '臀部', 1, 'https://www.bilibili.com/video/BV1uT411r7dc/?spm_id_from=333.337.search-card.all.click', 100, '2024-04-19 07:08:51', '2024-04-19 07:08:51');
INSERT INTO `video_material` VALUES (11, '腹部训练2', '6分钟新手腹部训练', '腹部', 1, 'https://www.bilibili.com/video/BV1QW4y1U7fY/?spm_id_from=333.337.search-card.all.click', 100, '2024-04-19 07:10:04', '2024-04-19 07:10:04');
INSERT INTO `video_material` VALUES (27, '美丽芭蕾', '美丽芭蕾锻炼身体', '全身1', 11, 'https://www.bilibili.com/video/BV1uT411r7dc/?spm_id_from=333.337.search-card.all.click', 200, '2024-05-10 12:18:44', NULL);

SET FOREIGN_KEY_CHECKS = 1;