From 3f6da84f8fea8f0ba6579f7b05929260a5c37168 Mon Sep 17 00:00:00 2001
From: Ben Shum <ben@evergreener.net>
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 <ben@evergreener.net>
Signed-off-by: Josh Stompro <stompro@stompro.org>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
---
.../src/sql/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.11.0