DO $$
DECLARE
	_path character varying(256) := 'patch-2026_02_11-EventInviteRemoveEventViewButton';
	_build integer := 16045;
BEGIN
	IF EXISTS (SELECT 1 FROM public."Versions" WHERE "Path" = _path) THEN
		RETURN;
	END IF;

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

	BEGIN
		UPDATE public."MessageSettings"
		SET
			"Value" = regexp_replace(
				"Value",
				'(?is)<tr[^>]*>\s*<td[^>]*>\s*<span[^>]*>\s*<a[^>]*@eventview[^>]*>.*?</a>\s*</span>\s*</td>\s*</tr>',
				'',
				'g'
			),
			"Timestamp" = timezone('utc'::text, now())
		WHERE "Key" = 'Email.EventInvite|BodyHtml'
		  AND "Value" ~* '@eventview';

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