Doctrine "on update CURRENT_TIMESTAMP" annotation (Symfony2)

Question

I need to make annotation for column in my entity - "on update CURRENT_TIMESTAMP" attribute. How can I do that?

Answer 1

You cannot use your own column definition:

/**
 * @ORM\Column(type="datetime", columnDefinition="DATETIME on update CURRENT_TIMESTAMP")
 */
private $updatedAt;

The example is for MySQL. Take into account, that columnDefinition is not portable among different databases or even their versions.