﻿-------------Mostafa 2021-11-10----------------------
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireDisplayDocumentsTab',N'Display Documents',N'عرض الوثائق','true',2,29,1,1,Null,Null,5)
Go

  ALTER TABLE WF_NewHireRequestFiles ADD DocumentsTypeCode [nvarchar](1000) NULL
  GO

-------------End 2021-11-10----------------------
--------------Sayed 2021-11-10-------------------
CREATE TABLE [dbo].[WF_BackToWorkRequest](
	[MasterRequestCode] [int] NOT NULL,
	[BackToWorkDate] [date] NOT NULL,
	[BackToWorkDateHijri] [nvarchar](10) NOT NULL,
	[IsSynced] [bit] NOT NULL,
 CONSTRAINT [PK_WF_BackToWorkRequest] PRIMARY KEY CLUSTERED 
(
	[MasterRequestCode] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[WF_BackToWorkRequest] ADD  DEFAULT (N'') FOR [BackToWorkDateHijri]
GO

ALTER TABLE [dbo].[WF_BackToWorkRequest] ADD  DEFAULT ((0)) FOR [IsSynced]
GO

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

ALTER TABLE [dbo].[WF_BackToWorkRequest] CHECK CONSTRAINT [FK_WF_BackToWorkRequest_WF_MasterRequests]
GO
CREATE TABLE [dbo].[Projects](
	[ProjectCode] [int] NOT NULL,
	[Name] [nvarchar](255) NULL,
	[Arabic_Name] [nvarchar](255) NULL,
	[Closed] [bit] NULL,
	[ManagerCode] [int] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Projects_ProjectCode] PRIMARY KEY CLUSTERED 
(
	[ProjectCode] 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
update Basis set SystemEffect=1 where BandCode<=500
go
update Basis set SystemEffect=-1 where BandCode>500

------------------End 2021-11-09-----------------------