DO $$ 
	DECLARE _path character varying(256) = 'patch-2025-02-12-Email_Templates_En';

	BEGIN
		IF EXISTS (SELECT "Id" FROM public."Versions" WHERE "Path"=_path) THEN
			RETURN;
		END IF;

		IF EXISTS (SELECT "Id" FROM public."Versions" WHERE "Build">=14592) THEN
			RETURN;
		END IF;

		BEGIN
			INSERT INTO public."MessageSettings"
			("Key","Value", "Lang")
			SELECT
			'Notification.ShareProject.Subject', 
			'You have been granted access','en'
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";
			
			INSERT INTO public."MessageSettings"
			("Key","Value", "Lang")
			SELECT
			'Notification.ShareProject.Html', 
			'<!DOCTYPE html
				PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
			<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="{{logo}}" 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>
																		<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>You have been granted access</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:16px; line-height:24px; color:#333333"
																					class="esd-text">The user <strong>{{name}}</strong> has granted 
																					you {{rigths}} to the project:
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></td>
																						</tr>
																					</tbody>
																				</table>
																				<div
																					style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333"
																					class="esd-text"><strong><a href="{{url}}">{{entityname}}</a></strong></div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="10"></td>
																						</tr>
																					</tbody>
																				</table>
																			</td>
																		</tr>
																		<tr>
																			<td align="left">
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></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="{{url}}"
																									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;">Open</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>','en'
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";
			
			
			
			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAddComment.Subject',' A new comment has been added to the task {{name}} ','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";

			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAddComment.Html','<!DOCTYPE html
				PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
			<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="{{logo}}" 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>
																		<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>A new comment has been added
			</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:16px; line-height:24px; color:#333333" class="esd-text">The user <strong>{{username}}</strong> has added a new comment to the task:  
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></td>
																						</tr>
																					</tbody>
																				</table>
																				<div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333" class="esd-text"><strong><a href="{{url}}" target="_blank">{{name}}</a></strong></div><br>
																				 <div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333" class="esd-text"><strong>{{value}}</strong>
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="10"></td>
																						</tr>
																					</tbody>
																				</table>
																			</td>
																		</tr>
																		<tr>
																			<td align="left">
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></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 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;" href="{{url}}" target="_blank">Open</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>','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";
			
			
			
			
			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAssignTask.Subject','A {{username}} assigned you a task','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";

			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAssignTask.Html','<!DOCTYPE html
				PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
			<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="{{logo}}" 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>
																		<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>A user assigned you a task</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:16px; line-height:24px; color:#333333" class="esd-text">The user <strong>{{username}}</strong> has assigned you a task. To review the task details, follow the link below: 
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></td>
																						</tr>
																					</tbody>
																				</table>
																				<div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333" class="esd-text"><strong><a href="{{url}}" target="_blank">{{name}}</a></strong></div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="10"></td>
																						</tr>
																					</tbody>
																				</table>
																			</td>
																		</tr>
																		<tr>
																			<td align="left">
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></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 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;" href="{{url}}" target="_blank">Open</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>','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";
			
			
			
			
			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedStatus.Subject','The status of the task {{name}} has been updated','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";

			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedStatus.Html','<!DOCTYPE html
				PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
			<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="{{logo}}" 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>
																		<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>The task status has been updated
			</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:16px; line-height:24px; color:#333333" class="esd-text">The user <strong>{{username}}</strong> has updated the status of the task:  
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></td>
																						</tr>
																					</tbody>
																				</table>
																				<div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333" class="esd-text"><strong><a href="{{url}}" target="_blank">{{name}}</a></strong></div><br>
																				 <div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333" class="esd-text"><strong>{{value}}</strong>
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="10"></td>
																						</tr>
																					</tbody>
																				</table>
																			</td>
																		</tr>
																		<tr>
																			<td align="left">
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></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 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;" href="{{url}}" target="_blank">Open</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>','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";
			
			
			
			
			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedTask.Subject','The task {{name}} has been updated','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";

			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedTask.Html','<!DOCTYPE html
				PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
			<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="{{logo}}" 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>
																		<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>The task has been updated</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:16px; line-height:24px; color:#333333" class="esd-text">The user <strong>{{username}}</strong> has updated the task. To review the details of the task, follow the link below: 
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></td>
																						</tr>
																					</tbody>
																				</table>
																				<div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333" class="esd-text"><strong><a href="{{url}}" target="_blank">{{name}}</a></strong></div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="10"></td>
																						</tr>
																					</tbody>
																				</table>
																			</td>
																		</tr>
																		<tr>
																			<td align="left">
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></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 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;" href="{{url}}" target="_blank">Open</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>','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";
			
			
			
			
			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAddNewTask.Subject','New task added {{name}}','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";

			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAddNewTask.Html','<!DOCTYPE html
				PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
			<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="{{logo}}" 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>
																		<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>New task added
			</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:16px; line-height:24px; color:#333333" class="esd-text">The user <strong>{{username}}</strong> added a new task:  
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></td>
																						</tr>
																					</tbody>
																				</table>
																				<div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333" class="esd-text"><strong><a href="{{url}}" target="_blank">{{name}}</a></strong></div><br>
																				 <div style="font-family:-apple-system,''Segoe UI'',''Helvetica Neue'',Helvetica,Roboto,Arial,sans-serif; font-size:16px; line-height:24px; color:#333333" class="esd-text"><strong>{{value}}</strong>
																				</div>
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="10"></td>
																						</tr>
																					</tbody>
																				</table>
																			</td>
																		</tr>
																		<tr>
																			<td align="left">
																				<table cellpadding="0" cellspacing="0" border="0" width="100%">
																					<tbody>
																						<tr>
																							<td height="20"></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 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;" href="{{url}}" target="_blank">Open</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>','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";
			
			
			
			
			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES('ResetPassword.Html|Subject' ,N'Recover the password','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";

			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES('ResetPassword.Html|BodyHtml' ,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>Recover the password</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:16px; line-height:30px; color:#333333">
																					Click on the button below to recover the password.
																				</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="@passwordUrl" 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;">Recover the password</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>','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";
			
			
			
			
			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES('EmailConfirm.Html|Subject' ,N'Email confirmation','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";

			INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES('EmailConfirm.Html|BodyHtml' ,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>Email confirmation</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">
																					Click on the button below to confirm the email address..
																				</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;">Confirm</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>','en')
			ON CONFLICT ("Key") DO UPDATE SET "Value"= EXCLUDED."Value","Lang"= EXCLUDED."Lang";

			INSERT INTO public."Versions" ("Path", "Build") VALUES (_path, 0);
           EXCEPTION
			WHEN OTHERS THEN RAISE NOTICE '[ERR] patch-2025-02-12-Email_Templates_En: %', SQLERRM;
		END;
	END;
$$