﻿---------------------Ali 2021-08-01---------

CREATE TABLE [dbo].[WF_MasterRequestsFiles](
	[MasterRequestFileCode] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[FileName] [nvarchar](500) NOT NULL,
	[FileType] [tinyint] NOT NULL,
 CONSTRAINT [PK_WF_MasterRequestsFiles] PRIMARY KEY CLUSTERED 
(
	[MasterRequestFileCode] 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_MasterRequestsFiles] ADD  CONSTRAINT [DF_WF_MasterRequestsFiles_FileType]  DEFAULT ((1)) FOR [FileType]
GO

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

ALTER TABLE [dbo].[WF_MasterRequestsFiles] CHECK CONSTRAINT [FK_WF_MasterRequestsFiles_WF_MasterRequests]
GO
---------------------End 2021-08-01---------
---------------------Mostafa 2021-08-02---------

  insert  into  SecurityPrivilegeActions (ID,AreaName, ControllerName, ActionName, ActionType,HTTPMethod,SecurityPrivilegeID)
VALUES (824,'WFAcademic', 'ProgramTitleType', 'Index',0,'get',15216),
       (825,'WFAcademic', 'ProgramTitleType', 'AcademicProgramTitleType_Read', 0,'post',15217),
       (826,'WFAcademic', 'ProgramTitleType', 'Save', 1,'get',15218),
       (827,'WFAcademic', 'ProgramTitleType', 'Save', 2,'post',15219),
       (828,'WFAcademic', 'ProgramTitleType', 'Delete', 0,'post',15220),
       (829,'WFAcademic', 'ProgramTitleType', 'Save', 0,'post',15221);
	   GO

	     insert  into  SecurityPrivilegeActions (ID,AreaName, ControllerName, ActionName, ActionType,HTTPMethod,SecurityPrivilegeID)
VALUES (830,'WFAcademic', 'SchoolTitleType', 'Index',0,'get',15222),
       (831,'WFAcademic', 'SchoolTitleType', 'GetAcademicSchoolTitleType_Read', 0,'post',15223),
       (832,'WFAcademic', 'SchoolTitleType', 'Save', 1,'get',15224),
       (833,'WFAcademic', 'SchoolTitleType', 'Save', 2,'post',15225),
       (834,'WFAcademic', 'SchoolTitleType', 'Delete', 0,'post',15226),
       (835,'WFAcademic', 'SchoolTitleType', 'Save', 0,'post',15227);
	   GO
 ---------------------End 2021-08-01---------
 ---------------------Hammad 2021-08-02--------------------------------------
 INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name], [IsForAllBranchs]) VALUES (22, N'TotalSalariesForEachPosition.trdx', N'TotalSalariesForEachPosition.trdx', N'Head Count  ( Positions And Salaries )', N'أعدد الموظفين - الوظائف والرواتب', 1)
 INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name], [IsForAllBranchs]) VALUES (23, N'AverageSalariesForEachPosition.trdx', N'AverageSalariesForEachPosition.trdx', N'Average Salaries For Each Position', N'متوسط الإجور لكل وظيفة', 1)
 Go
---------------------End 2021-08-02--------------------------------------
 ---------------------AKhaled 2021-08-02--------------------------------------
UPDATE SystemMenu SET ControllerName='/WFAcademic/ResearchProfileType' WHERE SystemMenuCode=407
Go
---------------------End 2021-08-02--------------------------------------

 ---------------------Mostafa 2021-08-04--------------------------------------
ALTER TABLE EmailTemplateType
ADD RequestTypeCode int ;
GO
 ---------------------End 2021-08-04--------------------------------------

 ---------------------Ali 2021-08-04--------------------------------------

