[Koha-devel] [Discussion tech] database table naming

[Marc Balmer]

Am 10.02.12 11:44, schrieb Paul Poulain:
> Continuing with open discussion for the future of Koha:
> 
> On the page http://wiki.koha-community.org/wiki/DB_schema_bugs, we have
> referenced some inconsistencies on the database.
> One of them is about table naming : acquisition related tables all start
> by aq, other tables don't have any prefix.
> 
> OTOH, Julian has submitted a bug
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5339 that adds
> an "invoice" table, related to acquisitions, but don't has a aq prefix.
> 
> The possible options are on
> http://wiki.koha-community.org/wiki/Table_naming, let's start the
> discussion !

A better (imo) move than prefixes would be to use DB schemas.  This way
related tables can be grouped in a schema, and default security can be
defined at the schema level (at least on PostgreSQL).

afaik, both MySQL and PostgreSQL support schemas.