[Koha-bugs] [Bug 13790] Add unique id issue_id to issues and old_issues tables

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

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

--- Comment #20 from Olli-Antti Kivilahti <olli-antti.kivilahti at jns.fi> ---
Thinking about Katrin's comment on Bug 13743 regarding the AUTO_INCREMENT of
old_issues.

Isnt it a bit dangerous to have the old_issues.issue_id as AUTO_INCREMENT?
This feature works as well without it, and prevents accidentally adding
old_issues from hypothetical other sources without a issue_id known.

When issues.issue_id and old_issues.issue_id get out of sync,
that would cause serious and hard-to-see issues when old_issues-table is not
populated on check-ins.

Nobody should touch the old_issues -table from anywhere but the
C4::Circulation::AddReturn(), but dropping the AUTO_INCREMENT will make it a
bit harder.

I don't think this issue is a blocker, but I would feel better.

BTW. Separating issues and old_issues is really awkward, but I guess we need to
just live with it. Thinking from a statistical point of view.

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