﻿--------------------------Hammad 2022-11-07--------
update ConfigParameter set ConfigCategoryCode=1 where ConfigKey='ViewReportInCrystal'
GO
--------------------------End 2022-11-07--------
--------------------------Hammaad 2022-11-08----

CREATE TABLE [dbo].[Rec_QuestionTemplatePositions](
	[QuestionTemplatePositionCode] [int] IDENTITY(1,1) NOT NULL,
	[PositionCode] [nvarchar](30) NOT NULL,
	[QuestionTemplateCode] [int] NOT NULL,
 CONSTRAINT [PK_Rec_QuestionTemplatePositions] PRIMARY KEY CLUSTERED 
(
	[QuestionTemplatePositionCode] 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].[Rec_QuestionTemplatePositions]  WITH CHECK ADD  CONSTRAINT [FK_Rec_QuestionTemplatePositions_Positions] FOREIGN KEY([PositionCode])
REFERENCES [dbo].[Positions] ([PositionCode])
GO

ALTER TABLE [dbo].[Rec_QuestionTemplatePositions] CHECK CONSTRAINT [FK_Rec_QuestionTemplatePositions_Positions]
GO

ALTER TABLE [dbo].[Rec_QuestionTemplatePositions]  WITH CHECK ADD  CONSTRAINT [FK_Rec_QuestionTemplatePositions_Rec_QuestionTemplate] FOREIGN KEY([QuestionTemplateCode])
REFERENCES [dbo].[Rec_QuestionTemplate] ([QuestionTemplateCode])
GO

ALTER TABLE [dbo].[Rec_QuestionTemplatePositions] CHECK CONSTRAINT [FK_Rec_QuestionTemplatePositions_Rec_QuestionTemplate]
GO

ALTER TABLE dbo.Rec_RecruitJobQuestion ADD
	QuestionKind int NULL,
	IsAnswerChanged bit NOT NULL CONSTRAINT DF_Rec_RecruitJobQuestion_IsAnswerChanged DEFAULT 0
GO


--------------------------End 2022-11-08----
--------------------------Hammad 2022-11-10----

CREATE TABLE [dbo].[Rec_RecruitClosedAnswer](
	[RecruitClosedAnswerCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitJobQuestionCode] [int] NOT NULL,
	[AnswerValue] [tinyint] NOT NULL,
 CONSTRAINT [PK_Rec_JobQuestionClosedAnswer] PRIMARY KEY CLUSTERED 
(
	[RecruitClosedAnswerCode] 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].[Rec_RecruitClosedAnswer]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitClosedAnswer_Rec_RecruitJobQuestion] FOREIGN KEY([RecruitJobQuestionCode])
REFERENCES [dbo].[Rec_RecruitJobQuestion] ([RecruitJobQuestionCode])
GO

ALTER TABLE [dbo].[Rec_RecruitClosedAnswer] CHECK CONSTRAINT [FK_Rec_RecruitClosedAnswer_Rec_RecruitJobQuestion]
GO

UPDATE Rec_RecruitJobQuestion
SET QuestionKind = (
SELECT Rec_QuestionTemplate.QuestionKind
FROM Rec_QuestionTemplate
WHERE Rec_QuestionTemplate.QuestionTemplateCode = Rec_RecruitJobQuestion.QuestionTemplateCode
);




CREATE TABLE [dbo].[Rec_RecruitDateRangeAnswer](
	[RecruitDateRangeAnswerCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitJobQuestionCode] [int] NOT NULL,
	[FromDate] [datetime] NOT NULL,
	[ToDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Rec_RecruitDateRangeAnswer] PRIMARY KEY CLUSTERED 
(
	[RecruitDateRangeAnswerCode] 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].[Rec_RecruitDateRangeAnswer]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitDateRangeAnswer_Rec_RecruitJobQuestion] FOREIGN KEY([RecruitJobQuestionCode])
REFERENCES [dbo].[Rec_RecruitJobQuestion] ([RecruitJobQuestionCode])
GO

ALTER TABLE [dbo].[Rec_RecruitDateRangeAnswer] CHECK CONSTRAINT [FK_Rec_RecruitDateRangeAnswer_Rec_RecruitJobQuestion]
GO



CREATE TABLE [dbo].[Rec_RecruitMultiChoiceAnswer](
	[RecruitMultiChoiceAnswerCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitJobQuestionCode] [int] NOT NULL,
	[AnswerDescription] [nvarchar](250) NOT NULL,
	[AnswerDescription_Arabic] [nvarchar](250) NOT NULL,
	[IsTrue] [bit] NOT NULL,
 CONSTRAINT [PK_Rec_RecruitMultiChoiceAnswer] PRIMARY KEY CLUSTERED 
(
	[RecruitMultiChoiceAnswerCode] 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].[Rec_RecruitMultiChoiceAnswer]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitMultiChoiceAnswer_Rec_RecruitJobQuestion] FOREIGN KEY([RecruitJobQuestionCode])
REFERENCES [dbo].[Rec_RecruitJobQuestion] ([RecruitJobQuestionCode])
GO

ALTER TABLE [dbo].[Rec_RecruitMultiChoiceAnswer] CHECK CONSTRAINT [FK_Rec_RecruitMultiChoiceAnswer_Rec_RecruitJobQuestion]
GO



CREATE TABLE [dbo].[Rec_RecruitNumRangeAnswer](
	[RecruitNumRangeAnswerCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitJobQuestionCode] [int] NOT NULL,
	[FromNumber] [int] NULL,
	[ToNumber] [int] NULL,
 CONSTRAINT [PK_Rec_RecruitNumRangeAnswer] PRIMARY KEY CLUSTERED 
(
	[RecruitNumRangeAnswerCode] 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].[Rec_RecruitNumRangeAnswer]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitNumRangeAnswer_Rec_RecruitJobQuestion] FOREIGN KEY([RecruitJobQuestionCode])
REFERENCES [dbo].[Rec_RecruitJobQuestion] ([RecruitJobQuestionCode])
GO

ALTER TABLE [dbo].[Rec_RecruitNumRangeAnswer] CHECK CONSTRAINT [FK_Rec_RecruitNumRangeAnswer_Rec_RecruitJobQuestion]
GO



--------------------------End 2022-11-10----


