CREATE TABLE [dbo].[Forum_EmailQueue_Tasks]
(
[EmailQueueID] [int] NOT NULL IDENTITY(1, 1),
[EmailFromAddress] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FromFriendlyName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EmailPriority] [int] NULL,
[EmailHTMLBody] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EmailTextBody] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EmailSubject] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PortalID] [int] NULL,
[QueuePriority] [int] NOT NULL,
[SendComplete] [bit] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_SendComplete] DEFAULT ((0)),
[QueueAddedDate] [datetime] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_QueueAddedDate] DEFAULT (getdate()),
[QueueStartedDate] [datetime] NULL,
[QueueCompletedDate] [datetime] NULL,
[ModuleID] [int] NULL,
[SentEmailCount] [int] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_SentEmailCount] DEFAULT ((0)),
[EnableFriendlyToName] [bit] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_EnableFriendlyToName] DEFAULT ((0)),
[DistroCall] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DistroIsSproc] [bit] NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_DistroIsSproc] DEFAULT ((0)),
[DistroParams] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ScheduleStartDate] [datetime] NULL,
[PersonalizeEmail] [bit] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_PersonalizeEmail] DEFAULT ((0)),
[SuccessfullSendCount] [int] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_SuccessfullSendCount] DEFAULT ((0)),
[FailedSendCount] [int] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_FailedSendCount] DEFAULT ((0)),
[Attachment] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaskFailed] [bit] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_TaskFailed] DEFAULT ((0)),
[TaskFailedCount] [int] NOT NULL CONSTRAINT [DF_Forum_EmailQueue_Tasks_TaskFailedCount] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_EmailQueue_Tasks] ADD CONSTRAINT [PK_Forum_EmailQueue_Tasks] PRIMARY KEY CLUSTERED ([EmailQueueID]) ON [PRIMARY]
GO