这是我参与「第五届青训营 」伴学笔记创作活动的第 15 天
users——用户表建表语句：
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
`username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名称',
`password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
`follow_count` int(11) NOT NULL COMMENT '关注总数',
`follower_count` int(11) NOT NULL COMMENT '粉丝总数',
`avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户头像',
`background_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户个人页顶部大图',
`signature` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '个人简介',
`total_favorited` bigint(255) NOT NULL COMMENT '获赞数',
`work_count` int(255) NOT NULL COMMENT '作品数',
`favorite_count` int(255) NOT NULL COMMENT '喜欢数',
`state` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1:可用,0:禁用',
`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
videos——视频表建表语句：
DROP TABLE IF EXISTS `videos`;
CREATE TABLE `videos` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '视频唯一标识id',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '视频标题',
`author_id` int(30) NULL DEFAULT NULL,
`play_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '视频播放地址',
`cover_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '视频封面地址',
`favorite_count` int(11) NOT NULL DEFAULT 0 COMMENT '视频的点赞总数',
`comment_count` int(11) NOT NULL DEFAULT 0 COMMENT '视频的评论总数',
`state` int(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1:可用,0:禁用',
`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1625864120676909057 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '视频表' ROW_FORMAT = Dynamic;
user_favorite_video——用户点赞表建表语句：
DROP TABLE IF EXISTS `user_favorite_video`;
CREATE TABLE `user_favorite_video` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`user_id` int(11) NOT NULL COMMENT '用户id',
`video_id` bigint(11) NOT NULL COMMENT '视频id',
`state` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1:点赞,0:取消点赞',
`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户点赞表' ROW_FORMAT = Dynamic;
comment——评论表建表语句：
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '视频评论id',
`user_id` int(11) NOT NULL COMMENT '评论用户id',
`video_id` bigint(20) NOT NULL COMMENT '该评论所属视频',
`content` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`state` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1:可用,0:禁用',
`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1626227792049864705 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评论表' ROW_FORMAT = Dynamic;
followers——关注表建表语句：
DROP TABLE IF EXISTS `followers`;
CREATE TABLE `followers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from_user_id` int(11) NOT NULL COMMENT '当前用户',
`to_user_id` int(11) NOT NULL COMMENT '被关注用户',
`state` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1:可用,0:禁用',
`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
followers——关注表建表语句：
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '消息id',
`from_user_id` int(11) NOT NULL COMMENT '消息发送者',
`to_user_id` int(11) NOT NULL COMMENT '消息接收者',
`content` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息内容',
`state` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1:可用,0:禁用',
`create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息表' ROW_FORMAT = Dynamic;
