[Koha-bugs] [Bug 4118] Add Collection Code to Statistics Table

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4118

Ian Walls <koha.sekjal at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Failed QA
                 CC|                            |koha.sekjal at gmail.com

--- Comment #6 from Ian Walls <koha.sekjal at gmail.com> ---
First patch is okay, just adds ccode to the stats table so you don't have to do
a multi-table join to get it from items and deleteditems.

The database update, though, looks a little janky:

ALTER TABLE `statistics` ADD `ccode` VARCHAR( 80 ) NULL ;

should be more like 

ALTER TABLE `statistics` ADD COLUMN `ccode` VARCHAR ( 10 ) AFTER
`associatedborrower`

The update message is also inaccurate ("Category code" instead of "collection
code")

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.