]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0389.data.issuance-holds.sql
Break up expensive queries, match index to quals
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0389.data.issuance-holds.sql
1 BEGIN;
2
3 INSERT INTO config.upgrade_log (version) VALUES ('0389'); -- miker
4
5 -- Making this a global_flag (UI accessible) instead of an internal_flag
6 INSERT INTO config.global_flag (name, label, enabled)
7     VALUES (
8         'circ.holds.empty_issuance_ok',
9         oils_i18n_gettext(
10             'circ.holds.empty_issuance_ok',
11             'Holds: Allow holds on empty issuances',
12             'cgf',
13             'label'
14         ),
15         TRUE
16     );
17
18 INSERT INTO permission.perm_list (code, description) VALUES ('ISSUANCE_HOLDS', 'Allow a user to place holds on serials issuances');
19
20 COMMIT;
21