使用ajax+asp.net2.0开发论坛

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BBSCategory]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[BBSCategory]( [CategoryID] [int] IDENTITY(1,1) NOT NULL, [CategoryName] [nvarchar](50) NULL, [CategoryDes] [nvarchar](100) NULL, CONSTRAINT [PK_BBSCategory] PRIMARY KEY CLUSTERED ( [CategoryID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BBSInfo]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[BBSInfo]( [InfoID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](50) NULL, [FileName] [nvarchar](100) NULL, [PostTime] [datetime] NULL, [ReplyCount] [int] NULL, [LastReplytime] [datetime] NULL, [PostUser] [nvarchar](50) NULL, [CategoryID] [int] NULL, CONSTRAINT [PK_BBSInfo] PRIMARY KEY CLUSTERED ( [InfoID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BBSInfo_BBSCategory]') AND parent_object_id = OBJECT_ID(N'[dbo].[BBSInfo]')) ALTER TABLE [dbo].[BBSInfo] WITH CHECK ADD CONSTRAINT [FK_BBSInfo_BBSCategory] FOREIGN KEY([CategoryID]) REFERENCES [dbo].[BBSCategory] ([CategoryID])