-------------------------------Ali 2020-09-30------------------------
CREATE TABLE [dbo].[DefaultPagesForParentMenu](
	[DefaultPagesForParentMenuId] [int] IDENTITY(1,1) NOT NULL,
	[SecurityUserCode] [int] NOT NULL,
	[ParentMenuCode] [int] NOT NULL,
	[DefaultPageCode] [int] NOT NULL,
 CONSTRAINT [PK_DefaultPagesForParentMenu] PRIMARY KEY CLUSTERED 
(
	[DefaultPagesForParentMenuId] 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 2020-09-30------------------------
-------------------------------Hammad 2020-09-30---------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (378, N'Stores Transactions Signature', N'إعتماد حركات المخازن', 357, N'/Inventory/StoreTransactionSignature', N'Index', N'fa fa-thumb-tack', N'get', 1, 1, 1)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14186, N'إعتماد حركات المخازن ', N'Stores Transactions Signature', 378, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14187, N'عرض إعتماد حركات المخازن', N'View Stores Transactions Signature', 378, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14188, N'إجراء إعتماد حركات المخازن', N'Action Stores Transactions Signature', 378, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14189, N'حفظ إعتماد حركات المخازن', N'Save Stores Transactions Signature', 378, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14190, N'إعادة فتح  حركات المخازن', N'ReOpen Stores Transactions ', 378, 2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (288, N'Inventory', N'StoreTransactionSignature', N'Index', 0, N'get', 14186)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (289, N'Inventory', N'StoreTransactionSignature', N'StoreTransactionSignature_Read', 0, N'post', 14187)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (290, N'Inventory', N'StoreTransactionSignature', N'Save', 2, N'get', 14188)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (291, N'Inventory', N'StoreTransactionSignature', N'Save', 0, N'post', 14189)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (292, N'Inventory', N'StoreTransactionSignature', N'Save', 1, N'get', 14190)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (378, 12)
Go
-------------------------------End 2020-09-30---------------------

-------------------------------Ali 2020-10-01---------------------

ALTER TABLE dbo.WF_MonthlyEffectsRequest ADD
	ClosingNumber tinyint NULL
GO
ALTER TABLE dbo.WF_MonthlyEffectsRequest SET (LOCK_ESCALATION = TABLE)
GO

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'ClosingTransactionNumber', N'Closing Transaction Number', N'عدد حركات الاغلاق', N'0', 1, 11, 2, 1, NULL, NULL, NULL)
GO
-------------------------------End 2020-10-01---------------------