DsJian.Web/DbScripts/SqlServer2005.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

--创建评论表
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[{0}Comments]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[{0}Comments](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [PostID] [int] NOT NULL,
    [Author] [nvarchar](100) NOT NULL,
    [AuthorEmail] [nvarchar](100) NULL,
    [AuthorHashedEmail] [nvarchar](100) NULL,
    [AuthorUrl] [nvarchar](150) NULL,
    [AuthorIP] [nvarchar](50) NOT NULL,
    [CommentTime] [datetime] NOT NULL CONSTRAINT [{0}DF_Comments_CommentTime]  DEFAULT (getdate()),
    [CommentTimeGMT] [datetime] NOT NULL CONSTRAINT [{0}DF_Comments_CommentTimeGMT]  DEFAULT (getutcdate()),
    [CommentContent] [text] NOT NULL,
    [CommentStatus] [int] NOT NULL CONSTRAINT [{0}DF_Comments_CommentStatus]  DEFAULT ((1)),
    [CommentType] [int] NOT NULL CONSTRAINT [{0}DF_Comments_CommentType]  DEFAULT ((1)),
    [AuthorArgent] [nvarchar](200) NULL,
    [ParentCommentID] [int] NULL,
    [ModifiedTime] [datetime] NOT NULL CONSTRAINT [{0}DF_Comments_ModifiedTime]  DEFAULT (getdate()),
    [ModifiedTimeGMT] [datetime] NOT NULL CONSTRAINT [{0}DF_Comments_ModifiedTimeGMT]  DEFAULT (getutcdate()),
 CONSTRAINT [{0}PK_COMMENTS] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[{0}Comments]') AND name = N'{0}IDX_COMMENET_TIME_GMT')
CREATE NONCLUSTERED INDEX [{0}IDX_COMMENET_TIME_GMT] ON [dbo].[{0}Comments] 
(
	[CommentTimeGMT] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[{0}Comments]') AND name = N'{0}IDX_COMMENT_POSTID')
CREATE NONCLUSTERED INDEX [{0}IDX_COMMENT_POSTID] ON [dbo].[{0}Comments] 
(
	[PostID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[{0}Comments]') AND name = N'{0}IDX_COMMENT_STATUS')
CREATE NONCLUSTERED INDEX [{0}IDX_COMMENT_STATUS] ON [dbo].[{0}Comments] 
(
	[CommentStatus] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[{0}Comments]') AND name = N'{0}IDX_COMMENT_STATUS_TIME_GMT')
CREATE NONCLUSTERED INDEX [{0}IDX_COMMENT_STATUS_TIME_GMT] ON [dbo].[{0}Comments] 
(
	[CommentStatus] ASC,
	[CommentTimeGMT] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]



--创建链接表
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[{0}Links]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[{0}Links](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [Linkurl] [nvarchar](250) NOT NULL,