[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Thomas Dukleth
Subject: Re: [Koha-devel] IMPORTANT Koha 3.0 updatedatase and kohastructure.sql
Date: Tue, 3 Jul 2007 23:33:38 -0000 (UTC)
User-agent: SquirrelMail/1.4.10a

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
109 E 9th Street, 3D
New York, NY  10003

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
> address@hidden |Full Demos at http://liblime.com/koha |1(888)KohaILS
> _______________________________________________
> Koha-devel mailing list
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/koha-devel

reply via email to

[Prev in Thread] Current Thread [Next in Thread]