﻿---------------------Hammad 2021-11-16------
ALTER TABLE dbo.WF_Track ADD
	EmailAfterTrackTemplateCode int NULL,
	EmailUserTypeAfterTrackTemplateCode int NULL
GO
---------------------End 2021-11-16------
---------------------Mostafa 2021-11-16------
SET IDENTITY_INSERT EmailTemplateType ON
INSERT INTO EmailTemplateType (EmailTemplateTypeCode, Name, Arabic_Name, IsEditable,AppModuleCode,RequestTypeCode)
VALUES 
(271, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,2),
(272, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,3),
(273, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,4),
(274, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,5),
(275, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,6),
(276, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,7),
(277, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,8),
(278, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,9),
(279, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,10),
(280, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,11),
(281, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,12),
(282, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,13),
(283, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,14),
(284, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,15),
(285, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,16),
(286, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,17),
(287, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,18),
(288, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,19),
(289, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,20),
(290, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,21),
(291, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,22),
(292, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,23),
(293, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,24),
(294, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,25),
(295, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,26),
(296, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,27),
(297, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,28),
(298, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,29),
(299, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,30),
(300, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,31),
(301, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,42),
(302, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,43),
(303, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,44),
(304, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,45),
(305, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,46),
(306, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,47),
(307, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,48),
(308, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,49),
(309, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,50),
(310, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,51),
(311, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,52),
(312, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,53),
(313, N'Send Notification AFter Track', N'ارسال اشعار بعد نهاية المسار',0,1,54);
SET IDENTITY_INSERT EmailTemplateType OFF
GO
---------------------End 2021-11-16------
---------------------AK 2021-11-17---------
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.AC_TransactionTemplate SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.AC_TransactionReply ADD
	TransactionTemplateCode int NULL,
	AuthorityContent nvarchar(MAX) NULL
GO
ALTER TABLE dbo.AC_TransactionReply ADD CONSTRAINT
	FK_AC_TransactionReply_AC_TransactionTemplate FOREIGN KEY
	(
	TransactionTemplateCode
	) REFERENCES dbo.AC_TransactionTemplate
	(
	TransactionTemplateCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.AC_TransactionReply SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
---------------------End 2021-11-17---------
---------------------Ali 2021-11-17---------


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_OverTimeSymphonyRequest](
	[OverTimeRequestId] [bigint] IDENTITY(1,1) NOT NULL,
	[EmployeeId] [int] NULL,
	[RecordAddBy] [int] NOT NULL,
	[RecordAddDate] [datetime] NOT NULL,
	[DepartmentApproval] [tinyint] NOT NULL,
	[HRApproval] [tinyint] NOT NULL,
	[HRApprovalUserId] [int] NULL,
	[HRApprovalDate] [datetime] NULL,
	[HRApprovalComment] [nvarchar](255) NULL,
	[RequesStatus] [tinyint] NULL,
	[CancelRequestNumber] [bigint] NULL,
	[AddDateHijri] [nvarchar](10) NOT NULL,
	[HRApprovalDateHijri] [nvarchar](10) NULL,
	[TrackCode] [int] NOT NULL,
	[RequestReason] [nvarchar](200) NULL,
	[RequestDate] [datetime] NOT NULL,
	[MinutesCount] [float] NOT NULL,
	[RecordLastChangeBy] [int] NULL,
	[RecordChangeDate] [datetime] NULL,
	[Closed] [bit] NULL,
	[RequestDateHijri] [nvarchar](10) NOT NULL,
	[PYear] [smallint] NOT NULL,
	[Period] [tinyint] NOT NULL,
	[MainType] [tinyint] NOT NULL,
	[SectionCode] [nvarchar](20) NULL,
	[TimeFrom] [time](5) NULL,
	[TimeTo] [time](5) NULL,
	[OvertimeTypeCode] [int] NULL,
	[MinutesCountAfterFactor] [float] NULL,
	[Cost] [float] NULL,
	[FileName] [nvarchar](150) NULL,
	[IsNextDay] [bit] NOT NULL,
	[EventName] [nvarchar](150) NULL,
	[EventTypeCode] [int] NULL,
	[EventLocation] [nvarchar](150) NULL,
	[GuestCount] [smallint] NULL,
	[ExpectedRevenue] [decimal](18, 2) NULL,
	[RequiredHours] [float] NULL,
	[RequiredStaffCount] [smallint] NULL,
	[HoursCountAfterFactor] [float] NULL,
	[HoursCount] [float] NULL,
	[SectionCodeRequest] [nvarchar](20) NOT NULL,
	[RequestTypeCode] [int] NOT NULL,
	[PositionCode] [nvarchar](30) NULL,
	[GenderCode] [int] NULL,
	[UnitNumber] [float] NOT NULL,
 CONSTRAINT [PK_WF_OverTimeSymphonyRequest] PRIMARY KEY CLUSTERED 
(
	[OverTimeRequestId] 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_OverTimeSymphonyRequest] ADD  CONSTRAINT [DF_WF_OverTimeSymphonyRequest_Closed]  DEFAULT ((0)) FOR [Closed]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] ADD  CONSTRAINT [DF_WF_OverTimeSymphonyRequest_Period]  DEFAULT ((0)) FOR [Period]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] ADD  CONSTRAINT [DF_WF_OverTimeSymphonyRequest_MainType]  DEFAULT ((0)) FOR [MainType]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] ADD  CONSTRAINT [DF_WF_OverTimeSymphonyRequest_IsNextDay]  DEFAULT ((0)) FOR [IsNextDay]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] ADD  CONSTRAINT [DF_WF_OverTimeSymphonyRequest_Hotel]  DEFAULT ((0)) FOR [RequestTypeCode]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] ADD  CONSTRAINT [DF_WF_OverTimeSymphonyRequest_UnitNumber]  DEFAULT ((0)) FOR [UnitNumber]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Employees] FOREIGN KEY([EmployeeId])
