bbs的数据结构和存储过程（一）_ASP实例

/*数据结构*/

/*bbs用户表*/

if exists(select * from sysobjects where id = object_id('BBSUser'))

drop table BBSUser

go

create table BBSUser

(

id int identity primary key ,

UserName varchar(20) default '' not null ,

Password varchar(10) default '' not null ,

Email varchar(100) default '' not null ,

Homepage varchar(150) default '' not null ,

Signature varchar(255) default '' not null ,

SignDate datetime default getdate() not null ,

Point int default 0 not null

)

go

create index ix_bbsuser on bbsuser (id , username , password)

/*bbs表情表*/

if exists(select * from sysobjects where id = object_id('Face'))

drop table Face

go

create table Face

(

id tinyint identity primary key ,

Face varchar(30) default '' not null

)

go

/*bbs表*/

if exists(select * from sysobjects where id = object_id('BBS'))

drop table BBS

go

create table BBS

(

id int identity primary key ,

RootID int default 0 not null , --根ID

FatherID int default 0 not null , --父ID

Layer tinyint default 0 not null , --层

OrderNum float(53) default 0 not null , --排序基数

UserID int default 0 not null , --发言人ID

ForumID tinyint default 1 not null , --版面ID

Subject varchar(255) default '' not null , --主题