﻿
--------------------------Ali 2026-03-16---------------------------

ALTER TABLE dbo.Departments ADD
	DepartmentGroupCode int NULL
GO
ALTER TABLE dbo.Divisions ADD
	DivisionGroupCode int NULL
GO


CREATE TABLE [dbo].[DepartmentsGroups](
	[DepartmentGroupCode] [int] NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[Closed] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_DepartmentsGroups_DepartmentGroupCode] PRIMARY KEY CLUSTERED 
(
	[DepartmentGroupCode] 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].[DepartmentsGroups] ADD  CONSTRAINT [DF_DepartmentsGroups_Closed]  DEFAULT ((0)) FOR [Closed]
GO


CREATE TABLE [dbo].[DivisionsGroups](
	[DivisionGroupCode] [int] NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[Closed] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_DivisionsGroups_DivisionGroupCode] PRIMARY KEY CLUSTERED 
(
	[DivisionGroupCode] 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].[DivisionsGroups] ADD  CONSTRAINT [DF_DivisionsGroups_Closed]  DEFAULT ((0)) FOR [Closed]
GO


ALTER TABLE dbo.EmployeeFiltering ADD
	PositionGroupCodes nvarchar(MAX) NULL,
	SectionGroupCodes nvarchar(MAX) NULL,
	FromPositionsGroupCode int NULL,
	FromSectionGroupCode int NULL,
	ToPositionsGroupCode int NULL,
	ToSectionGroupCode int NULL,

	DepartmentGroupCodes nvarchar(MAX) NULL,
	DivisionGroupCodes nvarchar(MAX) NULL,
	FromDepartmentGroupCode int NULL,
	FromDivisionGroupCode int NULL,
	ToDepartmentGroupCode int NULL,
	ToDivisionGroupCode int NULL

GO
--------------------------End 2026-03-16---------------------------
--------------------------Mostafa 2026-03-17---------------------------
INSERT INTO UserType (UserTypeCode,Name,Arabic_Name, HaveEmployee, OrganizationCategoryCode,IsVisible)
VALUES (49, 'Division General Manager Other', N'المدير العام للقطاع للاخر', 1, NULL, 1)
GO

--------------------------ENd 2026-03-17---------------------------
				