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)