﻿
-----------------------------------------------Ali 16-08-2023 ----------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1125,N'WorkFlow',N'GeneralRequest',N'Index',0,N'get',3341)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1126,N'WorkFlow',N'GeneralRequest',N'GeneralRequest_Read',0,N'post',3342)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1127,N'WorkFlow',N'GeneralRequest',N'Save',1,N'get',3343)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1128,N'WorkFlow',N'GeneralRequest',N'Save',2,N'get',3344)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1129,N'WorkFlow',N'GeneralRequest',N'Delete',0,N'post',3345)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1130,N'WorkFlow',N'GeneralRequest',N'Save',0,N'post',3347)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1131,N'WorkFlow',N'GeneralRequest',N'Cancel',0,N'post',3346)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1132,N'WorkFlow',N'GeneralRequestSignature',N'Index',0,N'get',3348)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1133,N'WorkFlow',N'GeneralRequestSignature',N'GeneralRequest_Read',0,N'post',3349)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1134,N'WorkFlow',N'GeneralRequestSignature',N'Save',2,N'get',3350)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1135,N'WorkFlow',N'GeneralRequestSignature',N'Save',0,N'post',3351)
Go
update WF_RequestType set IsApi=1 where RequestTypeId=19
Go
-----------------------------------------------End 16-08-2023 ----------------------
-----------------------------------------------MOstafa 16-08-2023 ----------------------
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1114,N'WorkFlow',N'MaintenanceRequest',N'Index',0,N'get',3194)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1115,N'WorkFlow',N'MaintenanceRequest',N'MaintenanceRequest_Read',0,N'post',3195)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1116,N'WorkFlow',N'MaintenanceRequest',N'Save',1,N'get',3196)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1117,N'WorkFlow',N'MaintenanceRequest',N'Save',2,N'get',3197)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1118,N'WorkFlow',N'MaintenanceRequest',N'Delete',0,N'post',3198)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1119,N'WorkFlow',N'MaintenanceRequest',N'Save',0,N'post',3199)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1120,N'WorkFlow',N'MaintenanceRequest',N'Cancel',0,N'post',3200)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1121,N'WorkFlow',N'MaintenanceRequestSignature',N'Index',0,N'get',3201)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1122,N'WorkFlow',N'MaintenanceRequestSignature',N'MaintenanceRequest_Read',0,N'post',3202)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1123,N'WorkFlow',N'MaintenanceRequestSignature',N'Save',2,N'get',3203)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1124,N'WorkFlow',N'MaintenanceRequestSignature',N'Save',0,N'post',3204)
Go
update WF_RequestType set IsApi=1 where RequestTypeId=12
Go
-----------------------------------------------End 16-08-2023 ----------------------
-----------------------------------------------AK 2023-08-16 ------------------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'RedirectLinkText', N'Redirect link text', N'الاسم الظاهر على رابط الايميل', N'اضغط هنا', 1, 54, 1, 1, NULL, NULL, NULL, N'الاسم الظاهر على رابط الايميل')
GO
 -----------------------------------------------End ------------------------------------
  --------------------------AK 2023-08-17-----------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1011,N'Renew contract request',N'طلب تجديد العقد',495,N'/WorkFlow/RenewContractRequest',N'Index','fa fa-thumb-tack',N'Get',7,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1011,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15362,N'طلب تجديد العقد',N'Renew contract request',1011,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15363,N'عرض طلب تجديد العقد',N'View Renew contract request',1011,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15364,N'إضافة طلب تجديد العقد',N'Add Renew contract request',1011,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15365,N'تعديل طلب تجديد العقد',N'Edit Renew contract request',1011,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15366,N'حذف طلب تجديد العقد',N'Delete Renew contract request',1011,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15367,N'حفظ طلب تجديد العقد',N'Save Renew contract request',1011,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15368,N'الغاء طلب تجديد العقد',N'Cancel Renew contract Request',1011,2)
Go

-- SSTAuthorizationActionFilterBefore (script only not added in db Check it and run if you want)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1158, N'WorkFlow', N'RenewContractRequest', N'Index', 0, N'get', 15362)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1159, N'WorkFlow', N'RenewContractRequest', N'RenewContractRequest_Read', 0, N'post', 15363)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1160, N'WorkFlow', N'RenewContractRequest', N'Save', 1, N'get', 15364)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1161, N'WorkFlow', N'RenewContractRequest', N'Save', 2, N'get', 15365)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1162, N'WorkFlow', N'RenewContractRequest', N'Delete', 0, N'post', 15366)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1163, N'WorkFlow', N'RenewContractRequest', N'Save', 0, N'post', 15367)

