-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
I was wondering if there was a reason why the date fields are stored as char(14), doesn't that make them a string? I want to analyse the dates things happened - between ranges etc, and could do with changing them to a double or big int or even a mysql date!
For what it's worth, if you use MediaWiki with a Postgres database, dates *are* stored as true timestamp fields. The only big problem I found when converting them over was with the archive table, which still needs to at least emulate a char(14) due to the URLs generated within the code. Just a heads up for when/if the timestamp changes for the MySQL version.
- -- Greg Sabino Mullane greg@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200608210919 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8