3 SELECT evergreen.upgrade_deps_block_check('0799', :eg_version);
5 -- allow state to be null
6 ALTER TABLE actor.usr_address ALTER COLUMN state DROP NOT NULL;
9 INSERT into config.org_unit_setting_type
10 (name, grp, label, description, datatype)
12 'ui.patron.edit.au.state.require',
15 'ui.patron.edit.au.state.require',
16 'Require State field on patron registration',
21 'ui.patron.edit.au.state.require',
22 'The State field will be required on the patron registration screen.',
29 INSERT into config.org_unit_setting_type
30 (name, grp, label, description, datatype)
32 'ui.patron.edit.au.state.show',
35 'ui.patron.edit.au.state.show',
36 'Show State field on patron registration',
41 'ui.patron.edit.au.state.show',
42 'The State field will be shown on the patron registration screen. Showing a field makes it appear with required fields even when not required. If the field is required this setting is ignored.',
49 INSERT into config.org_unit_setting_type
50 (name, grp, label, description, datatype)
52 'ui.patron.edit.au.state.suggest',
55 'ui.patron.edit.au.state.suggest',
56 'Suggest State field on patron registration',
61 'ui.patron.edit.au.state.suggest',
62 'The State field will be suggested on the patron registration screen. Suggesting a field makes it appear when suggested fields are shown. If the field is shown or required this setting is ignored.',