CREATE TABLE [dbo].[Forum_Threads]
(
[ThreadID] [int] NOT NULL,
[ForumID] [int] NOT NULL CONSTRAINT [DF_Forum_Threads_Replies] DEFAULT ((0)),
[Views] [int] NULL CONSTRAINT [DF_Forum_Threads_Views] DEFAULT ((0)),
[LastPostedPostID] [int] NULL CONSTRAINT [DF_Forum_Threads_LastPostedPostID] DEFAULT ((-1)),
[Replies] [int] NULL,
[IsPinned] [bit] NULL CONSTRAINT [DF_Forum_Threads_IsPinned] DEFAULT ((0)),
[PinnedDate] [datetime] NULL CONSTRAINT [DF_Forum_Threads_PinnedDate] DEFAULT (getdate()),
[ThreadStatus] [int] NOT NULL,
[AnswerPostID] [int] NOT NULL,
[AnswerUserID] [int] NOT NULL,
[PollID] [int] NULL,
[SitemapInclude] [bit] NULL,
[ContentItemID] [int] NULL,
[AnswerDate] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_Threads] ADD CONSTRAINT [PK_Forum_Threads] PRIMARY KEY CLUSTERED ([ThreadID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_Threads] ADD CONSTRAINT [IX_Forum_Threads] UNIQUE NONCLUSTERED ([ThreadID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_Threads] WITH NOCHECK ADD CONSTRAINT [FK_Forum_Threads_Forum_Forums] FOREIGN KEY ([ForumID]) REFERENCES [dbo].[Forum_Forums] ([ForumID]) ON DELETE CASCADE NOT FOR REPLICATION
GO