-------------------------------Ali 2020-12-28--------------------------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'CheckPassportWhenChangeDefualtPassword',N'Check Passport When Change Defualt Password',N'التحقق من جواز السفر',N'false',7,9,1,1,Null,Null,Null)
Go
------------------------------End 2020-12-28----------------------------
------------------------------Hammad 2020-12-28-------------------------
CREATE TABLE [dbo].[Rec_RecruitJobCountry](
	[RecruitJobCountryCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitJobCode] [int] NOT NULL,
	[CountryCode] [int] NOT NULL,
 CONSTRAINT [PK_Rec_RecruitJobCountry] PRIMARY KEY CLUSTERED 
(
	[RecruitJobCountryCode] 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_RecruitJobCountry]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitJobCountry_Country] FOREIGN KEY([CountryCode])
REFERENCES [dbo].[Country] ([CountryCode])
GO

ALTER TABLE [dbo].[Rec_RecruitJobCountry] CHECK CONSTRAINT [FK_Rec_RecruitJobCountry_Country]
GO

ALTER TABLE [dbo].[Rec_RecruitJobCountry]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitJobCountry_Rec_RecruitJob] FOREIGN KEY([RecruitJobCode])
REFERENCES [dbo].[Rec_RecruitJob] ([RecruitJobCode])
GO

ALTER TABLE [dbo].[Rec_RecruitJobCountry] CHECK CONSTRAINT [FK_Rec_RecruitJobCountry_Rec_RecruitJob]
GO
------------------------------End 2020-12-28-------------------------
--------------------------Hammad 2020-12-30--------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(406,N'Stocktaking',N'جرد المخزون',357,N'/Inventory/Stocktaking',N'Index','fa fa-thumb-tack',N'get',6,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(406,12)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14195,N'جرد المخزون',N'Stocktaking',406,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14196,N'عرض جرد المخزون',N'View Stocktaking',406,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14197,N'إضافة جرد المخزون',N'Add Stocktaking',406,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14198,N'حذف جرد المخزون',N'Delete Stocktaking',406,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14199,N'حفظ جرد المخزون',N'Save Stocktaking',406,2)

Go
------------------------------End 2020-12-30-------------------------