﻿ -------------------------------------- Hammad 2024-10-10 ------------------------
IF NOT EXISTS (
    SELECT 1
    FROM SecurityPrivilegeActions
    WHERE AreaName = 'inventory'
    AND ControllerName = 'itemcategory'
    AND ActionName = 'index'
    AND HTTPMethod = 'get'
)
BEGIN
 INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES
(2036, N'Inventory', N'ItemCategory', N'Index', 0, N'get', 14012);
END
 -------------------------------------- End 2024-10-10 ------------------------
 -------------------------------------- Ali 2024-10-08 ------------------------
 
 INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
	VALUES (1839, 1401,3097, 5)
	Go
 -------------------------------------- End 2024-10-08 ------------------------
 -------------------------------------- Hammad 2024-10-09 ---------------------

CREATE TABLE [dbo].[Qualifications](
	[QualificationCode] [int] NOT NULL,
	[Name] [nvarchar](400) NULL,
	[Arabic_Name] [nvarchar](400) NULL,
	[MainGrade] [nvarchar](20) NULL,
	[EducationCode] [tinyint] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Qualifications] PRIMARY KEY CLUSTERED 
(
	[QualificationCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Qualifications] ADD  CONSTRAINT [DF_Qualifications_QualificationCode]  DEFAULT ((0)) FOR [QualificationCode]
GO


CREATE TABLE [dbo].[Grades](
	[GradeCode] [tinyint] NOT NULL,
	[Name] [nvarchar](30) NULL,
	[Arabic_Name] [nvarchar](30) NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Grades] PRIMARY KEY CLUSTERED 
(
	[GradeCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Grades] ADD  CONSTRAINT [DF_Grades_GradeCode]  DEFAULT ((0)) FOR [GradeCode]
GO

 -------------------------------------- End 2024-10-09 ---------------------
 