-- 2013-04-24
DELETE FROM `apw_Settings` WHERE NAME LIKE 'transactionStatusChangedUserEmail%';

-- 2013-04-26
UPDATE `apw_Settings`
SET `value` = '<p>Order <strong>#{orderId}</strong> has been submitted</p>\r\n\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n  <tbody>\r\n     <tr valign="top">\r\n           <td width="50%">\r\n            <h3>Billing Information</h3>\r\n\r\n            <table border="0" cellpadding="3" cellspacing="0" width="100%">\r\n             <tbody>\r\n                 <tr>\r\n                        <th width="30%"><strong>Full Name:</strong></th>\r\n                        <td width="70%"><strong>{billingFirstName} {billingLastName}</strong></td>\r\n                  </tr>\r\n                   <tr>\r\n                        <th width="30%"><strong>Address:</strong></th>\r\n                      <td width="70%">{billingAddress}</td>\r\n                   </tr>\r\n                   <tr>\r\n                        <th width="30%"><strong>City/State/Zip:</strong></th>\r\n                       <td width="70%">{billingCityStateZip}</td>\r\n                 </tr>\r\n               </tbody>\r\n            </table>\r\n            </td>\r\n           <td width="5%">&nbsp;</td>\r\n          <td width="45%">\r\n            <h3>Payment Information</h3>\r\n\r\n            <table border="0" cellpadding="3" cellspacing="0" width="100%">\r\n             <tbody>\r\n                 <tr>\r\n                        <th width="30%"><strong>Payment Method:</strong></th>\r\n                       <td width="70%">{paymentTypeTitle}</td>\r\n                 </tr>\r\n<tr><th width="30%"><strong>Paid:</strong></th><td width="70%">{paid}</td></tr>\r\n                   <tr>\r\n                        <td colspan="2">{paymentInformation}</td>\r\n                   </tr>\r\n               </tbody>\r\n            </table>\r\n            </td>\r\n       </tr>\r\n   </tbody>\r\n</table>\r\n<br />\r\n<br />\r\n{cartItems}<br />\r\n<br />\r\n{viewDetailsLink}',
    
    `description` = 'Constants: {orderId} {billingFirstName} {billingLastName} {billingAddress} {billingCityStateZip} {paymentTypeTitle} {paid} {status} {subtotal} {tax} {total} {cartItems} {link} {paymentInformation} {viewDetailsLink}'
WHERE `name` = 'eCommerceOrderSubmitUserEmailBody'
LIMIT 1;

UPDATE `apw_Settings`
SET `value` = '<p>Order <strong>#{orderId}</strong> has been submitted</p>\r\n&nbsp;\r\n\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n   <tbody>\r\n     <tr valign="top">\r\n           <td width="50%">\r\n            <h3>Billing Information</h3>\r\n\r\n            <table border="0" cellpadding="3" cellspacing="0" width="100%">\r\n             <tbody>\r\n                 <tr>\r\n                        <th width="30%"><strong>Full Name:</strong></th>\r\n                        <td width="70%"><strong>{billingFirstName} {billingLastName}</strong></td>\r\n                  </tr>\r\n                   <tr>\r\n                        <th width="30%"><strong>Address:</strong></th>\r\n                      <td width="70%">{billingAddress}</td>\r\n                   </tr>\r\n                   <tr>\r\n                        <th width="30%"><strong>City/State/Zip:</strong></th>\r\n                       <td width="70%">{billingCityStateZip}</td>\r\n                 </tr>\r\n               </tbody>\r\n            </table>\r\n            </td>\r\n           <td width="5%">&nbsp;</td>\r\n          <td width="45%">\r\n            <h3>Payment Information</h3>\r\n\r\n            <table border="0" cellpadding="3" cellspacing="0" width="100%">\r\n             <tbody>\r\n                 <tr>\r\n                        <th width="30%"><strong>Payment Method:</strong></th>\r\n                       <td width="70%">{paymentTypeTitle}</td>\r\n                 </tr>\r\n               </tbody>\r\n            </table>\r\n            </td>\r\n       </tr>\r\n   </tbody>\r\n</table>\r\n<br />\r\n<br />\r\n{cartItems}\r\n<p>Click <a href="{link}">here</a> to view details.</p>\r\n',
    
    `description` = 'Constants: {orderId} {billingFirstName} {billingLastName} {billingAddress} {billingCityStateZip} {paymentTypeTitle} {paid} {status}  {subtotal} {tax} {total} {cartItems} {adminAdditionalNote} {link}'
WHERE `name` = 'eCommerceOrderSubmitAdminEmailBody'
LIMIT 1;
