LP1164197 - Add page number navigation to my lists and setting for number of lists...
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.add_setting_for_selecting_lists_per_page_for_my_list.sql
1 -- Evergreen DB patch XXXX.add_setting_for_selecting_lists_per_page_for_my_list.sql
2 --
3 -- Adds a setting for selecting the number of lists per page for my list.
4 --
5 BEGIN;
6
7 -- check whether patch can be applied
8 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
9
10 INSERT INTO config.usr_setting_type (name,opac_visible,label,description,datatype)
11     VALUES (
12         'opac.lists_per_page',
13         TRUE,
14         oils_i18n_gettext(
15             'opac.lists_per_page',
16             'Lists per Page',
17             'cust',
18             'label'
19         ),
20         oils_i18n_gettext(
21             'opac.lists_per_page',
22             'A number designating the amount of lists displayed per page.',
23             'cust',
24             'description'
25         ),
26         'string'
27     );
28     
29 COMMIT;