˵

1.޸ıdb_bbsеputtop,distillateֶΪINT,ĬֵΪ0
  (,ֱʹɾdb_bbs,SQLĲѯֱִSQű)
2.updateĿ¼еread_art_manage.asp,read_art_sub.asp,read_art_display.aspԭļ


ȫ°װ˵
ͬǰ



SQLű(****************ֱCOPYSQLĲѯִ)

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[db_bbs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[db_bbs]
GO

CREATE TABLE [dbo].[db_bbs] (
	[bbsID] [decimal](19, 0) IDENTITY (1, 1) NOT NULL ,
	[boardid] [int] NOT NULL ,
	[rootid] [decimal](19, 0) NOT NULL ,
	[title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[pic] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[author] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[putdate] [datetime] NULL ,
	[replydate] [datetime] NULL ,
	[clicknum] [int] NULL ,
	[replynum] [int] NOT NULL ,
	[collect] [tinyint] NULL ,
	[mailmsg] [tinyint] NULL ,
	[puttop] [int] NULL ,
	[distillate] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[db_bbs] WITH NOCHECK ADD 
	CONSTRAINT [PK_bbs] PRIMARY KEY  CLUSTERED 
	(
		[bbsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[db_bbs] ADD 
	CONSTRAINT [DF_bbs_rootid] DEFAULT (0) FOR [rootid],
	CONSTRAINT [DF_bbs_putdate] DEFAULT (getdate()) FOR [putdate],
	CONSTRAINT [DF_bbs_replydate] DEFAULT (getdate()) FOR [replydate],
	CONSTRAINT [DF_bbs_clicknum] DEFAULT (0) FOR [clicknum],
	CONSTRAINT [DF_bbs_replynum] DEFAULT (0) FOR [replynum],
	CONSTRAINT [DF_bbs_collect] DEFAULT (0) FOR [collect],
	CONSTRAINT [DF_bbs_mailmsg] DEFAULT (0) FOR [mailmsg],
	CONSTRAINT [DF_db_bbs_puttop] DEFAULT (0) FOR [puttop],
	CONSTRAINT [DF_db_bbs_distillate] DEFAULT (0) FOR [distillate]
GO

 CREATE  INDEX [IX_bbs] ON [dbo].[db_bbs]([boardid], [rootid], [author]) ON [PRIMARY]
GO



