Powiązań między tabelami nie kopiowałem
CREATE TABLE [dbo].[EmailMessage](
[SysEmailMessage] [int] IDENTITY(1,1) NOT NULL,
[SysEmailServer] [int] NOT NULL,
[SysSendTo] [int] NULL,
[SysCc] [int] NULL,
[SysBcc] [int] NULL,
[Topic] [varchar](2000) NULL,
[Body] [text] NULL,
[IsBodyHtml] [bit] NULL,
CONSTRAINT [PK_EmailMessage] PRIMARY KEY CLUSTERED
(
[SysEmailMessage] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo].[FaxMessage](
[SysFaxMessage] [int] IDENTITY(1,1) NOT NULL,
[SysSendTo] [int] NULL,
[FaxFile] [varbinary](max) NULL,
CONSTRAINT [PK_FaxMessage] PRIMARY KEY CLUSTERED
(
[SysFaxMessage] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[SmsMessage](
[SysSmsMessage] [int] IDENTITY(1,1) NOT NULL,
[SysSendTo] [int] NULL,
[Body] [varchar](2048) NULL,
CONSTRAINT [PK_SmsMessage] PRIMARY KEY CLUSTERED
(
[SysSmsMessage] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Task](
[SysTask] [int] IDENTITY(1,1) NOT NULL,
[SysTaskType] [int] NOT NULL,
[SysTaskStatus] [int] NOT NULL,
[SysSchedule] [int] NULL,
[SysError] [int] NULL,
[SysMessage] [int] NULL,
[CreationDate] [datetime] NOT NULL,
[ExecutionDate] [datetime] NULL,
[TaskOwner] [varchar](255) NOT NULL,
[Priority] [int] NULL,
[Comments] [varchar](1024) NULL,
CONSTRAINT [PK_Task] PRIMARY KEY CLUSTERED
(
[SysTask] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]