3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 INSERT INTO config.usr_setting_type (
14 'circ.default_overdue_notices_enabled',
17 'circ.default_overdue_notices_enabled',
18 'Receive Overdue and Courtesy Emails',
23 'circ.default_overdue_notices_enabled',
24 'Receive overdue and predue email notifications',
36 \qecho The following query will set the circ.default_overdue_notices_enabled
37 \qecho user setting to true (the default value) for all existing users,
38 \qecho ensuring they continue to receive overdue/predue emails.
40 \qecho INSERT INTO actor.usr_setting (usr, name, value)
43 \qecho 'circ.default_overdue_notices_enabled',
45 \qecho FROM actor.usr;
47 \qecho The following query will add the circ.default_overdue_notices_enabled
48 \qecho user setting as an opt-in setting for all action triggers that send
49 \qecho emails based on a circ being due (unless another opt-in setting is
50 \qecho already in use).
52 \qecho UPDATE action_trigger.event_definition
53 \qecho SET opt_in_setting = 'circ.default_overdue_notices_enabled',
54 \qecho usr_field = 'usr'
55 \qecho WHERE opt_in_setting IS NULL
56 \qecho AND hook = 'checkout.due'
57 \qecho AND reactor = 'SendEmail';
59 \qecho Evergreen admins who wish to use the new setting should run both of
60 \qecho the above queries. Admins who do not wish to use it, or who are
61 \qecho already using a custom opt-in setting of their own, do not need to