if((select count(*) from dbo.pal_TemplateType where templateType = 'Prints') = 0)
begin
INSERT INTO [dbo].[pal_TemplateType]
           ([templateType]
           ,[isActive]
           ,[sequence])
     VALUES
           ('Prints'
           ,1
           ,12);
end;

if((select count(*) from dbo.pal_Template where templateName = 'ShoppingListSelectionsHeader') = 0)
begin

INSERT INTO [dbo].[pal_Template]
           ([templateTypeId]
           ,[templateName]
           ,[templateContent])
     VALUES
           (12
           ,'ShoppingListSelectionsHeader'
           ,'<style type="text/css">
   td {
   font-family: Calibri;
   color: #595959;
   }
   .heading {
   font-size: 22pt;
   font-family: Calibri;
   color: #595959;
   }
   .full {
   width: 95%;
   }
   .forty{
   width:40%;
   }
   .spacer {
   height: 20px;
   }
   div {
   position: relative;
   float: left;
   }
   
</style>
<table class="full" cellpadding="0" cellspacing="0" border="0">
   <tbody>
      <tr>
         <td class="heading">{logo}</td>
         <td class="forty"><span class="heading">{FileName}</span>
            <br /><br/>
         </td>
      </tr>
   </tbody>
</table>
<table>
   <tbody>
      <tr>
         <td class="spacer"></td>
      </tr>
   </tbody>
</table>
');
end;

if((select count(*) from dbo.pal_Template where templateName = 'ShoppingListSelectionsBody') = 0)
begin

INSERT INTO [dbo].[pal_Template]
           ([templateTypeId]
           ,[templateName]
           ,[templateContent])
     VALUES
           (12
           ,'ShoppingListSelectionsBody'
           ,'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
   <head>
      <title>PurchaseOrder</title>
      <style type="text/css">
         td, a
         {
         font-family: Calibri;
         font-size: 11px;
         text-decoration: none;
         color: #595959;
         }
         .heading
         {
         font-size: 18px;
         font-weight: bold;
         }
         .title
         {
         font-size: 11px;
         }
         .titleAccount
         {
         font-size: 12px;
         }
         .titleDue
         {
         font-size: 16px;
         font-weight: bold;
         text-transform: uppercase;
         }
         .footer {
         position: absolute;
         bottom: 0;
         width: 100%;
         height: 50px;
         }
         .heading {
         font-size: 22pt;
         font-family: Calibri;
         color: #595959;
         }
         .mainInfo{
         font-size: 10pt;
         color: #595959;
         font-family: Calibri;
         font-weight: bold;
         }
         .subInfo{
         font-size: 9pt;
         color: #595959;
         font-family: Calibri;
         }
         .subheading{
         font-size: 14pt;
         color: #595959;
         font-family: Calibri;
         font-weight: bold;
         }
         .full {
         width: 95%;
         }
         .forty{
         width:40%;
         }
         .thirty{
         width:30%;
         }
         .twenty{
         width:20%;
         }
      </style>
   </head>
   <body class="RadEditorContentStyle">
      {ProductLines}
      <br/><br/><br/>
   </body>
</html>');
end