From 43b8b9f4e56dd4ea819eb5fdaf5b2f672958815c Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 19 Dec 2022 13:56:50 -0500 Subject: [PATCH] SQL: add post-upgrade script --- .../Pg/version-upgrade/pines-post-3.10-upgrade.sql | 41 ++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql new file mode 100644 index 0000000000..41cfc19e28 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql @@ -0,0 +1,41 @@ +BEGIN; + +-- add extend due date configs where applicable +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '87 days' where circ_modifier = 'art'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'audiobook'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'audiobook-ff'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '4 days' where circ_modifier = 'bestseller'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '32 days' where circ_modifier = 'book'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'book'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'book'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'book-ff'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'kit'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'localpass'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'magazine'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'microform'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'music'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'music-ff'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'realia-1'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'realia-2'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'software'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '4 days' where circ_modifier = 'statepass'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'talking book'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'toy'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'video-2'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'video-2-ff'; +update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_extend_min_interval = '11 days' where circ_modifier = 'videogame'; + +-- add portal page entries +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (1, 3, 'menuitem', 'Register New Patron', '/images/portal/registerpatron.png', '/eg/staff/circ/patron/register', null, 1); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (1, 5, 'menuitem', 'Holds Pull List', '/images/portal/holds.png', '/eg2/staff/circ/holds/pull-list', null, 1); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (2, 2, 'menuitem', 'Search Catalog', '/images/portal/book.png', '/eg2/staff/catalog/search', null, 1); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (2, 3, 'menuitem', 'Item Status / Information', '/images/portal/book.png', '/eg/staff/cat/item/search', null, 1); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (2, 4, 'menuitem', 'z39.50 Import', '/images/portal/z3950.png', '/eg/staff/cat/z3950/index', null, 1); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (3, 1, 'link', 'GPLS Help Desk', '/images/portal/helpdesk.png', 'https://help.georgialibraries.org', null, 1); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (3, 3, 'link', 'PINES Learning Center', '/images/portal/helpdesk.png', 'https://my.nicheacademy.com/pines', null, 1); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (3, 2, 'link', 'PINES Documentation', '/images/portal/helpdesk.png', 'https://pines.georgialibraries.org/documentation/', 'Policies and procedures', 1); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_url, target_url, entry_text, owner) values (3, 6, 'menuitem', 'PINES Quick Reports', '/images/portal/reports.png', '/report-creator', null, 1); + + +COMMIT; + -- 2.11.0