[pLog-svn] Notification of required database changes

[Oscar Renalias]

Are you sure it doesn't work?

Most of the new fields are just counters and the update process in the
wizard just counts the number of rows fulfilling certain condition and
setting the resulting value in the new column. It doesn't really
matter when or how many times you run these queries, they'll always
give the right result.

Oscar

On 4/5/06, Mark Wu <markplace at gmail.com> wrote:
> I think it will get success in "database" change pahse, but will fail in
> "data" change pashe...
>
> Because data change pashe only work from 1.0 -> 1.1
>
> I try it several times...  :P
>
> Mark
>
> > -----Original Message-----
> > From: plog-svn-bounces at devel.lifetype.net
> > [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of
> > Oscar Renalias
> > Sent: Wednesday, April 05, 2006 2:08 PM
> > To: plog-svn at devel.lifetype.net
> > Subject: Re: [pLog-svn] Notification of required database changes
> >
> > It should be possible to run the wizard as many times as
> > needed in the current development version of 1.1. If the new
> > columns are already available in the db, it won't do anything
> > and if they're not, it will execute an ALTER statement that
> > will take care of creating them.
> >
> > Oscar
> >
> > On 4/5/06, Paul Westbrook <paul at westbrooks.org> wrote:
> > > Hello,
> > >     When a schema change is made, what is the "right" way
> > to run these
> > > upgrades if lifetype is already installed?  Should the
> > wizard be run
> > > again?  Does the wizard handle upgrades within a major
> > version number
> > > (i.e. an earlier version of 1.1 when upgrading to a later
> > version of
> > > 1.1)
> > >
> > >    Or should we run the sql statements by hand?
> > >
> > > --Paul
> > >
> > >
> > > --
> > > Paul Westbrook
> > > paul at westbrooks.org
> > > <http://www.westbrooks.org>
> > >
> > >
> > > _______________________________________________
> > > pLog-svn mailing list
> > > pLog-svn at devel.lifetype.net
> > > http://devel.lifetype.net/mailman/listinfo/plog-svn
> > >
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.lifetype.net
> > http://devel.lifetype.net/mailman/listinfo/plog-svn
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>