]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/1124.data.wide_holds-workstation-settings.sql
LP#1712854 Stamping DB upgrade for hold UIs sort/speed
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 1124.data.wide_holds-workstation-settings.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('1124', :eg_version);
4
5 INSERT into config.workstation_setting_type (name, grp, datatype, label)
6 VALUES (
7     'eg.grid.circ.wide_holds.shelf', 'gui', 'object',
8     oils_i18n_gettext (
9         'eg.grid.circ.wide_holds.shelf',
10         'Grid Config: circ.wide_holds.shelf',
11         'cwst', 'label'
12     )
13 ), (
14     'eg.grid.cat.catalog.wide_holds', 'gui', 'object',
15     oils_i18n_gettext(
16         'eg.grid.cat.catalog.wide_holds',
17         'Grid Config: cat.catalog.wide_holds',
18         'cwst', 'label'
19     )
20 );
21
22 DELETE from config.workstation_setting_type
23 WHERE name = 'eg.grid.cat.catalog.holds' OR name = 'eg.grid.circ.holds.shelf';
24
25 COMMIT;