﻿---------------------Ali 2021-09-06---

 ALTER TABLE dbo.WF_OverTimeRequest ADD
	DependOn tinyint NOT NULL CONSTRAINT DF_WF_OverTimeRequest_DependOnVacationTime DEFAULT (0)
GO

ALTER TABLE dbo.TimePermissionsTypes ADD
	HaveOverTime bit NOT NULL CONSTRAINT DF_TimePermissionsTypes_HaveOverTime DEFAULT (0)
GO
---------------------End 2021-09-06---

---------------------Ali 2021-09-07---

 ALTER TABLE dbo.WF_VacationRequest ADD
	ModifiedBy int NULL,
	ModificationDate datetime NULL
GO
---------------------End 2021-09-07---
--------------------------AK 2021-09-09--------------------------------
DELETE SecurityGroupDetail WHERE PrivilegeID IN
(SELECT SP.ID FROM SystemMenu sm INNER JOIN SecurityPrivilege SP ON SM.SystemMenuCode=SP.SystemMenuCode WHERE sm.Name='Work Settings')
DELETE SecurityUserDetail WHERE PrivilegeID IN
(SELECT SP.ID FROM SystemMenu sm INNER JOIN SecurityPrivilege SP ON SM.SystemMenuCode=SP.SystemMenuCode WHERE sm.Name='Work Settings')
UPDATE SystemMenu SET NAME=LTRIM(RTRIM(NAME)), Arabic_Name=LTRIM(RTRIM(Arabic_Name)) WHERE Name LIKE ' %' OR Arabic_Name LIKE ' %'
UPDATE SystemMenu SET ShowInPrivilegePage=0 WHERE Name='Work Settings'
Go
 --------------------------End 2021-09-09--------------------------------
  --------------------------MOstafa 2021-09-13--------------------------------
 ALTER TABLE WF_RequestType ADD  AsyncWhatsAppMessage bit  Not Null  DEFAULT ((0)) 
GO

ALTER TABLE EmailTemplate ADD  MessageTemplate nvarchar(MAX) NULL
GO
 --------------------------End 2021-09-13--------------------------------