﻿------------------------------------Mostafa 2023-12-27------------------------------------------------------------

ALTER TABLE dbo.WF_MonthlyEffectType ADD
	RelatedRequestId int NOT NULL  DEFAULT 1
	GO
------------------------------------End 2023-12-27------------------------------------------------------------
------------------------------------Ali 2023-12-27------------------------------------------------------------

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1176, 225,15040 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1177, 169,15082 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1178, 183,3349 , NULL)
GO
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]=15378 where Id=984
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1179, 773,15385 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1180, 15,15172 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1181, 190,3202 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1182, 22,15187 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1183, 64,15097 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1184,43,15066 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1185, 2, 15157, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1186,29,15142 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1187,36,15201 , NULL)
GO
update [SecurityPrivilegeEndPointsDetails] set [SecurityPrivilegeId]=3581 where Id=355
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1188, 197,3588 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1189,50,15112 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1190,162,15317 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1191,176,3284 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1192,336,3071 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1193,349,3060 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1194,349,3387 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1195,323,3214 , NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1196,284,3108 , NULL)
GO
------------------------------------End 2023-12-27------------------------------------------------------------
 
 ----------------------------------Negm 2023 -12-27------------------------------------------------------------
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1197, 211 ,3445,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id,SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1198, 766 ,15370,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id,SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1199, 218 ,3236,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1200, 271 ,3465,null)
GO
update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId= 15346 where id = 958
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1201, 759 ,15353,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1202, 148 ,3417,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1203, 155 ,15290,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id,SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values ( 1204,57 ,15275,null)
GO
update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId= 15436 where id = 1150
GO
insert into SecurityPrivilegeEndPointsDetails(id,SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1205, 922 ,15443,null)
GO
update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId= 3265 where id = 1136
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1206, 908 ,3272,null)
GO
update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId= 15393 where id = 997
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1207, 780 ,15400,null)
GO
update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId= 15408 where id = 1027
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1208, 810 ,15414,null)
GO
update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId= 3315 where id = 1084
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1209, 855 ,3315,null)
GO
update SecurityPrivilegeEndPointsDetails set SecurityPrivilegeId= 3602 where id = 1096
go
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1210, 395 ,3609,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1211, 402 ,3624,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1212, 297 ,3141,null)
GO

insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1213, 310 ,3130,null)
GO
 
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1214, 258 ,3040,null)
GO

insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1215, 245 ,3085,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1216, 372 ,3382,null)
GO
insert into SecurityPrivilegeEndPointsDetails(id, SecurityPrivilegeEndPointId , SecurityPrivilegeId,RequestTypeId) values (1217, 372 ,3391,null)
GO
------------------------------------------------End 2023-12-27----------------------------------------------------------------