INSERT INTO `sa_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('reportDownloadSchoolHeader',  6, 'header',     '', 'Download School Archive File Email Template', '', '', 'n', 'n', 80, '2016-09-08 10:00:00', '2016-09-08 10:00:00'),
('reportDownloadSchoolSubject', 6, 'text',       'Subject', 'Archiving reports has been finished', '', '', 'y', 'n', 82, '2016-09-08 10:00:00', '2016-09-08 10:00:00'),
('reportDownloadSchoolBody',    6, 'htmlEditor', 'Message Body', '<p>Reports archival is finished and the archive will be available for downloading for the next 5 days.</p><p>You must be logged into your account in order to download the archive file by clicking the ''Download Archive'' link available on the <a href="http://lazar.dev.orange35.com/samnllc.org/trunk/www/reports-to-submit">''Reports to Submit''</a> page.</p>', '', '', 'y', 'n', 86, '2016-09-08 10:00:00', '2016-09-08 10:00:00');

INSERT INTO `sa_zz_SettingsOptions` (`id`, `name`, `variable`, `value`, `type`) VALUES (NULL, 'reportDownloadSchoolBody', 'mode', 'view', 'string');