﻿--------------------------------------- Hammad  2023-03-21 ------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'ArcFolderPrivilege', N'Work By Folder Privilege', N'العمل بصلاحيات المجلد ', N'false', 9, 17, 1, 1, NULL, NULL, NULL, N'العمل بصلاحيات المجلد من خلال صلاحيات لجروب المستخدمين   ')
GO
--------------------------------------- End  2023-03-21 ------------
--------------------------------------- Hammad  2023-03-23 ---------
CREATE TABLE [dbo].[Arc_FolderPrivilege](
	[FolderPrivilegeCode] [int] IDENTITY(1,1) NOT NULL,
	[FolderCode] [int] NOT NULL,
	[UserGroupCode] [int] NOT NULL,
	[ViewFolder] [bit] NOT NULL,
	[EditFolder] [bit] NOT NULL,
	[AllUsers] [bit] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_Arc_FolderPrivilege] PRIMARY KEY CLUSTERED 
(
	[FolderPrivilegeCode] 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].[Arc_FolderPrivilege]  WITH CHECK ADD  CONSTRAINT [FK_Arc_FolderPrivilege_Arc_Folder] FOREIGN KEY([FolderCode])
REFERENCES [dbo].[Arc_Folder] ([FolderCode])
GO

ALTER TABLE [dbo].[Arc_FolderPrivilege] CHECK CONSTRAINT [FK_Arc_FolderPrivilege_Arc_Folder]
GO

ALTER TABLE [dbo].[Arc_FolderPrivilege]  WITH CHECK ADD  CONSTRAINT [FK_Arc_FolderPrivilege_SecurityGroup] FOREIGN KEY([UserGroupCode])
REFERENCES [dbo].[SecurityGroup] ([SecurityGroupCode])
GO

ALTER TABLE [dbo].[Arc_FolderPrivilege] CHECK CONSTRAINT [FK_Arc_FolderPrivilege_SecurityGroup]
GO




CREATE TABLE [dbo].[Arc_FolderPrivilegeDetail](
	[FolderPrivilegeDetailCode] [int] IDENTITY(1,1) NOT NULL,
	[FolderPrivilegeCode] [int] NOT NULL,
	[UserCode] [int] NOT NULL,
	[ViewFolder] [bit] NOT NULL,
	[EditFolder] [bit] NOT NULL,
 CONSTRAINT [PK_Arc_FolderPrivilegeDetail] PRIMARY KEY CLUSTERED 
(
	[FolderPrivilegeDetailCode] 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].[Arc_FolderPrivilegeDetail]  WITH CHECK ADD  CONSTRAINT [FK_Arc_FolderPrivilegeDetail_Arc_FolderPrivilege] FOREIGN KEY([FolderPrivilegeCode])
REFERENCES [dbo].[Arc_FolderPrivilege] ([FolderPrivilegeCode])
GO

ALTER TABLE [dbo].[Arc_FolderPrivilegeDetail] CHECK CONSTRAINT [FK_Arc_FolderPrivilegeDetail_Arc_FolderPrivilege]
GO

ALTER TABLE [dbo].[Arc_FolderPrivilegeDetail]  WITH CHECK ADD  CONSTRAINT [FK_Arc_FolderPrivilegeDetail_SecurityUser] FOREIGN KEY([UserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[Arc_FolderPrivilegeDetail] CHECK CONSTRAINT [FK_Arc_FolderPrivilegeDetail_SecurityUser]
GO




--------------------------------------- End  2023-03-23 ------------

--------------------------------------- Hammad  2023-03-29 ------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (9044, N'إضافة صلاحيات مجلد ', N' Add Folder Privilage', 134, 2)
GO
--------------------------------------- End  2023-03-29 ------------