Re: [Koha-devel] [DISCUSSION] Database schema & coding guidelines

2012-05-25 Thread Chris Nighswonger
On Fri, May 25, 2012 at 12:23 PM, Marc Balmer wrote: > Am 25.05.12 18:00, schrieb Paul Poulain: > > In the wiki page http://wiki.koha-community.org/wiki/DB_schema_bugs, an > > insconsistency has been noticed: > > primary keys column name can be: id (in authorised_values table), xxxid > > (cityid)

Re: [Koha-devel] [DISCUSSION] Database schema & coding guidelines

2012-05-25 Thread Marc Balmer
Am 25.05.12 18:00, schrieb Paul Poulain: > In the wiki page http://wiki.koha-community.org/wiki/DB_schema_bugs, an > insconsistency has been noticed: > primary keys column name can be: id (in authorised_values table), xxxid > (cityid), xxx_id (label_id), xxxId (limitId), xxxcode (branchcode), > xxx

Re: [Koha-devel] [DISCUSSION] Database schema & coding guidelines

2012-05-25 Thread Ian Walls
I also favour "_id" in general... the underscore separates it out as an identifier, and it's already this way in a large percentage of the database. We need to be very careful, though, if we change any of the existing key names, so that it not only doesn't break the Koha code, but also doesn't bre

Re: [Koha-devel] [DISCUSSION] Database schema & coding guidelines

2012-05-25 Thread Jared Camins-Esakov
Paul, et. al., On Fri, May 25, 2012 at 12:00 PM, Paul Poulain wrote: > In the wiki page http://wiki.koha-community.org/wiki/DB_schema_bugs, an > insconsistency has been noticed: > primary keys column name can be: id (in authorised_values table), xxxid > (cityid), xxx_id (label_id), xxxId (limitId

[Koha-devel] [DISCUSSION] Database schema & coding guidelines

2012-05-25 Thread Paul Poulain
In the wiki page http://wiki.koha-community.org/wiki/DB_schema_bugs, an insconsistency has been noticed: primary keys column name can be: id (in authorised_values table), xxxid (cityid), xxx_id (label_id), xxxId (limitId), xxxcode (branchcode), xxxnumber (borrowernumber) => choose how to name PK an

[Koha-devel] Koha 3.6.5 released

2012-05-25 Thread Jared Camins-Esakov
The Koha release team is happy to announce the release of Koha 3.6.5 This is a stable release and contains bugfixes as well as updated translations. You can download it at http://download.koha-community.org/ Go forth, download, and enjoy :) RELEASE NOTES FOR KOHA 3.6.5 24 May 2012