MJ Ray wrote:

Mike Hansen <mwhansen@hmc.edu> wrote:

	I had this problem as well.  I believe that koha.mysql is way out of
date.  The changes are in the updatedatabase script and so they should
be in effect on a new installation.


Design question: why is updatedatabase used instead of the koha.mysql
file?

Some explanations :
* the koha.mysql is a old 1.2.x DB structure.
* all modifications are done through updatedatabase script.

During install, the db is created with koha.mysql then updated through updatedatabase.
This enable upgrading from any version to 2.0.0 one.

However, this upgradedatabase script is not enough when upgrading from 1.2.x to 2.0.0 version, as this upgrade require :
* updatedatabase
* populate MARC parameters table
* tune your marc
* migrate datas from old-DB to MARC-DB

I asked katipo for this upgrade tools, they can't do it for instance.
I spoke with jerome of a complete koha.mysql 2.0.0, that should not require upgradedatabase. I may build such a DB for 2.0.0 official release. BUT, the upgradedatabase will still be used for upgrading.

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)