Le 06/06/2012 15:55, Kyle Hall a écrit : > I agree with paul here. I think in the optimal solution would be a > table prefix for every column, so we have *zero* name clashes for > joins. I doubt we will get there any time soon, but it is something to > thing about. It simplifies queries, whereas having id as the pk for > each table convolutes and complicates queries.
Kyle, I can't remember where I saw this, but it's an old practise, that is not recommended anymore (SQL generally speaking) Plus I think this is something we can't introduce now without rewriting a lot of things everywhere. OTOH, I think updating primary key names is something more achievable, even if won't be made in 2 clics, I agree. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 _______________________________________________ Koha-devel mailing list [email protected] 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/
