4 -- Track the requesting user
5 ALTER TABLE staging.user_stage
6 ADD COLUMN requesting_usr INTEGER
7 REFERENCES actor.usr(id) ON DELETE SET NULL;
9 -- add county column to staged address tables and
10 -- drop state requirement to match actor.usr_address
11 ALTER TABLE staging.mailing_address_stage
12 ADD COLUMN county TEXT,
13 ALTER COLUMN state DROP DEFAULT,
14 ALTER COLUMN state DROP NOT NULL;
16 ALTER TABLE staging.billing_address_stage
17 ADD COLUMN county TEXT,
18 ALTER COLUMN state DROP DEFAULT,
19 ALTER COLUMN state DROP NOT NULL;
21 INSERT INTO config.org_unit_setting_type
22 (name, grp, datatype, label, description)
24 'opac.allow_pending_user',
28 'opac.allow_pending_user',
29 'Allow Patron Self-Registration',
34 'opac.allow_pending_user',
35 'Allow patrons to self-register, creating pending user accounts',
40 'opac.pending_user_expire_interval',
44 'opac.pending_user_expire_interval',
45 'Patron Self-Reg. Expire Interval',
50 'opac.pending_user_expire_interval',
51 'If set, this is the amount of time a pending user account will ' ||
52 'be allowed to sit in the database. After this time, the pending ' ||
53 'user information will be purged',
58 'ui.patron.edit.aua.county.show',
62 'ui.patron.edit.aua.county.require',
63 'Show count field on patron registration',
68 'ui.patron.edit.aua.county.require',
69 'The county field will be shown on the patron registration screen',