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 (file)
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;