ALTER TABLE  `apw_Transaction` CHANGE  `paymentTypeTitle`  `paymentTypeTitle` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;


UPDATE `apw_Settings`
SET `description` = 'Constants: {orderId} {billingFirstName} {billingLastName} {billingAddress} {billingCity} {billingState} {billingZip} {paymentTypeTitle} {paid} {status} {subtotal} {tax} {total} {cartItems} {link} {paymentInformation} {viewDetailsLink}'
WHERE `name` = 'eCommerceOrderSubmitUserEmailBody';


UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusYesUserEmailHeader';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusYesUserEmailSubject';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusYesUserEmailFrom';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusYesUserEmailBody';


UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusNoUserEmailHeader';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusNoUserEmailHeader';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusNoUserEmailSubject';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusNoUserEmailFrom';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderPaidStatusNoUserEmailBody';

UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderChangedUserEmailHeader';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderChangedUserEmailFrom';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderChangedUserEmailSubject';
UPDATE `apw_Settings` SET `system` = 'y' WHERE `name` = 'eCommerceOrderChangedUserEmailBody';