Date index for Mar 2003


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

Re: [achievo] SQL schema for mySQL in 0.9.2



gian paolo ciceri wrote:
I'm not able to find SQL schema for mySQL in 0.9.2.
(there are only PgSQL and Oracle schemas).

That's right. There isn't one. The PostgreSQL and Oracle schemas will be removed also in a future release, as soon as the setup system supports these databases too.


Why ? Is it the setup.php that creates table for mySQL ?

Yes.

Since I'm running 0.9.1. on mySQL, I'd like to see schema
changes before try to update.

Maybe you could create a copy of your database, run the setup script on this database and compare the result with your 0.9.1 database. The schema is created/updated automatically based on the node classes that can be found in the different modules. Only in special cases, when it's hard to detect certain changes based on the node class file (for example when a certain field gets renamed), customized code is used in the setup proces.


Any suggestion will be appreciated. I'm only trying
to figuring how changes (starting form the release notes)
are reflected in code.

Because the node classes reflect the database schema and vice versa the best way to start is comparing the old nodes with the new ones (which is a difficult thing to do for this release, because of the moving of all nodes to seperate modules), or do the above.


Regards,

Peter



http://www.achievo.org/lists achievo.org - ©1999-2002 ibuildings.nl BV