1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
| //创建web数据库
create database webdb;
use webdb;
//创建用户表
create table users (
id int(11) not null auto_increment,
username varchar(255) not null,
password varchar(255) not null,
primary key(id));
//创建文件信息表
CREATE TABLE fileinfo (
id INT AUTO_INCREMENT PRIMARY KEY,
filename VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
username VARCHAR(100) NOT NULL,
uploadtime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
duration FLOAT DEFAULT NULL,
isvideo TINYINT(1) NOT NULL DEFAULT 0
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;;
//创建评论表
CREATE TABLE comments (
id INT AUTO_INCREMENT PRIMARY KEY,
video_name VARCHAR(255) NOT NULL,
user_id INT NOT NULL,
parent_id INT DEFAULT 0,
content TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE TABLE video_likes (
user_id INT(11) NOT NULL,
video_name VARCHAR(255) NOT NULL,
PRIMARY KEY (user_id, video_name)
)CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE TABLE video_stats (
video_name VARCHAR(255) NOT NULL,
view_count INT(11) DEFAULT 0,
like_count INT(11) DEFAULT 0,
PRIMARY KEY (video_name)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
//或者直接设置整个数据库使用这个字符集
ALTER DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
