2回答

sd1700092

2018-06-28

我是这样子的，楼主凑合着用吧~~

create database video_server default charset utf8 COLLATE utf8_general_ci;

create table video_server.users

(

id int auto_increment

primary key,

login_name varchar(64) null,

pwd text not null,

constraint users_login_name_uindex

unique (login_name)

)

;

create table video_server.video_info

(

id varchar(64) not null

primary key,

author_id int null,

name text null,

display_ctime text null,

create_time datetime default CURRENT_TIMESTAMP() null

)

;

create table video_server.comments

(

id varchar(64) not null

primary key,

video_id varchar(64) null,

author_id int null,

content text null,

time datetime default CURRENT_TIMESTAMP null

)

;

CREATE TABLE video_server.sessions (

session_id tinytext not null,

TTL tinytext,

login_name varchar(64)

);

ALTER TABLE video_server.sessions ADD PRIMARY KEY (session_id(64));

create table video_del_rec(video_id varchar(64) NOT NULL PRIMARY_KEY);

0

0

艾文西

2018-06-20

这个在课程结束后的源代码中就会包含

0

0