From 1f73a0c10c627f7db4d792df0668151bb5ab4ada Mon Sep 17 00:00:00 2001 From: helene hickey Date: Wed, 16 Jan 2019 21:45:46 +0000 Subject: [PATCH] Bug 20491: Test plan: 1) Go to admin, then to MARC frameworks, then to default frameworks structure, then subfield stucture for 952 2) Verify that 'q' is described as 'checked out' 3) Go to /cgi-bin/koha/cataloguing/additem.pl?biblionumber=x 4) Verify that 'q' is also descirbed as 'Checked out' in 3) Apply patch and update your database 4) Verify that the description of 'q' has changed to 'Date due' 5) Go to /cgi-bin/koha/cataloguing/additem.pl?biblionumber=x 6) Verify that it has changed to 'Date due' --- .../atomicupdate/bug_20491_-_updating_marc_subfield_description.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_20491_-_updating_marc_subfield_description.sql diff --git a/installer/data/mysql/atomicupdate/bug_20491_-_updating_marc_subfield_description.sql b/installer/data/mysql/atomicupdate/bug_20491_-_updating_marc_subfield_description.sql new file mode 100644 index 0000000000..4c4c8caf47 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_20491_-_updating_marc_subfield_description.sql @@ -0,0 +1,3 @@ +UPDATE `marc_subfield_structure` +SET `liblibrarian` = 'Date due', `libopac`='Date due' +WHERE `tagfield`=952 AND `tagsubfield`='q'; -- 2.11.0