Bug 14598: (DB update) fix NULL itemtypes in statistics on 'return' rows
authorTomas Cohen Arazi <tomascohen@theke.io>
Tue, 1 Sep 2015 14:52:17 +0000 (11:52 -0300)
committerKyle M Hall <kyle@bywatersolutions.com>
Fri, 28 Oct 2016 11:29:57 +0000 (11:29 +0000)
commit2cdec7ff9178fd8f70b5885b7c2936ddf09e69f7
tree332894c68e95cab34bb570520850dc9c655ef353
parent34eb4c1fa95ea14047413436b8df42299d029ca4
Bug 14598: (DB update) fix NULL itemtypes in statistics on 'return' rows

This patch introduces an updatedatabase.pl entry that takes care of
updating existing statistics rows.

It does so by looping on the statistics rows, collecting itemnumber occurences
that are have NULL itemtypes.
It then chooses the right itemtype following what is proposed on bug 14651, and
then updates the rows in statistics using the calculated itemtype.

Regards

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
installer/data/mysql/updatedatabase.pl