[Koha-devel] DB for Koha 3.0

[Paul POULAIN]

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)