DB for Koha 3.0

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

DB for Koha 3.0

Paul POULAIN-2
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)


_______________________________________________
Koha-devel mailing list
[hidden email]
http://lists.nongnu.org/mailman/listinfo/koha-devel