CREATE TABLE [dbo].[Task]
(
[TaskID] [int] NOT NULL IDENTITY(1, 1),
[TaskType] [int] NOT NULL,
[StartDate] [datetime] NOT NULL CONSTRAINT [DF_Task_StartDate] DEFAULT (getdate()),
[StartMode] [int] NOT NULL CONSTRAINT [DF_Task_StartMode] DEFAULT ((0)),
[IntervalType] [int] NOT NULL CONSTRAINT [DF_Task_IntervalType] DEFAULT ((0)),
[IntervalCount] [int] NOT NULL CONSTRAINT [DF_Task_IntervalCount] DEFAULT ((0)),
[NrRuns] [int] NOT NULL CONSTRAINT [DF_Task_NrRuns] DEFAULT ((0)),
[LastRun] [datetime] NULL,
[LastRunStatus] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Task] ADD CONSTRAINT [PK_Task_TaskID] PRIMARY KEY CLUSTERED ([TaskID]) ON [PRIMARY]
GO