* Chris Cormack (chr...@catalyst.net.nz) wrote: > * 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. > Answering myself again, this won't work, because the original table will still keep handing out the wrong IDs.
What does MariaDB do? With their XtraDB tables (which are used by default still called InnoDB for compatibility) Chris > _______________________________________________ > 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/ -- 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/
