﻿----------------------Hammad 2021-07-04---------------
	 
ALTER TABLE dbo.Orientations
	DROP COLUMN DisplayOrientationFromDate

GO

ALTER TABLE dbo.Orientations
	DROP COLUMN DisplayOrientationToDate

GO
ALTER TABLE dbo.EmployeOrientation ADD
	DisplayOrientationFromDate datetime NULL,
	DisplayOrientationToDate datetime NULL
GO

ALTER TABLE dbo.Orientations ADD
	AllNewEmployee bit NOT NULL CONSTRAINT DF_Orientations_AllNewEmployee DEFAULT 0,
	DurationDisplayOrientations int NOT NULL CONSTRAINT DF_Orientations_DurationDisplayOrientations DEFAULT 0
GO
 ---------------------End 2021-07-04---------------