-- RequestType sqript run it if you want ( by default not Automatic run )
INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment], [WorkedByDefaultContract], [CategoryCode], [RequestTypeGroupCode], [SendEmailNotification], [AsyncWhatsAppMessage], [RequsetPrint], [SignatureRefusedComentMandatory], [IsApi], [IsMasterRequest], [NotifSignCountAction], [NotifSignCountController], [NotifSignCountArea], [IsEnableSSL], [WorkedByAssignmentContract], [IsMobile], [SignatureApprovedCommentMandatory]) VALUES(60,N'طلب تجديد العقد',N'Renew contract request',0, N'sst.sentmail@gmail.com', N'sst.sentmail@gmail.com', N'mwtjgyjxrrgczlfr', N'smtp.gmail.com', 587, N'SST System', NULL, NULL, 1, 1, 0, 0, 0, 1, 4, 1, 0, 1, 0, 1, 1, N'index', N'RenewContractRequestSignature', N'WorkFlow', 1, 1, 0, 0)

-- EmailTemplateType sqript run it if you want ( by default not Automatic run )
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(352,N'Renew contract request Sending',N'ارسال طلب تجديد العقد',0,1,60, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(353,N'Renew contract request Accept',N'الموافقة على طلب تجديد العقد',0,1,60, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(354,N'Renew contract request Refuse',N'رفض طلب تجديد العقد',0,1,60, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(355,N'Renew contract request Cancel',N'الغاء طلب تجديد العقد',0,1,60, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(356,N'Send Notification AFter Track',N'ارسال اشعار بعد نهاية المسار',0,1,60, 1 )
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

-- EmailTemplate sqript run it if you want ( by default not Automatic run )
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2290,N'Renew contract request Sending',N'ارسال طلب تجديد العقد',352,N'ارسال',N'ارسال',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2291,N'Renew contract request Accept',N'الموافقة على طلب تجديد العقد',353,N'الموافقة على',N'الموافقة على',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2292,N'Renew contract request Refuse',N'رفض طلب تجديد العقد',354,N'رفض',N'رفض',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2293,N'Renew contract request Cancel',N'الغاء طلب تجديد العقد',355,N'الغاء',N'الغاء',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2294, N'Send Notification AFter Track',N'ارسال اشعار بعد نهاية المسار',356,N'ارسال اشعار بعد نهاية المسار',N'ارسال اشعار بعد نهاية المسار',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
--------------------------End 2023-08-17 -----------------------------
--------------------------AK 2023-08-17-----------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1012,N'Renew contract request signature',N'اعتماد طلب تجديد العقد',500,N'/WorkFlow/RenewContractRequestSignature',N'Index','fa fa-thumb-tack',N'Get',8,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1012,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15369,N'اعتماد طلب تجديد العقد',N'Renew contract request signature',1012,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15370,N'عرض اعتماد طلب تجديد العقد',N'View Renew contract request signature',1012,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15371,N'تعديل اعتماد طلب تجديد العقد',N'Edit Renew contract request signature',1012,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15372,N'حفظ اعتماد طلب تجديد العقد',N'Save Renew contract request signature',1012,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15373,N'حفظ متعدد للاعتماد',N'Multiple Save',1012,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15374,N'عرض سجل الموظف',N'View Employee History',1012,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15375,N'ارجاع الطلب',N'Inverse Request',1012,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15376,N'اختيار كل الطلبات',N'Choose All Requests',1012,2)
Go

-- SSTAuthorizationActionFilterBefore (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1164,N'WorkFlow',N'RenewContractRequestSignature',N'Index',0,N'get',15369)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1165,N'WorkFlow',N'RenewContractRequestSignature',N'RenewContractRequestSignature_Read',0,N'post',15370)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1166,N'WorkFlow',N'RenewContractRequestSignature',N'Save',2,N'get',15371)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1167,N'WorkFlow',N'RenewContractRequestSignature',N'Save',0,N'post',15372)
--------------------------End 2023-08-17-----------------------------
--------------------------Hammad 2023-08-17--------------------------

CREATE TABLE [SST.ERP_Client].[dbo].[ClientSecurityUser](
	[ClientUserCode] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](30) NOT NULL,
	[Password] [nvarchar](250) NOT NULL,
	[IsActive] [bit] NOT NULL,
 CONSTRAINT [PK_ClientSecurityUser] PRIMARY KEY CLUSTERED 
