Re: [phpesp-general] phpESP 2.0.2 updating db

[Franky V. L. <lie...@te...>]

On Tue, 8 Jan 2008 15:29:49 -0600
"Cook, Ken" <kc...@sa...> wrote:

> In the scripts/db folder, there is not a script for updating from
> version phpESP 1.7.2 . Is there prescribed steps for updating the db
> from 1.7.2 to ? ?
> 

Well, since there wasn't an update script to go from 1.6.* to 1.7.2, I
would assume the db didn't change then. So, as indicated in
docs/UPDATING:

mysql_update-1.8.2h-1.8.2i.sql (if running a version <= 1.8.2h and
going to 1.8.2i)
mysql_update-1.8.2k-2.0.0.sql (if running a version 1.8.2i-1.8.2k and
going to 2.0.0)

(you need to execute them both in order).

I'm not aware of any DB version restrictions, so I would say this
shouldn't pose any problems, but due to the mysql password statement
changing between 3.x and 4.x (size went to 64 characters), you may want
to change the column type of "password" in the tables "respondent" and
"designer" from CHAR to VARCHAR (since your version still generates
shorter passwords). Maybe not a bad idea to do this in general ...

Franky