INSERT INTO `ma_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('licensePendingUserHeader', 7, 'header', '', 'License Pending (Vendor Users Notification)', '', '', 'n', 'n', 380, '2019-03-29 09:00:00', '2019-03-29 09:00:00'),
('licensePendingUserSubject', 7, 'text', 'Subject', 'License #{id} status has been changed to pending (by tribe "{tribe}")', '', '', 'y', 'n', 390, '2019-03-29 09:00:00', '2019-03-29 09:00:00'),
('licensePendingUserFrom', 7, 'text', 'From Email Address &nbsp; <span class="label_description">If you leave this field empty - the From Email Address will be the same as the one in General Settings.</span>', '', '', '', 'n', 'n', 400, '2019-03-29 09:00:00', '2019-03-29 09:00:00'),
('licensePendingUserBody', 7, 'HtmlEditor', 'Message Body', '<p>License #{id} status has been changed to pending:</p>\r\n\r\n<p><strong>DBA Name</strong>: {vendorDbaName}<br />\r\n<strong>Sole Proprietor:</strong> {vendorSoleProprietorName}<br />\r\n<strong>Federal ID</strong>: {vendorFederalId}<br />\r\n<strong>Phone</strong>: {vendorPhone}<br />\r\n<strong>License #</strong>: {id}<br />\r\n<strong>Tribe</strong>: {tribe}</p>\r\n\r\n<p><a href="{detailsUrl}">View License Details</a>&nbsp;</p>\r\n', '', 'Constants: {id} {vendorDbaName} {vendorSoleProprietorName} {vendorFederalId} {vendorPhone} {detailsUrl} {tribe}', 'y', 'n', 410, '2019-03-29 09:00:00', '2019-03-29 09:00:00');


INSERT INTO `ma_SettingsOptions` (`id`, `name`, `variable`, `value`, `type`, `sorter`) VALUES
(NULL, 'licensePendingUserBody', 'mode', 'view', 'string', NULL),
(NULL, 'licenseApprovedUserBody', 'mode', 'view', 'string', NULL);