From a02ad071a1bf6b347be49cc749df268a9a7f733e Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 3 Jan 2023 21:01:54 -0500 Subject: [PATCH] SQL: fix columns mismatch --- .../sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) 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 index c0a17d3d69..42cfe93d6c 100644 --- 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 @@ -26,15 +26,15 @@ update config.circ_matrix_matchpoint set renew_extends_due_date = true, renew_ex 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); +insert into config.ui_staff_portal_page_entry (page_col, col_pos, entry_type, 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, entry_type, 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, entry_type, 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, entry_type, 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, entry_type, 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, entry_type, 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, entry_type, 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, entry_type, 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, entry_type, label, image_url, target_url, entry_text, owner) values (3, 6, 'menuitem', 'PINES Quick Reports', '/images/portal/reports.png', '/report-creator', null, 1); -- enable global flag for expired account login -- 2.11.0