小程序短视频项目———数据库设计

⼩程序短视频项⽬———数据库设计数据库表的名字叫做imooc-video-dev
/*
Navicat MariaDB Data Transfer
Source Server        : .
Source Server Version : 100122
Source Host          : localhost:3306
Source Database      : imooc-video-dev
Target Server Type    : MariaDB
Target Server Version : 100122
File Encoding        : 65001
Date: 2018-05-30 19:37:40
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for bgm
数据融合
-- ----------------------------
DROP TABLE IF EXISTS `bgm`;
CREATE TABLE `bgm` (
`id` varchar(64) NOT NULL,
`author` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`path` varchar(255) NOT NULL COMMENT '播放地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of bgm
-- ----------------------------
INSERT INTO `bgm` VALUES ('18052674D26HH32P', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\好歌曲.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH33P', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH3X1', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH3X2', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH3X3', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH3X5', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH3X6', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH3X7', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH3X8', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('18052674D26HH3X9', '测试歌⼿名字', 'abc歌曲~~', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('1805290R3WTDMT9P', 'aa', 'aa', '\\bgm\\music.mp3');
INSERT INTO `bgm` VALUES ('180530DXKK4YYGTC', '达⽡', 'dwadw', '\\bgm\\music好歌曲.mp3');
-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
`id` varchar(20) NOT NULL,
`father_comment_id` varchar(20) DEFAULT NULL,
`to_user_id` varchar(20) DEFAULT NULL,
`video_id` varchar(20) NOT NULL COMMENT '视频id',
`from_user_id` varchar(20) NOT NULL COMMENT '留⾔者,评论的⽤户id',印刷制版机
`comment` text NOT NULL COMMENT '评论内容',
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程评论表';
-- ----------------------------
-- Records of comments
-- ----------------------------
INSERT INTO `comments` VALUES ('135240CW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈1', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('18034CW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈2', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('1803F50CW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈3', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('18052150CW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈4', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('180522F50626894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈5', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('180522F50C126894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈6', '2018-05-22 19:52:02');
服务器硬件检测INSERT INTO `comments` VALUES ('180522F50CW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈7', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('180522F5346894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈8', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('180522F54CW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈9', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('180523F533Y0837C', null, null, '180510CD0A6K3SRP', '180425CFA4RB6T0H', 'dwdawdwa', '2018-05-23
19:52:19');
INSERT INTO `comments` VALUES ('180523FATAR6C2Y8', '180523FB1BYS43HH', '180425CFA4RB6T0H', '180522FB4BZ1N9P0',
'180518CKMAAM5TXP', '回复评论', '2018-05-23 20:09:30');
INSERT INTO `comments` VALUES ('180523FB1BYS43HH', null, null, '180522FB4BZ1N9P0', '180425CFA4RB6T0H', '野马~~', '2018-05-23 20:10:09'); INSERT INTO `comments` VALUES ('180523FC0MKCTS3C', null, null, '180522FB4BZ1N9P0', '180425CFA4RB6T0H', 'dwdw', '2018-05-23 20:13:04'); INSERT INTO `comments` VALUES ('180523FCZM2CTCZC', null, null, '180522FB4BZ1N9P0', '180425CFA4RB6T0H', 'dwqdwqdqw', '2018-05-23 20:15:58');
INSERT INTO `comments` VALUES ('180523FD1H5HG9P0', null, null, '180522FB4BZ1N9P0', '1804
25CFA4RB6T0H', '1fewdew', '2018-05-23
20:16:10');
INSERT INTO `comments` VALUES ('180523FDBT3S3C00', null, null, '180522FB4BZ1N9P0', '180425CFA4RB6T0H', '123', '2018-05-23 20:17:16'); INSERT INTO `comments` VALUES ('180523FDFX4HS5P0', null, null, '180522FB4BZ1N9P0', '180425CFA4RB6T0H', '43trgtew', '2018-05-23
20:17:36');
INSERT INTO `comments` VALUES ('180523H79060HNHH', null, null, '180522FB4BZ1N9P0', '180425CFA4RB6T0H', '哈多好玩聊哦', '2018-05-23 22:47:06');
INSERT INTO `comments` VALUES ('180523HATXR841KP', null, null, '180522FB4BZ1N9P0', '180425CFA4RB6T0H', '⼤家诶哦⼤家欧⽂', '2018-05-23 22:57:42');
INSERT INTO `comments` VALUES ('180523K2DG3SGAA8', null, null, '180522FB4BZ1N9P0', '180518CKMAAM5TXP', 'dwdw', '2018-05-23 23:56:38'); INSERT INTO `comments` VALUES ('180523K2YRF1WNXP', null, null, '180522FB4BZ1N9P0', '180518CKMAAM5TXP', 'ddew', '2018-05-
23 23:58:03'); INSERT INTO `comments` VALUES ('180523K3FH1WT7R4', null, null, '180522FB4BZ1N9P0', '180518CKMAAM5TXP', 'tgergre', '2018-05-23
23:59:45');
INSERT INTO `comments` VALUES ('1805240G4G19R0PH', '180523HATXR841KP', '180425CFA4RB6T0H', '180522FB4BZ1N9P0',
'180518CKMAAM5TXP', '回复测试,final', '2018-05-24 00:45:31');
亮晶晶眼贴INSERT INTO `comments` VALUES ('18055W46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈11', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('180565016894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈22', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('1805650CW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈33', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('1805twW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈44', '2018-05-22 19:52:02');
INSERT INTO `comments` VALUES ('280522F50CW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈55', '2018-05-22 19:52:02');
05-22 19:52:02');
INSERT INTO `comments` VALUES ('qq1805twW46894', null, null, '180510CD0A6K3SRP', '180518CKMAAM5TXP', 'hhhh 测试啊哈哈哈66', '2018-05-22 19:52:02');
-- ----------------------------
-- Table structure for search_records
-- ----------------------------
DROP TABLE IF EXISTS `search_records`;
CREATE TABLE `search_records` (
`id` varchar(64) NOT NULL,
`content` varchar(255) NOT NULL COMMENT '搜索的内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='视频搜索的记录表';
-- ----------------------------
-- Records of search_records
-- ----------------------------
INSERT INTO `search_records` VALUES ('1', '慕课⽹');
INSERT INTO `search_records` VALUES ('18051309YBCMHYRP', '风景');
INSERT INTO `search_records` VALUES ('1805130DAXX58ARP', '风景');
INSERT INTO `search_records` VALUES ('1805130DMG6P0ZC0', '风景');
INSERT INTO `search_records` VALUES ('1805130FNGHD3B0H', '慕课⽹');
INSERT INTO `search_records` VALUES ('180513C94W152Z7C', 'dwqdwq');
INSERT INTO `search_records` VALUES ('180513DXNT7SY04H', '风景');
INSERT INTO `search_records` VALUES ('2', '慕课⽹');
INSERT INTO `search_records` VALUES ('3', '慕课⽹');收获时间
INSERT INTO `search_records` VALUES ('4', '慕课⽹');
INSERT INTO `search_records` VALUES ('5', '慕课');
INSERT INTO `search_records` VALUES ('6', '慕课');
INSERT INTO `search_records` VALUES ('7', 'zookeeper');
INSERT INTO `search_records` VALUES ('8', 'zookeeper');
INSERT INTO `search_records` VALUES ('9', 'zookeeper');
-- ----------------------------
-- Table structure for users
-
- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` varchar(64) NOT NULL,
`username` varchar(20) NOT NULL COMMENT '⽤户名',
`password` varchar(64) NOT NULL COMMENT '密码',
`face_image` varchar(255) DEFAULT NULL COMMENT '我的头像,如果没有默认给⼀张',
`nickname` varchar(20) NOT NULL COMMENT '昵称',
`fans_counts` int(11) DEFAULT'0' COMMENT '我的粉丝数量',
`follow_counts` int(11) DEFAULT'0' COMMENT '我关注的⼈总数',
`receive_like_counts` int(11) DEFAULT'0' COMMENT '我接受到的赞美/收藏的数量',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1001', 'test-imooc-1111', '9999', '/path000999', '慕课⽹好⽜⼗分⽜~', '123456', '111', '222');
INSERT INTO `users` VALUES ('180425B0B3N6B25P', 'imooc11', 'wzNncBURtPYCDsYd7TUgWQ==', null, 'imooc', '0', '0', '0');
INSERT INTO `users` VALUES ('180425BNSR1CG0H0', 'abc', '4QrcOUm6Wau+VuBX8g+IPg==', nu
ll, 'abc', '0', '0', '0');
INSERT INTO `users` VALUES ('180425CFA4RB6T0H', 'imooc', 'kU8h64TG/bK2Y91vRT9lyg==',
'/180425CFA4RB6T0H/face/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.W0eLNdT6MIvD3ba01f74ba779caa63d038c3c8200b4a.jpg', 'imooc1', '0', '2', '6');
INSERT INTO `users` VALUES ('180426F4D35R04X4', 'aaa', 'R7zlx09Yn0hn29V+nKn4CA==', null, 'aaa', '0', '0', '0');
INSERT INTO `users` VALUES ('180426F55CZPA9YW', 'aaaa', 'R7zlx09Yn0hn29V+nKn4CA==', null, 'aaaa', '0', '0', '0');
INSERT INTO `users` VALUES ('180426GA3SBB4DP0', '1001', 'bfw1xHdW6WLvBV0QSfH47A==', null, '1001', '0', '0', '0');
INSERT INTO `users` VALUES ('180426GAK87AB0X4', '10401', 'bfw1xHdW6WLvBV0QSfH47A==', null, '10401', '0', '0', '0');
INSERT INTO `users` VALUES ('180426GAWCC17KWH', '104701', 'bfw1xHdW6WLvBV0QSfH47A==', null, '104701', '0', '0', '0');
INSERT INTO `users` VALUES ('180426GBDFKDG5D4', '10re4701', 'bfw1xHdW6WLvBV0QSfH47A==', null, '10re4701', '0', '0', '0');
INSERT INTO `users` VALUES ('180426GBDFKDG5D4', '10re4701', 'bfw1xHdW6WLvBV0QSfH47A==', null, '10re4701', '0', '0', '0');
INSERT INTO `users` VALUES ('180426GBKN0YRFRP', '10rwee4701', 'bfw1xHdW6WLvBV0QSfH47A==', null, '10rwee4701', '0', '0', '0');
INSERT INTO `users` VALUES ('180426GH49XRZHX4', '390213890', 'H9V/tnfgt6nniqH5bDZ0hQ==', null, '390213890', '0', '0', '0');
INSERT INTO `users` VALUES ('180426GHH12WXPZC', '390ewqewq213890', 'H9V/tnfgt6nniqH5bDZ0hQ==', null, '390ewqewq213890', '0', '0', '0'); INSERT INTO `users` VALUES ('180426GHHPZ7NTC0', '390ewqewq21ewqe3890', 'H9V/tnfgt6nniqH5bDZ0hQ==', null, '390ewqewq21ewqe3890', '0', '0', '0');
INSERT INTO `users` VALUES ('180426H0GWP0C3HH', 'jdiowqjodij', 'wEmTz54sy+StEzB+TrtGSQ==', null, 'jdiowqjodij', '0', '0', '0');
INSERT INTO `users` VALUES ('180518CHS7SXMCX4', 'aaaaa', 'WU+AOzgKQTlu1j3KOVA1Qg==', null, 'aaaaa', '0', '0', '0');
INSERT INTO `users` VALUES ('180518CKMAAM5TXP', 'abc123', '6ZoYxCjLONXyYIU2eJIuAw==',
'/180518CKMAAM5TXP/face/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.Q27j7DxNKKk07adf242959818c45238b8f11b64cc255.png', 'abc123', '0', '0', '1');
-- ----------------------------
-- Table structure for users_fans
-- ----------------------------
DROP TABLE IF EXISTS `users_fans`;
CREATE TABLE `users_fans` (
`id` varchar(64) NOT NULL,
`user_id` varchar(64) NOT NULL COMMENT '⽤户',
`fan_id` varchar(64) NOT NULL COMMENT '粉丝',
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`,`fan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='⽤户粉丝关联关系表';
-- ----------------------------
-- Records of users_fans
-- ----------------------------
-- ----------------------------
-- Table structure for users_like_videos
-- ----------------------------
DROP TABLE IF EXISTS `users_like_videos`;
CREATE TABLE `users_like_videos` (
`id` varchar(64) NOT NULL,
`user_id` varchar(64) NOT NULL COMMENT '⽤户',
`video_id` varchar(64) NOT NULL COMMENT '视频',
PRIMARY KEY (`id`),
UNIQUE KEY `user_video_rel` (`user_id`,`video_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='⽤户喜欢的/赞过的视频';
设备防尘罩
-- ----------------------------
-- Records of users_like_videos
-- ----------------------------
INSERT INTO `users_like_videos` VALUES ('180520HBA054FPPH', '180518CKMAAM5TXP', '180510CCX05TABHH');
INSERT INTO `users_like_videos` VALUES ('180520HSBDW6M0SW', '180518CKMAAM5TXP', '180510CD0A6K3SRP');
-- ----------------------------
-- Table structure for users_report
-- ----------------------------
DROP TABLE IF EXISTS `users_report`;
CREATE TABLE `users_report` (
`id` varchar(64) NOT NULL,
`deal_user_id` varchar(64) NOT NULL COMMENT '被举报⽤户id',
`deal_video_id` varchar(64) NOT NULL,
`title` varchar(128) NOT NULL COMMENT '类型标题,让⽤户选择,详情见枚举',
`content` varchar(255) DEFAULT NULL COMMENT '内容',
`userid` varchar(64) NOT NULL COMMENT '举报⼈的id',
`create_date` datetime NOT NULL COMMENT '举报时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='举报⽤户表';
-- ----------------------------
-- Records of users_report
-- ----------------------------
INSERT INTO `users_report` VALUES ('180521FZ501ABDYW', '180425CFA4RB6T0H', '180510CD0A6K3SRP', '引⼈不适', '不合时宜的视频',
INSERT INTO `users_report` VALUES ('180521FZ501ABDYW', '180425CFA4RB6T0H', '180510CD0A6K3SRP', '引⼈不适', '不合时宜的视频',
'180518CKMAAM5TXP', '2018-05-21 20:58:35');
INSERT INTO `users_report` VALUES ('180521FZK44ZRWX4', '180425CFA4RB6T0H', '180510CD0A6K3SRP', '引⼈不适', '不合时宜的视频',
'180518CKMAAM5TXP', '2018-05-21 20:59:53');
INSERT INTO `users_report` VALUES ('180521FZR1TYRTXP', '180425CFA4RB6T0H', '180510CD0A6K3SRP', '辱骂谩骂', 't4t43',
'180518CKMAAM5TXP', '2018-05-21 21:00:18');
-- ----------------------------
-- Table structure for videos
-- ----------------------------
DROP TABLE IF EXISTS `videos`;
CREATE TABLE `videos` (
`id` varchar(64) NOT NULL,
`user_id` varchar(64) NOT NULL COMMENT '发布者id',
`audio_id` varchar(64) DEFAULT NULL COMMENT '⽤户使⽤⾳频的信息',
`video_desc` varchar(128) DEFAULT NULL COMMENT '视频描述',
`video_path` varchar(255) NOT NULL COMMENT '视频存放的路径',
`video_seconds` float(6,2) DEFAULT NULL COMMENT '视频秒数',
`video_width` int(6) DEFAULT NULL COMMENT '视频宽度',
`video_height` int(6) DEFAULT NULL COMMENT '视频⾼度',
`cover_path` varchar(255) DEFAULT NULL COMMENT '视频封⾯图',
`like_counts` bigint(20) NOT NULL DEFAULT'0' COMMENT '喜欢/赞美的数量',
`status` int(1) NOT NULL COMMENT '视频状态:\r\n1、发布成功\r\n2、禁⽌播放,管理员操作',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='视频信息表';
-- ----------------------------
-- Records of videos
-- ----------------------------
INSERT INTO `videos` VALUES ('180510CC3819RHBC', '180425CFA4RB6T0H', '', '风景',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.R5zVt7RTx6Vv6ee923498030ecd9328acf709bb3a278.mp4', '10.05', '960', '540',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372o6zAJs5sm5bPFcTzKXp_5wXsWusoR5zVt7RTx6Vv6ee923498030ecd9328acf709bb3a278.jpg', '0', '1', '2018-05-10 17:25:13');
INSERT INTO `videos` VALUES ('180510CCCK8A6S14', '180425CFA4RB6T0H', '', '夏天夏天',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.upJlpa1Oc99Zaf561ddc63a69c13472506f586cda815.mp4',
'10.00', '960', '540',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372o6zAJs5sm5bPFcTzKXp_5wXsWusoupJlpa1Oc99Zaf561ddc63a69c13472506f586cda815.jpg', '0', '1', '2018-05-10 17:26:13');
INSERT INTO `videos` VALUES ('180510CCK95WNG7C', '180425CFA4RB6T0H', '', '海贼王',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.nPTyoc9tyI3kabf2c7ceeb9b446b60b47b1705668857.mp4', '10.02', '544', '960',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372o6zAJs5sm5bPFcTzKXp_5wXsWusonPTyoc9tyI3kabf2c7ceeb9b446b60b47b1705668857.jpg', '0', '1', '2018-05-10 17:26:43');
INSERT INTO `videos` VALUES ('180510CCNC7C9FCH', '180425CFA4RB6T0H', '', '吃饭吃饭',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.uG2pt2vkkRI586933d88b91b9577ff8d2d4864443a50.mp4', '6.02', '960', '544',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372o6zAJs5sm5bPFcTzKXp_5wXsWusouG2pt2vkkRI586933d88b91b9577ff8d2d4864443a50.jpg', '0', '1', '2018-05-10 17:26:57');
INSERT INTO `videos` VALUES ('180510CCSFC45A5P', '180425CFA4RB6T0H', '', '风景可以',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.L5WSh3OtMAgf9e6b52aed5830d1bfcfdcb98b2600280.mp4', '9.90', '960', '404',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372o6zAJs5sm5bPFcTzKXp_5wXsWusoL5WSh3OtMAgf9e6b52aed5830d1bfcfdcb98b2600280.jpg', '0', '1', '2018-05-10 17:27:17');
INSERT INTO `videos` VALUES ('180510CCX05TABHH', '180425CFA4RB6T0H', '', '变魔术',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.yptyFK8MwgrL9e2d3e37c168928a9db960e3b24f782b.mp4', '6.02', '540', '960',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372o6zAJs5sm5bPFcTzKXp_5wXsWusoyptyFK8MwgrL9e2d3e37c168928a9db960e3b24f782b.jpg', '1', '1', '2018-05-10 17:27:33');
INSERT INTO `videos` VALUES ('180510CD0A6K3SRP', '180425CFA4RB6T0H', '', '来⼀场说⾛就⾛的旅⾏',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372.o6zAJs5sm5bPFcTzKXp_5wXsWuso.qtm2zeEgenrf7993bfb60dbac65af7b7847d51ee4445.mp4', '5.02', '960', '544',
'/180425CFA4RB6T0H/video/wxa2049f5aead89372o6zAJs5sm5bPFcTzKXp_5wXsWusoqtm2zeEgenrf7993bfb60dbac65af7b7847d51ee4445.jpg', '3', '1', '2018-05-10 17:27:54');
INSERT INTO `videos` VALUES ('180513FW054FFRAW', '180425CFA4RB6T0H', '', '复⽤上传测试',

本文发布于:2024-09-24 22:36:03,感谢您对本站的认可!

本文链接:https://www.17tex.com/tex/4/244664.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

标签:视频   名字   测试   时间   赞美   数量   播放
留言与评论(共有 0 条评论)
   
验证码:
Copyright ©2019-2024 Comsenz Inc.Powered by © 易纺专利技术学习网 豫ICP备2022007602号 豫公网安备41160202000603 站长QQ:729038198 关于我们 投诉建议