[Koha-devel] Serious problem

[Chris Cormack]

* Chris Cormack (chrisc at catalyst.net.nz) wrote:
> * Mark Tompsett (mtompset at hotmail.com) wrote:
> > Greetings,
> > 
> > And what if you wish to undo a checkout?
> > There are advantages to having it.
> > -- Perhaps we should ponder why we are uniquely keying on the id in 
> > old_issues?
> 
> What? Undo an old check out? You mean like unreturn something?
> There is no code to do that. If you want to unreturn something, you just reissue it.
> 
> It is just a history file, if it just auto_incremented the same way as issues does
> then the whole problem goes away.
> 
> I see no more advantage to having no issues_id, than to have one that auto increments.
> You'd still have to have a custom query either way if someone did decide to write
> a bizarre piece of code that unreturned items. (Please no one do this, it's a horrible idea)
> 
> Chris


Of course, there is no reason that those tables (deleted* and old_*) need to be innodb.
We do not foreign key to them.
If they were MyISAM, then this problem would go away.

Chris

-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 801 bytes
Desc: not available
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160906/150c1c94/attachment.pgp>