From ffc303771bc101604c2d115da96654da0522bb55 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Thu, 3 Dec 2015 14:02:17 +0100 Subject: [PATCH] Bug 8085: Follow-up: Update to 'Hold Slip' for existing installations Title and description are updated separately, in case that the library has changed one of them when editing the slip. To test: - Verify that you have a letter named 'Reserve Slip' in your database - Run the database update - Verify the slip has been renamed correctly --- installer/data/mysql/atomicupdate/bug_8085_rename_reserve_slip.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_8085_rename_reserve_slip.sql diff --git a/installer/data/mysql/atomicupdate/bug_8085_rename_reserve_slip.sql b/installer/data/mysql/atomicupdate/bug_8085_rename_reserve_slip.sql new file mode 100644 index 0000000..9b25536 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_8085_rename_reserve_slip.sql @@ -0,0 +1,4 @@ +-- Rename 'Reserve slip' to 'Holds slip' to match Koha's terminology +UPDATE letter SET name = "Hold Slip" WHERE name = "Reserve Slip"; +UPDATE letter SET title = "Hold Slip" WHERE title = "Reserve Slip"; + -- 1.9.1