﻿------------------------Hammad 2025-02-13---------------------------
update EmailTemplateType set Name='Send Notification AFter Track',Arabic_Name='ارسال اشعار بعد نهاية المسار' where EmailTemplateTypeCode=495
Go

delete EmailTemplate where EmailTemplateCode= 4412 and EmailTemplateTypeCode=495
Go
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (499, N'Send Refuse Notification After End of Track', N'إشعار بالرفض بعد نهاية المسار', 0, 1, 68, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate]) 
VALUES ( N'إرسال إشعار بالموافقة بعد نهاية المسار', N'إرسال إشعار بالموافقة بعد نهاية المسار', 495, N'إرسال إشعار بالموافقة بعد نهاية المسار', N'إرسال إشعار بالموافقة بعد نهاية المسار', 0, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate]) 
VALUES ( N'إرسال إشعار بالرفض بعد نهاية المسار', N'إرسال إشعار بالرفض بعد نهاية المسار', 499, N'إرسال إشعار بالرفض بعد نهاية المسار', N'إرسال إشعار بالرفض بعد نهاية المسار', 0, NULL, NULL, NULL, NULL)
GO

------------------------End 2025-02-13------------------------------
 ----------------------------------------- AK 2025-02-13 --------------------
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (15539,N'إمكانية تعديل الطلب',N'Can Modify Request  ',37,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (15540,N'إمكانية تعديل الطلب',N'Can Modify Request  ',70,2)
GO
----------------------------------------- AK 2025-02-13 --------------------- 
----------------------------------------- Ali 2025-02-13 --------------------- 
ALTER TABLE dbo.TermsAndConditions ADD
	Subject [nvarchar](150) NULL,
	Closed bit NOT NULL DEFAULT 0
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UsersTermsAndConditions](
	[UserTermsAndConditionCode] [int] IDENTITY(1,1) NOT NULL,
	[TermsAndConditionId] [int] NOT NULL,
	[UserCode] [int] NOT NULL,
	[FromEmeil] [nvarchar](100) NULL,
	[ToEmeil] [nvarchar](100) NULL,
	[SendDate] [datetime] NOT NULL,
 CONSTRAINT [PK_UsersTermsAndConditions] PRIMARY KEY CLUSTERED 
(
	[UserTermsAndConditionCode] 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].[UsersTermsAndConditions]  WITH CHECK ADD  CONSTRAINT [FK_UsersTermsAndConditions_SecurityUser] FOREIGN KEY([UserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[UsersTermsAndConditions] CHECK CONSTRAINT [FK_UsersTermsAndConditions_SecurityUser]
GO

ALTER TABLE [dbo].[UsersTermsAndConditions]  WITH CHECK ADD  CONSTRAINT [FK_UsersTermsAndConditions_UsersTermsAndConditions] FOREIGN KEY([TermsAndConditionId])
REFERENCES [dbo].[TermsAndConditions] ([TermsAndConditionsId])
GO

ALTER TABLE [dbo].[UsersTermsAndConditions] CHECK CONSTRAINT [FK_UsersTermsAndConditions_UsersTermsAndConditions]
GO



----------------------------------------- End 2025-02-13 --------------------- 


