
update pal_Template
set templateContent = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Email Template</title>
        <style type="text/css">
            <!--
        body, td, th {
            font-family: Trebuchet MS, Arial, Helvetica, sans-serif;
            font-size: 12px;
            color: #666;
        }

        body {
            background-color: #CCC;
        }

        a:link {
            text-decoration: none;
        }

        a:visited {
            text-decoration: none;
        }

        a:hover {
            text-decoration: underline;
        }

        a:active {
            text-decoration: none;
        }

        h1 {
            font-size: 14px;
            color: #F60;
        }
        -->
        </style>
    </head>
    <body link="#BA4C14" alink="#BA4C14" class="RadEditorContentStyle">
        <table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
            <tbody>
                <tr>
                    <td style="background-color: #ffffff;">
                    <table width="100%" border="0" cellspacing="0" cellpadding="8">
                        <tbody>
                            <tr>
                                <td style="background-color: #e7e7e7;">
                                <img alt="" src="/images/logo.png" /></td>
                            </tr>
                            <tr>
                                <td>
                                Hi {name},<br />
                                <br />
                                </td>
                            </tr>
                            <tr>
                                <td>Please see the collaboration log post details below.<br />
                                <br />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                Subject: {Subject Name}<br />
                                Posted By: {User Name}<br />
                                Date Posted: {Date}<br />
                                Log Post:<br />
                                {LogPost}<br />
                                <br />
                                </td>
                            </tr>
                            <tr>
                                <td>Click <a href="{SubjectWebAddress}">here</a> to view this subject.<br />
                                <br />
                                </td>
                            </tr>
                            <tr>
                                <td>...........................................................................................................................................................................</td>
                            </tr>
                            <tr>
                                <td>Kind Regards,<br />
                                IEB Team</td>
                            </tr>
                        </tbody>
                    </table>
                    </td>
                </tr>
            </tbody>
        </table>
    </body>
</html>'
where templateName = 'Examination Moderation Log';

update pal_Template
set templateContent = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Email Template</title>
        <style type="text/css">
            <!--
        body, td, th {
            font-family: Trebuchet MS, Arial, Helvetica, sans-serif;
            font-size: 12px;
            color: #666;
        }

        body {
            background-color: #CCC;
        }

        a:link {
            text-decoration: none;
        }

        a:visited {
            text-decoration: none;
        }

        a:hover {
            text-decoration: underline;
        }

        a:active {
            text-decoration: none;
        }

        h1 {
            font-size: 14px;
            color: #F60;
        }
        -->
        </style>
    </head>
    <body link="#BA4C14" alink="#BA4C14" class="RadEditorContentStyle">
        <table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
            <tbody>
                <tr>
                    <td style="background-color: #ffffff;">
                    <table width="100%" border="0" cellspacing="0" cellpadding="8">
                        <tbody>
                            <tr>
                                <td style="background-color: #e7e7e7;">
                                <img alt="" src="/images/logo.png" /></td>
                            </tr>
                            <tr>
                                <td><strong>Examination Moderation Status</strong><br />
                                <br />
                                Hi {name},</td>
                            </tr>
                            <tr>
                                <td>Please see below the change in details.<br />
                                <br />
                                </td>
                            </tr>
                            <tr>
                                <td>{StatusBlock}<br />
                                <br />
                                </td>
                            </tr>
                            <tr>
                                <td>Click <a href="{SubjectWebAddress}">here</a> to view this subject.<br />
                                <br />
                                </td>
                            </tr>
                            <tr>
                                <td>...........................................................................................................................................................................</td>
                            </tr>
                            <tr>
                                <td>Kind Regards,<br />
                                IEB Team</td>
                            </tr>
                        </tbody>
                    </table>
                    </td>
                </tr>
            </tbody>
        </table>
    </body>
</html>'
where templateName = 'Examination Moderation Status';