3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 -- state can no longer be a "not 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 on registration',
21 'ui.patron.edit.au.state.require',
22 'Require the State field to be filled when registering or editing a patron.',
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 on registration',
41 'ui.patron.edit.au.state.show',
42 'Show the state field when registering or editing a patron.',
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 on registration',
61 'ui.patron.edit.au.state.suggest',
62 'Suggest filling the state field when registering or editing a patron.',