Add date insert and date update fields.

table_date.sql

ALTER TABLE `[[_TABLE_]]` ADD `date_insert` DATETIME NOT NULL , ADD INDEX ( `date_insert` ) ;
ALTER TABLE `[[_TABLE_]]` ADD `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP , ADD INDEX ( `date_update` ) ;

DROP TRIGGER IF EXISTS `Trigger_DateInsert_[[_TABLE_]]`;

DELIMITER //

CREATE TRIGGER `Trigger_DateInsert_[[_TABLE_]]` BEFORE INSERT ON `[[_TABLE_]]`
FOR EACH ROW BEGIN
     SET NEW.`date_insert` = NOW();
END
//

DELIMITER ;

To use it, remplace [[_TABLE_]] by table name.