(
	[ClientUserCode] 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.SecurityUser ADD
	ClientUserCode int NULL,
	IsGeneral bit NOT NULL CONSTRAINT DF_SecurityUser_IsGeneral DEFAULT ((0))
GO
--------------------------End 2023-08-17-----------------------------
------------------------mahmoud 20-8-2023---------------------------

update WF_RequestType set IsApi = 1 where RequestTypeId= 26
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1147,N'WorkFlow',N'NewJobRequest',N'Index',0,N'get',3457)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1148,N'WorkFlow',N'NewJobRequest',N'NewJob_Read',0,N'post',3458)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1149,N'WorkFlow',N'NewJobRequest',N'Save',1,N'get',3459)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1150,N'WorkFlow',N'NewJobRequest',N'Save',2,N'get',3460)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1151,N'WorkFlow',N'NewJobRequest',N'Delete',0,N'post',3462)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1152,N'WorkFlow',N'NewJobRequest',N'Save',0,N'post',3461)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1153,N'WorkFlow',N'NewJobRequest',N'Cancel',0,N'post',3463)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1154,N'WorkFlow',N'NewJobRequestSignature',N'Index',0,N'get',3464)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1155,N'WorkFlow',N'NewJobRequestSignature',N'NewJobRequestSignature_Read',0,N'post',3465)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1156,N'WorkFlow',N'NewJobRequestSignature',N'Save',2,N'get',3466)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1157,N'WorkFlow',N'NewJobRequestSignature',N'Save',0,N'post',3467)
Go

--------------------------------- End ----------------------------
--------------------------AK 2023-08-21-----------------------------
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (765, NULL, NULL, N'RenewContractRequest', N'SearchRenewContractRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (766, NULL, NULL, N'RenewContractRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (767, NULL, NULL, N'RenewContractRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (768, NULL, NULL, N'RenewContractRequest', N'Put', N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (769, NULL, NULL, N'RenewContractRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (770, NULL, NULL, N'RenewContractRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (771, NULL, NULL, N'RenewContractRequest', N'Get', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (970, 765, 15363, 60)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (971, 766, 15365, 60)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (972, 767, 15365, 60)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (973, 768, 15367, 60)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (974, 769, 15367, 60)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (975, 770, 15349, 60)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (976, 771, 15348, 60)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (977, 12, 15368, 60) --Cancel
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (978, 9, 15370, 60) -- View sign
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (979, 10, 15370, 60) -- View sign
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (980, 8, 15371, 60) --edit sign
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (981, 13, 15372, 60) -- save sign
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (982, 11, 15374, 60) -- view empLog
GO
--------------------------End 2023-08-21-----------------------------
--------------------------Hammad 2023-08-21--------------------------
SET IDENTITY_INSERT [dbo].[SecurityGroup] ON 
GO

INSERT [dbo].[SecurityGroup] ([SecurityGroupCode], [Name], [Arabic_Name], [IsEditable], [IsDefault], [PasswordPolicyCode]) 
VALUES (100, N'General Users', N'المستخدم العام ', 1, 0, NULL)
GO
SET IDENTITY_INSERT [dbo].[SecurityGroup] OFF
GO
--------------------------End 2023-08-21--------------------------

---------------------------------mahmoud 21-8-2023------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1013,N'Housing Employee Request',N'طلب تسكين موظف',496,N'/WorkFlow/HousingEmployeeRequest',N'Index','fa fa-thumb-tack',N'get',23,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1013,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15377,N'طلب تسكين موظف',N'Housing Employee Request',1013,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15378,N'عرض طلب تسكين موظف',N'View Housing Employee Request',1013,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15379,N'إضافة طلب تسكين موظف',N'Add Housing Employee Request',1013,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15380,N'تعديل طلب تسكين موظف',N'Edit Housing Employee Request',1013,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15381,N'حذف طلب تسكين موظف',N'Delete Housing Employee Request',1013,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15382,N'حفظ طلب تسكين موظف',N'Save Housing Employee Request',1013,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1168,N'WorkFlow',N'HousingEmployeeRequest',N'Index',0,N'get',15377)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1169,N'WorkFlow',N'HousingEmployeeRequest',N'HousingEmployeeRequest_Read',0,N'post',15378)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1170,N'WorkFlow',N'HousingEmployeeRequest',N'Save',1,N'get',15379)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1171,N'WorkFlow',N'HousingEmployeeRequest',N'Save',2,N'get',15380)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1172,N'WorkFlow',N'HousingEmployeeRequest',N'Delete',0,N'post',15381)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1173,N'WorkFlow',N'HousingEmployeeRequest',N'Save',0,N'post',15382)
Go


INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment],[WorkedByDefaultContract],[CategoryCode],[RequestTypeGroupCode],[SendEmailNotification], [AsyncWhatsAppMessage], [RequsetPrint],[SignatureRefusedComentMandatory], [IsApi], [IsMasterRequest], [NotifSignCountAction], [NotifSignCountController], [NotifSignCountArea], [IsEnableSSL], [WorkedByAssignmentContract], [IsMobile], [SignatureApprovedCommentMandatory])
VALUES(61,N'طلب تسكين موظف',N'Housing Employee Request',0,N'sst.sentmail@gmail.com',N'sst.sentmail@gmail.com',N'mwtjgyjxrrgczlfr',N'smtp.gmail.com',587,N'SST System',NULL,NULL,1,1,0,0,0,1,1,1,0,1,0,1,1, N'index', N'HousingEmployeeRequestSignature',N'WorkFlow', 1,1,0,0)

