[EMAIL PROTECTED] wrote: > Hi, > > For situations like this one, for who update via SVN, that Paul and Aaron to > add that information to the Changelog file.
The ChangeLog contains the comments attached to the commits. It does not and should not include upgrade information. > I have a similar situation that it was needed a update to the tables but them > i went to sql/mysql directory and i saw that was something new, it was the > change_headervalues.sql or something. 2.1.x is clearly marked as a moving target. Migration scripts are mostly targeted at people upgrading from 2.0. If you track SVN (like you do), you are expected to follow dbmail-dev. Changes to the database are always discussed and/or announced there so people running cutting-edge can test them. That said, Anne is *not* running svn but 2.0. And no, the foreign keys were not introduced in 2.0.7, but in 2.0.0!! They were /modified/ in 2.0.7 to include a 'ON UPDATE CASCADE', but afaik that's it. People migrating from MyISAM to InnoDB will need to do more than just issue a couple of 'alter table ... set type=InnoDB' statements. As such that is not documented anywhere, however. An omission that may need to be fixed. Foreign keys are very much advisable in 2.0, and they will be *required* in 2.2. A lot of the sanity checks in dbmail-util that are aimed at maintaining database integrity are simply meant to compensate for the lack of foreign keys in myisam. That type of check is not in place in 2.1 for all the new cache tables, and they never will be. So in sum: myisam is deprecated. Lack of proper foreign key restraints is deprecated. Migrate to innodb, and make sure the FKs are in place. Aaron and I can not support each and every conceivable upgrade path in the code, documentation, or on the list, even when we're happy to discuss things. You can always hire us to help you though. And keep sending us your patches, or post howto's on the wiki. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
