-- Waiver Paragraph
INSERT INTO `apw_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('eventWaiverParagraph', 1, 'htmlEditor', 'Waiver Paragraph', '', '', '', 'y', 'n', 45, '2016-04-05 14:30:00', '2016-04-05 14:30:00');

INSERT INTO `apw_SettingsOptions` (`id`, `name`, `variable`, `value`, `type`, `sorter`) VALUES (NULL, 'eventWaiverParagraph', 'mode', 'view', 'string', NULL);

ALTER TABLE `apw_Event` 
 ADD `showWaiver` enum('y','n') NOT NULL DEFAULT 'n' AFTER `regularPrice`;

ALTER TABLE `apw_EventAttendee`
 ADD `waiverAgreed` enum('y','n') DEFAULT NULL AFTER `approved`;