DO $$


BEGIN
 

INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAddComment.Subject','К задаче {{name}} добавлен комментарий ','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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>Был добавлен новый комментарий
</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">Пользователь <strong>{{username}}</strong> добавил новый комментарий к задаче:  
                                                                    </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">Открыть</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>','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";




INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAssignTask.Subject','Пользователь  {{username}} назначил вам задачу','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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>Пользователь назначил вам задачу</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">Пользователь <strong>{{username}}</strong> назначил вам задачу. Для ознакомления с подробностями задачи перейдите по следующей ссылке: 
                                                                    </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">Открыть</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>','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";


INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAssignTask.Subject','A {{username}} assigned you a task','en')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";




INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedStatus.Subject','У задачи {{name}} изменен статус','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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>Статус задачи был изменен
</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">Пользователь <strong>{{username}}</strong> изменил статус задачи:  
                                                                    </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">Открыть</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>','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";


INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedStatus.Subject','The status of the task {{name}} has been updated','en')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";




INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedTask.Subject','Задача была изменена {{name}}','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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>Задача была изменена</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">Пользователь <strong>{{username}}</strong> изменил задачу. Для ознакомления с подробностями задачи перейдите по следующей ссылке: 
                                                                    </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">Открыть</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>','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedTask.Subject','The task {{name}} has been updated','en')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";




INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAddNewTask.Subject','Добавлена новая задача {{name}}','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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>Была добавлена новая задача
</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">Пользователь <strong>{{username}}</strong> добавил новую задачу:  
                                                                    </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">Открыть</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>','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectAddNewTask.Subject','New task added {{name}}','en')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

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","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";




INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedComment.Subject','В задаче {{name}} изменен комментарий ','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedComment.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>Был изменен комментарий
</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">Пользователь <strong>{{username}}</strong> изменил комментарий к задаче:  
                                                                    </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">Открыть</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>','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";


INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedComment.Subject','The comment was changed in the task {{name}} ','en')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectChangedComment.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 comment was changed 
</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> changed 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","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";


INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectUploadAttachment.Subject','A new attachment {{attachment}} has been added to the tasks: {{name}}','en')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectUploadAttachment.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 comment was changed 
</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 been added to the tasks:  
                                                                    </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","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";


INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectUploadAttachment.Subject','Добавлено новое вложение в задачу {{name}}','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";

INSERT INTO public."MessageSettings"("Key",  "Value", "Lang") VALUES ('Notification.ProjectUploadAttachment.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>В задаче {{name}} добавлено новое вложение: {{attachment}}
</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"<strong>Автор: {{username}}</strong>
                                                                    </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>Дата: {{date}}</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><br> Вы можете просмотреть вложение в задаче по ссылке: 
                                                                    </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>','')
ON CONFLICT ("Key","Lang") DO UPDATE SET "Value"= EXCLUDED."Value";


END $$
