Re: [Koha-devel] the branch tables

[Finlay Thompson]

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)