﻿-------------------------------Hammad 2022-04-18---
ALTER TABLE Rec_RecruitJob
ALTER COLUMN UserCodeResponsibleEvaluation nvarchar(200)
Go

ALTER TABLE Rec_RecruitJobStages
ALTER COLUMN UserCodeResponsibleInterview nvarchar(200)
Go
-------------------------------Hammad 2022-04-18---
-------------------------------Hammad 2022-04-19---
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) 
VALUES (324, N'Approval Evaluation Stage For applicants jobs', N'إعتماد مرحلة تقيم المتقدمين ', 0, 4)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode]) 
VALUES ( N'Approval Evaluation Stage For applicants jobs', N'إعتماد مرحلة تقيم المتقدمين', 324, N'إعتماد مرحلة تقيم المتقدمين ', N'إعتماد مرحلة تقيم المتقدمين للوظيفة', 1, NULL, NULL, NULL)
Go

SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) 
VALUES (325, N'Approval Interview Stage For applicants jobs', N'إعتماد مراحل مقابلة المتقدمين ', 0, 4)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode]) 
VALUES ( N'Approval Interview Stage For applicants jobs', N'إعتماد مرحلة مقابلة المتقدمين', 325, N'إعتماد مرحلة مقابلة المتقدمين ', N'إعتماد مرحلة مقابلة المتقدمين للوظيفة', 1, NULL, NULL, NULL)
Go
-------------------------------End 2022-04-19---
-------------------------------Sayed 2022-04-19-------------
ALTER TABLE dbo.EmailTemplateType ADD
	HaveUserAccount bit NOT NULL CONSTRAINT DF_EmailTemplateType_HaveUserAccount DEFAULT ((1))
GO
ALTER TABLE dbo.EmailTemplateType SET (LOCK_ESCALATION = TABLE)
GO
----------------------------End 2022-04-19----------------
----------------------------Hammad 2022-04-20----------------
delete ConfigParameter where ConfigKey='NumberOfCalculation'
GO
----------------------------End 2022-04-20----------------