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.