﻿--------------------------------------- Hammad  23-01-2023 ---------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
 VALUES (N'FixVacationUnitNoAndFiles', N'Fix Vacation Unit No And Files', N'Fix Vacation UnitNo And Files', N'true', 18, 2, 1, 0, NULL, NULL, NULL, N'')
GO
--------------------------------------- End 23-01-2023 ---------
--------------------------------------- Ali 24-01-2023 ---------


CREATE TABLE [dbo].[SecurityUserAuthorityHistory](
	[SecurityUserAuthorityHistoryCode] [int] IDENTITY(1,1) NOT NULL,
	[SecurityUserAuthorityCode] [int] NOT NULL,
	[SecurityUserCode] [int] NOT NULL,
	[AuthorityCode] [int] NOT NULL,
	[IsDefault] [bit] NOT NULL,
	[StartDate] [date] NULL,
	[EndDate] [date] NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
 CONSTRAINT [PK_SecurityUserAuthorityHistory] PRIMARY KEY CLUSTERED 
(
	[SecurityUserAuthorityHistoryCode] 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].[SecurityUserAuthorityHistory] ADD  CONSTRAINT [DF_SecurityUserAuthorityHistory_IsDefault]  DEFAULT ((1)) FOR [IsDefault]
GO

ALTER TABLE [dbo].[SecurityUserAuthorityHistory]  WITH CHECK ADD  CONSTRAINT [FK_SecurityUserAuthorityHistory_SecurityUserAuthority] FOREIGN KEY([SecurityUserAuthorityCode])
REFERENCES [dbo].[SecurityUserAuthority] ([SecurityUserAuthorityCode])
GO

ALTER TABLE [dbo].[SecurityUserAuthorityHistory] CHECK CONSTRAINT [FK_SecurityUserAuthorityHistory_SecurityUserAuthority]
GO




ALTER TABLE dbo.SecurityUserAuthority ADD
	CreatedBy int NULL,
	CreationDate datetime NULL,
	IsDeleted bit NOT NULL CONSTRAINT DF_SecurityUserAuthority_IsDeleted DEFAULT 0,
	DeletedBy int NULL,
	DeletedDate datetime NULL
GO


--------------------------------------- End 24-01-2023 ---------
--------------------------------------- Ali 25-01-2023 ---------

 ALTER TABLE dbo.WF_ResignationRequest ADD
	DisclaimerDate date NULL
GO


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFDaysNumDisclaimerBeforResignationDate',N'Days number for Disclaimer befor Resignation date',N'عدد الايام لتقديم اخلاء الطرف قبل تاريخ الاستقالة',N'5',2,8,2,1,Null,Null,7)
Go

--------------------------------------- End 25-01-2023 ---------
