--------------------------Ali 2021-02-18------------------------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'AddOrganizationStructureFrom', N'Add Organization Structure From', N'اضافة الهيكل اللإدارى من', N'68', 1, 14, 6, 1, 1, CAST(N'2021-02-18T16:59:24.307' AS DateTime), NULL)
Go
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (68, N'Default', N'افتراضى', N'AddOrganizationStructureFrom')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (69, N'Org9', N'Org9', N'AddOrganizationStructureFrom')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (70, N'Org8', N'Org8', N'AddOrganizationStructureFrom')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (71, N'Org7', N'Org7', N'AddOrganizationStructureFrom')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (72, N'Org6', N'Org6', N'AddOrganizationStructureFrom')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (73, N'Org5', N'Org5', N'AddOrganizationStructureFrom')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (74, N'Org4', N'Org4', N'AddOrganizationStructureFrom')
Go


  ALTER TABLE dbo.Divisions ADD
	FatherCode nvarchar(20) NULL
GO
/****** Object:  Table [dbo].[Org4]    Script Date: 18/02/2021 4:01:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Org4](
	[Org4Code] [nvarchar](20) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[FatherCode] [nvarchar](20) NULL,
	[Closed] [bit] NULL,
	[Org4GroupCode] [int] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Org4] PRIMARY KEY CLUSTERED 
(
	[Org4Code] 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
/****** Object:  Table [dbo].[Org5]    Script Date: 18/02/2021 4:01:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Org5](
	[Org5Code] [nvarchar](20) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[FatherCode] [nvarchar](20) NULL,
	[Closed] [bit] NULL,
	[Org5GroupCode] [int] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Org5] PRIMARY KEY CLUSTERED 
(
	[Org5Code] 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
/****** Object:  Table [dbo].[Org6]    Script Date: 18/02/2021 4:01:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Org6](
	[Org6Code] [nvarchar](20) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[FatherCode] [nvarchar](20) NULL,
	[Closed] [bit] NULL,
	[Org6GroupCode] [int] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Org6] PRIMARY KEY CLUSTERED 
(
	[Org6Code] 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
/****** Object:  Table [dbo].[Org7]    Script Date: 18/02/2021 4:01:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Org7](
	[Org7Code] [nvarchar](20) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[FatherCode] [nvarchar](20) NULL,
	[Closed] [bit] NULL,
	[Org7GroupCode] [int] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Org7] PRIMARY KEY CLUSTERED 
(
	[Org7Code] 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
/****** Object:  Table [dbo].[Org8]    Script Date: 18/02/2021 4:01:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Org8](
	[Org8Code] [nvarchar](20) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[FatherCode] [nvarchar](20) NULL,
	[Closed] [bit] NULL,
	[Org8GroupCode] [int] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Org8] PRIMARY KEY CLUSTERED 
(
	[Org8Code] 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
/****** Object:  Table [dbo].[Org9]    Script Date: 18/02/2021 4:01:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Org9](
	[Org9Code] [nvarchar](20) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[FatherCode] [nvarchar](20) NULL,
	[Closed] [bit] NULL,
	[Org9GroupCode] [int] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Org9] PRIMARY KEY CLUSTERED 
(
	[Org9Code] 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

--------------------------End 2021-02-18------------------------------------