[Koha-devel] the branch tables
Finlay Thompson
finlay at katipo.co.nz
Thu Dec 4 13:53:08 CET 2003
Hi Paul
I have had look in the code regarding branchcategories and branchrelations.
The C4::Koha::getbranches() method populates the branch's hash with
information out of the branchrelations table.
This information is then used in a nmber of places around the rest of
Koha: circulation, reserves, opac-reserves, and other places too. If you
delete the table it will certainly create bugs and probably cause koha
to break.
Both the branchrelations and branchcategories tables are used in the
branches.pl script, and that would break if you deleted the tables.
I notice that the dependence on these tables is light, and the code
could quite easily be modified to take them out. Although some other
mechanism needs to be put in place to handle the issues around different
kinds of branches.
I wrote an email a while ago to the devel list explaing what these
tables are about, and some possible modifications to make it a bit better.
http://sourceforge.net/mailarchive/message.php?msg_id=4570739
I cant help with the other tables, as I dont know what they are for.
Finlay
paul POULAIN wrote:
> Hi chris,
>
> In the DB schema (see previous post), i've listed 10 tables that are
> not used, or almost not used in Koha.
> Could you check the list & confirm deletion (look at branchcategories
> & branchrelations specifically)
>
> Note : i'll drop tables only in 2.0.x branch, not in 2.0.0 one (to
> avoid last-minut bugs)
>
More information about the Koha-devel
mailing list