I think i've finished the 1st draft for a better DB consistency in Koha 3.0
If you :
* have mySQL 4.1
* have a 2.2 DB
* update your CVS copy
* run updater/updatedatabase
you should see :
* some useless tables dropped (
* some field updated (mainly to be able to put the foreign keys)
* many foreign keys placed. You may encounter a problem if your DB is
not completely consistent. If you see the following error :
DBD::mysql::db do failed: Cannot add or update a child row: a foreign
key constraint fails at updater/updatedatabase line 928.
read carefully the line following.
If you have another error, let me know.
Paul POULAIN et Henri Damien LAURENT
en logiciels libres et bibliothéconomie (http://www.koha-fr.org)