From: Ben Shum <ben@evergreener.net>
Date: Tue, 1 May 2018 14:38:39 +0000 (-0400)
Subject: LP#1759238: Add upgrade script to fix typo for Physical Description in DB
X-Git-Url: http://git.equinoxoli.org/?p=evergreen-equinox.git;a=commitdiff_plain;h=3f6da84f8fea8f0ba6579f7b05929260a5c37168

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 <ben@evergreener.net>
Signed-off-by: Josh Stompro <stompro@stompro.org>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
---

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 0000000..5e77249
--- /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;