[Koha-devel] IMPORTANT Koha 3.0 updatedatase and kohastructure.sql

[Thomas Dukleth]

This seems to be a very serious problem.  I thought it may have been just
me for not updating from CVS frequently enough since I have not been
contributing any code lately.


Thomas Dukleth
Agogme
109 E 9th Street, 3D
New York, NY  10003
USA
http://www.agogme.com
212-674-3783


On Tue, July 3, 2007 7:07 pm, Joshua M. Ferraro wrote:
> Hi all,
>
> For years, we've had trouble maintaining the official Koha SQL
> definition, it seems like every developer probably has a slightly
> different definition. This is fine, however, we need to decide on
> an appropriate process for updating the official kohastructure.sql
> file that forms the basis for the new Web Installer in Koha 3.0.
> If you look back through the history of this file:
>
> http://cvs.savannah.nongnu.org/viewvc/koha/installer/kohastructure.sql?root=koha&view=log
>
> You'll notice vastly different versions ... people seem to
> just overwrite it with a new def exported in their favorite tool
> (mysqldump, phpmyadmin, etc.). Recently I had to revert kohastructure.sql
> in CVS because it patently failed for me ... I noticed that there are
> some definitions missing as well, and discrepancies between versions
> w/respect to the constraints.
>
> For instance, I asked Paul this afternoon to send me his 3.0 SQL
> definition, but that didn't include the 'defaultvalue' column in
> the marc_subfield_structure table, and, as a result, the MARC
> editor is broken for new installations when using that definition.
>
> I'd also like to point out that updatedatabase should start completely
> blank for 3.0. IMO updatedatabase shouldn't be the upgrade path
> from 1.x or 2.x to 3.0 ... rather, it should be the upgrade path
> for 3.0 to 3.2, etc. Other thoughts?
>
> I'd like to get feedback from everyone on the best way to maintain
> kohastructure.sql and updatedatabase, to make sure we always have a
> known SQL definition and update process. Comments, ideas?
>
> Cheers,
>
> --
> Joshua Ferraro                       SUPPORT FOR OPEN-SOURCE SOFTWARE
> President, Technology       migration, training, maintenance, support
> LibLime                                Featuring Koha Open-Source ILS
> jmf at liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
>
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at nongnu.org
> http://lists.nongnu.org/mailman/listinfo/koha-devel
>