From c81b7e7bd01e5c439d07adb07db4ab1fdd8112f4 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 10 Jan 2022 10:07:47 -0500 Subject: [PATCH] SQL: include DB changes for LP1951162 --- .../pines_additional_sql_upgrade.sql | 28 ++++++++++++++++++++++ 1 file changed, 28 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines_additional_sql_upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines_additional_sql_upgrade.sql index 70d58c44ab..8f9461addb 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines_additional_sql_upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines_additional_sql_upgrade.sql @@ -44,4 +44,32 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 1101, 'ADMIN_STUDENT_CARDS', oils_i18n_gettext(1101, 'Modify student card settings', 'ppl', 'description')); + +-- apply holdings template updates +DO $SQL$ +BEGIN + + PERFORM TRUE FROM config.usr_setting_type WHERE name = 'cat.copy.templates'; + + IF NOT FOUND THEN -- no matching user setting + + PERFORM TRUE FROM config.workstation_setting_type WHERE name = 'cat.copy.templates'; + + IF NOT FOUND THEN + -- no matching workstation setting + -- Migrate the existing user setting and its data to the new name. + + UPDATE config.usr_setting_type + SET name = 'cat.copy.templates' + WHERE name = 'webstaff.cat.copy.templates'; + + UPDATE actor.usr_setting + SET name = 'cat.copy.templates' + WHERE name = 'webstaff.cat.copy.templates'; + + END IF; + END IF; + +END; +$SQL$; commit; -- 2.11.0