1 -- Evergreen DB patch 0670.data.mark-email-and-phone-invalid.sql
3 -- Add org unit settings and standing penalty types to support
4 -- the mark email/phone invalid features.
8 -- check whether patch can be applied
9 SELECT evergreen.upgrade_deps_block_check('0670', :eg_version);
12 INSERT INTO config.standing_penalty (id, name, label, staff_alert, org_depth) VALUES
15 'INVALID_PATRON_EMAIL_ADDRESS',
18 'Patron had an invalid email address',
27 'INVALID_PATRON_DAY_PHONE',
30 'Patron had an invalid daytime phone number',
39 'INVALID_PATRON_EVENING_PHONE',
42 'Patron had an invalid evening phone number',
51 'INVALID_PATRON_OTHER_PHONE',
54 'Patron had an invalid other phone number',