CREATE TABLE [dbo].[VWTasks]
(
[TaskID] [int] NOT NULL,
[TaskName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TaskClass] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StartDate] [datetime] NOT NULL,
[Days] [smallint] NOT NULL,
[Weeks] [smallint] NOT NULL,
[Months] [smallint] NOT NULL,
[EndDate] [datetime] NULL,
[Seconds] [smallint] NOT NULL,
[Minutes] [smallint] NOT NULL,
[Hours] [smallint] NOT NULL,
[NextDate] [datetime] NOT NULL,
[LastDate] [datetime] NULL,
[ExeCount] [int] NOT NULL CONSTRAINT [DF_VWTasks_ExeCount] DEFAULT ((0)),
[ExeMax] [int] NOT NULL CONSTRAINT [DF_VWTasks_ExeMax] DEFAULT ((0)),
[Enabled] [bit] NOT NULL CONSTRAINT [DF_VWTasks_Enabled] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_VWTasks_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_VWTasks_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[DaysOfWeek] [tinyint] NOT NULL CONSTRAINT [DF_VWTasks_DaysOfWeek] DEFAULT ((0)),
[TaskTypeID] [int] NULL,
[AssignedEngine] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaskStatus] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssignedUser] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusDetails] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastFailDate] [datetime] NOT NULL CONSTRAINT [DF_VWTasks_LastFailDate] DEFAULT (CONVERT([datetime],'1900-01-01',(126))),
[LastDayOfMonth] [smallint] NOT NULL CONSTRAINT [DF_VWTasks_LastDayOfMonth] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VWTasks] ADD CONSTRAINT [PK_VWTasks] PRIMARY KEY CLUSTERED ([TaskID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VWTasks] ADD CONSTRAINT [FK_VWTasks_TaskTypeID_VWTaskTypes] FOREIGN KEY ([TaskTypeID]) REFERENCES [dbo].[VWTaskTypes] ([TaskTypeID])
GO