DO $$
	BEGIN
		IF EXISTS (SELECT "Id" FROM public."Versions" WHERE "Build">=3099) THEN
			RETURN;
	END IF;

	BEGIN

		UPDATE public."MessageSettings" SET "Value" = N'<html><head></head>
<body style="padding:0;Margin:0">
	<table cellpadding="0" cellspacing="0" border="0" width="100%">
		<tbody>
			<tr>
				<td align="center" bgcolor="#F8F8F8" width="100%">
					<table cellpadding="0" cellspacing="0" width="100%" border="0">
						<tbody>
							<tr>
								<td align="center">
									<table align="center" cellpadding="0" cellspacing="0" border="0" style="max-width:900px; min-width:320px; width:90%">
										<tbody>
											<tr>
												<td align="left">
													<table align="center" cellpadding="0" cellspacing="0" border="0" width="90%">
														<tbody>
															<tr>
																<td align="left">
																	<table cellpadding="0" cellspacing="0" border="0" width="100%">
																		<tbody>
																			<tr>
																				<td height="20"></td>
																			</tr>
																		</tbody>
																	</table><img src="@eventimage" border="0" style="display:block; max-width:250px; max-height: 35px; ">
																	<table cellpadding="0" cellspacing="0" border="0" width="100%">
																		<tbody>
																			<tr>
																				<td height="20"></td>
																			</tr>
																		</tbody>
																	</table>
																</td>
															</tr>
														</tbody>
													</table>
												</td>
											</tr>
											<tr>
												<td align="left" bgcolor="#FFFFFF" style="border-radius:24px">
													<table align="center" cellpadding="0" cellspacing="0" border="0" width="90%">
														<tbody id="container">
															<tr>
																<td align="left">
																	<table cellpadding="0" cellspacing="0" border="0" width="100%">
																		<tbody>
																			<tr>
																				<td height="30"></td>
																			</tr>
																		</tbody>
																	</table>
																	<div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:22px; line-height:30px; color:#333333">
																		<strong>Подтверждение почты</strong>
																	</div>
																	<table cellpadding="0" cellspacing="0" border="0" width="100%">
																		<tbody>
																			<tr>
																				<td height="10"></td>
																			</tr>
																		</tbody>
																	</table>
																	<div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:22px; line-height:30px; color:#333333">
																		Нажмите на кнопку ниже, чтобы подтвердить адрес электронной почты.
																	</div>
																	<table cellpadding="0" cellspacing="0" border="0" width="100%">
																		<tbody>
																			<tr>
																				<td height="30"></td>
																			</tr>
																		</tbody>
																	</table>
																	<table cellpadding="0" cellspacing="0" border="0" width="200" style="width:200px">
																		<tbody>
																			<tr>
																				<td align="center" valign="middle" height="45" style="background-color:#175cd3;border-radius:7px;height:45px" bgcolor="#175CD3"><a href="@confirmUrl" style="display:block;width:100%;font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; color:#ffffff; font-size:16px; line-height:45px; text-decoration:none; white-space:nowrap; margin:0!important; padding:0;">Подтвердить</a>
																				</td>
																			</tr>
																		</tbody>
																	</table>
																	<table cellpadding="0" cellspacing="0" border="0" width="100%">
																		<tbody>
																			<tr>
																				<td height="30"></td>
																			</tr>
																		</tbody>
																	</table>
																</td>
															</tr>
														</tbody>
													</table>
												</td>
											</tr>
										</tbody>
									</table>
									<table cellpadding="0" cellspacing="0" border="0" width="100%">
										<tbody>
											<tr>
												<td height="40"></td>
											</tr>
										</tbody>
									</table>
								</td>
							</tr>
						</tbody>
					</table>
				</td>
			</tr>
		</tbody>
	</table>
</body></html>'
WHERE "Key" = 'EmailConfirm.Html|BodyHtml';

		EXCEPTION
			WHEN OTHERS THEN RAISE NOTICE 'Add contacts application error.';
		END;
	END;
$$