老师数据库sql语句还是上传一下吧

来源：6-1 大前端和golang模版引擎介绍

_Zereker_

2018-07-02

写回答

3回答

慕瓜2466355

2020-05-10

用户表：
CREATE TABLE users(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,login_name VARCHAR(64) UNIQUE KEY NOT NULL,pwd TEXT NOT NULL);
视频表：
CREATE TABLE video_info(id VARCHAR(64) PRIMARY KEY NOT NULL,author_id INT UNSIGNED,name TEXT,display_ctime TEXT,create_time DATETIME DEFAULT CURRENT_TIMESTAMP);
评论表：
CREATE TABLE comments(id VARCHAR(64) PRIMARY KEY NOT NULL,video_id VARCHAR(64), author_id INT UNSIGNED,content TEXT,time DATETIME DEFAULT CURRENT_TIMESTAMP);
session表：
CREATE TABLE sessions(session_id TINYTEXT NOT NULL, TTL TINYTEXT,login_name VARCHAR(64));//创建sessions表
ALTER TABLE sessions ADD PRIMARY KEY (session_id(64));//修改sessions表session_id字段为主键

待删除的视频表：
CREATE TABLE video_del_rec(video_id VARCHAR(64) PRIMARY KEY NOT NULL);

痞子过

2018-07-11

create database video default charset utf8;
use video;

create table users(author_id bigint not null primary key auto_increment,
login_name varchar(64) ,pwd text) engine=innodb;

create table video_info(video_id varchar(64) not null primary key,author_id bigint,name text,
display_ctime text,create_time datetime) engine=innodb;

create table sessions(session_id tinytext not null ,
ttl tinytext,login_name varchar(64)) engine=innodb;

create table comments(command_id varchar(64) not null primary key,video_id varchar(64),

author_id bigint,content text,time datetime
) engine=innodb;

可以参考这个，调整了下主键标识