bbsmax.sql

这是一个关于论坛的一点小的源代码

GO
CREATE TABLE [dbo].[bbsMax_Users]
(
[UserID] [int] NOT NULL IDENTITY(1, 1),
[idMaxID] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_bbsMax_Users_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_Users] 上创建主键 [PK_bbsMax_Users]'
GO
ALTER TABLE [dbo].[bbsMax_Users] ADD CONSTRAINT [PK_bbsMax_Users] PRIMARY KEY CLUSTERED  ([UserID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Users] 的索引 [IX_bbsMax_Users]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Users] ON [dbo].[bbsMax_Users] ([idMaxID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Split_ntext]'
GO
CREATE FUNCTION [dbo].[bbsMax_Split_ntext]
(
	@text ntext,
	@Separator nvarchar(2) = N','
)
RETURNS @ItemTable TABLE 
(
	id int identity(1,1),
	item nvarchar(256) 
)
AS
BEGIN

	DECLARE @s nvarchar(4000), @i int, @j int   
	SELECT @s = SUBSTRING(@text, 1, 4000), @i=1   
	IF (@s = '')
		INSERT @ItemTable VALUES ('')
	ELSE BEGIN
		WHILE @s <> '' BEGIN

			IF len(@s) = 4000   
				SELECT @j = 4000 - CHARINDEX(@Separator, REVERSE(@s)), @i = @i + @j + 1, @s = LEFT(@s, @j)
			ELSE     
				SELECT @i = @i + 4000, @j = LEN(@s)

			INSERT @ItemTable
			SELECT SUBSTRING(@s, ID ,CHARINDEX(@Separator, @s + @Separator, ID) - ID)   
			FROM bbsMax_Identities_4000 WITH (NOLOCK)
			WHERE ID <= @j + 1 AND CHARINDEX(@Separator, @Separator + @s, ID) - ID = 0   

			SELECT @s = SUBSTRING(@text, @i, 4000)

		END  
	END 
	RETURN;
END
GO
PRINT N'正在创建 [dbo].[bbsMax_Split_nvarchar]'
GO
CREATE FUNCTION [dbo].[bbsMax_Split_nvarchar]
(
	@text nvarchar(4000),
	@Separator nvarchar(2) = N','
)
RETURNS @ItemTable TABLE 
(
	id int identity(1,1),
	item nvarchar(256) 
)
AS
BEGIN

	INSERT @ItemTable
	SELECT SUBSTRING(@text, ID ,CHARINDEX(@Separator, @text + @Separator, ID) - ID)   
	FROM bbsMax_Identities_4000 WITH (NOLOCK)
	WHERE ID <= LEN(@text) + 1 AND CHARINDEX(@Separator, @Separator + @text, ID) - ID = 0   

	RETURN;
END
GO
PRINT N'正在创建 [dbo].[bbsMax_Threads]'
GO
CREATE TABLE [dbo].[bbsMax_Threads]
(
[ThreadID] [int] NOT NULL IDENTITY(1, 1),
[ForumID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_ForumID] DEFAULT ((0)),
[ThreadCatalogID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_ThreadCatalogID] DEFAULT ((0)),
[ThreadType] [tinyint] NOT NULL CONSTRAINT [DF_bbsMax_Threads_ThreadType] DEFAULT ((0)),
[IconID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_EmoticonID] DEFAULT ((0)),
[Subject] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[SubjectStyle] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Threads_SubjectStyle] DEFAULT ((0)),
[TotalReplies] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_TotalReplies] DEFAULT ((0)),
[TotalViews] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_TotalViews] DEFAULT ((0)),
[TotalAttachments] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_TotalAttachments] DEFAULT ((0)),
[Price] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_Price] DEFAULT ((0)),
[Rank] [tinyint] NOT NULL CONSTRAINT [DF_bbsMax_Threads_Rank] DEFAULT ((0)),
[PostUserID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_PostUserID] DEFAULT ((0)),
[PostNickName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Threads_PostNickName] DEFAULT (''),
[LastPostUserID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Threads_LastPostUserID] DEFAULT ((0)),
[LastPostNickName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Threads_LastPostNickName] DEFAULT (''),
[IsLocked] [bit] NOT NULL CONSTRAINT [DF_bbsMax_Threads_IsLocked] DEFAULT ((0)),
[IsValued] [bit] NOT NULL CONSTRAINT [DF_bbsMax_Threads_IsValued] DEFAULT ((0)),
[Perorate] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Threads_Perorate] DEFAULT (''),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_bbsMax_Threads_CreateDate] DEFAULT (getdate()),
[UpdateDate] [datetime] NOT NULL CONSTRAINT [DF_bbsMax_Threads_UpdateDate] DEFAULT (getdate()),
[SortOrder] [bigint] NOT NULL,
[ThreadLog] [nvarchar] (128) NOT NULL CONSTRAINT [DF_bbsMax_Threads_ThreadLog] DEFAULT ('')
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_Threads] 上创建主键 [PK_bbsMax_Threads]'
GO
ALTER TABLE [dbo].[bbsMax_Threads] ADD CONSTRAINT [PK_bbsMax_Threads] PRIMARY KEY CLUSTERED  ([ThreadID] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Threads] 的索引 [IX_bbsMax_Threads_Catalog]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Threads_Catalog] ON [dbo].[bbsMax_Threads] ([ForumID], [ThreadCatalogID], [SortOrder] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Threads] 的索引 [IX_bbsMax_Threads_Forum]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Threads_Forum] ON [dbo].[bbsMax_Threads] ([ForumID], [SortOrder] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Threads] 的索引 [IX_bbsMax_Threads_Type]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Threads_Type] ON [dbo].[bbsMax_Threads] ([ThreadType], [ForumID], [SortOrder] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Threads] 的索引 [IX_bbsMax_Threads_User]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Threads_User] ON [dbo].[bbsMax_Threads] ([PostUserID], [ForumID], [SortOrder] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Threads] 的索引 [IX_bbsMax_Threads_Valued]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Threads_Valued] ON [dbo].[bbsMax_Threads] ([IsValued], [ForumID], [SortOrder] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Threads] 的索引 [IX_bbsMax_Threads_SortOrder]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Threads_SortOrder] ON [dbo].[bbsMax_Threads] ([SortOrder] DESC) ON [PRIMARY]
GO
EXEC sp_fulltext_table N'[dbo].[bbsMax_Threads]', 'create', N'FTCatalog_bbsMax_Threads', N'PK_bbsMax_Threads'
GO
EXEC sp_fulltext_column N'[dbo].[bbsMax_Threads]', N'Subject', 'add', 2052
GO
EXEC sp_fulltext_table N'[dbo].[bbsMax_Threads]', 'activate'
GO
PRINT N'正在创建 [dbo].[bbsMax_Questions]'
GO
CREATE TABLE [dbo].[bbsMax_Questions]
(
[ThreadID] [int] NOT NULL,
[IsClosed] [bit] NOT NULL CONSTRAINT [DF_bbsMax_Questions_IsClosed] DEFAULT ((0)),
[Reward] [int] NOT NULL CONSTRAINT [DF_bbsMax_Questions_Reward] DEFAULT ((0)),
[RewardCount] [int] NOT NULL CONSTRAINT [DF_bbsMax_Questions_RewardCount] DEFAULT ((0)),
[AlwaysEyeable] [bit] NOT NULL CONSTRAINT [DF_bbsMax_Questions_AlwaysEyeable] DEFAULT ((0)),
[ExpiresDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_Questions] 上创建主键 [PK_bbsMax_Questions]'
GO
ALTER TABLE [dbo].[bbsMax_Questions] ADD CONSTRAINT [PK_bbsMax_Questions] PRIMARY KEY CLUSTERED  ([ThreadID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Questions] 的索引 [IX_bbsMax_Questions_ExpiresDate]'
GO
CREATE NONCLUSTERED INDEX [IX_bbsMax_Questions_ExpiresDate] ON [dbo].[bbsMax_Questions] ([IsClosed], [ExpiresDate]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Forums]'
GO
CREATE TABLE [dbo].[bbsMax_Forums]
(
[ForumID] [int] NOT NULL IDENTITY(1, 1),
[ParentID] [int] NOT NULL,
[ForumType] [tinyint] NOT NULL,
[ForumStatus] [tinyint] NOT NULL CONSTRAINT [DF_bbsMax_Forums_ForumStatus] DEFAULT ((0)),
[ThreadCatalogStatus] [tinyint] NOT NULL CONSTRAINT [DF_bbsMax_Forums_ThreadCatalogStatus] DEFAULT ((2)),
[CodeName] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Forums_CodeName] DEFAULT (''),
[ForumName] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[Description] [ntext] COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[Readme] [ntext] COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[LogoUrl] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Forums_LogoUrl] DEFAULT (''),
[ThemeID] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Forums_ThemeID] DEFAULT (''),
[ColumnSpan] [tinyint] NOT NULL CONSTRAINT [DF_bbsMax_Forums_ColumnSpan] DEFAULT ((0)),
[TotalThreads] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_ThreadCount] DEFAULT ((0)),
[TotalPosts] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_PostCount] DEFAULT ((0)),
[TodayThreads] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_TodayThreadCount] DEFAULT ((0)),
[TodayPosts] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_TodayPostCount] DEFAULT ((0)),
[LastThreadID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_LastPostID] DEFAULT ((0)),
[YestodayLastThreadID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_YestodayLastThreadID] DEFAULT ((0)),
[YestodayLastPostID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_YestodayLastPostID] DEFAULT ((0)),
[Password] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Forums_Password] DEFAULT (''),
[PermissionSchemeID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_PermissionID] DEFAULT ((0)),
[PointSchemeID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_PointSchemeID] DEFAULT ((0)),
[SortOrder] [int] NOT NULL CONSTRAINT [DF_bbsMax_Forums_SortOrder] DEFAULT ((0)),
[ExtendedAttributes] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_Forums] 上创建主键 [PK_bbsMax_Forums]'
GO
ALTER TABLE [dbo].[bbsMax_Forums] ADD CONSTRAINT [PK_bbsMax_Forums] PRIMARY KEY CLUSTERED  ([ForumID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Forums] 的索引 [IX_bbsMax_Forums_SortOrder]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Forums_SortOrder] ON [dbo].[bbsMax_Forums] ([ParentID], [SortOrder]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Forums] 的索引 [IX_bbsMax_Forums_CodeName]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Forums_CodeName] ON [dbo].[bbsMax_Forums] ([CodeName]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Posts]'
GO
CREATE TABLE [dbo].[bbsMax_Posts]
(
[PostID] [int] NOT NULL IDENTITY(1, 1),
[ForumID] [int] NOT NULL,
[ThreadID] [int] NOT NULL,
[PostType] [tinyint] NOT NULL CONSTRAINT [DF_bbsMax_Posts_PostType] DEFAULT ((0)),
[IconID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Posts_IconID] DEFAULT ((0)),
[Subject] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[Content] [ntext] COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[ContentFormat] [tinyint] NOT NULL CONSTRAINT [DF_bbsMax_Posts_ContentFormat] DEFAULT ((10)),
[EnableSignature] [bit] NOT NULL CONSTRAINT [DF_bbsMax_Posts_EnableSignature] DEFAULT ((1)),
[EnableReplyNotice] [bit] NOT NULL CONSTRAINT [DF_bbsMax_Posts_EnableReplyNotice] DEFAULT ((0)),
[IsShielded] [bit] NOT NULL CONSTRAINT [DF_bbsMax_Posts_IsShielded] DEFAULT ((0)),
[UserID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Posts_UserID] DEFAULT ((0)),
[NickName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[LastEditorID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Posts_LastEditorID] DEFAULT ((0)),
[LastEditor] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Posts_LastEditor] DEFAULT (N''),
[IPAddress] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_Posts_IPAddress] DEFAULT ('000.000.000.000'),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_bbsMax_Posts_CreateDate] DEFAULT (getdate()),
[UpdateDate] [datetime] NOT NULL CONSTRAINT [DF_bbsMax_Posts_UpdateDate] DEFAULT (getdate()),
[SortOrder] [bigint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_Posts] 上创建主键 [PK_bbsMax_Posts]'
GO
ALTER TABLE [dbo].[bbsMax_Posts] ADD CONSTRAINT [PK_bbsMax_Posts] PRIMARY KEY CLUSTERED  ([PostID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Posts] 的索引 [IX_bbsMax_Posts_Forum]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Posts_Forum] ON [dbo].[bbsMax_Posts] ([ForumID], [SortOrder] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Posts] 的索引 [IX_bbsMax_Posts_Thread]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Posts_Thread] ON [dbo].[bbsMax_Posts] ([ThreadID] DESC, [SortOrder] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Posts] 的索引 [IX_bbsMax_Posts_User]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Posts_User] ON [dbo].[bbsMax_Posts] ([UserID], [ThreadID] DESC, [SortOrder] DESC) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Posts] 的索引 [IX_bbsMax_Posts_SortOrder]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_Posts_SortOrder] ON [dbo].[bbsMax_Posts] ([SortOrder] DESC) ON [PRIMARY]
GO
EXEC sp_fulltext_table N'[dbo].[bbsMax_Posts]', 'create', N'FTCatalog_bbsMax_Posts', N'PK_bbsMax_Posts'
GO
EXEC sp_fulltext_column N'[dbo].[bbsMax_Posts]', N'Subject', 'add', 2052
GO
EXEC sp_fulltext_column N'[dbo].[bbsMax_Posts]', N'Content', 'add', 2052
GO
EXEC sp_fulltext_table N'[dbo].[bbsMax_Posts]', 'activate'
GO
PRINT N'正在创建 [dbo].[bbsMax_GetUnapprovedPosts]'
GO
-- =============================================
-- Author:		<sek>
-- Create date: <2007/2/8>
-- Description:	<>
-- =============================================
CREATE PROCEDURE [dbo].[bbsMax_GetUnapprovedPosts]
	@ForumID int
