]> 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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 27 Apr 2020 10:32:37 +0000 (11:32 +0100)
commitec1bfd2b749b8ed9bd8688abdd47b9736ba872d0
treead0a2fd109566e6cd6a164919eef3a07232be27b
parentb50641b4791f68a119ce5060c852e02cdb523956
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>
Koha/Schema/Result/Deleteditem.pm
Koha/Schema/Result/Item.pm
installer/data/mysql/kohastructure.sql