UPDATE `apw_Settings` SET `value` = 'Event Registration Notification (sends to user)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'eventSignupNotificationHeader' LIMIT 1 ; UPDATE `apw_Settings` SET `value` = 'New Job Notification (sends to admin)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'jobListingAdded2AdminHeader' LIMIT 1 ; UPDATE `apw_Settings` SET `value` = 'Order changed (sends to user)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'eCommerceOrderChangedUserEmailHeader' LIMIT 1 ; UPDATE `apw_Settings` SET `value` = 'Paid Status changed to NO (sends to admin)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'eCommerceOrderPaidStatusNoUserEmailHeader' LIMIT 1 ; UPDATE `apw_Settings` SET `value` = 'Paid Status changed to YES (sends to user)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'eCommerceOrderPaidStatusYesUserEmailHeader' LIMIT 1 ; UPDATE `apw_Settings` SET `value` = 'Order submitted (sends to admin)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'eCommerceOrderSubmitAdminEmailHeader' LIMIT 1 ; UPDATE `apw_Settings` SET `value` = 'Order submitted (sends to user)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'eCommerceOrderSubmitUserEmailHeader' LIMIT 1 ; UPDATE `apw_Settings` SET `value` = 'Payment confirmation (sends to user)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'transactionStatusChangedUserEmailHeader' LIMIT 1 ; UPDATE `apw_Settings` SET `value` = '"Forgot Password" Email Template (sends to user)' WHERE CONVERT( `apw_Settings`.`name` USING utf8 ) = 'forgotPasswordEmailHeader' LIMIT 1 ;