USE [HelpDesk02_Def]
GO

/***  Notification for Auto-Close Tickets   ***/
IF NOT EXISTS( SELECT * FROM [dbo].[tblNotification] WHERE nID=28 )
	INSERT [dbo].[tblNotification] ([nID], [nParentTableID], [tName], [tMailContent], [tDescription], 
	[fFieldsChanged], [tCaption], [nWhenID], [nWhenParentTableID], [dEnabledFrom], [nTrigger], [nEnablePeriod], 
	[tEnablePeriodUnit], [nMailTemplate], [nCalendarItem], [nReportID], [nReportFormat], [nReportArea]) 
	VALUES (28, 1, N'Auto-close$Tickets', '<None>', N'Action to Auto-Close Tickets - no Email Sent',  
	2, N'Auto-close Tickets', 28, 15, NULL, 1, 24, 
	'h', NULL, NULL, 25, NULL, NULL);

GO

