UPDATE qs_Settings SET `value` = 'Event Registration Confirmation (User Who Registers Notification)' WHERE `name` = 'eventNotificationAuthorHeader' LIMIT 1; UPDATE qs_Settings SET `value` = 'Event Registration Confirmation (Attendees Notification)' WHERE `name` = 'eventNotificationAttendeeHeader' LIMIT 1; UPDATE qs_Settings SET required = 'n' WHERE `name` = 'eventNotificationAuthorFrom'; UPDATE qs_Settings SET required = 'n' WHERE `name` = 'eventNotificationAttendeeFrom'; UPDATE qs_Settings SET required = 'n' WHERE `name` = 'eventNotificationAdminFrom'; INSERT INTO `qs_SettingsOptions` (`name`, `variable`, `value`, `type`) VALUES ('eventNotificationAuthorBody', 'mode', 'view', 'string'), ('eventNotificationAttendeeBody', 'mode', 'view', 'string'), ('eventNotificationAdminBody', 'mode', 'view', 'string');