﻿--------------------------Hammad 2022-11-03--------
ALTER TABLE dbo.ForeignerUser ADD
PhoneNumber nvarchar(150)  NULL
GO
--------------------------End 2022-11-03--------
--------------------------Ali 2022-11-03--------
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1068,N'Recruitment',N'RecruitRequiredFile',N'Index',0,N'get',5136)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1069,N'Recruitment',N'RecruitRequiredFile',N'RecruitRequiredFile_Read',0,N'post',5137)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1070,N'Recruitment',N'RecruitRequiredFile',N'Save',1,N'get',5138)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1071,N'Recruitment',N'RecruitRequiredFile',N'Save',2,N'get',5139)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1072,N'Recruitment',N'RecruitRequiredFile',N'Delete',0,N'post',5140)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1073,N'Recruitment',N'RecruitRequiredFile',N'Save',0,N'post',5141)
Go

CREATE TABLE [dbo].[Rec_RecruitRequiredFiles](
	[RecruitRequiredFileCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](100) NOT NULL,
	[Arabic_Name] [nvarchar](100) NOT NULL,
	[Description] [nvarchar](250) NULL,
	[FileName] [nvarchar](250) NOT NULL,
	[IsForHirinig] [bit] NOT NULL,
 CONSTRAINT [PK_Rec_RecruitRequiredFiles] PRIMARY KEY CLUSTERED 
(
	[RecruitRequiredFileCode] 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

--------------------------Hammad 2022-11-03--------

