ALTER TABLE `ma_Vendor`
    ADD `soleProprietorDlNumber` VARCHAR(64) NULL DEFAULT NULL AFTER `soleProprietorLastName`,
    ADD `soleProprietorDlState` CHAR(2) NULL DEFAULT NULL AFTER `soleProprietorDlNumber`;

UPDATE `ma_Settings`
SET
    `value` = '<p>New license has been submitted:</p>\r\n\r\n<p><strong>DBA Name</strong>: {vendorDbaName}<br />\r\n<strong>Main Contact</span>:</strong> {vendorSoleProprietorName}<br />\r\n<strong>Main Contact Driver''s License Number</span>:</strong> {vendorSoleProprietorDlNumber}<br />\r\n<strong>Main Contact Driver''s License Issuance State</span>:</strong> {vendorSoleProprietorDlStateTitle}<br />\r\n<strong>Federal ID</strong>: {vendorFederalId}<br />\r\n<strong>Phone</strong>: {vendorPhone}<br />\r\n<strong>License #</strong>: {id}</p>\r\n\r\n<p>Click <a href="{detailsUrl}">here</a> to view details.</p>\r\n',
    `description` = 'Constants: {id} {vendorDbaName} {vendorSoleProprietorName} {vendorSoleProprietorDlNumber} {vendorSoleProprietorDlStateTitle} {vendorFederalId} {vendorPhone} {detailsUrl}'
WHERE `name` = 'bgScreeningToBgCompanyBody'
LIMIT 1;