REFERENCES [dbo].[Employees] ([EmployeeCode])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Employees]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Positions] FOREIGN KEY([PositionCode])
REFERENCES [dbo].[Positions] ([PositionCode])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Positions]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Sections] FOREIGN KEY([SectionCodeRequest])
REFERENCES [dbo].[Sections] ([SectionCode])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Sections]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_SecurityUser] FOREIGN KEY([RecordAddBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_SecurityUser]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_SecurityUser2] FOREIGN KEY([RecordLastChangeBy])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_SecurityUser2]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_SecurityUserHRApproval] FOREIGN KEY([HRApprovalUserId])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_SecurityUserHRApproval]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_OvertimeEventType] FOREIGN KEY([EventTypeCode])
REFERENCES [dbo].[WF_OvertimeEventType] ([EventTypeCode])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_OvertimeEventType]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_OvertimeType] FOREIGN KEY([OvertimeTypeCode])
REFERENCES [dbo].[WF_OvertimeType] ([OvertimeTypeCode])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_OvertimeType]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_RequestStatus] FOREIGN KEY([DepartmentApproval])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_RequestStatus]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_RequestStatus1] FOREIGN KEY([HRApproval])
REFERENCES [dbo].[WF_RequestStatus] ([RequestStatusId])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_RequestStatus1]
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_Track] FOREIGN KEY([TrackCode])
REFERENCES [dbo].[WF_Track] ([TrackId])
GO

ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_WF_Track]
GO


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_ReimbursementRequest](
	[MasterRequestCode] [int] NOT NULL,
	[MemberNumber] [nvarchar](100) NOT NULL,
	[BeneficiaryName] [nvarchar](100) NULL,
 CONSTRAINT [PK_WF_ReimbursementRequest] 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_ReimbursementRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_ReimbursementRequest_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_ReimbursementRequest] CHECK CONSTRAINT [FK_WF_ReimbursementRequest_WF_MasterRequests]
GO


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_ReimbursementDocument](
	[ReimbursementDocumentCode] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[FileName] [nvarchar](500) NOT NULL,
 CONSTRAINT [PK_WF_ReimbursementDocument] PRIMARY KEY CLUSTERED 
(
	[ReimbursementDocumentCode] 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_ReimbursementDocument]  WITH CHECK ADD  CONSTRAINT [FK_WF_ReimbursementDocument_WF_ReimbursementRequest_MasterRequestCode] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_ReimbursementRequest] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_ReimbursementDocument] CHECK CONSTRAINT [FK_WF_ReimbursementDocument_WF_ReimbursementRequest_MasterRequestCode]
GO

ALTER TABLE dbo.WF_RequestType ADD
	SignatureRefusedComentMandatory bit NOT NULL CONSTRAINT DF_WF_RequestType_SignatureRefusedComentMandatory DEFAULT ((0))
GO
---------------------End 2021-11-17---------
---------------------Hammad 2021-11-17---------
ALTER TABLE dbo.WF_OverTimeRequestFinalSignature
ADD CONSTRAINT PK_CompositeOverTimeFinalSignature
UNIQUE(OverTimeRequestId, StepNumber, UserId) 
GO

ALTER TABLE dbo.WF_CompensationRequestFinalDayRestSignature
ADD CONSTRAINT PK_CompositeCompensationFinalSignature
UNIQUE(CompensationRequestForADayOfRestId, StepNumber, UserId) 
GO
---------------------End 2021-11-17---------
---------------------Hammad 2021-11-18---------

ALTER TABLE dbo.VacationType ADD
	RepeatVacationYearlyCount int NULL,
	CalcVacationYearlyFromTypeCode int NULL
GO
---------------------End 2021-11-18---------