UPDATE `ie_zz_SettingsCategory` SET `name` = 'Reports' WHERE `ie_zz_SettingsCategory`.`id` = 6;
UPDATE `ie_zz_Settings` SET `label` = 'Report Instructions Page' WHERE `ie_zz_Settings`.`name` = 'reportInstructions';

INSERT INTO `ie_zz_Settings` 
    (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) 
    VALUES 
    ('reportDownloadHeader', '6', 'header', '', 'Download Archive File Email Template', '', '', 'n', 'n', '20', NOW(), NOW());

INSERT INTO `ie_zz_Settings` 
    (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) 
    VALUES 
    ('reportDownloadSubject', '6', 'text', 'Subject', 'Report is done. See details inside.', '', '', 'y', 'n', '30', NOW(), NOW()), 
    ('reportDownloadTo', '6', 'emails', 'To Email Address(es)', 'ira@orange35.com', '', 'Use commas to separate email addresses', 'y', 'n', '40', NOW(), NOW());

INSERT INTO `ie_zz_Settings` 
    (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) 
    VALUES 
    ('reportDownloadFrom', '6', 'text', 'From Email Address', 'Friends of  Education <info@improvek-12education.org>', '', '', 'y', 'n', '50', NOW(), NOW()),
    ('reportDownloadBody', '6', 'htmlEditor', 'Message Body', 'Please <a href={url}>click here</a> to download report archive.', '', '', 'y', 'n', '60', NOW(), NOW());

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

UPDATE `ie_zz_Settings` SET `description` = 'Constants: {url}' WHERE `ie_zz_Settings`.`name` = 'reportDownloadBody';