	
	
	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);
	
	-- English
	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2, 1, 2, N'Intrusion alarm reset', N'Intrusion alarm reset detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (5, 1, 5, N'Intrusion alarm dismiss', N'Intrusion alarm dismissed on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (6, 1, 6, N'Guard Code Entered', N'Guard Code Entered detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (7, 1, 7, N'New Guard Code', N'New Guard Code detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (9, 1, 9, N'Tamper reset', N'Tamper state was reset (cancelled) on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (10, 1, 10, N'External Disarm', N'External Disarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (11, 1, 11, N'Jamming Detected', N'Jamming Detected detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (12, 1, 12, N'Jamming Restored', N'Jamming Restored detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (13, 1, 13, N'Device By passed', N'Device By passed detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (14, 1, 14, N'Device Unbypassed', N'Device Unbypassed detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (15, 1, 15, N'User Code Tamper', N'Device {<DeviceLabel>} Locked - Invalid User Code Used. Detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (16, 1, 16, N'Begin Local Programming', N'Begin Local Programming detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (17, 1, 17, N'Begin Remote Programming', N'Begin Remote Programming detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (18, 1, 18, N'End Of Local Programming', N'End Of Local Programming detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (19, 1, 19, N'End Of Remote Programming', N'End Of Remote Programming detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (20, 1, 20, N'Perimeter Alarm', N'Perimeter Alarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (21, 1, 24, N'Medication Missed', N'Medication Missed detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (22, 1, 101, N'Fire/Smoke alarm', N'Fire/Smoke alarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (23, 1, 102, N'Fire alarm reset', N'Fire alarm was reset on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (24, 1, 103, N'Fire alarm dismiss', N'Fire alarm dismissed on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (25, 1, 104, N'Flood alarm', N'Flood alarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (26, 1, 105, N'Flood alarm reset', N'Flood alarm was reset on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (27, 1, 106, N'Flood alarm dismiss', N'Flood alarm dismissed on',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (28, 1, 107, N'Gas Alarm', N'Gas Alarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (29, 1, 108, N'Gas Alarm Reset', N'Gas Alarm Reset detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (30, 1, 109, N'Gas Alarm Cancelled', N'Gas Alarm Cancelled detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (31, 1, 110, N'Extreme Temperature Alarm', N'Extreme Temperature Alarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (32, 1, 111, N'Extreme Temperature Alarm Reset', N'Extreme Temperature Alarm Reset detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (33, 1, 201, N'Power failure', N'Hub power failure detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (34, 1, 202, N'Power restored', N'Hub power restored on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (35, 1, 203, N'Low battery', N'Low battery level detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (36, 1, 204, N'Low battery reset', N'Battery low level indicaiton was reset on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (37, 1, 205, N'Empty Battery', N'Empty Battery detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (38, 1, 206, N'Empty Battery Reset', N'Empty Battery Reset detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (39, 1, 207, N'Communication Fault', N'Communication Fault detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (40, 1, 208, N'New Operative Code', N'New Operative Code detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (41, 1, 209, N'Change Configuration In Program', N'Change Configuration In Program detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (42, 1, 210, N'Transmitter Fault', N'Transmitter Fault detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (43, 1, 211, N'Connection loss', N'Connection loss detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (44, 1, 212, N'Supervision Restored', N'Supervision Restored detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (45, 1, 301, N'GSM Level', N'GSM Level detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (46, 1, 302, N'Panel Communication Status', N'Panel Communication Status detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (47, 1, 303, N'Hub Arming Usage', N'Hub Arming Usage detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (48, 1, 304, N'Panel Release Information', N'Panel Release Information detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (49, 1, 305, N'Call CMS', N'Call CMS detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (50, 1, 401, N'Security Video In Panel', N'Security Video In Panel detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (51, 1, 402, N'Comfort Video In Panel', N'Comfort Video In Panel detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (52, 1, 403, N'Pre Alarm Video In Panel', N'Pre Alarm Video In Panel detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (53, 1, 404, N'Security Video In CMS', N'Security Video In CMS detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (54, 1, 405, N'Pre Alarm Video In CMS', N'Pre Alarm Video In CMS detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (55, 1, 406, N'Video Capture Failure', N'Video Capture Failure detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (56, 1, 501, N'Employee Entry', N'Employee Entry detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (57, 1, 502, N'Employee Exit', N'Employee Exit detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (58, 1, 503, N'Controlled User Arm', N'Controlled User Arm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (59, 1, 504, N'Controlled User Disarm', N'Controlled User Disarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (60, 1, 701, N'Self Test Event', N'Self Test Event detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (61, 1, 0, N'Unknown', N'Unknown detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (62, 1, 22, N'Door Lock Remote Request', N'Door Lock Remote Request detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (64, 1, 23, N'External Arm', N'External Arm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (65, 1, 26, N'Wrong Medication', N'Wrong Medication detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (66, 1, 27, N'Inactivity Alarm', N'Inactivity Alarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (67, 1, 28, N'Inactivity Alarm Reset', N'Inactivity Alarm Reset detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (68, 1, 306, N'Perimetral Flash Function', N'Perimetral Flash Function detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (69, 1, 307, N'Perimetral Voice Function', N'Perimetral Voice Function detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (70, 1, 308, N'Home Automation Status', N'Home Automation Status detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (71, 1, 309, N'Door Lock Status', N'Door Lock Status detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (72, 1, 310, N'Home Automation Remote Request', N'Home Automation Remote Request detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (73, 1, 311, N'Entry In IP Listening', N'Entry In IP Listening detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (74, 1, 315, N'Device Release Information', N'Device Release Information detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (75, 1, 407, N'Comfort Video In CMS', N'Comfort Video In CMS detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (76, 1, 408, N'Last Video Detections Information', N'Last Video Detections Information detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (77, 1, 801, N'Response To User Command', N'Response To User Command detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (78, 1, 850, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (79, 1, 851, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (80, 1, 852, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (81, 1, 853, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (82, 1, 854, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (83, 1, 855, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (84, 1, 856, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (85, 1, 858, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (86, 1, 859, N'Detection Video ', N'Attached please find the video recorded during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (87, 1, 860, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (88, 1, 861, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (89, 1, 862, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (90, 1, 863, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (91, 1, 864, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (92, 1, 865, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (93, 1, 866, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (94, 1, 868, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (95, 1, 869, N'Detection Photos', N'Attached please find the photos taken during the security event of',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (96, 1, 857, N'Requested Video', N'Attached please find the video taken upon your request on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (97, 1, 867, N'Requested Photos', N'Attached please find the photos taken upon your request on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (101, 1, 150, N'Safety alarm', N'Safety alarm detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (102, 1, 151, N'Safety Alarm Reset', N'Safety Alarm Reset detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (103, 1, 152, N'Safety alarm dismiss', N'Safety alarm dismissed on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (104, 1, 156, N'Panic Alarm Cancelled', N'Panic Alarm Cancelled detected on',null)		
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (193, 1, 1, N'Intrusion alarm', N'Intrusion alarm activated on','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (194, 1, 3, N'Panic alarm', N'Panic alarm activated by {<Product Name>} user on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (195, 1, 4, N'DURESS ALARM. activated BY {<Product Name>} system user', N'DURESS ALARM. activated BY {<Product Name>} system user on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (196, 1, 8, N'Tamper alarm', N'Tamper alarm detected on','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (197, 1, 21, N'Siren was stopped successfully', N'Siren was stopped successfully on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (201, 1, 29, N'Perimeter Alarm Reset', N'Perimeter Alarm Reset detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (202, 1, 44, N'Intrusion alarm', N'Intrusion alarm dismissed on','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (219, 1, 705, N'Connection restored', N'Hub connection was restored on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (220, 1, 706, N'Connection loss', N'Hub connection was lost on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (800, 1, 1105, N'Smart Plug Turned ON', N'{<DeviceLabel>} mode changed to ON',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (801, 1, 1106, N'Smart Plug Turned OFF', N'{<DeviceLabel>} mode changed to OFF',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (803, 1, 1107, N'Appliance Connected', N'Appliance added to {<DeviceLabel>}',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (804, 1, 1108, N'Appliance Disconnected', N'Appliance removed from {<DeviceLabel>}',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (805, 1, 1104, N'Technical Alert', N'Technical Alert {<DeviceLabel>}',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (527, 1, 1010, N'Device tampered', N'Device tampered on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (528, 1, 220, N'Hub connection moved to 3G backup channel', N'',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (529, 1, 221, N'Hub connection moved back to LAN connection', N'',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (540, 1, 1256, N'Wake up Alarm', N'','notification_alarm_wake_up_clock.mp3')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (541, 1, 1257, N'{User Defined Text}', N'{User Defined Text}','notification_alarm_siren_30_sec.mp3')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[SoundFile]) VALUES (3347, 1, 153, N'OTHER ALARM. {<Product Name>} system detected intrusion', N'OTHER ALARM. {<Product Name>} system detected intrusion on', NULL)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[SoundFile]) VALUES (3349, 1, 155, N'Other Alarm Cancelled', N'Other Alarm Cancelled', NULL)

	-- SPANISH
	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (600, 2, 2, N'Restablecimiento de alarma de robo', N'Reinicio de alarma de robo detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (601, 2, 5, N'Cancelado  de Alarma de robo', N'Alarma de Robo Cancelada',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (602, 2, 6, N'Código de Guardia Ingresado', N'Código de guardia ingresado, detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (603, 2, 7, N'Código de Guardia Nuevo', N'Código Nuevo de Guardia detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (604, 2, 9, N'Sensor de Manipulación Restablecido', N'Restablecimiento de Sensor de manipulación detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (605, 2, 10, N'Desarmado Externo', N'Desarmado externo detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (606, 2, 11, N'Atasco Detectado', N'Atasco Detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (607, 2, 12, N'Atasco Restaurado', N'Atasco Restaurado detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (608, 2, 13, N'Dispositivo Ignorado', N'Dispositivo ignorado detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (609, 2, 14, N'Dispositivo habilitado', N'Dispositivo sin desvío detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (610, 2, 15, N'Código Usuario de sensor de manipulación', N'Código de Usuario de Manipulación detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (611, 2, 16, N'Inicio de Programación Local', N'Inicio de Programación Local detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (612, 2, 17, N'Inicio de programación remota', N'Inicio de programación remota detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (613, 2, 18, N'Fin de programación local', N'Fin de la programación local detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (614, 2, 19, N'Fin de programación remota', N'Fin de la programación remota detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (615, 2, 20, N'Alarma de Perímetro', N'Medicación perdida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (616, 2, 24, N'Medicación perdida', N'Medicación perdida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (617, 2, 101, N'Alarma de incendios', N'Alarma de incendio detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (618, 2, 102, N'Reinicio de Alarma de incendio ', N'Reinicio de alarma de incendio detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (619, 2, 103, N'Alarma de incendio cancelada', N'Detector de humo Cancelado detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (620, 2, 104, N'Alarma de inundación', N'Alarma de inundación detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (621, 2, 105, N'Reinicio de Alarma de Inundación', N'Alarma de inundación restablecida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (622, 2, 106, N'Alarma de inundación cancelada', N'Alarma de inundación cancelada detectada en',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (623, 2, 107, N'Alarma de Gas', N'Alarma de gas detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (624, 2, 108, N'Reinicio de Alarma de Gas', N'Reinicio de alarma de gas detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (625, 2, 109, N'Alarma de Gas cancelada', N'Alarma de Gas Cancelado detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (626, 2, 110, N'Alarma de temperatura extrema', N'Alarma de temperatura extrema detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (627, 2, 111, N'Reinicio de Alarma de temperatura extrema', N'Reinicio de Alarma de Temperatura Extrema detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (628, 2, 201, N'falla de energía', N'Falla de energía detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (629, 2, 202, N'energía restablecida', N'Energía restablecida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (630, 2, 203, N'Batería baja', N'Batería baja detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (631, 2, 204, N'Reinicio por Batería baja', N'Restaurar batería baja detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (632, 2, 205, N'batería muerta', N'Batería muerta detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (633, 2, 206, N'Reinicio por Batería muerta', N'Restaurar batería muerta detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (634, 2, 207, N'fallo de comunicación', N'Fallo de comunicación detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (635, 2, 208, N'Código Operativo Nuevo', N'Nuevo Código Operativo detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (636, 2, 209, N'Cambiar configuración en el programa', N'Cambio de configuración en el programa detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (637, 2, 210, N'falla de transmisor', N'Fallo del transmisor detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (638, 2, 211, N'Supervisión perdida', N'Supervisión Perdida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (639, 2, 212, N'Supervisión Restaurada', N'Supervisión Restaurada detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (640, 2, 301, N'Nivel de GSM', N'Nivel GSM detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (641, 2, 302, N'Estado del panel de Comunicación', N'Estado de la comunicación del Panel detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (642, 2, 303, N'Uso de Armado del Panel de Control', N'Manejo del armado del Panel de Control detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (643, 2, 304, N'Emisión de Información del Panel', N'Emisión de información del panel detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (644, 2, 305, N'Llamar CMS', N'Llamado al CMS detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (645, 2, 401, N'Video de Seguridad en el Panel', N'Video de Seguridad en el Panel detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (646, 2, 402, N'Video de Conveniencia en el Panel', N'Video de Conveniencia en el Panel detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (647, 2, 403, N'Vídeo Pre Alarma en el Panel', N'Vídeo Pre-Alarma en el Panel detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (648, 2, 404, N'Video de Seguridad en CMS', N'Video de Seguridad en CMS detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (649, 2, 405, N'Vídeo Pre Alarma en CMS', N'Vídeo Pre-Alarma en CMS detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (650, 2, 406, N'Falla en captura de video', N'Falla en captura de video detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (651, 2, 501, N'Entrada de Empleado', N'Entrada de empleados detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (652, 2, 502, N'Salida de Empleado', N'Salida de Empleados detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (653, 2, 503, N'Armado Controlado por el Usuario', N'Armado controlado por el usuario detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (654, 2, 504, N'Desarmado Controlado por el Usuario', N'Desarmado controlado por el usuario detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (655, 2, 701, N'Evento de prueba automático', N'Evento Auto-Test detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (656, 2, 0, N'desconocido', N'Desconocido detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (657, 2, 22, N'Solicitud remota de bloqueo de puerta', N'Solicitud remota de bloqueo de puerta remota detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (658, 2, 23, N'Armado Externo', N'Armado externo detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (659, 2, 26, N'Medicación erronea', N'Medicación erronea detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (660, 2, 27, N'Alarma de Inactividad', N'Alarma de inactividad detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (661, 2, 28, N'Restauración de Alarma de Inactividad', N'Alarma  de inactividad restaurada detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (662, 2, 306, N'Función Flash Perimetral', N'Función de flash perimetral detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (663, 2, 307, N'Función de Voz Perimetral', N'Función de voz Perimetral detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (664, 2, 308, N'Estado de Automatización del Hogar', N'Estado de Automatización del Hogar detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (665, 2, 309, N'Estado del cierre de puerta', N'Estado de bloqueo de la puerta detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (666, 2, 310, N'Solicitud remota de Automatización del Hogar', N'Solicitud remota de automatización del hogar detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (667, 2, 311, N'La entrada en la escucha de IP', N'Entrada en lista IP detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (668, 2, 315, N'Información sobre liberación del dispositivo', N'Información de liberación de dispositivo detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (669, 2, 407, N'Video de Conveniencia en CMS', N'Vídeo de conveniencia en CMS detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (670, 2, 408, N'Información de Detecciones de Último video', N'Información de la detección del último video detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (671, 2, 801, N'Respuesta a una orden del usuario', N'Respuesta a una orden del usuario detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (672, 2, 850, N'Detección de vídeo ', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (673, 2, 851, N'Detección de vídeo ', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (674, 2, 852, N'Detección de vídeo ', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (675, 2, 853, N'Detección de vídeo', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (676, 2, 854, N'Detección de vídeo', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (677, 2, 855, N'Detección de vídeo', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (678, 2, 856, N'Detección de vídeo', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (679, 2, 858, N'Detección de vídeo', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (680, 2, 859, N'Detección de vídeo', N'Se adjunta el vídeo grabado durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (681, 2, 860, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (682, 2, 861, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (683, 2, 862, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (684, 2, 863, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (685, 2, 864, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (686, 2, 865, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (687, 2, 866, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (688, 2, 868, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (689, 2, 869, N'Fotos de detección', N'Adjuntamos las fotos tomadas durante el evento de seguridad de',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (690, 2, 857, N'Vídeo solicitado', N'Se adjunta el video tomado a su solicitud',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (691, 2, 867, N'Fotos solicitadas', N'Adjuntamos las fotos tomadas a su solicitud',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (695, 2, 1, N'ALARMA DE ROBO. {<Product Name>} sistema detecta intrusión', N'ALARMA DE ROBO. {<Product Name>} sistema detecta intrusión en','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (696, 2, 3, N'Alarma de pánico. Activado por {<Product Name>} usuario de sistema', N'Alarma de pánico. Activado por {<Product Name>} usuario de sistema en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (697, 2, 4, N'Alarma de coacción. Activado por {<Product Name>} usuario del sistema', N'Alarma de coacción. Activado por {<Product Name>} usuario del sistema  EN',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (698, 2, 8, N'Alarma de sensor de manipulación. {<Product Name>} sistema detectó', N'Alarma de sensor de manipulación. {<Product Name>} sistema ha detectado manipulaciones','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (699, 2, 21, N'Sirena se detuvo con éxito', N'Sirena se detuvo con éxito en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (702, 2, 29, N'Perímetro de restablecimiento de alarma', N'Restauración de alarma perimetral detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (703, 2, 44, N'ALARMA DE ROBO. {<Product Name>} sistema detecta intrusión', N'ALARMA DE ROBO. {<Product Name>} sistema detecta intrusión en','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (705, 2, 150, N'Alarma de seguridad', N'Alarma de seguridad detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (706, 2, 151, N'restablecimiento de alarma de Seguridad ', N'Restablecer alarma de seguridad detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (707, 2, 152, N'Alarma de seguridad cancelada', N'Alarma de Seguridad Cancelada detectada en',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (714, 2, 156, N'Panic Alarm Cancelled', N'Panic Alarm Cancelled detected on',null)		
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (708, 2, 1105, N'Enchufe inteligente  Encendido', N'{<DeviceLabel>} el modo cambia a encendido',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (709, 2, 1106, N'Enchufe inteligente Se apaga', N'{<DeviceLabel>} el modo cambia a apagado',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (710, 2, 1107, N'Aparato conectado', N'',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (711, 2, 1108, N'Aparato desconectado', N'',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (712, 2, 1104, N'Alerta técnica', N'',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (713, 2, 1010, N'Dispositivo Manipulado', N'',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (542, 2, 1256, N'', N'','notification_alarm_wake_up_clock.mp3')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (543, 2, 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
	
	