Bug 37558

Summary: Statistics table does not have an id
Product: Koha Reporter: Nick Clemens (kidclamp) <nick>
Component: Architecture, internals, and plumbingAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: dcook, jonathan.druart, julian.maurice, katrin.fischer, martin.renvoize
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 37540    
Bug Blocks:    

Description Nick Clemens (kidclamp) 2024-08-02 14:32:49 UTC
See bug 37540 - we have to manually stringify dates in the statistics objects when unblessing because we cannot refetch a fresh object from the DB as we have no id.

Should we add an update to add a primary key to the statistics table?
Comment 1 Jonathan Druart 2024-09-24 08:11:03 UTC
Yes, all tables should have one.
Comment 2 David Cook 2024-09-30 04:36:45 UTC
Yeah, I reckon this needs an autoincrement primary key id column.