﻿--------------------------MOstafa 2021-11-04-----------------------------
 ALTER TABLE [dbo].[WF_RequestType] ADD
 RequsetPrint int NOT NULL DEFAULT ((1))
 GO
   ALTER TABLE [dbo].[WF_letterTypes] ADD
 ReportName nvarchar(50)  NULL
 GO
   ALTER TABLE [dbo].[WF_letterTypes] ADD
 IsShowAccordingFinancial bit NOT NULL DEFAULT ((1))
 GO
--------------------------End 2021-11-04-----------------------------
---------------------AK 2021-11-07---------
	ALTER TABLE SecurityUserAuthority ADD StartDate Date  NULL 
	GO
	UPDATE SecurityUserAuthority SET StartDate='2021-01-01'
	GO
	ALTER TABLE SecurityUserAuthority ADD EndDate Date  NULL 
	GO
	UPDATE SecurityUserAuthority SET EndDate='2021-12-31'
	GO
---------------------End 2021-11-07---------
---------------------AK 2021-11-08---------
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.SecurityUser SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.AC_TransactionAuthorityImage ADD
	SendImageBy int NULL
GO
ALTER TABLE dbo.AC_TransactionAuthorityImage ADD CONSTRAINT
	FK_AC_TransactionAuthorityImage_SecurityUser FOREIGN KEY
	(
	SendImageBy
	) REFERENCES dbo.SecurityUser
	(
	SecurityUserCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.AC_TransactionAuthorityImage SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
---------------------End 2021-11-08---------
---------------------Hammad 2021-11-08------
ALTER TABLE dbo.WF_Track ADD
	SkippSendEmailAfterTrack bit NOT NULL CONSTRAINT DF_WF_Track_SkippSendEmailAfterTrack DEFAULT 0
GO
ALTER TABLE dbo.WF_NewHireRequest ADD
	EstablishmentCode int NULL,
	VisaNumber nvarchar(50) NULL,
	Email nvarchar(50) NULL,
	Mobile nvarchar(50) NULL
GO
---------------------End 2021-11-08------