3 INSERT INTO config.upgrade_log (version) VALUES ('0169'); -- phasefx
5 -- Effective undoes 0117.data.org-setting-notes-require-initials.sql
6 -- At the time of this script, these shouldn't be in any production systems, so I'm removing, not "upgrading".
7 DELETE FROM actor.org_unit_setting WHERE name IN (
8 'ui.circ_and_cat.notes.require_initials',
9 'ui.circ.standing_penalty.require_initials'
11 DELETE FROM config.org_unit_setting_type WHERE name IN (
12 'ui.circ_and_cat.notes.require_initials',
13 'ui.circ.standing_penalty.require_initials'
16 INSERT INTO config.org_unit_setting_type ( name, label, description, datatype )
18 'ui.staff.require_initials',
20 'ui.staff.require_initials',
21 'GUI: Require staff initials for entry/edit of item/patron/penalty notes/messages.',
25 'ui.staff.require_initials',
26 'Appends staff initials and edit date into note content.',
30 FROM config.org_unit_setting_type -- Since this script is way after the setting was introduced, being careful
31 WHERE NOT EXISTS (SELECT 1 FROM config.org_unit_setting_type WHERE name = 'ui.staff.require_initials');