ALTER TABLE `mm_Transaction` ADD `billingCompanyName` VARCHAR(255) NULL DEFAULT NULL AFTER `billingLastName`; UPDATE `mm_Settings` SET `description` = 'Constants: {orderId} {billingFirstName} {billingLastName} {billingCompanyName} {billingAddress} {billingCity} {billingState} {billingZip} {billingEmail} {billingPhone} {shippingFirstName} {shippingLastName} {shippingAddress} {shippingCity} {shippingTitle} {shippingNameTitle} {shippingServiceCodeTitle} {paymentTypeTitle} {paid} {status} {promo} {giftCard} {subtotal} {tax} {total} {cartItems} {userAdditionalNote} {link}' WHERE `name` IN('eCommerceOrderSubmitUserEmailBody', 'eCommerceOrderSubmitAdminEmailBody'); UPDATE `mm_Settings` SET `value` = REPLACE(`value`, '{billingAddress}
', '{billingCompanyName}
{billingAddress}
') WHERE `name` IN('eCommerceOrderSubmitUserEmailBody', 'eCommerceOrderSubmitAdminEmailBody');