
   ----------------------------Ali 2021-01-03-----------------------------------

  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'DisplayUserAuthorityAfterAddAuthority', N'Display Add User Authority After Add Authority', N'اظهار  اضافة جهات المستحدم بعد اضافة الجهات', N'false', 6, 16, 1, 1, NULL, NULL, NULL)
    Go
  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'DisplayAuthorityUsers', N'Display Authority Users', N'اظهار مستخدمين الجهة', N'false', 6, 17, 1, 1, NULL, NULL, NULL)
  Go

     ALTER TABLE dbo.[WF_RequestType] ADD
	DisplayUserName tinyint NOT NULL  DEFAULT 0
GO

 ALTER TABLE dbo.[WF_RequestType] ADD
	HaveAttachment bit NOT NULL  DEFAULT 0
GO
  ----------------------------End 2021-01-03-----------------------------------

  ----------------------------Hammad 2021-01-05--------------------------------

    update [dbo].[SystemMenu] set IsVisible=0 where SystemMenuCode in (2,3)
	Go
  ----------------------------End 2021-01-05-----------------------------------
  ---------------------------Sayed 2021-01-05----------------------------
  INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (301, N'Inventory', N'Stocktaking', N'Index', 0, N'get', 14195)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (302, N'Inventory', N'Stocktaking', N'Stocktaking_Read', 0, N'post', 14196)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (303, N'Inventory', N'Stocktaking', N'Save', 1, N'get', 14197)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (304, N'Inventory', N'Stocktaking', N'Delete', 0, N'post', 14198)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (305, N'Inventory', N'Stocktaking', N'Save', 0, N'post', 14199)
Go
  ----------------------------End 2021-01-05-----------------------------------

  ----------------------------Hammad 2021-01-06---------------------------------

CREATE TABLE [dbo].[Rec_RecruitEmployeeUndeclaredPosition](
	[RecruitEmployeeUndeclaredPositionCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitEmployeeCode] [int] NOT NULL,
	[PositionCode] [nvarchar](30) NOT NULL,
 CONSTRAINT [PK_Rec_RecruitEmployeeUndeclaredPosition] PRIMARY KEY CLUSTERED 
(
	[RecruitEmployeeUndeclaredPositionCode] 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_RecruitEmployeeUndeclaredPosition]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitEmployeeUndeclaredPosition_Positions] FOREIGN KEY([PositionCode])
REFERENCES [dbo].[Positions] ([PositionCode])
GO

ALTER TABLE [dbo].[Rec_RecruitEmployeeUndeclaredPosition] CHECK CONSTRAINT [FK_Rec_RecruitEmployeeUndeclaredPosition_Positions]
GO

ALTER TABLE [dbo].[Rec_RecruitEmployeeUndeclaredPosition]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitEmployeeUndeclaredPosition_Rec_RecruitEmployee] FOREIGN KEY([RecruitEmployeeCode])
REFERENCES [dbo].[Rec_RecruitEmployee] ([RecruitEmployeeCode])
GO

ALTER TABLE [dbo].[Rec_RecruitEmployeeUndeclaredPosition] CHECK CONSTRAINT [FK_Rec_RecruitEmployeeUndeclaredPosition_Rec_RecruitEmployee]
GO

  ----------------------------End 2021-01-06---------------------------------
