﻿---------------------------Hammad 2021-05-31---------------------
 INSERT [dbo].[ConfigCategory] ([ConfigCategoryCode], [Name], [Arabic_Name]) VALUES (14, N'Recruitment Online', N'التوظيف الاونلاين')
  Go
  
INSERT [dbo].[ConfigCategoryModule] ([ConfigCategoryModuleCode], [ConfigCategoryCode], [AppModuleCode]) VALUES (4, 4)
INSERT [dbo].[ConfigCategoryModule] ([ConfigCategoryModuleCode], [ConfigCategoryCode], [AppModuleCode]) VALUES (14, 4)
Go
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES
 (N'RecCertificatesInformationRequired', N'Certificates Information Required', N'    بيانات الشهادات  إجبارى', N'false', 14, 6, 1, 1, NULL, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'RecContactInformationRequired', N'Contact Information Required', N'   بيانات التواصل إجبارى', N'false', 14, 1, 1, 1, NULL, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'RecPreviousExperienceRequired', N'Previous Experience Required', N'    الخبرات السابقة إجبارى', N'false', 14, 2, 1, 1, NULL, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'RecQualificationsInformationRequired', N'Qualifications Information Required', N'    بيانات المؤهلات الدراسية  إجبارى', N'false', 14, 3, 1, 1, NULL, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'RecReferencesInformationRequired', N'References  Information Required', N'    بيانات المرجع إجبارى', N'false', 14, 7, 1, 1, NULL, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'RecSkillsInformationRequired', N'Skills Information Required', N'    بيانات المهارات  إجبارى', N'false', 14, 4, 1, 1, NULL, NULL, NULL)
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'RecTrainingInformationRequired', N'Training Information Required', N'    بيانات التدريب  إجبارى', N'false', 14, 5, 1, 1, NULL, NULL, NULL)

Go

CREATE TABLE [dbo].[SecUserGeneralType](
	[SecUserGeneralTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[GeneralTypeCode] [tinyint] NOT NULL,
	[SecurityUserCode] [int] NOT NULL,
 CONSTRAINT [PK_SecUserGeneralType] PRIMARY KEY CLUSTERED 
(
	[SecUserGeneralTypeCode] 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].[SecUserGeneralType] ADD  CONSTRAINT [DF_SecUserGeneralType_GeneralTypeCode]  DEFAULT ((0)) FOR [GeneralTypeCode]
GO

ALTER TABLE [dbo].[SecUserGeneralType]  WITH CHECK ADD  CONSTRAINT [FK_SecUserGeneralType_GeneralTypes] FOREIGN KEY([GeneralTypeCode])
REFERENCES [dbo].[GeneralTypes] ([GeneralTypeCode])
GO

ALTER TABLE [dbo].[SecUserGeneralType] CHECK CONSTRAINT [FK_SecUserGeneralType_GeneralTypes]
GO

ALTER TABLE [dbo].[SecUserGeneralType]  WITH CHECK ADD  CONSTRAINT [FK_SecUserGeneralType_SecurityUser] FOREIGN KEY([SecurityUserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[SecUserGeneralType] CHECK CONSTRAINT [FK_SecUserGeneralType_SecurityUser]
GO



---------------------------End 2021-05-31---------------------
---------------------------Ali 2021-05-31---------------------

CREATE TABLE [dbo].[WF_RequestTypeSubContractGroups](
	[RequestTypeSubContractGroupId] [int] IDENTITY(1,1) NOT NULL,
	[RequestTypeId] [int] NOT NULL,
	[SubContractGroupCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_RequestTypeSubContractGroups] PRIMARY KEY CLUSTERED 
(
	[RequestTypeSubContractGroupId] 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_RequestTypeSubContractGroups]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequestTypeSubContractGroups_SubContractGroups] FOREIGN KEY([SubContractGroupCode])
REFERENCES [dbo].[SubContractGroups] ([SubContractGroupCode])
GO

ALTER TABLE [dbo].[WF_RequestTypeSubContractGroups] CHECK CONSTRAINT [FK_WF_RequestTypeSubContractGroups_SubContractGroups]
GO

ALTER TABLE [dbo].[WF_RequestTypeSubContractGroups]  WITH CHECK ADD  CONSTRAINT [FK_WF_RequestTypeSubContractGroups_WF_RequestType] FOREIGN KEY([RequestTypeId])
REFERENCES [dbo].[WF_RequestType] ([RequestTypeId])
GO

ALTER TABLE [dbo].[WF_RequestTypeSubContractGroups] CHECK CONSTRAINT [FK_WF_RequestTypeSubContractGroups_WF_RequestType]
GO


ALTER TABLE dbo.WF_RequestType ADD
	WorkedByDefaultContract bit NOT NULL CONSTRAINT DF_WF_RequestType_WorkedByDefaultContract DEFAULT ((0))
GO
---------------------------End 2021-05-31---------------------
---------------------------Hammad 2021-06-1------------------
ALTER TABLE dbo.EmailTemplate ADD
	JobTypeCode int NULL
GO

---------------------------End 2021-06-1------------------