﻿--------------------------Ali 2021-10-06-------------------------

  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFMustAddPreviousExperiences',N'Must Add Previous Experiences',N'الزامية اضافة الخبرات السابقة',N'false',2,10,1,1,Null,Null,5)
Go


  CREATE TABLE [dbo].[WF_EmployeesExperiences](
	[EmployeesExperienceCode] [int] IDENTITY(1,1) NOT NULL,
	[NewHireRequestCode] [int] NOT NULL,
	[Position] [nvarchar](150) NOT NULL,
	[Salary] [float] NULL,
	[PreviousCurrencyCode] [tinyint] NOT NULL,
	[DateFrom] [datetime] NULL,
	[DateTo] [datetime] NULL,
	[ReasonLeave] [nvarchar](200) NULL,
	[PlaceName] [nvarchar](150) NULL,
 CONSTRAINT [PK_WF_PreviousExperiences] PRIMARY KEY CLUSTERED 
(
	[EmployeesExperienceCode] 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_EmployeesExperiences]  WITH CHECK ADD  CONSTRAINT [FK_WF_PreviousExperiences_WF_NewHireRequest] FOREIGN KEY([NewHireRequestCode])
REFERENCES [dbo].[WF_NewHireRequest] ([NewHireRequestCode])
GO

ALTER TABLE [dbo].[WF_EmployeesExperiences] CHECK CONSTRAINT [FK_WF_PreviousExperiences_WF_NewHireRequest]
GO
  --------------------------End 2021-10-06-------------------------
  --------------------------Hammad 2021-10-09----------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFDisplayEmployeeFinancialPrivilege', N'DisplayEmployeeFinancialPrivilege', N'   عرض موظفين صلاحيات المالية', N'false', 2, 5, 1, 1, NULL, NULL, 9)
 Go
   --------------------------End 2021-10-09----------------------
     --------------------------Mostafa 2021-10-12----------------------
     ALTER TABLE [dbo].[Rec_RecruitJob] ADD
	ShowConditionJob bit NOT NULL DEFAULT 0;
GO
--------------------------End 2021-10-12----------------------
--------------------------Mostafa 2021-10-14----------------------
insert into  ConfigParameter 
(ConfigKey,Name,Arabic_Name,ConfigValue,ConfigCategoryCode,OrderNo,ConfigType,IsVisible)
VALUES ('ArcEmpDocumentMaxFileSize','Maximum Employee Archive File Size',N'اقصي حجم لملف أرشيف الموظفين '
,10485760,1,40,2,N'True')

--------------------------End 2021-10-12----------------------
--------------------------Ali 2021-10-16----------------------

ALTER TABLE dbo.AC_TransactionAuthorityImage ADD
	SendImageDate datetime NULL
GO
--------------------------End 2021-10-16----------------------