﻿-------------------------------Hammad 2022-03-08---------
ALTER TABLE dbo.WF_Track ADD
	IsMaxDays bit NOT NULL CONSTRAINT DF_WF_Track_IsMaxDays DEFAULT 0,
	MaxDaysCount int NULL
GO

CREATE TABLE [dbo].[WF_TrackMaxDays](
	[TrackMaxDaysId] [int] IDENTITY(1,1) NOT NULL,
	[TrackId] [int] NOT NULL,
	[MinDaysCount] [int] NOT NULL,
	[MaxDaysCount] [int] NOT NULL,
 CONSTRAINT [PK_WF_TrackMaxDays] PRIMARY KEY CLUSTERED 
(
	[TrackMaxDaysId] 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

ALTER TABLE [dbo].[WF_TrackMaxDays]  WITH CHECK ADD  CONSTRAINT [FK_WF_TrackMaxDays_WF_Track] FOREIGN KEY([TrackId])
REFERENCES [dbo].[WF_Track] ([TrackId])
GO

ALTER TABLE [dbo].[WF_TrackMaxDays] CHECK CONSTRAINT [FK_WF_TrackMaxDays_WF_Track]
GO


CREATE TABLE [dbo].[WF_TrackMaxDaysDetail](
	[TrackMaxDaysDetailId] [int] IDENTITY(1,1) NOT NULL,
	[TrackMaxDaysId] [int] NOT NULL,
	[UserTypeId] [int] NOT NULL,
	[UserId] [int] NULL,
	[StepNumber] [int] NOT NULL,
	[Skippable] [bit] NOT NULL,
 CONSTRAINT [PK_WF_TrackMaxDaysDetail] PRIMARY KEY CLUSTERED 
(
	[TrackMaxDaysDetailId] 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

ALTER TABLE [dbo].[WF_TrackMaxDaysDetail] ADD  CONSTRAINT [DF_WF_TrackMaxDaysDetail_Skippable]  DEFAULT ((0)) FOR [Skippable]
GO

ALTER TABLE [dbo].[WF_TrackMaxDaysDetail]  WITH CHECK ADD  CONSTRAINT [FK_WF_TrackMaxDaysDetail_WF_TrackMaxDays] FOREIGN KEY([TrackMaxDaysId])
REFERENCES [dbo].[WF_TrackMaxDays] ([TrackMaxDaysId])
GO

ALTER TABLE [dbo].[WF_TrackMaxDaysDetail] CHECK CONSTRAINT [FK_WF_TrackMaxDaysDetail_WF_TrackMaxDays]
GO

-------------------------------End 2022-03-08---------
-------------------------------Hammad 2022-03-08------
ALTER TABLE dbo.WF_TrackMaxDays ADD
	CreatedBy int NULL,
	CreationDate datetime NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (589, N'Tracks', N'المسارات', 28, N'/WorkFlow/Track', N'AddtionalTrack', N'fa fa-sitemap', N'get', 3, 0, 0)
GO
-------------------------------End 2022-03-08------