From 325aa64bb094badf0f20791cef98327c4534a7e1 Mon Sep 17 00:00:00 2001 From: Lari Taskula Date: Tue, 17 May 2016 14:44:45 +0300 Subject: [PATCH] [PASSED QA] Bug 16200: Convert all existing expired holds accounttype to HE Before Bug 16200 expired holds have used accounttype F which is also used by other type of fines. This patch updates all existing expired holds to new accounttype HE (Hold Expired). To test: -1. Make sure you translated the string in previous patch of this buug 1. Find a Patron with "Hold waiting too long" fines and go to his Fines tab 2. Change Koha's language to some other than English 3. Observe that "Hold waiting too long" is still in English 4. Apply patch and run database update 5. Go back to Patron's Fines tab 6. Observe that "Hold waiting too long" is now translated Signed-off-by: Olli-Antti Kivilahti Signed-off-by: Katrin Fischer --- .../atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 installer/data/mysql/atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql diff --git a/installer/data/mysql/atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql b/installer/data/mysql/atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql new file mode 100644 index 0000000..b1c957d --- /dev/null +++ b/installer/data/mysql/atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql @@ -0,0 +1 @@ +UPDATE accountlines SET accounttype='HE', description=itemnumber WHERE (description REGEXP '^Hold waiting too long [0-9]+') AND accounttype='F'; -- 1.9.1