From 3f6da84f8fea8f0ba6579f7b05929260a5c37168 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Tue, 1 May 2018 10:38:39 -0400 Subject: [PATCH] LP#1759238: Add upgrade script to fix typo for Physical Description in DB This upgrade script will check and update the typo if it is present in an existing installation. Signed-off-by: Ben Shum Signed-off-by: Josh Stompro Signed-off-by: Chris Sharp --- .../Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql new file mode 100644 index 0000000000..5e77249cd6 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql @@ -0,0 +1,11 @@ +BEGIN; + +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +--LP#1759238: Fix typo in seed data for Physical Description + +UPDATE config.metabib_field + SET label = 'Physical Description' + WHERE id = 39 AND label = 'Physical Descrption'; + +COMMIT; -- 2.43.2