* Chris Cormack (chrisc@catalyst.net.nz) wrote:
* Mark Tompsett (mtompset@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