Many patrons in the sample file are expired now that we all live in the future. Ideally we would set the dates relative so that patrons don't start to get too old or be expired etc.
Created attachment 115858 [details] [review] Bug 27530: Set dateexpiry to 2099 in sample patrons To prevent them to be expired. Note that the last patron is kept expired.
Created attachment 115859 [details] [review] 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.
Created attachment 115884 [details] [review] Bug 27530: Set dateexpiry to 2099 in sample patrons To prevent them to be expired. Note that the last patron is kept expired. Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Created attachment 115885 [details] [review] 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>
Created attachment 116101 [details] [review] Bug 27530: Set dateexpiry to 2099 in sample patrons To prevent them to be expired. Note that the last patron is kept expired. Signed-off-by: Nick Clemens <nick@bywatersolutions.com> Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Created attachment 116102 [details] [review] 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> Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
This will only work for the installers that have already been moved to the yaml system. But I am ok with the limit in this case. I believe the most installed sample data is probably the English one.
Pushed to master for 21.05, thanks to everybody involved!
Pushed to 20.11.x for 20.11.03
Pushed to 20.05.x for 20.05.09
Not backported to oldoldstable (19.11.x). Feel free to ask if it's needed.