CREATE TABLE [dbo].[Forum_Post_Reported]
(
[PostReportedID] [int] NOT NULL IDENTITY(1, 1),
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_Forum_Post_Reported] DEFAULT (getdate()),
[PostID] [int] NOT NULL,
[UserID] [int] NOT NULL,
[Reason] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Addressed] [bit] NOT NULL CONSTRAINT [DF_Forum_Post_Reported_Addressed] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_Post_Reported] ADD CONSTRAINT [PK_Forum_Post_Reported] PRIMARY KEY CLUSTERED ([PostReportedID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_Post_Reported] WITH NOCHECK ADD CONSTRAINT [FK_Forum_Post_Reported_Forum_Posts] FOREIGN KEY ([PostID]) REFERENCES [dbo].[Forum_Posts] ([PostID]) ON DELETE CASCADE NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[Forum_Post_Reported] WITH NOCHECK ADD CONSTRAINT [FK_Forum_Post_Reported_Users] FOREIGN KEY ([UserID]) REFERENCES [dbo].[Users] ([UserID]) ON DELETE CASCADE NOT FOR REPLICATION
GO