Okay, that wiped out any doubts. :) thanks. I just wanted to be sure about this. ;)
Regards Simon -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Donnerstag, 27. März 2008 09:14 An: DBMail mailinglist Betreff: Re: AW: [Dbmail] DBMail 2.2.10 second release candidate Simon Lange wrote: > Late question i know, but... > > What about the cleanup in the mysql scheme definition? What does that mean > for existing installations? Do we have to alter the tables and if so which > one. Im asking because there is nothing mentioned within upgrading install > or changelog within the distribution of 2.2.10. is there a plan to > distribute a alter mysql script too? Im asking because what happens when in > a future release you add/change features and has only the "new" scheme in > mind forgetting the existing schemes? Inconsistency by accident? Know what I > mean? It doesn't mean anything for existing installations. I do *not* intent to construct an alter table script. It only affects users of not-yet-existing Rails applications talking to the dbmail-mysql database directly. It does not and will not affect functionality of dbmail utilities or daemons. The mysql cleanup mainly affected the width specification on integer type columns. Those width specifications do not affect storage, but only provide hints for displaying the column. Rails uses those hints to deduce the intented datatype: tinyint(1) is assumed to be a boolean, tinyint(3) a normal 8bit integer. A totally braindead approach imo, but there was no downside for me to accomodate an otherwise completely reasonable request. The other change was setting the UNSIGNED keyword on all integer type columns. Since dbmail will already never insert negative values it doesn't really matter much for now. Mysql users who have UNSIGNED set on those columns will see the maximum value increase by 100%. But that will only affect truly massive installations, and those will/should have the manpower and budget to hire a mysql dba who can tweak the schema to fit their needs. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
