As I use postgresql, that won't work.
Although the general idea does.
Thanks for the tip!
Op 6-jul-2006, om 16:28 heeft Paul J Stevens het volgende geschreven:
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
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
