Bug 23081: set default to 0 for items.issues and deleteditems.issues
authorAndrew Fuerste-Henry <andrew@bywatersolutions.com>
Sun, 26 Apr 2020 23:51:25 +0000 (23:51 +0000)
committerLucas Gass <lucas@bywatersolutions.com>
Thu, 14 May 2020 21:42:43 +0000 (21:42 +0000)
commit6bef3c3c6987b8ebdc2820a9fdabfb5b34ba2b4b
treeb3bee123ace2d69e33207aa39cd861a2d99c7643
parent693069ea1e73a3bc421c0a83918da03ec0ace6cc
Bug 23081: set default to 0 for items.issues and deleteditems.issues

To test:
- save and run this sql query in reports: select sum(if(issues is null,1,0)),sum(if(issues=0,1,0)) from items
- you should see a lot of nulls and no zeros
- apply patch
- updatedatabase
- re-run your query and see that your nulls have changed to zeros
- create a new item
- rerun your query and see your new item is counted in the zeros, not the nulls

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
(cherry picked from commit 02896efdf347adbfa0cb262c9b7d46e11dbe4866)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
Koha/Schema/Result/Deleteditem.pm
Koha/Schema/Result/Item.pm
installer/data/mysql/kohastructure.sql