[Svn] DDL scripts update
roundcube at gmail.com
Thu Apr 3 08:42:10 CEST 2008
> I've question about http://trac.roundcube.net/ticket/1484854
> How to make those changes? I mean, we don't have an update script.
> I can modify initial script(s), but what with update? How to do that?
Actually we don't have an automated update-scenario. I think MDB2 has some
Schema creation/reverse-engineering functions that might me useful to
update any existing database schema. It operates with an XML-based
specification of the desired database schema. But I haven't worked with it
Regarding the ticket: I've done some index-optimization in
http://trac.roundcube.net/changeset/1218 but not for Postgres.
For now I'd suggest to write ALTER TABLE statements to SQL/update.* to
represent the changes in our DB schema.
More information about the Svn