	
	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);
	
	
	-- SPANISH Chile
	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2600, 10, 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 (2601, 10, 5, N'Cancelado  de Alarma de robo', N'Alarma de Robo Cancelada',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2602, 10, 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 (2603, 10, 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 (2604, 10, 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 (2605, 10, 10, N'Desarmado Externo', N'Desarmado externo detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2606, 10, 11, N'Atasco Detectado', N'Atasco Detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2607, 10, 12, N'Atasco Restaurado', N'Atasco Restaurado detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2608, 10, 13, N'Dispositivo Ignorado', N'Dispositivo ignorado detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2609, 10, 14, N'Dispositivo habilitado', N'Dispositivo sin desvío detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2610, 10, 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 (2611, 10, 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 (2612, 10, 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 (2613, 10, 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 (2614, 10, 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 (2615, 10, 20, N'Alarma de Perímetro', N'Medicación perdida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2616, 10, 24, N'Medicación perdida', N'Medicación perdida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2617, 10, 101, N'Alarma de incendios', N'Alarma de incendio detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2618, 10, 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 (2619, 10, 103, N'Alarma de incendio cancelada', N'Detector de humo Cancelado detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2620, 10, 104, N'Alarma de inundación', N'Alarma de inundación detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2621, 10, 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 (2622, 10, 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 (2623, 10, 107, N'Alarma de Gas', N'Alarma de gas detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2624, 10, 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 (2625, 10, 109, N'Alarma de Gas cancelada', N'Alarma de Gas Cancelado detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2626, 10, 110, N'Alarma de temperatura extrema', N'Alarma de temperatura extrema detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2627, 10, 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 (2628, 10, 201, N'falla de energía', N'Falla de energía detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2629, 10, 202, N'energía restablecida', N'Energía restablecida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2630, 10, 203, N'Batería baja', N'Batería baja detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2631, 10, 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 (2632, 10, 205, N'batería muerta', N'Batería muerta detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2633, 10, 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 (2634, 10, 207, N'fallo de comunicación', N'Fallo de comunicación detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2635, 10, 208, N'Código Operativo Nuevo', N'Nuevo Código Operativo detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2636, 10, 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 (2637, 10, 210, N'falla de transmisor', N'Fallo del transmisor detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2638, 10, 211, N'Supervisión perdida', N'Supervisión Perdida detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2639, 10, 212, N'Supervisión Restaurada', N'Supervisión Restaurada detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2640, 10, 301, N'Nivel de GSM', N'Nivel GSM detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2641, 10, 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 (2642, 10, 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 (2643, 10, 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 (2644, 10, 305, N'Llamar CMS', N'Llamado al CMS detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2645, 10, 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 (2646, 10, 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 (2647, 10, 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 (2648, 10, 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 (2649, 10, 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 (2650, 10, 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 (2651, 10, 501, N'Entrada de Empleado', N'Entrada de empleados detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2652, 10, 502, N'Salida de Empleado', N'Salida de Empleados detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2653, 10, 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 (2654, 10, 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 (2655, 10, 701, N'Evento de prueba automático', N'Evento Auto-Test detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2656, 10, 0, N'desconocido', N'Desconocido detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2657, 10, 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 (2658, 10, 23, N'Armado Externo', N'Armado externo detectado en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2659, 10, 26, N'Medicación erronea', N'Medicación erronea detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2660, 10, 27, N'Alarma de Inactividad', N'Alarma de inactividad detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2661, 10, 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 (2662, 10, 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 (2663, 10, 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 (2664, 10, 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 (2665, 10, 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 (2666, 10, 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 (2667, 10, 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 (2668, 10, 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 (2669, 10, 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 (2670, 10, 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 (2671, 10, 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 (2672, 10, 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 (2673, 10, 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 (2674, 10, 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 (2675, 10, 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 (2676, 10, 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 (2677, 10, 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 (2678, 10, 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 (2679, 10, 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 (2680, 10, 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 (2681, 10, 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 (2682, 10, 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 (2683, 10, 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 (2684, 10, 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 (2685, 10, 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 (2686, 10, 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 (2687, 10, 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 (2688, 10, 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 (2689, 10, 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 (2690, 10, 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 (2691, 10, 867, N'Fotos solicitadas', N'Adjuntamos las fotos tomadas a su solicitud',null)
--	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2692, 10, 112, N'Alarma de inundación', N'Alarma de inundación detectada en',null)
--	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2693, 10, 113, N'Restablecimiento de alarma Inundación', N'Reinicio de alarma de inundación detectado en',null)
--	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2694, 10, 114, N'Alarma de inundación Cancelada', N'Cancelación de alarma de inundación detectada en',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2695, 10, 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 (2696, 10, 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 (2697, 10, 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 (2698, 10, 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 (2699, 10, 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 (2700, 10, 1010, N'Dispositivo manipulado', N'Dispositivo manipulado',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2701, 10, 705, N'Panel de Control conectado', N'El Panel de Control está nuevamente conectado',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2702, 10, 706, N'Panel de Control desconectado', N'Dispositivo manipulado',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2703, 10, 44, N'ALARMA DE ROBO. {<Product Name>} Sistema detectó intrusión', N'ALARMA DE ROBO. {<Product Name>} Sistema detectó intrusión','siren_10_sec.wav')
--    INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2704, 10, 37, N'{<Product Name>} Sistema Armado.', N'{<Product Name>} El sistema está armado ',null)
--    INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (2705, 10, 38, N'{<Product Name>} Sistema Desarmado.', N'{<Product Name>} El sistema está desarmado',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (550, 10, 1256, N'', N'','notification_alarm_wake_up_clock.mp3')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (551, 10, 1257, N'', N'','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)

	
	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
	
	