AS
	SET NOCOUNT ON 
	
	IF(@ForumID>0)
	begin
		SELECT * FROM [bbsMax_Threads] WITH(NOLOCK) WHERE ForumID=@ForumID AND ThreadID IN(SELECT DISTINCT(ThreadID) FROM [bbsMax_Posts] WHERE ForumID=@ForumID AND SortOrder >= 5000000000000000)
		SELECT * FROM [bbsMax_Posts] WITH(NOLOCK) WHERE ThreadID IN (SELECT ThreadID FROM [bbsMax_Threads]  WITH(NOLOCK) WHERE ForumID=@ForumID) AND ForumID=@ForumID AND SortOrder >= 5000000000000000 ORDER BY ThreadID,SortOrder DESC
	end
	ELSE
	begin
		SELECT * FROM [bbsMax_Threads] WITH(NOLOCK) WHERE ThreadID IN(SELECT DISTINCT(ThreadID) FROM [bbsMax_Posts] WHERE SortOrder >= 5000000000000000)
		SELECT * FROM [bbsMax_Posts] WITH(NOLOCK) WHERE SortOrder >= 5000000000000000 ORDER BY ThreadID,SortOrder DESC
	end
GO
PRINT N'正在创建 [dbo].[bbsMax_PollItems]'
GO
CREATE TABLE [dbo].[bbsMax_PollItems]
(
[ItemID] [int] NOT NULL IDENTITY(1, 1),
[ThreadID] [int] NOT NULL,
[ItemName] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[PollItemCount] [int] NOT NULL CONSTRAINT [DF_bbsMax_PollItems_PollCount] DEFAULT ((0))
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_PollItems] 上创建主键 [PK_bbsMax_PollItem]'
GO
ALTER TABLE [dbo].[bbsMax_PollItems] ADD CONSTRAINT [PK_bbsMax_PollItem] PRIMARY KEY CLUSTERED  ([ItemID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_PollItems] 的索引 [IX_bbsMax_PollItems_List]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_bbsMax_PollItems_List] ON [dbo].[bbsMax_PollItems] ([ThreadID], [ItemID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_PollItemDetails]'
GO
CREATE TABLE [dbo].[bbsMax_PollItemDetails]
(
[ItemID] [int] NOT NULL,
[UserID] [int] NOT NULL,
[NickName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS_WS NOT NULL CONSTRAINT [DF_bbsMax_PollItemDetails_NickName] DEFAULT (''),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_bbsMax_PollItemDetails_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_PollItemDetails] 上创建主键 [PK_bbsMax_PollItemDetails]'
GO
ALTER TABLE [dbo].[bbsMax_PollItemDetails] ADD CONSTRAINT [PK_bbsMax_PollItemDetails] PRIMARY KEY CLUSTERED  ([ItemID], [UserID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Links]'
GO
CREATE TABLE [dbo].[bbsMax_Links]
(
[LinkID] [int] NOT NULL IDENTITY(1, 1),
[LinkName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[LinkDescription] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[LinkType] [tinyint] NOT NULL CONSTRAINT [DF_bbsMax_Links_LinkType] DEFAULT ((0)),
[Url] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[LogoUrl] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[TotalClick] [int] NOT NULL CONSTRAINT [DF_bbsMax_Links_TotalClick] DEFAULT ((0)),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_bbsMax_Links_CreateDate] DEFAULT (getdate()),
[SortOrder] [int] NOT NULL CONSTRAINT [DF_bbsMax_Links_SortOrder] DEFAULT ((0))
) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_Links] 上创建主键 [PK_bbsMax_Links]'
GO
ALTER TABLE [dbo].[bbsMax_Links] ADD CONSTRAINT [PK_bbsMax_Links] PRIMARY KEY NONCLUSTERED  ([LinkID]) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Attachments]'
GO
CREATE TABLE [dbo].[bbsMax_Attachments]
(
[AttachmentID] [int] NOT NULL IDENTITY(1, 1),
[PostID] [int] NOT NULL,
[DiskFileID] [int] NOT NULL,
[FileID] [int] NOT NULL,
[FileName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS_WS NOT NULL,
[FileSize] [bigint] NOT NULL,
[TotalDownloads] [int] NOT NULL CONSTRAINT [DF_bbsMax_Attachments_TotalDownloads] DEFAULT ((0)),
[TotalDownloadUsers] [int] NOT NULL CONSTRAINT [DF_bbsMax_Attachments_TotalDownloadUsers] DEFAULT ((0)),
[Price] [int] NOT NULL,
[FileExtendedInfo] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS_WS NULL CONSTRAINT [DF_bbsMax_Attachments_FileExtendedInfo] DEFAULT (N''),
[UserID] [int] NOT NULL CONSTRAINT [DF_bbsMax_Attachments_UserID] DEFAULT ((0))
) ON [PRIMARY]
GO
PRINT N'正在创建 [dbo].[bbsMax_Attachments] 的索引 [IX_bbsMax_Attachments_List]'
GO
CREATE UNIQUE CLUSTERED INDEX [IX_bbsMax_Attachments_List] ON [dbo].[bbsMax_Attachments] ([PostID], [DiskFileID]) ON [PRIMARY]
GO
PRINT N'正在 [dbo].[bbsMax_Attachments] 上创建主键 [PK_bbsMax_Attachments]'
GO
ALTER TABLE [dbo].[bbsMax_Attachments] ADD CONSTRAINT [PK_bbsMax_At