---------------------------Hammad 2020-12-17--------------------------------------

CREATE TABLE [dbo].[Emp_DelegationSection](
	[Emp_DelegationSectionId] [int] IDENTITY(1,1) NOT NULL,
	[DelegationId] [int] NOT NULL,
	[SectionCode] [nvarchar](20) NOT NULL,
 CONSTRAINT [PK_Emp_DelegationSection] PRIMARY KEY CLUSTERED 
(
	[Emp_DelegationSectionId] 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].[Emp_DelegationSection]  WITH CHECK ADD  CONSTRAINT [FK_Emp_DelegationSection_Emp_Delegation] FOREIGN KEY([DelegationId])
REFERENCES [dbo].[Emp_Delegation] ([DelegationId])
GO

ALTER TABLE [dbo].[Emp_DelegationSection] CHECK CONSTRAINT [FK_Emp_DelegationSection_Emp_Delegation]
GO

ALTER TABLE [dbo].[Emp_DelegationSection]  WITH CHECK ADD  CONSTRAINT [FK_Emp_DelegationSection_Sections] FOREIGN KEY([SectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
GO

ALTER TABLE [dbo].[Emp_DelegationSection] CHECK CONSTRAINT [FK_Emp_DelegationSection_Sections]
GO

---------------------------End 2020-12-17--------------------------------------
---------------------------Hammad 2020-12-17-----------------------------------
ALTER TABLE dbo.WF_RequestType ADD
	CanDelegation bit NOT NULL CONSTRAINT DF_WF_RequestType_CanDelegation DEFAULT 1
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1250, N' السماح باضافة مهام قديمة ', N'Can Add Old Task ', 404, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1251, N'السماح بتعديل وحذف مهام قديمة ', N'Can Delete and Edit Old Task', 404, 2)
GO

---------------------------End 2020-12-17---------------------------------

---------------------------Hammad 2020-12-20------------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFAirTicketVacationRequest', N'AirTicket Vacation Mandatory', N'طلب الأجازة الزامى', N'true', 2, 4, 1, 1, NULL, NULL, 4)
 Go
 ---------------------------End 2020-12-17--------------------------------


