Hello all, 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 ( - sessionqueries, - marcrecorddone, - users, - itemsprices, - biblioanalysis, - borexp, * 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 Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org)