Incidentally, I'll try to get this into SVN myself, but there's a BINARY specified on the name column of the dbmail_mailboxes table. That breaks the case-insensitive mailbox matching and has to be removed.
Aaron On Thu, 2006-07-06 at 16:28 +0200, Paul J Stevens wrote: > There's no native capability yet. > > I use: > > mysqladmin create dbmaila > mysqladmin create dbmailb > mysqldump -d dbmail|mysql dbmaila > mysql dbmailb < sql/mysql/create_tables.mysql > mysqldump -d dbmaila > dbmaila.sql > mysqldump -d dbmailb > dbmailb.sql > diff dbmaila.sql dbmailb.sql > > this should provide you with a pretty good idea of any changes. > > > Marc Dirix wrote: > > Hi, > > > > Since I run svn head most of the time, is there a way to keep > > track of changes in the sql tables. > > Recently I found my dbmail_replycache table lacking a column which > > did go into the sql schema templates but not in my db, because it was > > created before the change was made. > > > > If I know something has changed, I can create my own migrate scripts. > > > > Best regards, > > > > Marc > > _______________________________________________ > > Dbmail-dev mailing list > > [email protected] > > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > >
