mysql timestamp 默认值当前时间

插入和更新时默认值为当前时间，字段不能用Datetime类型，需要用timestamp类型，

建表时的写法为

`InsertTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

DROP TABLE IF EXISTS `obj_Test`;
CREATE TABLE `obj_Test` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,  ,
  `InsertTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ReasonCode` smallint(2) DEFAULT NULL,
 PRIMARY KEY (`ID`) 
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;