* Chris Cormack (chr...@catalyst.net.nz) wrote: > * Mark Tompsett (mtomp...@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
signature.asc
Description: PGP signature
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
