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 (441, 8, 24, N'Обрыв  шлейфа устройства', N'Обрыв  шлейфа устройства',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (442, 8, 102, N'Сброс пожарной тревоги', N'Сброс пожарной тревоги',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (443, 8, 103, N'Отмена пожарной тревоги', N'Отмена пожарной тревоги',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (444, 8, 104, N'Тревога "протечка воды"', N'Тревога "протечка воды"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (445, 8, 105, N'Сброс тревоги "протечка воды"', N'Сброс тревоги "протечка воды"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (446, 8, 106, N'Отмена тревоги "протечка воды"', N'Отмена тревоги "протечка воды"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (447, 8, 107, N'Тревога "утечка газа"', N'Тревога "утечка газа"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (448, 8, 108, N'Сброс тревоги "утечка газа"', N'Сброс тревоги "утечка газа"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (449, 8, 109, N'Отмена тревоги "утечка газа"', N'Отмена тревоги "утечка газа"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (450, 8, 110, N'Тревога "повышение температуры"', N'Тревога "повышение температуры"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (451, 8, 111, N'Сброс тревоги "повышение температуры"', N'Сброс тревоги "повышение температуры"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (452, 8, 201, N'Отключение электропитания 220В', N'Отключение электропитания 220В',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (453, 8, 202, N'Восстановление электропитания 220В', N'Восстановление электропитания 220В',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (454, 8, 203, N'Понижение напряжения батареи', N'Понижение напряжения батареи',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (455, 8, 204, N'Восстановление напряжения батареи', N'Восстановление напряжения батареи',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (456, 8, 205, N'Батарея разряжена', N'Батарея разряжена',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (457, 8, 206, N'Восстановление батареи', N'Восстановление батареи',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (458, 8, 207, N'Ошибка связи', N'Ошибка связи',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (459, 8, 208, N'Новый оперативный код', N'Новый оперативный код',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (460, 8, 209, N'Конфигурация программы изменена', N'Конфигурация программы изменена',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (461, 8, 210, N'Неисправность передатчика', N'Неисправность передатчика',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (462, 8, 211, N'Потеря связи с датчиком', N'Потеря связи с датчиком',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (463, 8, 212, N'Восстановление связи с датчиком', N'Восстановление связи с датчиком',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (464, 8, 301, N'Уровень GSM', N'Уровень GSM',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (465, 8, 302, N'Коммуникационный статус панели', N'Коммуникационный статус панели',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (466, 8, 303, N'Статус панели', N'Статус панели',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (467, 8, 304, N'Версия  панели', N'Версия  панели',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (468, 8, 305, N'Позвоните оператору ЦСМ', N'Позвоните оператору ЦСМ',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (469, 8, 401, N'Видео "взлом" в панели', N'Видео "взлом" в панели',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (470, 8, 402, N'Видео "комфорт" в панели', N'Видео "комфорт" в панели',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (471, 8, 403, N'Видео "периметр" в панели', N'Видео "периметр" в панели',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (472, 8, 404, N'Видео "взлом" передано на ЦСМ', N'Видео "взлом" передано на ЦСМ',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (473, 8, 405, N'Видео "периметр" передано на ЦСМ', N'Видео "периметр" передано на ЦСМ',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (474, 8, 406, N'Сбой видеосъемки', N'Сбой видеосъемки',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (475, 8, 501, N'Снято с охраны персоналом', N'Снято с охраны персоналом',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (476, 8, 502, N'Поставлено под охрану персоналом', N'Поставлено под охрану персоналом',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (477, 8, 503, N'Поставлено под охрану клиентом', N'Поставлено под охрану клиентом',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (478, 8, 504, N'Снято с охраны клиентом', N'Снято с охраны клиентом',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (479, 8, 701, N'Автотест', N'Автотест',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (480, 8, 0, N'Неизвестно', N'Неизвестно',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (481, 8, 22, N'Удаленная команда на дверной замок', N'Удаленная команда на дверной замок',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (482, 8, 23, N'Удаленная команда на постановку под охрану', N'Удаленная команда на постановку под охрану',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (483, 8, 26, N'Wrong Medication', N'Wrong Medication detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (484, 8, 27, N'Тревога "нет движения"', N'Тревога "нет движения"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (485, 8, 28, N'Сброс тревоги "нет движения"', N'Сброс тревоги "нет движения"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (486, 8, 306, N'Perimetral Flash Function', N'Perimetral Flash Function detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (487, 8, 307, N'Perimetral Voice Function', N'Perimetral Voice Function detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (488, 8, 308, N'Статус системы домашней автоматики', N'Статус системы домашней автоматики',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (489, 8, 309, N'Статус дверного замка', N'Статус дверного замка',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (490, 8, 310, N'Удаленная команда на систему домашней атоматики', N'Удаленная команда на систему домашней атоматики',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (491, 8, 311, N'Подключение к панели по IP', N'Подключение к панели по IP',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (492, 8, 315, N'Версия устройства', N'Версия устройства',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (493, 8, 407, N'Видео "комфорт" передано на ЦСМ', N'Видео "комфорт" передано на ЦСМ',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (494, 8, 408, N'Последняя информация о срабатывании видео детекторов', N'Последняя информация о срабатывании видео детекторов',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (495, 8, 801, N'Принята удаленная команда пользователя', N'Принята удаленная команда пользователя',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (496, 8, 850, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (497, 8, 851, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (498, 8, 852, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (499, 8, 853, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (500, 8, 854, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (501, 8, 855, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (502, 8, 856, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (503, 8, 858, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (504, 8, 859, N'Видео по тревоге ', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (505, 8, 860, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (506, 8, 861, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (507, 8, 862, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (508, 8, 863, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (509, 8, 864, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (510, 8, 865, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (511, 8, 866, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (512, 8, 868, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (513, 8, 869, N'Фото по тревоге', N'Направляем в приложении видео, снятое по тревоге',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (514, 8, 857, N'Видео по запросу', N'Направляем в приложении видео, снятое по запросу',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (515, 8, 867, N'Фото по запросу', N'Направляем в приложении фото, снятые по запросу',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (516, 8, 1, N'Тревога. Система {<Product Name>}   обнаружила "Взлом"', N'Тревога. Система {<Product Name>}   обнаружила "Взлом"','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (517, 8, 3, N'Тревога КТС. Пользователь системы {<Product Name>}   нажал тревожную кнопку', N'Тревога КТС. Пользователь системы {<Product Name>}   нажал тревожную кнопку',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (518, 8, 4, N'Тревога. Пользователь системы {<Product Name>}   произвел снятие с охраны по принуждению.', N'Тревога. Пользователь системы {<Product Name>}   произвел снятие с охраны по принуждению.',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (519, 8, 8, N'Тревога. Система {<Product Name>}   обнаружила "Взлом".', N'Тревога. Система {<Product Name>}   обнаружила "Взлом".','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (520, 8, 21, N'Сирена выключена', N'Сирена выключена',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (523, 8, 101, N'Пожарная тревога. Система {<Product Name>}   обнаружила задымление.', N'Пожарная тревога. Система {<Product Name>}   обнаружила задымление.',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (524, 8, 29, N'Сигнал "Проникновение" с уличного датчика отменен', N'Сигнал "Проникновение" с уличного датчика отменен',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (525, 8, 44, N'Сигнал "Проникновение"', N'Система {<Product Name>} обнаружила сигнал "Проникновение"','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (530, 8, 706, N'Система не на связи', N'Система {<Product Name>} не на связи',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (531, 8, 705, N'Связь с сервером восстановлена', N'Связь с сервером восстановлена',null)	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (425, 8, 2, N'Сброс тревоги "взлом"', N'Сброс   тревоги "взлом"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (426, 8, 5, N'Отмена тревоги "взлом"', N'Отмена тревоги "взлом"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (427, 8, 6, N'Введен код  снятия ЧОП', N'Введен код  снятия ЧОП',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (428, 8, 7, N'Создан новый код снятия ЧОП', N'Создан новый код снятия ЧОП',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (429, 8, 9, N'Восстановление тампера', N'Восстановление тампера',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (430, 8, 10, N'Удаленное снятие с охраны', N'Удаленное снятие с охраны',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (431, 8, 11, N'Обнаружена радио помеха', N'Обнаружена радио помеха',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (432, 8, 12, N'Радио помеха  не детектируется', N'Радио помеха  не детектируется',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (433, 8, 13, N'Включен обход  датчика', N'Включен обход  датчика',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (434, 8, 14, N'Выключен обход датчика', N'Выключен обход датчика',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (435, 8, 15, N'Блокирован код пользователя', N'Блокирован код пользователя',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (436, 8, 16, N'Начало локального  программирования', N'Начало локального  программирования',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (437, 8, 17, N'Начало удаленного  программирования', N'Начало удаленного  программирования',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (438, 8, 18, N'Завершение локального  программирования', N'Завершение локального  программирования',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (439, 8, 19, N'Завершение удаленного  программирования', N'Завершение удаленного  программирования',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (440, 8, 20, N'Тревога периметра', N'Тревога периметра',null)
	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (546, 8, 1256, N'', N'','notification_alarm_wake_up_clock.mp3')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (547, 8, 1257, N'', N'','notification_alarm_siren_30_sec.mp3')
	
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (552, 8, 1010, N'Открыт тампер устройства', N'Система {<Product Name>} обнаружила открытие тампера устройства',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (553, 8, 1105, N'Розетка Z-wave {<DeviceLabel>} ВКЛ.', N'Розетка Z-wave {<DeviceLabel>} ВКЛ.',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (554, 8, 1106, N'Розетка Z-wave {<DeviceLabel>} ВЫКЛ.', N'Розетка Z-wave {<DeviceLabel>} ВЫКЛ.',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (555, 8, 1107, N'Добавлена связь с устройством {<DeviceLabel>}', N'Добавлена связь с устройством {<DeviceLabel>}',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (556, 8, 1108, N'Удалена связь с устройством  {<DeviceLabel>}', N'Удалена связь с устройством  {<DeviceLabel>}',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (557, 8, 1104, N'Неисправность устройства {<DeviceLabel>}', N'Система {<Product Name>} обнаружила неисправность устройства {<DeviceLabel>}',null)
	--shay:TODO
	--INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (558, 38, 1104, N'Система {<Product Name>}: Режим "Охрана" отключен', N'Система {<Product Name>}: Режим "Охрана" отключен',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (561, 8, 40, N'Отключен режим "Охрана"', N'Отключен режим "Охрана"',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (562, 8, 39, N'Включен режим "Охрана"', N'Включен режим "Охрана"',null)

	--DUTCH
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1500, 9, 2, N'Reset inbraakalarm', N'Reset inbraakalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1501, 9, 5, N'Inbraakalarm geannuleerd', N'Inbraakalarm geannuleerd',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1502, 9, 6, N'Bewakingscode ingevoerd', N'Invoeren bewakingscode gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1503, 9, 7, N'Nieuwe bewakingscode', N'Nieuwe bewakingscode gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1504, 9, 9, N'Reset sabotage', N'Reset sabotage gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1505, 9, 10, N'Externe uitschakeling', N'Externe uitschakeling gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1506, 9, 11, N'Interferentie gedetecteerd', N'Interferentie gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1507, 9, 12, N'Interferentie hersteld', N'Herstel interferentie gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1508, 9, 13, N'Apparaat omzeild', N'Apparaat omzeild gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1509, 9, 14, N'Apparaat niet omzeild', N'Apparaat niet omzeild gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1510, 9, 15, N'Sabotage Gebruikerscode', N'Apparaat {<DeviceLabel>} Geblokkeerd -Ongeldige gebruikerscode gebruikt. Gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1511, 9, 16, N'Begin lokaal programmeren', N'Begin lokaal programmeren gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1512, 9, 17, N'Begin remote programmeren', N'Begin remote programmeren gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1513, 9, 18, N'Einde lokaal programmeren', N'Einde lokaal programmeren gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1514, 9, 19, N'Einde remote programmeren', N'Einde remote programmeren gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1515, 9, 20, N'Perimeter-alarm', N'Perimeter-alarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1516, 9, 24, N'Medicatie vergeten', N'Medicatie vergeten gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1517, 9, 101, N'Brandalarm', N'Brandalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1518, 9, 102, N'Brandalarm reset', N'Reset brandalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1519, 9, 103, N'Brandalarm geannuleerd', N'Annuleren brandalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1520, 9, 104, N'Wateroverloopalarm', N'Wateroverloopalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1521, 9, 105, N'Reset Wateroverloopalarm', N'Wateroverloopalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1522, 9, 106, N'Wateroverloopalarm geannuleerd', N'Annuleren Wateroverloopalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1523, 9, 107, N'Gasalarm gedetecteerd', N'Gasalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1524, 9, 108, N'Reset gasalarm', N'Reset gasalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1525, 9, 109, N'Gasalarm geannuleerd', N'Annuleren gasalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1526, 9, 110, N'Alarm extreme temperatuur', N'Alarm extreme temperatuur gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1527, 9, 111, N'Reset alarm extreme temperatuur', N'Reset alarm extreme temperatuur gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1528, 9, 201, N'Stroomonderbreking', N'Stroomonderbreking gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1529, 9, 202, N'Stroomtoevoer hersteld', N'Stroomtoevoer hersteld gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1530, 9, 203, N'Batterij bijna leeg', N'Batterij bijna leeg gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1531, 9, 204, N'Reset Batterij bijna leeg', N'Reset Batterij bijna leeg gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1532, 9, 205, N'Batterij leeg', N'Batterij leeg gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1533, 9, 206, N'Reset Batterij leeg', N'Reset Batterij leeg ontdekt op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1534, 9, 207, N'Communicatiefout', N'Communicatiefout gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1535, 9, 208, N'Nieuwe Werkingscode', N'Nieuwe werkingscode gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1536, 9, 209, N'Verandering Configuratie in programma', N'Verandering Configuratie in programma gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1537, 9, 210, N'Transmitterfout', N'Transmitterfout gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1538, 9, 211, N'Supervisie verbroken', N'Supervisie verbroken gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1539, 9, 212, N'Supervisie hersteld', N'Supervisie hersteld gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1540, 9, 301, N'GSM-niveau', N'GSM-niveau gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1541, 9, 302, N'Communicatiestatus basisstation', N'Communicatiestatus basisstation gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1542, 9, 303, N'Activatiegebruik basisstation', N'Activatiegebruik basisstation gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1543, 9, 304, N'Panel Release Information', N'Panel Release Information detected on',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1544, 9, 305, N'Oproep CMS', N'Oproep CMS gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1545, 9, 401, N'Alarmvideo op basisstation', N'Alarmvideo op basisstation gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1546, 9, 402, N'Video camera-portal op basisstation', N'Video camera-portal op basisstation gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1547, 9, 403, N'Pre-alarmvideo op basisstation', N'Pre-alarmvideo op basisstation gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1548, 9, 404, N'Alarmvideo in CMS', N'Alarmvideo in CMS gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1549, 9, 405, N'Pre-alarmvideo in CMS', N'Pre-alarmvideo in CMS gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1550, 9, 406, N'Video-opnamefout ', N'Video-opnamefout gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1551, 9, 501, N'Binnenkomst werknemer', N'Binnenkomst werknemer gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1552, 9, 502, N'Vertrek werknemer', N'Vertrek werknemer gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1553, 9, 503, N'Gecontroleerde activering door gebruiker', N'Gecontroleerde activering door gebruiker gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1554, 9, 504, N'Gecontroleerde uitschakeling door gebruiker', N'Gecontroleerder uitschakeling door gebruiker gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1555, 9, 701, N'Zelftest', N'Zelftest gedetecteerd',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1556, 9, 0, N'Onbekend', N'Onbekend gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1557, 9, 22, N'Verzoek deurslot op afstand', N'Verzoek deurslot op afstand gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1558, 9, 23, N'Externe inschakeling', N'Externe inschakeling gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1559, 9, 26, N'Verkeerde medicatie', N'Verkeerde medicatie gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1560, 9, 27, N'Inactiviteit alarm', N'Inactiviteit Alarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1561, 9, 28, N'Reset inactiviteit alarm', N'Reset inactiviteit alarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1562, 9, 306, N'Perimetrale flash-functie', N'Perimetrale flash-functie gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1563, 9, 307, N'Perimetrale stemfunctie', N'Perimetrale stemfunctie gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1564, 9, 308, N'Home automation-Status', N'Home-automationstatus gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1565, 9, 309, N'Status Deurslot', N'Status deurslot gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1566, 9, 310, N'Remote verzoek Home Automation', N'Remote verzoek Home Automation gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1567, 9, 311, N'Invoer in IP-luisterlijst', N'Invoer in IP-luisterlijst gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1568, 9, 315, N'Release-informatie apparaat', N'Release-informatie apparaat gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1569, 9, 407, N'Video camera-portal In CMS', N'Video camera-portal In CMS gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1570, 9, 408, N'Informatie over detecties laatste video', N'Informatie over detecties laatste video gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1571, 9, 801, N'Respons op gebruikerscommando', N'Respons op gebruikerscommando gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1572, 9, 850, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1573, 9, 851, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1574, 9, 852, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1575, 9, 853, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1576, 9, 854, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1577, 9, 855, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1578, 9, 856, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1579, 9, 858, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1580, 9, 859, N'Detectie video', N'Als bijlage de video-opname tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1581, 9, 860, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1582, 9, 861, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1583, 9, 862, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1584, 9, 863, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1585, 9, 864, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1586, 9, 865, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1587, 9, 866, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1588, 9, 868, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1589, 9, 869, N'Detectie foto´s', N'Als bijlage de foto´s tijdens alarm-event van',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1590, 9, 857, N'Opgevraagde video', N'Als bijlage de video die tijdens die op uw verzoek genomen zijn op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1591, 9, 867, N'Opgevraagde foto´s', N'Als bijlage de foto´s die tijdens die op uw verzoek genomen zijn op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1595, 9, 1, N'INBRAAKALARM. Systeem {<Product Name>} heeft indringing gedetecteerd', N'INBRAAKALARM. Systeem {<Product Name>}  heeft indringing gedetecteerd op','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1596, 9, 3, N'PANIEKALARM. Geactiveerd door systeemgebruiker {<Product Name>} ', N'PANIEKALARM. Geactiveerd door systeemgebruiker {<Product Name>} op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1597, 9, 4, N'GEDWONGEN ALARM. Geactiveerd DOOR systeemgebruiker {<Product Name>} ', N'GEDWONGEN ALARM. Geactiveerd DOOR systeemgebruiker {<Product Name>}  op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1598, 9, 8, N'ALARM GESABOTEERD.Systeem {<Product Name>} heeft sabotage gedetecteerd', N'ALARM GESABOTEERD.Systeem {<Product Name>} heeft sabotage gedetecteerd op','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1599, 9, 21, N'Sirene succesvol uitgeschakeld', N'Sirene succesvol uitgeschakeld op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1602, 9, 29, N'Reset Perimeter-alarm', N'Reset Perimeter-alarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1603, 9, 44, N'INBRAAKALARM.Systeem {<Product Name>} heeft indringing gedetecteerd', N'INBRAAKALARM.Systeem {<Product Name>} heeft indringing gedetecteerd op','siren_10_sec.wav')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1605, 9, 150, N'Veiligheidsalarm', N'Veiligheidsalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1606, 9, 151, N'Reset Veiligheidsalarm', N'Reset Veiligheidsalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1607, 9, 152, N'Veiligheidsalarm geannuleerd', N'Annulering veiligheidsalarm gedetecteerd op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (222, 9, 156, N'Panic Alarm Cancelled', N'Panic Alarm Cancelled detected on',null)		
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1613, 9, 1010, N'Apparaat gesaboteerd', N'Apparaat gesaboteerd',null)		
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1614, 9, 705, N'Basisstation online', N'Basisstation weer online op',null)
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (1615, 9, 706, N'Basisstation offline', N'Basisstation offline op',null)

	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (548, 9, 1256, N'', N'','notification_alarm_wake_up_clock.mp3')
	INSERT @CD_NotificationMessages ([NotificationMessageId], [LanguageCode], [EventCode], [NotificationMessage], [EmailBodyMessage],[soundfile]) VALUES (549, 9, 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