update `vt_Settings` set `system` = 'y'
where `idCategory` = 2
and `name` in (
  'newsletterFormEmailHeader',
  'newsletterFormEmailSubject',
  'newsletterFormEmailFrom',
  'newsletterFormEmailTo',
  'newsletterFormEmailBody',
  'newsletterFormUserEmailHeader',
  'newsletterFormUserEmailSubject',
  'newsletterFormUserEmailFrom',
  'newsletterFormUserEmailBody',
  'giftCardEmailHeader',
  'giftCardEmailSubject',
  'giftCardEmailFrom',
  'giftCardEmailBody',
  'blogCommentEmailHeader',
  'blogCommentEmailSubject',
  'blogCommentEmailFrom',
  'blogCommentEmailTo',
  'blogCommentEmailBody',
  'reviewFormEmailHeader',
  'reviewFormEmailSubject',
  'reviewFormEmailFrom',
  'reviewFormEmailTo',
  'reviewFormEmailBody'
);

update `vt_Settings` set `fieldType` = 'text' where `idCategory` = 4 and `name` = 'userNeedEmailConfirmationFrom';

update `vt_SettingsCategory` set `system` = 'y' where `id` = 6;

update `vt_Settings` set `system` = 'y' where `name` like 'eCommerceOrderOrderStatusSentUser%';
update `vt_Settings` set `system` = 'y' where `name` like 'eCommerceOrderChangedUser%';
