﻿---------------------Hammad 2021-08-28------
CREATE TABLE [dbo].[Arc_Delegation](
	[DelegationId] [int] IDENTITY(1,1) NOT NULL,
	[UserCode] [int] NOT NULL,
	[DelegatorUserCode] [int] NOT NULL,
	[FromDate] [datetime] NOT NULL,
	[ToDate] [datetime] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_Arc_Delegation] PRIMARY KEY CLUSTERED 
(
	[DelegationId] 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

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (561, N' Arc Delegation', N' تفويض الارشفة', 133, N'/Archive/ArcDelegation', N'Index', N'fa fa-thumb-tack', N'get', 4, 1, 1)
 Go
 INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (561, 3)
 Go
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (9032, N' تفويض الارشفة', N' Arc Delegation', 561, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (9033, N'عرض  تفويض الارشفة', N'View  Arc Delegation', 561, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (9034, N'إضافة  تفويض الارشفة', N'Add  Arc Delegation', 561, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (9035, N'تعديل  تفويض الارشفة', N'Edit  Arc Delegation', 561, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (9036, N'حذف  تفويض الارشفة', N'Delete  Arc Delegation', 561, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (9037, N'حفظ  تفويض الارشفة', N'Save  Arc Delegation', 561, 2)
Go
---------------------End 2021-08-28------
---------------------Hammad 2021-08-29---
Alter Table Arc_Folder Add
CreatedBy int NULL
GO
update Arc_Folder set CreatedBy=UserCode ;
ALTER TABLE Arc_Folder
ALTER COLUMN CreatedBy int NOT NULL;
---------------------End 2021-08-29---