------------------------------- Ali 2020-04-08 --------------------------
  EXEC sp_RENAME 'WF_NewHireRequest.PassportIDTypeCode' , 'IDTypeCode', 'COLUMN'
  EXEC sp_RENAME 'WF_NewHireRequest.PassportCityCode' , 'IDCityCode', 'COLUMN'
  EXEC sp_RENAME 'WF_NewHireRequest.PassportPoliceStation' , 'IDPoliceStation', 'COLUMN'
  EXEC sp_RENAME 'WF_NewHireRequest.CityCode' , 'MilitaryCityCode', 'COLUMN'
  Go

  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
  VALUES (N'APPLinkEvaluationTypesWithReportTemplate', N'Link Evaluation Types with report template', N'ربط انواع التقييم بنموذج التقرير', N'true', 10, 14, 1, 1, NULL, NULL, NULL)
 Go
------------------------------- End 2020-04-08 --------------------------
------------------------------- A.Khaled 2020-04-08 --------------------------
CREATE TABLE [dbo].[WF_VehiclesRequest](
	[MasterRequestCode] [int] NOT NULL,
	[RequestFromTime] [time](5) NOT NULL,
	[RequestToTime] [time](5) NOT NULL,
	[IsFullDay] [bit] NULL,
	[DirectionCode] [int] NOT NULL,
	[VehicleTypeCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_VehiclesRequest] PRIMARY KEY CLUSTERED 
(
	[MasterRequestCode] 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].[WF_VehiclesRequest] ADD  CONSTRAINT [DF_WF_VehiclesRequest_FullDay]  DEFAULT ((0)) FOR [IsFullDay]
GO

ALTER TABLE [dbo].[WF_VehiclesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_VehiclesRequest_WF_Direction] FOREIGN KEY([DirectionCode])
REFERENCES [dbo].[WF_Direction] ([DirectionCode])
GO

ALTER TABLE [dbo].[WF_VehiclesRequest] CHECK CONSTRAINT [FK_WF_VehiclesRequest_WF_Direction]
GO

ALTER TABLE [dbo].[WF_VehiclesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_VehiclesRequest_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_VehiclesRequest] CHECK CONSTRAINT [FK_WF_VehiclesRequest_WF_MasterRequests]
GO

ALTER TABLE [dbo].[WF_VehiclesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_VehiclesRequest_WF_VehicleType] FOREIGN KEY([VehicleTypeCode])
REFERENCES [dbo].[WF_VehicleType] ([VehicleTypeCode])
GO

ALTER TABLE [dbo].[WF_VehiclesRequest] CHECK CONSTRAINT [FK_WF_VehiclesRequest_WF_VehicleType]
GO
------------------------------- End 2020-04-08 --------------------------
------------------------------- Hammad 2020-04-09 --------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (247, N'Performance Final Appraisal Report', N'تقرير تقييم الأداء النهائي', 224, N'/Appraisal/PerformanceFinalAppraisalReport', N'Index', NULL, N'get', 4, 1, 1)
 Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10075, N'تقرير تقييم الأداء النهائي  ', N'    Performance Final Appraisal Report ', 247, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10076, N'عرض تقرير تقييم الأداء النهائي  ', N'View Performance Final Appraisal Report', 247, 2)
Go

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES ( 247, 8)

Go
------------------------------- End 2020-04-09 --------------------------