-- Email Templates
UPDATE `qs_Settings` SET `required` = 'n' WHERE `name` IN (
  'contactFormEmailFrom',
  'newsletterFormEmailFrom',
  'newsletterFormUserEmailFrom',
  'giftCardEmailFrom',
  'blogCommentEmailFrom'
) ;

UPDATE `qs_Settings` SET `value` = '' WHERE `name` IN (
  'contactFormEmailFrom',
  'newsletterFormEmailFrom',
  'newsletterFormUserEmailFrom',
  'giftCardEmailFrom',
  'blogCommentEmailFrom'
) ;

-- Order Templates
UPDATE `qs_Settings` SET `required` = 'n' WHERE `name` IN (
  'eCommerceOrderOrderStatusNewUserEmailFrom',
  'eCommerceOrderOrderStatusPackedUserEmailFrom',
  'eCommerceOrderOrderStatusSentUserEmailFrom',
  'eCommerceOrderOrderStatusClosedUserEmailFrom',
  'eCommerceOrderPaidStatusYesUserEmailFrom',
  'eCommerceOrderPaidStatusNoUserEmailFrom',
  'eCommerceOrderSubmitUserEmailFrom',
  'eCommerceOrderSubmitAdminEmailFrom',
  'eCommerceOrderChangedUserEmailFrom'
);

UPDATE `qs_Settings` SET `value` = '' WHERE `name` IN (
  'eCommerceOrderOrderStatusNewUserEmailFrom',
  'eCommerceOrderOrderStatusPackedUserEmailFrom',
  'eCommerceOrderOrderStatusSentUserEmailFrom',
  'eCommerceOrderOrderStatusClosedUserEmailFrom',
  'eCommerceOrderPaidStatusYesUserEmailFrom',
  'eCommerceOrderPaidStatusNoUserEmailFrom',
  'eCommerceOrderSubmitUserEmailFrom',
  'eCommerceOrderSubmitAdminEmailFrom',
  'eCommerceOrderChangedUserEmailFrom'
);
