[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36101

--- Comment #13 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to Lari Strand from comment #9)
> "Keeping an itemnumber in this table that does no longer exist is bad
> practice."
> 
> We still have deleted-tables so I don't consider the data as non-existing.

Dont you think that we should adhere to proven standards as to SQL,
normalization, etc ? :)

> 
> If we touch these old_-tables like this and destroy this archived data that
> can be linked still with deleted-tables, shouldn't we do the same to
> action_logs? I consider action_logs as an "archive" table just like
> old_issues or old_reserves (not sure if we do this already, though. Remove
> itemnumbers/biblionumbers from action_logs that are linked to deleted
> items/biblios?).

Good point. There is room for further improvement indeed. But no reason to
switch good to less.

-- 
You are receiving this mail because:
You are watching all bug changes.