//库
create database liuyan charset=utf8;

//用户表
create table user(id int primary key auto_increment,username varchar(20),password
varchar(20),nick varchar(20));

//发表留言表
create table liuyan(id int primary key auto_increment,
	content varchar(100),
	urls text(1000),
	created timestamp,
	user_id int,nick varchar(20)
);

//评论表
create table comment(id int primary key auto_increment,
	content varchar(100),
	liuyan_id int,
	nick varchar(50)
);