INSERT INTO `qs_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('userRegistrationAdminEmailAssocHeader', 4, 'Header', '', 'Individual Registration (Admin Notification)', '', '', 'n', 'n', 800, NOW(), NOW()),
('userRegistrationAdminEmailAssocSubject', 4, 'text', 'Subject', 'New Individual has been registered', '', '', 'y', 'n', 810, NOW(), NOW()),
('userRegistrationAdminEmailAssocFrom', 4, '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', 820, NOW(), NOW()),
('userRegistrationAdminEmailAssocBody', 4, 'HtmlEditor', 'Message Body', '<p>\r\n	New User has been registered&nbsp;at&nbsp; Adapta Interactive Framework website.</p>\r\n<p>\r\n	Name: <strong>{firstName}</strong><strong> {lastName}</strong><br />\r\n	Email: <strong>{email}</strong><br />\r\n	Phone Number:<strong> {directPhone}</strong><br />\r\n	<br />\r\n	<a href="{link}" target="_blank">Click here to view details</a>.</p>\r\n', 'Basic', 'Constants: {membershipType} {firstName} {lastName} {email} {directPhone} {cellPhone} {homeAddress} {homeAddress2} {homeCity} {homeState} {homeZip} {companyName} {companyPhone} {companyFax} {companyAddress} {companyAddress2} {companyCity} {companyState} {companyZip}', 'y', 'n', 830, NOW(), NOW());

INSERT INTO `qs_SettingsOptions` (`id`, `name`, `variable`, `value`, `type`, `sorter`) VALUES
(NULL, 'userRegistrationAdminEmailAssocBody', 'scriptOptions[enterMode]', '2', 'string', NULL),
(NULL, 'userRegistrationAdminEmailAssocBody', 'height', '300', 'int', NULL),
(NULL, 'userRegistrationAdminEmailAssocBody', 'mode', 'view', 'string', NULL);