UPDATE `ie_zz_Settings` SET `value` = 'Overdue Reports Notification Email Template' WHERE `name` = 'reportOverdueEmailHeader';

UPDATE `ie_zz_Settings` SET `sorter` = `sorter` + 10
WHERE `idCategory` = 6
AND `sorter` >= 180; -- reportOverdueEmailHeader sorter


INSERT INTO `ie_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`)
VALUES ('reportSubmissionEmailHeader', '6', 'header', '', 'Report Submission Email Template', '', '', 'n', 'n', '180', NOW(), NOW());

INSERT INTO `ie_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`)
VALUES ('reportSubmissionEmailSubject', '6', 'text', 'Subject', 'New school report has been submitted', '', '', 'y', 'n', '181', NOW(), NOW());

INSERT INTO `ie_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`)
VALUES ('reportSubmissionEmailTo', '6', 'emails', 'To Email Address(es)', '', '', 'Use commas to separate email addresses', 'y', 'n', '182', NOW(), NOW());

INSERT INTO `ie_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`)
VALUES ('reportSubmissionEmailFrom', '6', 'text', 'From Email Address', 'Friends@tcfbank.com', '', '', 'y', 'n', '183', NOW(), NOW());

INSERT INTO `ie_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`)
VALUES ('reportSubmissionEmailBody', '6', 'htmlEditor', 'Message Body', '', '', 'Constants: {dueData} {section} {topic} {description} {reportUrl} {reportContacts} {file} {comments} {submittedOn} {schoolName} {schoolUrl} {schoolContacts} {userName} {userPosition} {userPhone} {userEmail}', 'y', 'n', '184', NOW(), NOW());

INSERT INTO `ie_zz_SettingsOptions` (`id`, `name`, `variable`, `value`, `type`) VALUES
(NULL, 'reportSubmissionEmailBody', 'mode', 'view', 'string'),
(NULL, 'reportSubmissionEmailBody', 'toolbarSet', 'Basic', 'string');