How to make Doctrine use a MySQL TIMESTAMP column instead of DATETIME?

Question

I'm looking for a way to use the MySQL timestamp column type in Doctrine 1.0. I was able to get it working by modifying Doctrine_DataDict_Mysql to return TIMESTAMP instead of DATETIME when the specified type is timestamp, but I'm fairly certain that it's not the right way, and it will probably break at some point.

Doctrine 2.0 seems to come with a built-in type mapping facility, but I can't find an equivalent mechanism in 1.0, and I'm kind of stuck with it for now.

Any pointers would be much appreciated.

Answer 1

You would probably have better luck with this question on the Doctrine IRC channel or Google group; this is an extremely domain-specific question (which is okay), and there are surely more experts on the subject at one of those forums than here.

Chances are, though, you'll have to look at the source and do extensive testing to see what effects this will have. On the bright side, it looks like Doctrine has an extensive set of test cases, so you should be able to automate most if not all of this testing.