[Svn] DDL scripts update

Thomas Bruederli roundcube at gmail.com
Thu Apr 3 08:42:10 CEST 2008


A.L.E.C wrote:
> 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 
so far.

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.

~Thomas

_______________________________________________
http://lists.roundcube.net/mailman/listinfo/svn



More information about the Svn mailing list