﻿---------------------------- AK 2023-07-11 ----- 
CREATE TABLE [dbo].[WF_MasterRequestsSignatureFiles](
	[MasterRequestSignatureFileCode] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestSignatureCode] [int] NOT NULL,
	[FileName] [nvarchar](500) NOT NULL,
	[FileType] [tinyint] NOT NULL,
 CONSTRAINT [PK_WF_MasterRequestsSignatureFiles] PRIMARY KEY CLUSTERED 
(
	[MasterRequestSignatureFileCode] 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_MasterRequestsSignatureFiles] ADD  CONSTRAINT [DF_WF_MasterRequestsSignatureFiles_FileType]  DEFAULT ((1)) FOR [FileType]
GO

ALTER TABLE [dbo].[WF_MasterRequestsSignatureFiles]  WITH CHECK ADD  CONSTRAINT [FK_WF_MasterRequestsSignatureFiles_WF_MasterRequestsSignature] FOREIGN KEY([MasterRequestSignatureCode])
REFERENCES [dbo].[WF_MasterRequestsSignature] ([MasterRequestSignatureCode])
GO

ALTER TABLE [dbo].[WF_MasterRequestsSignatureFiles] CHECK CONSTRAINT [FK_WF_MasterRequestsSignatureFiles_WF_MasterRequestsSignature]
GO
---------------------------- End 2023-07-11 -----
---------------------------- MOstafa 2023-07-12 -----
ALTER TABLE dbo.Divisions ADD
AccountantCode int NULL
Go
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (38, N'Accountant ', N'محاسب', 0, NULL)
GO
---------------------------- End 2023-07-12 -----
---------------------------------------------mahmoud 12-7-2023

INSERT into WF_RequestType (RequestTypeId ,RequestTypeName , RequestTypeNameEn, IsEditable, SenderUserName, SenderFrom, SenderPassword, SenderHostName, SenderPort, SenderName , SubmitBeforRequestDate, SubmitAfterRequestDate, IsUsed, CanDelegation, DisplayUserName,HaveAttachment, WorkedByDefaultContract, CategoryCode, RequestTypeGroupCode, SendEmailNotification, AsyncWhatsAppMessage, RequsetPrint, SignatureRefusedComentMandatory, IsApi, IsMasterRequest,NotifSignCountAction, NotifSignCountController, NotifSignCountArea, IsEnableSSL,WorkedByAssignmentContract,IsMobile, SignatureApprovedCommentMandatory   )
values(58, N'طلب العرض الوظيفى ', N'JobOfferRequest' , 0 , N'sst.sentmail@gmail.com' , N'sst.sentmail@gmail.com' , N'xbgozymifquvbwxj',N'smtp.sendgrid.net' ,587, N'HR System', NULL, Null, 1,1,0,0,0,1, 4,1,0,1,0,1,1,N'Index', N'JobOfferRequestSignature', N'WorkFlow', 1,1,0,0 )
Go

-------------------------------------------------end ----------------------------