bbsdatatable.txt

jsp简单的bbs系统

create table bbsuser(
username varchar(20) not null,
password varchar(20) not null,
nickname varchar(20) not null,
sex varchar(2) not null,
birthyear varchar(4) not null,
birthmonth varchar(4) not null,
birthday varchar(4) not null,
email varchar(50) not null,
mobile varchar(20) null,
signature varchar(250) null,
usergrade varchar(20) null,
userscore smallint not null,
primary key(username));

create table sort(
id smallint not null,
sortname varchar(20) not null,
master varchar(20) null,
primary key(id),
foreign key(master)
references bbsuser(username) on delete cascade);


create table topic(
id smallint not null,
topicname varchar(20) not null,
topiccontent varchar(2000) null,
owner varchar(20) not null,
time date not null,
sortid smallint not null,
primary key(id),
foreign key(owner)
references bbsuser(username) on delete cascade,
foreign key(sortid)
references sort(id) on delete cascade); 

create table responses(
id smallint not null,
title varchar(20) not null,
content varchar(2000) null,
owner varchar(20) not null,
time date not null,
topicid smallint not null,
primary key(id),
foreign key(owner)
references bbsuser(username) on delete cascade,
foreign key(topicid)
references topic(id) on delete cascade);