update [dbo].[ConsolidatedReport] set [Name]=N'023_Handicapped working in the facility' ,    [Arabic_Name]= N'المعوقين العاملين بالمنشأة_023 '    where [ConsolidatedReportCode]=1 
update [dbo].[ConsolidatedReport] set [Name]= N'101_Retirement',                             [Arabic_Name]= N'الإحالة علي المعاش_101'               where [ConsolidatedReportCode]=2 
update [dbo].[ConsolidatedReport] set [Name]= N'102_Resignations',                           [Arabic_Name]= N'102_لإستقالات'                         where [ConsolidatedReportCode]=3 
update [dbo].[ConsolidatedReport] set [Name]= N'103_New Hire',                               [Arabic_Name]= N'103_المعينين الجدد'                  where [ConsolidatedReportCode]=4 
update [dbo].[ConsolidatedReport] set [Name]= N'106_Basic Data - ( All Employees )',         [Arabic_Name]= N'106_البيانات الأساسة - كل الموظفين'   where [ConsolidatedReportCode]=5 
update [dbo].[ConsolidatedReport] set [Name]= N'110_Social Insurance',                       [Arabic_Name]= N'110_التأمينات الإجتماعية'           where [ConsolidatedReportCode]=6 
update [dbo].[ConsolidatedReport] set [Name]= N'117_Name List',                              [Arabic_Name]= N'117_قائمة الأسماء'                  where [ConsolidatedReportCode]=7 
update [dbo].[ConsolidatedReport] set [Name]= N'119_Name List With Total Salary',            [Arabic_Name]= N'119_قائمة بالأسماء والرواتب'   where [ConsolidatedReportCode]=8 
update [dbo].[ConsolidatedReport] set [Name]= N'148_Expired Contract',                       [Arabic_Name]= N'148_انتهاء العقود'   where [ConsolidatedReportCode]=9 
update [dbo].[ConsolidatedReport] set [Name]= N'150_Military Certificates Expired',          [Arabic_Name]= N'150_الشهادات العسكرية منتهية الصلاحية'   where [ConsolidatedReportCode]=10
update [dbo].[ConsolidatedReport] set [Name]= N'253_Turnover',                               [Arabic_Name]= N'253_معدل الدوران'   where [ConsolidatedReportCode]=11
update [dbo].[ConsolidatedReport] set [Name]= N'262_Average Salaries for each Position',     [Arabic_Name]= N'262_متوسط الأجور لكل وظيفة'   where [ConsolidatedReportCode]=12
update [dbo].[ConsolidatedReport] set [Name]= N'190_Vacations Balances Until Specific Date', [Arabic_Name]= N'190_أرصدة الاجازات'   where [ConsolidatedReportCode]=13
update [dbo].[ConsolidatedReport] set [Name]= N'195_Vacations Balances With Salary',         [Arabic_Name]= N'195_أرصدة الأجازات مع الراتب'   where [ConsolidatedReportCode]=14
update [dbo].[ConsolidatedReport] set [Name]= N'221_Monthly Insurance',                      [Arabic_Name]= N'221_التأمينات الشهرية'   where [ConsolidatedReportCode]=15
update [dbo].[ConsolidatedReport] set [Name]= N'156_In and out in Special day ( Totals )',   [Arabic_Name]= N'156_المتواجد والغير متواجد في يوم'   where [ConsolidatedReportCode]=16
update [dbo].[ConsolidatedReport] set [Name]= N'127_Contracts Data',                         [Arabic_Name]= N'127_بيانات العقود'   where [ConsolidatedReportCode]=17
update [dbo].[ConsolidatedReport] set [Name]= N'184_Leaves Transaction',                     [Arabic_Name]= N'184_حركة الاجازات'   where [ConsolidatedReportCode]=18
update [dbo].[ConsolidatedReport] set [Name]= N'106_Basic Data',                             [Arabic_Name]= N'106_البيانات الاساسية '   where [ConsolidatedReportCode]=20
Go

  update [SystemMenu] set IsVisible=0,ShowInPrivilegePage=0
  where SystemMenuCode=479
  Go
    update [ConfigParameter] set ConfigValue ='false'
  where [ConfigKey]=N'ShowEmployeesSubContracts'
  Go

INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (1, N'Normal', N'الطبيعى', 1.25, 0, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (2, N'Day oFF', N'اجازة اسبوعية', 1.5, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (3, N'Holiday', N'اعياد', 1.7, 1, NULL, NULL, 2, NULL, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (4, N'Hotel_W(1KD)', N'Hotel_W(1KD)', 1, 0, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (5, N'Hotel_EventType(1.25)', N'Hotel_EventType(1.25)', 1.25, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (6, N'Casual_M(1KD)', N'Casual_M(1KD)', 1, 0, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (7, N'Casual_F(1.25KD)', N'Casual_F(1.25KD)', 1.25, 0, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (8, N'Morning', N'صباحي', 1.5, 1, CAST(N'06:00:00' AS Time), CAST(N'18:00:00' AS Time), 1, 41, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (9, N'Evening', N'مسائى', 1.7, 1, CAST(N'18:00:00' AS Time), CAST(N'23:59:59' AS Time), 1, 42, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (10, N'Evening', N'مسائى', 1.7, 1, CAST(N'00:00:00' AS Time), CAST(N'06:00:00' AS Time), 1, 42, NULL)
INSERT [dbo].[WF_OvertimeType] ([OvertimeTypeCode], [Name], [Arabic_Name], [Factor], [IsPercentage], [FromTime], [ToTime], [TypeOfLaw], [BandCode], [OverTimeLateBand]) VALUES (11, N'Morning And Evening', N'مسائى وصباحي   ', 0, 1, NULL, NULL, 1, NULL, NULL)

GO
 ---------------------End 2021-08-04--------------------------------------

 
 ---------------------MOstafa 2021-08-04--------------------------------------
update EmailTemplateType set RequestTypeCode=2 where EmailTemplateTypeCode iN(21,22,23,24)
GO
update EmailTemplateType set RequestTypeCode=3 where EmailTemplateTypeCode iN(28,29,30,31)
GO
update EmailTemplateType set RequestTypeCode=4 where EmailTemplateTypeCode iN(32,33,34,35)
Go
update EmailTemplateType set RequestTypeCode=6 where EmailTemplateTypeCode iN(38,39,40,41)
Go
update EmailTemplateType set RequestTypeCode=5 where EmailTemplateTypeCode iN(42,43,44,45)
GO
update EmailTemplateType set RequestTypeCode=7 where EmailTemplateTypeCode iN(47,48,49,50)
GO
update EmailTemplateType set RequestTypeCode=8 where EmailTemplateTypeCode iN(51,52,53,54)
GO
update EmailTemplateType set RequestTypeCode=9 where EmailTemplateTypeCode iN(55,56,57,58)
GO
update EmailTemplateType set RequestTypeCode=10 where EmailTemplateTypeCode iN(60,61,62,63)
GO
update EmailTemplateType set RequestTypeCode=11 where EmailTemplateTypeCode iN(64,65,66,67)
GO
update EmailTemplateType set RequestTypeCode=12 where EmailTemplateTypeCode iN(84,85,86,87)
GO
update EmailTemplateType set RequestTypeCode=13 where EmailTemplateTypeCode iN(91,92,93,94)
GO
update EmailTemplateType set RequestTypeCode=14 where EmailTemplateTypeCode iN(97,98,99,100)
GO
update EmailTemplateType set RequestTypeCode=15 where EmailTemplateTypeCode iN(101,102,103,104)
GO
update EmailTemplateType set RequestTypeCode=16 where EmailTemplateTypeCode iN(105,106,107,108)
GO
update EmailTemplateType set RequestTypeCode=17 where EmailTemplateTypeCode iN(109,110,111,112)
GO
update EmailTemplateType set RequestTypeCode=18 where EmailTemplateTypeCode iN(114,115,116,117)
GO
update EmailTemplateType set RequestTypeCode=19 where EmailTemplateTypeCode iN(120,121,122,123)
GO
update EmailTemplateType set RequestTypeCode=20 where EmailTemplateTypeCode iN(128,129,130)
GO
update EmailTemplateType set RequestTypeCode=21 where EmailTemplateTypeCode iN(124,125,126,127)
GO
update EmailTemplateType set RequestTypeCode=22 where EmailTemplateTypeCode iN(131,132,133)
GO
update EmailTemplateType set RequestTypeCode=23 where EmailTemplateTypeCode iN(134,135,136,137)
GO
update EmailTemplateType set RequestTypeCode=24 where EmailTemplateTypeCode iN(138,139,140,141)
go
update EmailTemplateType set RequestTypeCode=25 where EmailTemplateTypeCode iN(142,143,144,145)
GO
update EmailTemplateType set RequestTypeCode=26 where EmailTemplateTypeCode iN(148,149,150,151)
GO
update EmailTemplateType set RequestTypeCode=27 where EmailTemplateTypeCode iN(152,153,154,155)
GO
update EmailTemplateType set RequestTypeCode=28 where EmailTemplateTypeCode iN(156,157,158,159)
Go
update EmailTemplateType set RequestTypeCode=29 where EmailTemplateTypeCode iN(162,163,164,165)
GO
update EmailTemplateType set RequestTypeCode=30 where EmailTemplateTypeCode iN(166,167,168,169)
GO
update EmailTemplateType set RequestTypeCode=31 where EmailTemplateTypeCode iN(170,171,172,173)
Go
update EmailTemplateType set RequestTypeCode=32 where EmailTemplateTypeCode iN(176,177,178,179)
GO
update EmailTemplateType set RequestTypeCode=33 where EmailTemplateTypeCode iN(180,181,182,183)
GO
update EmailTemplateType set RequestTypeCode=34 where EmailTemplateTypeCode iN(184,185,186,187)
Go
update EmailTemplateType set RequestTypeCode=35 where EmailTemplateTypeCode iN(188,189,190,191)
GO
update EmailTemplateType set RequestTypeCode=36 where EmailTemplateTypeCode iN(192,193,194,195)
GO
update EmailTemplateType set RequestTypeCode=37 where EmailTemplateTypeCode iN(196,197,198,199)
GO
update EmailTemplateType set RequestTypeCode=38 where EmailTemplateTypeCode iN(200,201,202,203)
GO
update EmailTemplateType set RequestTypeCode=39 where EmailTemplateTypeCode iN(204,205,206,207)
GO
update EmailTemplateType set RequestTypeCode=40 where EmailTemplateTypeCode iN(208,209,210,211)
Go
update EmailTemplateType set RequestTypeCode=41 where EmailTemplateTypeCode iN(212,213,214,215)
GO
update EmailTemplateType set RequestTypeCode=42 where EmailTemplateTypeCode iN(216,217,218,219)
Go
update EmailTemplateType set RequestTypeCode=43 where EmailTemplateTypeCode iN(220,221,222,223)
Go
update EmailTemplateType set RequestTypeCode=44 where EmailTemplateTypeCode iN(224,225,226,227)
GO
update EmailTemplateType set RequestTypeCode=45 where EmailTemplateTypeCode iN(228,229,230,231)
GO
update EmailTemplateType set RequestTypeCode=46 where EmailTemplateTypeCode iN(232,233,234,235)
GO
update EmailTemplateType set RequestTypeCode=47 where EmailTemplateTypeCode iN(236,237,238,239)
GO
update EmailTemplateType set RequestTypeCode=48 where EmailTemplateTypeCode iN(240,241,242,243)
GO
update EmailTemplateType set RequestTypeCode=49 where EmailTemplateTypeCode iN(244,245,246,247)
GO
update EmailTemplateType set RequestTypeCode=50 where EmailTemplateTypeCode iN(248,249,250,251)
GO
update EmailTemplateType set RequestTypeCode=51 where EmailTemplateTypeCode iN(252,253,254,255)
Go
update EmailTemplateType set RequestTypeCode=52 where EmailTemplateTypeCode iN(256,257,258,259)
GO
update EmailTemplateType set RequestTypeCode=53 where EmailTemplateTypeCode iN(261,262,263,264)
Go
 ---------------------End 2021-08-04--------------------------------------


  ---------------------Mostafa 2021-08-04--------------------------------------
 
CREATE TABLE [dbo].[WF_TaskForceRequest](
	[MasterRequestCode] [int] NOT NULL,
	[CurrentBranchCode] [int] NOT NULL,
	[TaskForceDirection] [int] NULL,
	[TaskForceBranchCode] [int] NULL,
 CONSTRAINT [PK_WF_TaskForceRequest] 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_TaskForceRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_AssignmentRequest_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO
ALTER TABLE [dbo].[WF_TaskForceRequest] CHECK CONSTRAINT [FK_WF_AssignmentRequest_WF_MasterRequests]
GO


 INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment],[WorkedByDefaultContract],[CategoryCode],[RequestTypeGroupCode]) VALUES(54,N'طلب انتداب',N'Task Force Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0,0,1,1)
Go

SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(266,N'Task Force Request Sending',N'ارسال طلب انتداب',0,1,54)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(267,N'Task Force Request Accept',N'الموافقة على طلب انتداب',0,1,54)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(268,N'Task Force Request Refuse',N'رفض طلب انتداب',0,1,54)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(269,N'Task Force Request Cancel',N'الغاء طلب انتداب',0,1,54)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

GO

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(1189,N'Task Force Request Sending',N'ارسال طلب انتداب',266,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(1190,N'Task Force Request Accept',N'الموافقة على طلب انتداب',267,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(1191,N'Task Force Request Refuse',N'رفض طلب انتداب',268,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(1192,N'Task Force Request Cancel',N'الغاء طلب انتداب',269,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
Go

 ---------------------End 2021-08-04--------------------------------------
 ---------------------AK 2021-11-14---------
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_Transaction ADD
	TransactionTemplateCode int NULL,
	AuthorityContent nvarchar(MAX) NULL
GO
ALTER TABLE dbo.AC_Transaction ADD CONSTRAINT
	FK_AC_Transaction_AC_TransactionTemplate FOREIGN KEY
	(
	TransactionTemplateCode
	) REFERENCES dbo.AC_TransactionTemplate
	(
	TransactionTemplateCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.AC_Transaction SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
---------------------End 2021-11-14---------
---------------------Hammad 2021-11-14---------
update ConfigParameter set ConfigValue= 'false' where ConfigKey='WFNewHireDisplayDocumentsTab'
---------------------End 2021-11-14---------