use bbs
go

--用戶表約束
alter table userInfo 
	add 
	constraint PK_uId primary key (uId),
	constraint UQ_uName unique(uName),
	constraint DF_uType default(0) for uType,
	constraint  DF_uRegTime default(getdate()) for uRegTime
go

--版塊表約束
alter table sectionInfo
	add 
	constraint PK_sId primary key(sId),
	constraint DF_sMasterId default(0) for sMasterId,
	constraint DF_sTopicCount default(0) for sTopicCount,
	constraint DF_sParentId default(0) for sParentId
go 

--發(fā)帖表
alter table topicInfo
	add 
	constraint PK_tId primary key(tId),
	constraint FK_tSId foreign key(tSId) references sectionInfo(sId),
	constraint FK_tUId foreign key(tUId) references userInfo(uId),
	constraint DF_tReplyCount default(0) for tReplyCount,
	constraint DF_tClickCount default(0) for tClickCount,
	constraint DF_tPublishTime default(getDate()) for tPublishTime
go

--跟帖表
alter table replyInfo
	add
	constraint PK_rId primary key(rId),
	constraint FK_rTId foreign key(rTId) references topicInfo(tId),
	constraint FK_rSId foreign key(rSId) references sectionInfo(sId),
	constraint FK_rUId foreign key(rUId) references userInfo(uId),
	constraint DF_rPublishTime default(getdate()) for rPublishTime
go

--短信表
alter table messageInfo
	add
	constraint PK_mId primary key(mId),
	constraint FK_mSendUnameId foreign key(mSendUnameId) references userInfo(uId),
	constraint FK_mReceiveUnameId foreign key(mReceiveUnameId) references userInfo(uId),
	constraint DF_mPostTime default(getdate()) for mPostTime,
	constraint DF_mReadSign default(false) for mReadSign
go