Declare @CampaignTemplateCount as int
SET @CampaignTemplateCount = (Select Count(*) FROM pal_Template WHERE [templateTypeId] = 3)

IF @CampaignTemplateCount = 0
BEGIN

INSERT [dbo].[pal_Template] ([templateTypeId], [templateName], [templateContent]) VALUES (3, N'Personalised Campaign', N'<!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>Dear {name}</strong><br />
                                <br />
                                Content to be placed here
                                </td>
                            </tr>
                            <tr>
                                <td>
                                <p>Thank You,<br />
                                Palette </p>
                                </td>
                            </tr>
                            <tr>
                                <td>...........................................................................................................................................................................</td>
                            </tr>
                            <tr>
                                <td>To unsubscribe | <a href="{WebAddress}/unsubscribe-me">click here</a></td>
                            </tr>
                        </tbody>
                    </table>
                    </td>
                </tr>
            </tbody>
        </table>
    </body>
</html>')

INSERT [dbo].[pal_Template] ([templateTypeId], [templateName], [templateContent]) VALUES (3, N'Non-Personalised Campaign', N'<!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>Heading</strong><br />
                                <br />
                                Content to be placed here
                                </td>
                            </tr>
                            <tr>
                                <td>
                                <p>Thank You,<br />
                                Palette </p>
                                </td>
                            </tr>
                            <tr>
                                <td>...........................................................................................................................................................................</td>
                            </tr>
                            <tr>
                                <td>To unsubscribe | <a href="{WebAddress}/unsubscribe-me">click here</a></td>
                            </tr>
                        </tbody>
                    </table>
                    </td>
                </tr>
            </tbody>
        </table>
    </body>
</html>')

END