]> git.koha-community.org Git - koha.git/commit
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)
committerJoy Nelson <joy@bywatersolutions.com>
Fri, 8 May 2020 21:15:55 +0000 (21:15 +0000)
commit02896efdf347adbfa0cb262c9b7d46e11dbe4866
tree6eaab1ac32757200ea3d147a9d4a267bdde58d25
parent85339f38a096c63a9794cab424b4b4d4ce94e291
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>
Koha/Schema/Result/Deleteditem.pm
Koha/Schema/Result/Item.pm
installer/data/mysql/kohastructure.sql