Bugzilla – Attachment 115885 Details for
Bug 27530
Sample patron data should be updated and/or use relative dates
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 27530: Set correct dateofbirth for 'C'
Bug-27530-Set-correct-dateofbirth-for-C.patch (text/plain), 1.13 KB, created by
Nick Clemens (kidclamp)
on 2021-01-27 13:24:52 UTC
(
hide
)
Description:
Bug 27530: Set correct dateofbirth for 'C'
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2021-01-27 13:24:52 UTC
Size:
1.13 KB
patch
obsolete
>From a4f60a71c7f0460bb0fd76846ebbeceb0ad4c7bd Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Wed, 27 Jan 2021 10:22:27 +0100 >Subject: [PATCH] Bug 27530: Set correct dateofbirth for 'C' > >Categories B, J, K and YA have a upper age limit of 17 years. >We are setting the dateofbirth to today - 15 years to prevent juvenils >to be 70! > >Note that DATE_SUB is a MySQLism, but there is no way to be portable >here. > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> >--- > installer/data/mysql/en/optional/sample_patrons.yml | 3 +++ > 1 file changed, 3 insertions(+) > >diff --git a/installer/data/mysql/en/optional/sample_patrons.yml b/installer/data/mysql/en/optional/sample_patrons.yml >index a7baf0d38a..c68b75e58f 100644 >--- a/installer/data/mysql/en/optional/sample_patrons.yml >+++ b/installer/data/mysql/en/optional/sample_patrons.yml >@@ -2424,3 +2424,6 @@ tables: > flags: ~ > sort1: 0.91641750830823 > sort2: 0.27291712562825 >+ >+sql_statements: >+ - "UPDATE borrowers SET dateofbirth=DATE_SUB(CAST(NOW() AS DATE), INTERVAL 15 YEAR) WHERE categorycode IN ('B', 'J', 'K', 'YA');" >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 27530
:
115858
|
115859
|
115884
|
115885
|
116101
|
116102