﻿-------------------------------Mostafa 2022-04-03---
SET IDENTITY_INSERT [dbo].[AppModule] ON  
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name],IsLicensed) VALUES (19, N'Machine', N' الماكينة',1)
SET IDENTITY_INSERT [dbo].[AppModule] OFF
GO
INSERT [dbo].[ConfigCategory] ([ConfigCategoryCode], [Name], [Arabic_Name]) VALUES (12, N'Machine', N' الماكينة')
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES (N'SyncSchedule', N'Sync Schedule', N'جدول المزامنة', N'true', 19, 1, 4, 1, NULL, NULL, NULL)
GO
INSERT [dbo].[ConfigCategoryModule] ([ConfigCategoryCode], [AppModuleCode])
VALUES ( 19, 19)
GO
-------------------------------End 2022-04-03---
-------------------------------Ali 2022-04-05---

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(604,N'Journal Entries',N'قيود اليوميه',584,N'/GenerlLedger/JournalHeader',N'Index','fa fa-thumb-tack',N'get',9,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(604,18)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23052,N'قيود اليوميه',N'Journal Entries',604,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23053,N'عرض قيود اليوميه',N'View Journal Entries',604,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23054,N'إضافة قيود اليوميه',N'Add Journal Entries',604,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23055,N'تعديل قيود اليوميه',N'Edit Journal Entries',604,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23056,N'حذف قيود اليوميه',N'Delete Journal Entries',604,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23057,N'حفظ قيود اليوميه',N'Save Journal Entries',604,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1014,N'GenerlLedger',N'JournalHeader',N'Index',0,N'get',23052)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1015,N'GenerlLedger',N'JournalHeader',N'JournalHeader_Read',0,N'post',23053)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1016,N'GenerlLedger',N'JournalHeader',N'Save',1,N'get',23054)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1017,N'GenerlLedger',N'JournalHeader',N'Save',2,N'get',23055)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1018,N'GenerlLedger',N'JournalHeader',N'Delete',0,N'post',23056)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1019,N'GenerlLedger',N'JournalHeader',N'Save',0,N'post',23057)
Go
-------------------------------End 2022-04-05---
-------------------------------Mostafa 2022-04-05---
USE [SST.ERP_Client] CREATE TABLE [dbo].[BackgroundEvent](
	[Code] [int] IDENTITY(1,1) NOT NULL,
	[DateFtom] [date] NULL,
	[DateTo] [date] NULL,
	[FileName] [nvarchar](max) NULL,
 CONSTRAINT [PK_BackgroundEvent] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
-------------------------------End 2022-04-05---