﻿
--------------------------mahmoud  2022-12-15-----
ALTER TABLE dbo.WF_PermissionRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_PermissionRequest_IsFromMobile DEFAULT ((0))
GO

ALTER TABLE dbo.WF_FingerPrintRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_FingerPrintRequest_IsFromMobile DEFAULT ((0))
GO

ALTER TABLE dbo.WF_VacationRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_VacationRequest_IsFromMobile DEFAULT ((0))
GO

ALTER TABLE dbo.WF_CompensationRequestForADayOfRest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_CompensationRequestForADayOfRest_IsFromMobile DEFAULT ((0))
GO

--------------------------End 2022-12-15-----

----------------------------  Mahmoud 18-12-2022 ----------------------------

ALTER TABLE dbo.WF_AirTicketRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_AirTicketRequest_IsFromMobile DEFAULT ((0))
GO

ALTER TABLE dbo.WF_OverTimeRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_OverTimeRequest_IsFromMobile DEFAULT ((0))
GO

ALTER TABLE dbo.WF_PenaltyRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_PenaltyRequest_IsFromMobile DEFAULT ((0))
GO

ALTER TABLE dbo.WF_ResignationRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_ResignationRequest_IsFromMobile DEFAULT ((0))
GO


ALTER TABLE dbo.WF_LoanRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_LoanRequest_IsFromMobile DEFAULT ((0))
GO

ALTER TABLE dbo.WF_PromotionRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_PromotionRequest_IsFromMobile DEFAULT ((0))
GO

ALTER TABLE dbo.WF_NewEmployeesRequest ADD
IsFromMobile bit NOT NULL CONSTRAINT DF_WF_NewEmployeesRequest_IsFromMobile DEFAULT ((0))
GO



--------------------------------------- end  18-12-2022 ------------------
