	
	SET IDENTITY_INSERT [dbo].[CD_NotificationMessages] ON
	DECLARE @CD_NotificationMessages TABLE ([NotificationMessageId] INT NOT NULL, [LanguageCode] TINYINT NOT NULL, [EventCode] SMALLINT NOT NULL, [NotificationMessage] NVARCHAR(100) NULL, [EmailBodyMessage] NVARCHAR(100) NULL,[SoundFile] nvarchar(250) null);
	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (326, 4, 2, N'Reset Allarme Furto', N'Reset Allarme Furto',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (327, 4, 5, N'Allarme Furto Cancellato', N'Allarme Furto Cancellato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (330, 4, 9, N'Tamper Reset', N'Tamper Reset',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (332, 4, 11, N'Rilevato disturbo Radio', N'Rilevato disturbo Radio',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (333, 4, 12, N'Riprisrino da disturbo Radio', N'Riprisrino da disturbo Radio',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (334, 4, 13, N'Dispositivo Bypassato', N'Dispositivo Bypassato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (335, 4, 14, N'Dispositivo non Bypassato', N'Dispositivo non Bypassato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (337, 4, 16, N'Iniziare Programmazione Locale', N'Iniziare Programmazione Locale',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (338, 4, 17, N'Iniziare Programmazione Remota', N'Iniziare Programmazione Remota',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (339, 4, 18, N'Fine Programmazione Locale', N'Fine Programmazione Locale',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (340, 4, 19, N'Fine Programmazione Remota', N'Fine Programmazione Remota',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (341, 4, 20, N'Allarme Perimetrale', N'Allarme Perimetrale',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (342, 4, 24, N'Sabotaggio Dispositivo Filare', N'Sabotaggio Dispositivo Filare',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (343, 4, 102, N'Reset da Allarme Incendio', N'Reset da Allarme Incendio',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (344, 4, 103, N'Allarme incendio cancellato', N'Allarme incendio cancellato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (345, 4, 104, N'Allarme Allagamento', N'Allarme Allagamento',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (346, 4, 105, N'Reset Allarme Allagamento', N'Reset Allarme Allagamento',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (347, 4, 106, N'Allarme Allagamento Cancellato', N'Allarme Allagamento Cancellato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (348, 4, 107, N'Allarme Gas', N'Allarme Gas',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (349, 4, 108, N'Reset Allarme Gas', N'Reset Allarme Gas',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (350, 4, 109, N'Allarme Gas cancellato', N'Allarme Gas cancellato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (351, 4, 110, N'Allarme Temperatura critica', N'Allarme Temperatura critica',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (352, 4, 111, N'Reset Allarme Temperatura critica', N'Reset Allarme Temperatura critica',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (353, 4, 201, N'Allarme mancanza alimentazione', N'Allarme mancanza alimentazione',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (354, 4, 202, N'Ripristino da mancanza alimentazione', N'Ripristino da mancanza alimentazione',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (355, 4, 203, N'Batteria bassa', N'Batteria bassa',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (356, 4, 204, N'Reset Batteria bassa', N'Reset Batteria bassa',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (357, 4, 205, N'Batteria Carica', N'Batteria Carica',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (358, 4, 206, N'Reset Batteria Carica', N'Reset Batteria Carica',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (359, 4, 207, N'Gusto di comunicazione', N'Gusto di comunicazione',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (361, 4, 209, N'Modifica di configurazione', N'Modifica di configurazione',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (362, 4, 210, N'Trasmissione di guasto', N'Trasmissione di guasto',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (363, 4, 211, N'Superviosione persa', N'Superviosione persa',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (364, 4, 212, N'Ripristino da supervisione', N'Ripristino da supervisione',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (365, 4, 301, N'Livello GSM', N'Livello GSM',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (366, 4, 302, N'Pannello di comunicazione di stato', N'Pannello di comunicazione di stato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (367, 4, 303, N'Pannello di controllo Utilizzo Inserimento', N'Pannello di controllo Utilizzo Inserimento',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (368, 4, 304, N'Pannello di Informazione sulla distribuzione', N'Pannello di Informazione sulla distribuzione',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (369, 4, 305, N'Chiamata a CMS', N'Chiamata a CMS',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (370, 4, 401, N'Pannello di Videosorveglianza', N'Pannello di Videosorveglianza',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (371, 4, 402, N'Pannello di Comfort Video', N'Pannello di Comfort Video',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (372, 4, 403, N'Pannello Video pre Allarme', N'Pannello Video pre Allarme',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (373, 4, 404, N'Videosorveglianza in CMS', N'Videosorveglianza in CMS',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (374, 4, 405, N'Video di Pre-Allarme in CMS', N'Video di Pre-Allarme in CMS',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (375, 4, 406, N'Cattura Video Fallita', N'Cattura Video Fallita',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (376, 4, 501, N'Entrata obbligata', N'Entrata obbligata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (377, 4, 502, N'Uscita obbligata', N'Uscita obbligata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (378, 4, 503, N'Inserimento Utente controllato', N'Inserimento Utente controllato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (379, 4, 504, N'Disinserimento utente controllato', N'Disinserimento utente controllato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (380, 4, 701, N'Eventi auto-test', N'Eventi auto-test',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (381, 4, 0, N'Sconosciuto', N'Sconosciuto',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (382, 4, 22, N'Richiesta di Blocco porta remota', N'Richiesta di Blocco porta remota',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (383, 4, 23, N'Inserimento esterno', N'Inserimento esterno',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (384, 4, 26, N'Ripristino da allarme sabotaggio filare', N'Ripristino da allarme sabotaggio filare',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (385, 4, 27, N'Allarme di inattività', N'Allarme di inattività',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (386, 4, 28, N'Reset da allarme di Inattività', N'Reset da allarme di Inattività',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (387, 4, 306, N'Funzione Flash perimetrale', N'Funzione Flash perimetrale',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (388, 4, 307, N'Funzione voce perimetrale', N'Funzione voce perimetrale',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (389, 4, 308, N'Stato home Automation', N'Stato home Automation',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (390, 4, 309, N'Stato Blocco porte', N'Stato Blocco porte',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (391, 4, 310, N'Richiesta Home automation Remota', N'Richiesta Home automation Remota',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (392, 4, 311, N'Entrata In Ascolto IP', N'Entrata In Ascolto IP',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (393, 4, 315, N'Informazioni FW Dispositivi', N'Informazioni FW Dispositivi',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (394, 4, 407, N'Comfort Video In CMS', N'Comfort Video In CMS',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (395, 4, 408, N'Informazioni ultimi video rilevati', N'Informazioni ultimi video rilevati',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (396, 4, 801, N'Risposta al comando dell''''utente', N'Risposta al comando dell''''utente',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (397, 4, 850, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (398, 4, 851, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (399, 4, 852, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (400, 4, 853, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (401, 4, 854, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (402, 4, 855, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (403, 4, 856, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (404, 4, 858, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (405, 4, 859, N'Video Rilevato', N'Video Rilevato',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (406, 4, 860, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (407, 4, 861, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (408, 4, 862, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (409, 4, 863, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (410, 4, 864, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (411, 4, 865, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (412, 4, 866, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (413, 4, 868, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (414, 4, 869, N'Immagine Rilevata', N'Immagine Rilevata',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (415, 4, 857, N'Video Richiesto', N'Video Richiesto',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (416, 4, 867, N'Immagine Richiesta', N'Immagine Richiesta',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (417, 4, 1, N'ALLARME FURTO.Il sistema {<Product Name>} ha rilevato intrusioni', N'ALLARME FURTO.Il sistema {<Product Name>} ha rilevato intrusioni','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (418, 4, 3, N'ALLARME PANICO attivato da utente {<Product Name>}', N'ALLARME PANICO attivato da utente {<Product Name>}',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (419, 4, 4, N'ALLARME ANTICOERCIZIONE attivato da utente {<Product Name>}', N'ALLARME ANTICOERCIZIONE attivato da utente {<Product Name>}',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (420, 4, 8, N'ALLARME FURTO.Il sistema {<Product Name>} ha rilevato intrusioni', N'ALLARME FURTO.Il sistema {<Product Name>} ha rilevato intrusioni','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (421, 4, 21, N'Sirena tacitata con successo', N'Sirena tacitata con successo',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (424, 4, 101, N'ALLARME FUMO.Rilevato dal sistema {<Product Name>}', N'ALLARME FUMO.Rilevato dal sistema {<Product Name>}',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (300, 4, 150, N'Safety Alarm', N'Safety Alarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (301, 4, 151, N'Safety Alarm Reset', N'Safety Alarm Reset detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (302, 4, 152, N'Safety Alarm Cancelled', N'Safety Alarm Cancelled detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (221, 4, 156, N'Panic Alarm Cancelled', N'Panic Alarm Cancelled detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (528, 4, 1010, N'Dispositivo  con allarme Tamper', N'Dispositivo  con allarme Tamper',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (529, 4, 44, N'ALLARME FURTO.Il sistema {<Product Name>} ha rilevato intrusioni', N'ALLARME FURTO.Il sistema {<Product Name>} ha rilevato intrusioni','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1400, 4, 1105, N'Presa Intelligente accesa', N'',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1401, 4, 1106, N'Presa Intelligente spenta', N'',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1403, 4, 1107, N'Apparecchio collegato', N'',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1404, 4, 1108, N'Apparecchio scollegato', N'',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1405, 4, 1104, N'Problema tecnico', N'',null)	
	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (544, 4, 1256, N'', N'','notification_alarm_wake_up_clock.mp3')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (545, 4, 1257, N'', N'','notification_alarm_siren_30_sec.mp3')
	
	MERGE INTO dbo.[CD_NotificationMessages] AS TARGET  
	USING @CD_NotificationMessages AS SOURCE  
	ON TARGET.[NotificationMessageId] = SOURCE.[NotificationMessageId] 
	WHEN MATCHED THEN    
	UPDATE SET [LanguageCode] = SOURCE.[LanguageCode], [EventCode] = SOURCE.[EventCode], [NotificationMessage] = SOURCE.[NotificationMessage], [EmailBodyMessage] = SOURCE.[EmailBodyMessage] ,[notificationtypeversion]='0', [SoundFile] = source.[SoundFile]
	WHEN NOT MATCHED BY TARGET THEN   
	INSERT ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[notificationtypeversion],SoundFile)   
	VALUES (SOURCE.[NotificationMessageId], SOURCE.[LanguageCode], SOURCE.[EventCode], SOURCE.[NotificationMessage], SOURCE.[EmailBodyMessage],'0',source.SoundFile)  
	OUTPUT $action, SOURCE.*;

	SET IDENTITY_INSERT [dbo].[CD_NotificationMessages] OFF

