-------------------------------- Hammad 2019-11-27----------------
CREATE TABLE [dbo].[WF_SendEmailSetup](
	[SendEmailSetupCode] [int] IDENTITY(1,1) NOT NULL,
	[RequestTypeId] [int] NOT NULL,
	[FLevelFromHourCount] [float] NOT NULL,
	[FLevelToHourCount] [float] NOT NULL,
	[FLevelHoursRepeatReminder] [nvarchar](50) NULL,
	[FLevelBcc] [nvarchar](50) NULL,
	[FLevelCC] [nvarchar](50) NULL,
	[ToUpLevelUserAfterHourCount] [float] NOT NULL,
	[ToUpLevelUserTypeCode] [int] NOT NULL,
	[UpLevelBcc] [nvarchar](50) NULL,
	[UpLevelCC] [nvarchar](50) NULL,
 CONSTRAINT [PK_WF_SendEmailSetup] PRIMARY KEY CLUSTERED 
(
	[SendEmailSetupCode] 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

CREATE TABLE [dbo].[WF_EmailNotification](
	[EmailNotificationCode] [int] IDENTITY(1,1) NOT NULL,
	[RequestTypeCode] [int] NOT NULL,
	[NotificationDate] [datetime] NOT NULL,
	[PendingCount] [int] NOT NULL,
	[SendToUserCode] [int] NOT NULL,
	[CcUsers] [nvarchar](50) NULL,
	[BccUsers] [nvarchar](50) NULL,
	[SendToLevel] [int] NOT NULL,
	[PendingForSent] [bit] NOT NULL,
	[SendEmailDate] [datetime] NULL,
	[RequestCodes] [nvarchar](50) NULL,
 CONSTRAINT [PK_WF_EmailNotification] PRIMARY KEY CLUSTERED 
(
	[EmailNotificationCode] 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].[WF_EmailNotification] ADD  CONSTRAINT [DF_WF_EmailNotification_PendingForSent]  DEFAULT ((0)) FOR [PendingForSent]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1: First Level , 2:Up Level' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WF_EmailNotification', @level2type=N'COLUMN',@level2name=N'SendToLevel'
GO


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (3451, N'عرض إعدادات إرسال التنبية', N'View Send Notification Email Setup', 96, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (3452, N'حفظ إعدادات إرسال التنبية', N'Save Send Notification Email Setup ', 96, 2)
 Go

 ALTER TABLE dbo.WF_EmailNotification ADD
	PendingForSent bit NOT NULL CONSTRAINT DF_WF_EmailNotification_PendingForSent DEFAULT 0
GO

 -------------------------------- End 2019-11-27----------------
 -------------------------------- Ali 2019-12-1----------------
 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFCanShowCost', N'Can view cost', N'عرض التكلفة', N'true', 2, 10, 1, 1, NULL, NULL, 3)
 -------------------------------- End 2019-12-1----------------