-- EmailTemplateType sqript run it if you want ( by default not Automatic run )
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(357,N'Housing Employee Request Sending',N'ارسال طلب تسكين موظف',0,1,61, 1 )

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(358,N'Housing Employee Request Accept',N'الموافقة على طلب تسكين موظف',0,1,61, 1 )

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(359,N'Housing Employee Request Refuse',N'رفض طلب تسكين موظف',0,1,61, 1 )

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(360,N'Housing Employee Request Cancel',N'الغاء طلب تسكين موظف',0,1,61, 1 )
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
Go


SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2295,N'Housing Employee Request Sending',N'ارسال طلب تسكين موظف',357,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2296,N'Housing Employee Request Accept',N'الموافقة على طلب تسكين موظف',358,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2297,N'Housing Employee Request Refuse',N'رفض طلب تسكين موظف',359,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(2298,N'Housing Employee Request Cancel',N'الغاء طلب تسكين موظف',360,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

Go
-----------------------------end  21-8-2023------------------------------------
-----------------------------MOstafa  22-8-2023------------------------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
VALUES (N'QualificationsRead', N'Source Read Qualifications', N'مصدر قراءه المؤهلات', N'90', 1, 35, 6, 1, NULL, NULL, NULL, N'مصدر قراءه المؤهلات')
GO
GO
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (90, N'EmployeeEducationData', N'EmployeeEducationData', N'QualificationsRead')
GO
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (91, N'EmployeeEducationFullData', N'EmployeeEducationFullData', N'QualificationsRead')
GO
-----------------------------end  22-8-2023------------------------------------

------------------------------------mahmoud 23-8-2023 ---------------------------------

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (772, NULL, NULL, N'HousingEmployeeRequest', N'SearchHousingEmployeeRequest', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (773, NULL, NULL, N'HousingEmployeeRequest', N'GetDetails', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (774, NULL, NULL, N'HousingEmployeeRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (775, NULL, NULL, N'HousingEmployeeRequest', N'Put', N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (776, NULL, NULL, N'HousingEmployeeRequest', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (777, NULL, NULL, N'HousingEmployeeRequest', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (778, NULL, NULL, N'HousingEmployeeRequest', N'Get', N'Get')
GO


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (983, 772, 15378, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (984, 773, 15380, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (985, 774, 15380, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (986, 775, 15382, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (987, 776, 15382, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (988, 777, 15381, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (989, 778, 15380, NULL)
GO


INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15383,N'الغاء طلب تسكين موظف  ',N'Cancel Housing Employee Request',1013,2)

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (990, 12, 15383, 60) --Cancel



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1014,N'Housing Employee Request Signature',N'إعتماد طلب تسكين موظف',501,N'/WorkFlow/HousingEmployeeRequestSignature',N'Index','fa fa-thumb-tack',N'get',26,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1014,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15384,N'إعتماد طلب تسكين موظف',N'Housing Employee Request Signature',1014,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15385,N'عرض إعتماد طلب تسكين موظف',N'View Housing Employee Request Signature',1014,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15386,N'تعديل إعتماد طلب تسكين موظف',N'Edit Housing Employee Request Signature',1014,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15387,N'حفظ إعتماد طلب تسكين موظف',N'Save Housing Employee Request Signature',1014,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15388,N'حفظ متعدد للاعتماد',N'Multiple Save',1014,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15389,N'عرض سجل الموظف',N'View Employee History',1014,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15390,N'ارجاع الطلب',N'Inverse Request',1014,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15391,N'اختيار كل الطلبات',N'Choose All Requests',1014,2)

Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1174,N'WorkFlow',N'HousingEmployeeRequestSignature',N'Index',0,N'get',15384)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1175,N'WorkFlow',N'HousingEmployeeRequestSignature',N'HousingEmployeeRequestSignature_Read',0,N'post',15385)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1176,N'WorkFlow',N'HousingEmployeeRequestSignature',N'Save',2,N'get',15386)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1177,N'WorkFlow',N'HousingEmployeeRequestSignature',N'Save',0,N'post',15387)


 INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (990, 12, 15383, 61)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (991, 9, 15385, 61)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (992, 10, 15385, 61)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (993, 8, 15386, 61)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (994, 13, 15387, 61)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (995, 11, 15389, 61)
------------------------------------ end ------------------------------------------------
